Proverbs & Idioms & SayingsList of SAP Tables (Cheat Sheet)
Since I have not found another place to put this 1 page cheat sheet, it is in this section. Of course, 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, SAP.CO, ABAP, the Data Dictionary, and some other SAP basis items. Some examples which are inlcuded in the PDF:
SAP tables
| 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 » SAP Tables as PDF (approx. 100 KB).
Management / Business Abbreviations
Management
AIDA(S) - Attention, Interest, Desire, Action, Satisfaction
KISS - Keep it short and simple
Business version: Keep it Simple, Stupid
KPI - Key performance indicator
LOI - Letter of Intent
MBO - Management by Objectives
NPV - Net present value
PM - Project Manager
POC - Proof of Concept
POS - Point of sale
PQP - Project Quality Plan
RFI - Request for Information
RFP - Request for Proposal
RIP - Rest in Peace
ROI - Return on Investment
ROI - Region of Interest
SMART - Specific, Measurable,
Achievable, Relevant, Time-Specific
SOD - Statement of Direction
T&M - Time and Material
TCO - Total cost of ownership
TQM - Total Quality Management
UAT - User Acceptance Test
USP - Unique Selling Point / Proposition
WIP - Work in Process
Business
AP - Accounts Payable
AR - Accounts Receivables
BI / BW - Business Intelligence / Warehousing
BPM / CPM - Business / Corporate Performance Management
CoA - Charts of Accounts
CpD - Conto-pro-Diverse
DWH - Data Warehouse
CMS - Content Management System
CRM - Customer Relationship Management
ERP - Enterprise Resource Planning
GL - General Ledger
IMG - Implementation Management Guide
KM - Knowledge Management
SCM - Supply Chain Management
Technical / IT Abbreviations
ABAP - Advanced Business Application Programming
ASCII - American Standard Code for Information Interchange
API - Application Program Interface
BAPI - Business API
BAdI - Business Add-In
CASE - Computer Aided Software Engineering
DOM - Document Object Model
EAI - Enterprise Application Integration
GUI - Graphical User Interface
HTML - HyperText Markup Language
J2EE - Java 2 Enterprise Edition
JSP - Java Server Page
JRE - Java Runtime Environment
LUW - Logical Unit of Work
LIFO - Last in First Out
MVC - Model-View-Controller
ODBO - OLE DB for OLAP
OLAP - Online-Analytical-Processing
RFC - Remote Function Call
RFC - Request for Change / Comments
RPC - Remote Procedure Call
RSS - Rich Site Summary
RSS - Really Simple Syndication
SaaS - Software as a Service
SOAP - Simple Object Access Protocol
SOA - Service-oriented architecture
SSL - Secure Sockets Layer
SVG - Scalable Vector Graphics
TCP - Transmission Control Protocol
UML - Unified Modeling Language
VPN - Virtual Private Network
XML - Extensible Markup Language