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

Exploring COVID-19 food supply chain disruptions

The food sector has been hard hit by COVID-19. Learn what some of those issues have been, how some companies have escaped the ...

Who are the real leaders among cloud ERP vendors?

The competition between SAP and Oracle is as bitter as ever, and contenders like IFS, Infor and Workday have serious offerings. ...

Cloud ERP adoption options take on greater urgency

Cloud doesn't always mean what you think it does. Understanding the two main types of SaaS, and how they differ from private ...

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

Top 7 data catalog use cases for enterprises

From data lake modernization to data democratization, there are many benefits to a data catalog. Experts talk about the top ways ...

Metamorphosis of Kafka Confluent event streaming technologies

Kafka Confluent event streaming tools allow data managers, analysts and developers to capture, process, store, access and analyze...

Isima emerges with bi(OS) converged data platform

Startup launches with the general availability of a converged platform that offers the promise of integrating multiple data ...

SearchAWS

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 ...

Learn the scope of Amazon subscription services

Prime is just one of Amazon's many membership offerings. Learn the features and fees of Amazon subscriptions to understand this ...

Amazon healthcare initiatives wake up an industry slow to change

Amazon's entrance into healthcare pushes established healthcare businesses to address and improve longstanding logistical and ...

SearchBusinessAnalytics

Baseball's Twins deploy Databricks to improve analytics power

With the amount of data used to make player personnel decisions in baseball growing exponentially, the Minnesota Twins began ...

Maine state government modernizes with Oracle Analytics

Hampered by siloed data and a data warehouse constructed 25 years ago, Maine's state government used tools from Oracle to break ...

TigerGraph adds cloud support, helps standardize graph coding

With democratization of graph databases in mind, TigerGraph recently added support for Microsoft Azure and took steps to help ...

SearchContentManagement

Adobe Sign business workflows ease digital transformations

Adobe Sign's automated digital processes more than ever help businesses overcome the restrictions imposed on in-person ...

Consider these electronic signature best practices

Some tips to think about when creating an e-signing process include cataloging documents requiring signatures, building user ...

What the CCPA means for content security

Now that the CCPA is in full effect, businesses must adjust their processes to better protect content. Organizations should ...

SearchHRSoftware

4 ways HR and IT can collaborate on employee experience

The COVID-19 pandemic is causing new issues for workers across industries. Here's how HR and IT can collaborate on creating a ...

Digital adoption platforms can improve employee experience

DAPs guide employees through new systems and offer tips on workflow best practices. Turnover and onboarding challenges drove ...

The HR software buying team: Roles, responsibilities, tips

Choosing the right HR software requires teamwork and forethought. Here's a look at which people to include in the evaluation and ...

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.