Identifying transparent tables used by a structure

In this expert response, Bert Vanstechelman discusses how to identify transparent tables used by a structure.

Bert Vanstechelman, Logos Consulting

Published: 27 Jun 2006

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

What is the most efficient way to identify the transparent tables used by a structure? I tried to identify the tables using a database trace, but this is very time-consuming.

The most efficient way to identify the transparent tables in structures is by using transaction S11 (ABAP Dictionary). After accessing the transaction, insert a table name and use the 'where used' functionality. Limit your search to structures.

Dig Deeper on SAP ABAP

Related Q&A from Bert Vanstechelman

Changing time zones in SAP ECC 6.0

An SAP user wants to know the risks of changing time zones in ECC 6.0. Continue Reading

Accessing SAP IDES 4.7 though SAP GUI

An SAP user wants to know how to access an SAP IDES 4.7 system via the Internet through SAP GUI. Continue Reading

How to establish communication between SAP Unicode and non-Unicode systems

Find out how to establish a connection between SAP R/3 4.7 and SAP ECC 6.0 non-Unicode systems, and learn how to maintain a connection when changing ... Continue Reading

SearchERP

The disruptive impact of COVID-19 on warehouse automation

The pandemic has had mixed effects on warehouse automation. Learn why this has been the case and what warehouse leaders say are ...

Crafts Technology manages COVID-19 changes with ECI JobBoss

Crafts Technology, a medium-sized manufacturer that performs small-volume jobs, is using ECI JobBoss ERP software to manage ...

Partnerships add more supply chain visibility to SAP LBN

New SAP Logistics Business Network partnerships provide users with key logistics data on shipment location and estimated arrival ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Cazena launches Instant AWS Cloud Data Lake service

Cazena advanced its cloud data platform with an integrated service that helps organizations to more quickly benefit from a cloud ...

Rockset raises $40M for real-time indexing database

The CEO and co-founder of real-time indexing database vendor details the evolution of the company from its origins in the open ...

Growing enterprise benefits of augmented data management

Gartner predicts plenty of growth in the booming augmented data management market, which helps data professionals focus on ...

SearchAWS

New Amazon grocery stores run on computer vision, apps

Amazon dives deeper into the grocery business with its first 'new concept' grocery store, driven by automation, computer vision ...

Amazon's sustainability initiatives: Half empty or half full?

Amazon's public perception and investment profile are at stake as altruism and self-interest mix in its efforts to become a more ...

How Amazon launched the warehouse robotics industry

In 2012, the warehouse robotics industry consisted of Kiva Systems, the sole supplier to serve all e-commerce companies. When ...

SearchBusinessAnalytics

Microsoft enhances integration between Power BI and Excel

The latest Microsoft update to its popular spreadsheet features an integration with Power BI that lets the analytics platforms ...

How DataOps architecture benefits your analytics strategy

A DataOps framework can provide access more efficiently throughout an organization to ease the analytics process and deliver ...

8 types of bias in data analysis and how to avoid them

Analytics can exhibit biases that affect the bottom line or incite social outrage through discrimination. It's important to ...

SearchContentManagement

How to navigate video conference recording privacy

Video conferences are convenient for companies whose employees are working remotely due to COVID-19, but now they must determine ...

Baseball team digitizes media, uses AI to uncover metadata

The San Francisco Giants' digitization and metadata tagging project helps the baseball organization revisit old content and ...

Headless CMS powers personalized, omnichannel e-commerce

As the headless CMS gains steam, understand why e-commerce companies are the most likely ones to reap the benefits and what ...

SearchHRSoftware

Tech trends in HR, 2020 edition: A shift in direction

The pandemic has hurt HR technology budgets, but it is also accelerating other tech trends in HR such as making HR services part ...

Remote workforce technology boosts employee productivity

Spurred by COVID-19, companies are taking a fresh look at the benefits of a remote workforce supported by advanced HR tools and ...

Firms dive into data for diversity and inclusion strategies

People analytics managers are seeking out and analyzing HR data that intersects with and impacts the employee work experience.

T-SQL (Transact-SQL)

What is the difference between DBMS and RDBMS?

What's the difference between DDL and DML?

How to use a SQL Server graph database to map data relationships

Please create a username to comment.