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

ERP alternatives poised to take the stage in 2021

The momentum for companies to adopt cloud-first and industry-specific ERP systems has created an opening for alternative ERP ...

IFS Field Service Management software: Overview, pros, cons

IFS FSM software is meant to manage field staff and assets. Learn about its advantages and disadvantages and whether your company...

Salesforce Slack buy biggest step yet outside the CRM realm

Salesforce has tried to buy its way into the rest of the enterprise before. Is Slack the golden ticket that will take it beyond ...

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

Enterprise data lakes hold the key to actionable insights

Technological pillars of sound business decisions, AI, machine learning and advanced analytics depend on the quantity, quality ...

Data fabrics help data lakes seek the truth

Data fabrics can play a key role in aligning business goals with the integration, governance, reliability and democratization of ...

Kyligence builds out data cloud for OLAP and big data

Kyligence is advancing the Apache Kylin project with a cloud-native offering that can help organizations more efficiently execute...

SearchAWS

Amazon's impact on publishing transforms the book industry

Amazon changed the way we publish, purchase and read books. Publishing experts said they expect more industry disruption to come.

How Amazon and COVID-19 influence 2020 seasonal hiring trends

Retail and logistics companies must adapt their hiring strategies to compete with Amazon and respond to the pandemic's effect on ...

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

SearchBusinessAnalytics

Why using graph analytics for big data is on the rise

Graph analytics is being used across industries for different reasons. Read on to see how they can improve organizational ...

Data governance framework key to analytics success

Successful data-driven decision-making relies on good data at its core, and it's a strong governance plan that ensures the ...

Looker, Google planning plenty of analytics collaborations

While collaboration with its parent company is prominent in Looker's plans, so are investments in analytics capabilities ...

SearchContentManagement

Best enterprise content management software of 2021

When it comes to ECM, there are myriad vendors to choose from. Delve into 10 tools on the market to understand their capabilities...

What is the future of ECM?

ECM isn't dead; it has evolved from a technology into an approach. Learn about the history of the ECM and look forward into the ...

5 steps to a successful ECM implementation

Implementing an ECM system is a major undertaking. Check out these steps to get on the right track before you jump into the ...

SearchHRSoftware

Diversity, equity and inclusion are hot, but tools need vetting

The diversity, equity and inclusion tools market is going mainstream, giving HR buyers more options than ever before. But due ...

Biden revokes Trump's contested DEI training order

President Joe Biden has revoked an executive order from former President Donald Trump that discouraged federal agencies and ...

How HR can help promote a caring culture

HR's role has become increasingly strategic and part of that requires focusing on truly supporting employees. Here's some advice ...

Graph database vs. relational database: Key differences

T-SQL (Transact-SQL)

What is the difference between DBMS and RDBMS?

What's the difference between DDL and DML?