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

Machine health systems play critical role in age of disruption

As the COVID-19 crisis disrupts industries, manufacturers can keep lines running by using machine health monitoring systems to ...

In crisis, opportunity: Downturn in ERP industry has upside

The inaugural ERP Confab examines what the economic downturn from the pandemic means for ERP users and vendors. Plus: a deep dive...

AR vs. VR vs. MR: Differences, similarities and manufacturing uses

Augmented reality, virtual reality and mixed reality are becoming valuable tools in manufacturing, but it's easy to get them ...

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

Instaclustr CTO on open source database as a service

Ben Bromhead, co-founder and CTO of Instaclustr, provides insight into the state of the open source database-as-a-service market ...

Percona users detail open source database challenges

Speakers from Shopify and LinkedIn outline open source database cloud and security challenges and best practices at the Percona ...

Grafana 7.0 from Grafana Labs expands data visualization

Distributed tracing data joins log metrics in Grafana 7.0 release, providing users with more ways to connect, observe and ...

SearchAWS

What Amazon's culture and practices can teach your company

Amazon has set a standard for workplace innovation that many firms aim to emulate. But experts advise executives to adjust ...

Break down the components of Amazon's retail business

Scan this overview of Amazon's various retail business units, from online platforms to brick-and-mortar stores, to understand ...

AWS ARM-based chips could shift microprocessor market

Amazon confronts cloud rivals with microprocessor designs. AWS ARM-based A1 instances offer high processing for lower costs and ...

SearchBusinessAnalytics

HR use case shows value of Oracle Analytics Cloud

A use case presented during Oracle Analytics' virtual user conference shows how the vendor's platform can bring value to an ...

Sisense helps Soft Stuff pivot business during pandemic

Soft Stuff, a wholesale distributor of gourmet foods, was able to change its business strategy amid the COVID-19 crisis, thanks ...

4 features of great data visualization and storytelling

Data visualization and storytelling go hand in hand when it comes to explaining data. Here are four ways to make sure you build ...

SearchContentManagement

Adobe Experience Manager buoys U.S. census during pandemic

The first U.S. Census digital experience was launched in time for the pandemic, and now Adobe looks to parlay the success into ...

Microsoft buys Softomotive to boost Power Platform RPA

Microsoft's acquisition of Softomotive gives Power Automate users a low-code RPA system to build bots for Windows-based tasks.

Get to know key features of content services platforms

A content services platform is more than a database -- it is an intelligent information engine. Organizations should be familiar ...

SearchHRSoftware

Zuckerberg lists benefits, drawbacks of remote work

After the pandemic, Facebook co-founder and CEO Mark Zuckerberg believes his firm will have more employees who work remotely, ...

HR technologies solidify HR employee experience near and far

Culture, physical and virtual workspaces, and policies play key roles in fostering worker loyalty and engagement -- with the help...

AI in HR recruitment targets high-demand technology talent

As demand for technology talent persists, even during pandemic times, AI, chatbots and machine learning play an increasingly ...

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.