Finding data in SAP
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
This tip is excerpted from Matt Wong's SAP Basis site.
When learning to program in SAP with ABAP/4, it can sometimes be difficult to find the right tables and fields to work with (don't worry, it gets pretty easy). But initially it's tough, and it may continue to be when you're trying something you've never done before. Here are some tips to help locate data:
Go to an SAP report or program that does something similar to what you want to do, and:
- Click on the screen fields, and use F1->Technical Info to find the field & table names.
- Trace the program with ST05 (SQL Trace) and ST01 (System Trace).
- Follow the program with the debugger (enter /h in the command line).
- Use the Table Contents utility to verify that the tables have the data that you think they have (SE80 -> Dictionary Objects (press Edit), enter the name of the table you want to see, and press Display. Go To Utilities -> Table Contents).
- Look for a logical database that sounds like what you're looking for. Analyze its structure and program to understand how its data is processed, and where the data is being kept.
Did you like this tip? If so (or if not) let us know. Send an email to sound off. Or go to our tips page and rate this, and other, tips, or send us one of your own.
Flying Start SAP R/3: A Guide to Get You Up and Running
Author : Gabriele Schicht and Andrea Schmieden
Publisher : Addison Wesley
ISBN/CODE : 0201675293
Cover Type : Soft Cover
Pages : 224
Published : Jan 2001
SAP is the world's leading provider of inter-enterprise software solutions and R/3 is the core component at the heart of their business improvement and integration practices. If you are one of the ten million licensed users of this system, you need a quick and clear route to R/3 fluency to help you master the essential tasks your job requires. Published by SAP Press, Flying Start with SAP R/3 provides the first ever guide for R/3 end-users which carries the official SAP seal of approval.