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

Dimension tables vs. fact tables: What's the difference? Fact tables and dimension tables are used together in star schemas to support data analytics applications. But they play different roles and hold different types of data.

Conquer real-time operational analytics in SQL Server 2016 Analytics helps improve business operations, and SQL Server 2016 users can master it -- in real time, using operational data in a transactional database.

How can SAP Software Provisioning Manager foster migration success? If you're moving to Business Suite on HANA, you'll want to know how to use Software Provisioning Manager for a successful migration. Here's important advice.

In-memory OLTP reborn with SQL Server 2016 Microsoft's in-memory OLTP needed improvements, and they are here with SQL Server 2016. Learn about the enhancements to this query-boosting feature.

How to improve OLTP with SQL Server 2014 In-Memory Basit Farooq explains how to improve the performance of OLTP applications using SQL Server 2014 In-Memory. He details what makes SQL Server 2014 In-Memory different from other in-memory database engines and how to use that to your advantage.

Dive deep into SQL Server 2014 in-memory OLTP Probably the biggest feature of the upcoming release, SQL Server 2014 in-memory OLTP has benefits that DBAs should know about. Learn how to set it up.

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

Managing DB2 transaction logs when upgrading to SAP ECC 6.0

A SearchSAP.com reader wants to know how an increase of indexes and tables after upgrade to SAP ECC 6.0 will affect the memory requirements of a DB2 ... Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

CRM vs. ERP: Understand differences and CRM choices

As vendors' offerings of ERP suites and CRM standalone modules get more complex, it can be helpful to learn -- or review -- the ...

With Scout, Workday acquisition strategy takes shape

Workday's planned acquisition of Scout RFP, a sourcing and procurement platform, says one thing to analysts: It is pushing to ...

10 ERP software choices for process manufacturing

Selecting ERP software for process manufacturing can be confusing, and different industries have different requirements. Learn ...

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

CockroachDB 19.2 improves distributed database performance

New release of CockroachDB cloud-native distributed database platform helps to reduce latency; it also gets enhanced data backup ...

Redis Labs eases database management with RedisInsight

Based on the open source RDBTools project, Redis Labs' new tool gives database administrators a stable graphical user interface ...

How AI could save the enterprise data catalog

Enterprise data catalogs record all the databases and files in a corporation, but sometimes it can become out of date. Advances ...

SearchAWS

A complete guide to AWS re:Invent 2019

AWS re:Invent is one of the biggest cloud and IT events of the year. Use this AWS conference guide to get the latest news and ...

AWS SysOps certification exam guide outlines admin responsibility

In this book excerpt from "AWS Certified SysOps Administrator Associate All-in-One Exam Guide," review the best practices for OS ...

AWS data lake and data warehouse options for the cloud

Get ready for data analytics in the cloud. Learn the best ways to handle your data on AWS. Distinguish between data lakes and ...

SearchBusinessAnalytics

Alteryx analytics platform focuses on ease of use

Alteryx is focusing on ease of use in new platform updates as it looks to attract users beyond its traditional base of data ...

Salesforce acquisition of Tableau finally getting real

With Salesforce and Tableau finally free to start integrating, Andrew Beers, Tableau's chief technology officer, talks about what...

Tableau analytics platform upgrades driven by user needs

In a Q&A, Tableau chief technology officer Andrew Beers talks about the driving factors behind recent product upgrades centered ...

SearchContentManagement

Box cloud content management helps simplify digital work

Box currently has three main areas of focus: integration with enterprise applications, content security and collaboration. The ...

Acquia cloud CMS on AWS, Vista cash flow raise user expectations

Acquia's new venture backing and customer experience cloud apps precipitate a need for easier integrations and setup for future ...

Adobe Sign introduces updates targeting mobile device users

The updates include a new home screen and a page for users to track the signing process, the ability to zoom and navigation ...

SearchHRSoftware

6 employee activism lessons HR needs today

Employee activism spiked last year, and experts say that as the 'age of purpose' gathers force, more workers will follow suit. ...

As politics heat up, so do hiring bias worries

The political polarization in the nation is also causing problems in the workplace. Political discussions are more common, and it...

Digital workplace transformation strategy: 6 steps to creating yours

Find out how to do a digital workplace transformation in the right way. Involving different departments and understanding needs ...

Dig Deeper on SAP ABAP

Related Q&A from Bert Vanstechelman

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.