How To Find Table Names In Sap

Transcript

Contents Introduction .................................................................................................................................................. 2 Using F1 option ......................................................................................................................................... 2 Using SE11 ................................................................................................................................................. 4 Using debug mode .................................................................................................................................... 6 Using a SQL Trace ...................................................................................................................................... 8 Introduction There are instances where you have to find the field name & Table name in SAP. Eg: Writing Functional Specs, Creating Condition tables, etc. This document will give you an overview of finding those field names & table names in SAP. Using F1 option   Locate the required field in the Transaction. Press F1   Press key in the Performance Assistant window You can find table & field names in the Technical Information window. This is the simplest way of finding table names. Using SE11 There are instances where you cannot find the tale name form the above method. Then you can try this option.   Go to SE11 transaction Place the cursor in the Database table box, & press F4  Press  Now you have to drill down relevant nodes to find the table name. button in the popup Using debug mode   Go to the Transaction code Enter the required data & then enter “/h” in the command field. Make sure you do this just before entering in to the Tx. Eg: For the given example, you have to put Material & then type “/h” in the command field & press Enter.   Press Enter Key You will be able to see the below message.    Press Enter again Now you’ll be in a different screen. Go to the following Menu path  Enter “SELECT” in the pop up.  Press Enter  Now press to go through the ABAP Code. It’ll take you through the code where you get “SELECT” in the ABAP coding. You can find the table name by going through the code in that manner.  Anytime you can switch off the debugging mode by typing “/n” in the command field. Using a SQL Trace If you know any report (Standard SAP report or a Z report) which used the same field, you can use this method to find the table name of the field you require. By using this method you will run that report & check the tables called during execution.   Go to transaction ST05 Tick on SQL Trace check box.   Press Give the report transaction name Button   Press Enter Now go to the same report transaction in a separate window & run the report  Come back to the Transaction ST05 & press the trace.   Now press on Press Enter to the pop up to deactivate to check on the trace.  Trace List (below shown) will give you all the tables executed by the report.   You have to go through the code & find the table name applicable. To get a clear trace, it’s always advisable to run a simple report. Author: Anupa Wijesinghe E-Mail: [email protected] / [email protected] Website: www.learnsaptips.com View my profile in LinkedIn Follow me on Twitter Disclaimer This article is done based on my research and readings, unless otherwise stated. The views expressed are my own and not of anyone else. Author accepts no liability for the content of the articles in this website or for the consequences of any actions taken on the basis of the information provided. Using this information is at the users own discretion and responsibility.