SAP Tables - Overview
Since I have not found another place to put these tips (for consultants, developers, users) it is in this section. There are many useful lists of SAP tables on the Internet, but, for one reason or the other, I could not find one overview in the tips and tricks section, which suits my own needs. So, finally I created my own Cheat Sheet, 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.
Tip: Via the SAP data modell (using transaction code SE11) the SAP table structure (list of table fields) can be viewed.
Remark: The usual SAP terminology create, read, update and delete (CRUD) is here abbreviated referred to as change or maintain.
List of SAP Tables
ABAP & SAP Data Dictionary Tables | |
DD01L | Domains |
DD02L/T/V | SAP Tables (se11) |
DD03L/T | Table Fields (View: DD03VT) |
DD04L/T | Data elements |
DD07L | Values for the domains (View: DD07V) |
DD09L | Technical settings of tables |
DD12L | Secondary Indices |
TDEVC-T | Packages (Development class) |
TFDIR,TFTIT | Function Module (se37) / FM short text |
ENLFDIR | Add. Attributes: Function Modules |
TADIR-T | Directory of Repository Objects |
TRDIR | Programs / Sources (REPOSRC / D010SINF) |
TMDIR | Methods in a class |
D010TAB | Where Used: Report - Tables |
TAPLT | Program Application Long Texts |
SEOCLASS | ABAP Objects Class |
D020S/T | Screen Short Description |
TSE05 | ABAP Editor insert commands |
DM42S | Table relationship (sd11) |
T100 | Messages |
TSTC-T | Transaction Codes (= TC) |
TSTCP | Parameter for transactions |
FILEPATH | Logical file names |
PATH | Physical paths / file names |
SYST | ABAP System Fields (structure) |
VBMOD | Update function modules (Registered) |
VBDATA | Update data |
Text / Print / Spool / SAP Documentation | |
STXFADM | Smart Forms: Administration |
STXB | Texts in non-SAP script format |
STXH | SAP script text file header |
STXL | SAP script text file lines |
TSP01 | Spool Requests |
TSP02 | Print Requests |
TST01/03 | TemSe - header and data (= Temp. Sequential) |
TTXOB/T, | Valid text objects, see TTXID for text IDs |
DOKIL | Index for Documentation Table DOKH |
DOKHL | Documentation: Headers |
DOKTL | Documentation - text lines |
Number ranges | |
NRIV | Number range intervals |
TNRO | Number range objects |
ALV (ABAP List Viewer) Layouts / Table Controls | |
LTDX-T | ALV display layouts |
LTDXD/S | Default display variants |
TCVIEW | Table control views (user settings) |
User Administration / Authorizations | |
USR01/3 | User master / address data (View V_ADDR_USR) |
USR02 | Logon data (including "Lock status") |
USR04/5 | Authorizations / Parameter ID |
USR10 | Authorization profiles |
UST12 | Authorizations |
USR12 | Authorization values |
USR21 | Assign user address key [ADRP] |
USR41 | User logon data (sm04) |
UST04 | User -> Profile |
DEVACCESS | Table for development user / key |
USR40 | Prohibited passwords |
USOBT | Transaction -> authorization object |
TSTCA | Transaction -> authorizations |
TOBJ | Authorization objects -> Class assignment |
General ledger (=G/L) accounts | |
SKA1 / T | G/L accounts (chart of accounts) |
SKAS | Chart of accounts: key word list |
SKB1 | G/L accounts (company code) |
SKM1 / T | Sample G/L accounts |
SKPF | Inventory Sampling |
Orders (Cost Accounting) | |
AUFK | Order master data |
AFKO | Order header data PP orders |
AFPO | Order item |
Customer / Creditor | |
KNA1 | Customer Master |
KNAS | VAT registration numbers |
KNB1/5 | Company code / Dunning data |
KNB4 | Customer payment history |
KNBK | Bank details |
KNC1/3 | Transaction Posting figures / Special G/L |
Vendor / Debtor | |
LFA1 | Vendor Master |
LFAS | VAT registration numbers |
LFB1/5 | Company code / Dunning data |
LFBK | Bank details |
LFC1/3 | Transaction figures / Special G/L |
LFM1 | Record purchasing organization |
T078K | Transact.-depend. screen selection |
SAP-FI: Accounting documents (postings) | |
BKPF | Accounting documents |
BSEG | Document line |
BSID | Accounting: Secondary index customers |
BSIK | Accounting: Secondary index vendors |
BSIP | Vendor validation of double doc. |
BSIS | Accounting: Secondary index for G/L |
BSAD | Customers (cleared items) |
BSAK | Vendors (cleared items) |
BSAS | G/L accounts (cleared items) |
BSET | Tax Data Document line |
BSEC | One-Time Account Doc. Line / CpD |
VBKPF | Header for Document Parking |
F111G | Settings Payment Requests |
AGKO | Cleared Accounts |
GLT0 | G/L account transaction figures |
REGUH | Settlement data payment program |
REGUP | Processed items payment program |
REGUT | TemSe - Administration Data |
SAP-CO: Controlling / Cost center | |
CSKA | Cost elements (chart of accounts) |
CSKB | Cost elements (controlling area) |
CSKU | Cost element texts |
CSLA/T | Activity master |
CSKS/T | Cost center: Master |
CSSK | Cost center: Cost element |
CSSL | Cost center: Activity |
COSP | CO Object: Cost Totals for External Postings |
COEP | CO Object: Line Items (by Period) |
COBK | CO Object: Document header |
COST | CO Object: Price Totals |
TKA01/2 | Controlling areas / assignment |
KEKO | Product Costing - Header Data |
KEPH | Cost Components for Cost of Goods Mfd |
KALO | Costing Run: Costing Objects (KVMK) |
KANZ | Sales order items - costing objects |
CEPC-T | Profit Center Master Data Table |
CKPH-T | Master Record: Cost Object ID Number |
SAP Business Address Services | |
ADCP | Person -> Address assignment |
ADRP | Persons |
ADR2 | Telephone Number |
ADRC | Addresses (Business Address Service) |
ADRCITY | Postal cities |
SAP Basis Administration | |
BTCUEV/D | Event ID for background process. |
BTCSEV/D | System event ID for background processing |
BTCJSTAT | Run-time statistics background processing |
CCCFLOW | Client Copy Control Flow |
SDBAC | Database Action Table |
VRSX | Central Table: Version Management |
CVERS | Release Status of Software Components within the SAP System |
PAT03 | Hot packages |
TPROT | Tables to be logged |
DBTABLOG | Log Records of Table Changes |
Transport Requests | |
E070 /E71K | Header of Requests / Tasks (View: E070V) |
E070C | Source / Target Client of Requests / Tasks |
TLOCK | Lock Table |
Variants (Reports & Jobs) | |
VARID/T | Variant for Reports |
TVARV | Variables in selection criteria |
VARI | Variant storage (similar to INDX) |
VARIS | Assignment of variant to selection screen |
SAP Office / Workflow | |
SOFM | Folder contents |
SOOS | Send process |
SWWWIHEAD | Header: All Work Item Types |
SAP Tables - Without Category | |
CDHDR | Change document header |
CDPOS | Change document items |
JCDS / JEST | Change Documents for System / User Status |
JSTO | Status object information |
ARCH_OBJ | Objects for archiving and reorganization |
SNAP | Snapshot for Runtime Errors (Dumps) |
TBTCO | Job status overview |
TBTCP | Batch Input step overview |
DDSHPVAL5 | Personal Help Values |
Currency | |
TCURC/T | Currency codes (Report RFTBFF00) |
TCURR | Exchange Rates (View: V_CURC) |
TCURX/F/V | Decimal places / Conversion Factors / Types |
Calendar Functions | |
T247 | Month name and short text |
T015M | Names of the months |
TFACD | Factory calendar definition |
TTZZ/D | Time Zones / Summer time rules |
THOCI | Public holiday calendar index |
House Banks | |
T012-T | House Banks |
T012A / B | Allocation pmnt methods -> Bank transfer |
T012C | Terms for bank transactions |
T012D | Parameter for DMEs and foreign PM |
T012E | EDI-compatible house banks / PM |
T012K | House Bank Accounts |
T012O | ORBIAN Detail: Bank Accounts, . |
BNKA | Bank Master |
TIBAN | IBAN (International Bank Account Number) |
Interests | |
T056 | Interest settlement |
T056G | Interest calculation rules |
T056R | Interest reference definition |
T056S | Interest scale interest terms |
T056Z | Interest Rates |
T5DCX | Calculation for Contribution Reimbursement |
Taxes | |
T059A/B | Type of Recipient for Vendors |
T059C/D | . per Withholding Tax Type |
T059E/G | Income Types |
T059F | Formulas for Calc. Withholding Tax |
T059K | Withholding tax code; process. key |
T059P/Z | Withholding tax types / tax code; enhanced |
T007A/S | Tax Keys |
T007B | Tax Processing in Accounting |
Payment (= pmnt) Methods | |
T042 | Parameters for payment transactions |
T042A | Bank selection for payment program |
T042B | Details on the company codes that pay |
T042C | Technical Settings: payment program |
T042D | Available amounts for payment program |
T042E | Company code-specific: payment methods |
T042F / H | Payment method supplements |
T042G | Groups of company codes (payment program) |
T042I | Account determination for payment program |
T042J | Bank charges determination |
T042K | Accounts for bank charges |
T042N / L | Bank transaction codes |
T042S | Charges/expenses for automatic pmnt transactions |
T042V | Value date for automatic payments |
T042W | Permitted currency keys for payment method |
T042Z | Payment method for automatic payment |
T008 | Blocking reasons for automatic pmnt transactions |
Tolerance Groups (TG) | |
T043-T | Assign Accounting Clerks > Tolerance Groups |
T043G-T | TG of Customers / Vendors |
T043I | TG for persons proc. Inventory Differences |
T043K | Control of Payment Notices to C/V |
T043S-T | Tolerances for Groups of G/L Accounts |
T043U | Negative grace period |
Enterprise structure / SAP FI Basis Customizing | |
T000/1 | Clients / Company Codes (= CC) |
T880 | Global Company Data |
T003-T | Document Types |
T004 | Directory of Charts of Accounts |
T077S | G/L account groups |
T009 | Fiscal Year Variants |
T014 | Credit control areas |
T010O/P | Posting period variant |
T001B | Permitted Posting Periods |
T002 | Language Keys |
T005-T | Countries |
T006 | Units of Measurement |
TGSB-T | Business Areas |
Tips & Tricks - SAP Tables
Download SAP Tables Cheat Sheet - as PDF
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).
Table-Types
There are 4 Table-Types within the SAP System:
- Tables which have technical control functions within the SAP system. They are maintained either by SAP or by users with special authorization.
- Other tables contain basic commercial data (bank data, currency ...).
- Tables for the organization of a company (company codes, customer data ...).
- 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 - Tips & Tricks to maintain them, are provided on the linked pages.
The work-life-balance: Klingon Programmers with more global approach and a variety of international team members.
Specifying and developing software is more often than not (and despite all efforts to regulate it), a process, which easily gets out of control, see If Architects Had To Work Like Programmers — and be aware of the subtle differences.