SAP tables are created, displayed and maintained via the SAP data dictionary using transactions such as SE11 and SE80 and are the building blocks of the SAP environment. It is here where all the data within your SAP system is stored ready to be processed or accessed via your ABAP code. But it's not just business data within tables such as MARA and MARC that store material details, EKKO and EKPO that store purchasing details or even BSEG, BSAK and BSIK which stores accounting data but also the core info that essentially makes up the system.
For example when you create an ABAP report/program this code is then stored within a database table. Not only that the metadata of tables is also stored in database tables. For example, DD02L stores the global settings and attributes for each table, DD03L stores the list of fields that make up the table. The details about each of these fields are also stored in a variety of tables depending on how the field is made up.
Display any SAP database table
Display full details of any table in SAP including documentation, field list, ABAP select code...Simply input the table name and press the display button
Or if you have access to and SAP system you can use transaction SE11 and enter the table name in there and press display.
Tables list by Module area
Here is a list of tables organised by SAP functional or module area (i.e. CRM, MM etc) to help you find the information you are looking for.
- SAP CRM tables - CRM related tables and t-codes
- SAP Vendor master table data - Vendor tables and t-codes
- SAP Purchase Order Table list - PO Tables
- SAP Project Systems table list - List of Project system database tables
- SAP MM Table list - Materials Management
- SAP BC Table list - Basis Components
- SAP cost Centre table list - Controlling tables (inc cost centre)
- SAP production order tables - Production order table ( AFKO, AFPO, AFVC, AFVU )
- SAP Plant Table list - logistics/Plant tables
- SAP SD table list - sales and distribution tables
- See here for full list of tables by module area
This can also be done within your SAP system using the "SAP Applications" option of the table search help ( i.e. via SE11).
Popular dictionary tables within SAP systems
A000 Condition Table for Pricing
PA0000 HR Master record tables(info types for PNP logical database)
COVP CO Object: Line Items (See FM HRGPBS_DRILL_READ_COVP)
EKKO SAP PO tables
DD02V Data dictionary tables
TRDIR Table of SAP programs
USR02 Logon data
Help to find table information
So you can see there is a lot of complicated interlinked information stored in hundreds of thousands of sap tables! But how do you know what is stored in what? Well, the simple answer is experienced plays a big part and is also why you get a lot of specialisation in SAP. Because along with all these tables, many transactions allow a user to add, maintain and process the data.
But this is also where SE80.can help, providing information about all these database tables (also includes Structures and Views). This allows you to be able to perform a simple keyword search (i.e. table name/title) and view the details of each table on one page including details such as:
• Name of table/database
• Delivery class
• Text table if appropriate
• Field list
• Key field indicator
• Data element
• Data type
• Check table
• Field description
• Link to full details about each field/data element/domain
Add data to SAP database tables
As mentioned above there are many transactions that allow you to maintain the data within SAP tables but what if you want to add data directly to a database. There are two ways to do this, the first method is manual via transactions such as SM30, SE16, SE80 etc. and the second method is via ABAP code inserted into a program or report.
Downloadable PDF list
System overload put a 2-page downloadable pdf document together many years ago which includes some of the more useful tables available in SAP. It's not a definitive list but its a very good overview and is in a very nice colour-coded format. Click here to view/download the PDF table list