Monday, January 16, 2012

Searching for a SAP Table / Field

Method 1
The simplest way to search for a Table or Field would be by clicking on F1, then click on Technical Information. Now look under Field Data tab and you can find Table Name & Field Name. You will not be able to view Struct. Tables in SE11,SE16, but instead you will have to look for the Transparent Table instead. Read on..

Alternative 2
Searching for a field is easy, just click on F1 and look for it under Technical Information. However Tables sometimes are given as Structures there in Technical Information. A simple way to get the Transparent table would be.
Use T-code SE11
1) Copy the Field name
2) Paste the Field name under Database Table in SE11
3) Execute
4) Click on Where-Used List button
5) Select Table Fields
6) Execute


Alternative 3
You can run ST05 SQL Trace.
1) Activate the Trace
2) Run the transaction where you need to search for the Table
3) Deactivate the Trace
4) Display Trace


Alternative 4
Use T-code DB15
1) Go to Tables From Which Data is Archived radio button
2) Search by using Tables in Object
3) Search all Tables

Alternative 5
Use T-code SE16
1) Click on F4 on Table name field
2) Click on F4 on Application Component field
3) Search for relevant Module and sub module then execute

No comments:

Post a Comment