SAP Tables

• Proverbs & Idioms & Sayings
• Famous Quotes, Puns ...
•  
• Transition Words
• Conjunctions
• List of Synonyms
•  
• English Language Humor
• Humor & Fun & Jokes
•  
• Doppelkopf
•  
• SAP Transactions Overview
• SAP Tables Overview

List of SAP Tables (Cheat Sheet / Overview)

Since I have not found another place to put this 2 page cheat sheet (for consultants, developers, users) it is in this section. There are many useful lists of SAP tables on the web, but, for one reason or the other, I could not find one overview, which suits my own needs. So, finally I created my own list, including the most important SAP tables (functional and technical). It covers SAP-FI (currency, bank data, payment methods, calendar, taxes, accounting documents), SAP-CO (Cost center, cost elements, profit center) , ABAP, the Data Dictionary, User and System Administration, SAP Workflow, Number Ranges and some other SAP basis tables. Some examples which are included in the PDF:

SAP Tables Overview

DD02L SAP Tables	DD03L Table Fields	DD04L Data elements	TADIR Directory of Repository Objects
VARID Variant for Reports	TFDIR Function Modules	T100 Messages	TSE05 ABAP Editor insert commands
USR03 User address data	USR02 Logon data	USR01 User master	USR21 Assign user address key [ADRP]
TLOCK Transports: Locks	DBTABLOG Log Records	PAT03 Hot packages	UE070 Header of Requests/Tasks
SNAP Snapshots: Runtime	TBTCO Jobs status	TBTCP Batch Input steps	ARCH_OBJ Objects for archive / reorg.
TCURC Currency codes	T056 Interest settlement	T012 House Banks	BNKA Bank Master
T043 Assign Accounting Clerks	T007A Tax Keys	T000 Clients	T059A Type of Recipient For Vendors
T006 Units of Measurement	T002 Language Keys	T005 Countries	T004 Directory of Charts of Accounts
AUFK Order master data	KNA1 Customer Master	LFA1 Vendor Master	AFKO Order header data PP orders
CSKA Cost elements (CoA)	COBK Document header	TKA01 Controlling areas	SKA1 G/L accounts (chart of accounts)
BKPF Accounting header	BSEG Document line	BSID Sec. index cust.	BSIK Secondary index vendors

Please be invited to use this list and/or leave some suggestions for enhancement. However, out of experience, allow me to make one stipulation: although this cheat sheet is freely available, please refrain from uploading it to other servers.

The list starts with the most useful tables and the items are categorized: ABAP, Data Dictionary, FI, CO, Spool, Cost Center, Vendors (Creditor), Customers (Debitor), Banks, Taxes, Clients, Accounting, Payment methods etc.).

Below is a screenshot of the pdf, to show an overview of the structure (the list contains both customizing and operational tables):

Please feel free to download the corresponding 2 page cheat sheet » List of important SAP Tables as PDF (approx. 100 KB).

 

There are 4 Table-Types within the SAP System:
1. Tables which have technical control functions within the SAP system. They are maintained either by SAP or by users with special authorization.
2. Other tables contain basic commercial data (bank data, currency ...) or
3. the company structure (company codes, customer data ...).
4. And last but not least there are tables for application data, which contain business transactions and master data and are processed using SAP programs.

An overview of the most important SAP Tables for all these categories, as well as the necessary SAP Transaction Codes to maintain them, are provided on the linked pages.

 

 

List of Management / Business Abbreviations

 

List of Technical / IT Abbreviations

 

 

 

 

Optimized for Standards