Problem solve Get help with specific problems with your technologies, process and projects.

Time-saving ST05 tips

Here are some time-saving tips for when you're working with ST05.

ST05 sometimes display up to a few dozen possible sources of transparent tables, making it impossible and exhausting...

to examine each table one by one. My tip here is that you can short-list the possible candidate of transparent table by examining the number of records fetched and INSERT statement in ST05 table listing. A. Using number of table record fetched in ST05 for Display/Change transaction Example: Searching PO line item transparent table, get a created PO with let say 10 line items: a. Go to ME23, key-in PO number. Wait! Don't ENTER first. b. Open another session, go to ST05, switched on SQL trace c. Go back to screen at (a), ENTER now d. Go back to SQL trace screen from (b), Trace Off then List Trace to examine the list of table, check and short list those table with fetched record number of 10(in this example), these are the possible source of PO item data transparent table. 2. Short list those table with INSERT transaction in ST05 for Create transaction. Example: PO creation a. Do the same steps as in (A1), but with transaction ME21 b. In SQL trance table listing, check and short listing those table with INSERT in statement column B. Using search help in looking for configuration transparent table 1. From any screen field Example: Search configuration table for PO item category a. Go to transaction ME21 b. Click on Item category screen field (technical info indicate it comes from structure field), list the search help, click the item category on search help result, display the technical info of this field in this search help result. If the technical info indicate a transparent table, this is the table you are looking for, else if it comes from a view, check out the view definition. 2. From data browser SE16 Example: If you know any transparent table that contains the PO Item Category (example: EKPO), display it in SE16, double clicking on any record from selected entries, display the search help result for item category, then check the search help result technical info as in (B1).  

This was last published in May 2003

Dig Deeper on SAP ABAP

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close