12/7/2020 SAP Tables — Overview

SAP Tables
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 SAP Business Address Services
DD01L Domains ADCP Person -> Address assignment
DD02L/T/V SAP Tables (se11) ADRP Persons
DD03L/T Table Fields (View: DD03VT) ADR2 Telephone Number
DD04L/T Data elements ADRC Addresses (Business Address Service)
DD07L Values for the domains (View: DD07V) ADRCITY Postal cities
DD09L Technical settings of tables SAP Basis Administration
DD12L Secondary Indices BTCUEV/D Event ID for background process.
TDEVC-T Packages (Development class) BTCSEV/D System event ID for background processing
TFDIR,TFTIT Function Module (se37) / FM short text BTCJSTAT Run-time statistics background processing
ENLFDIR Add. Attributes: Function Modules CCCFLOW Client Copy Control Flow
TADIR-T Directory of Repository Objects SDBAC Database Action Table
TRDIR Programs / Sources (REPOSRC / D010SINF) VRSX Central Table: Version Management
TMDIR Methods in a class Release Status of Software Components within
CVERS
D010TAB Where Used: Report - Tables the SAP System
TAPLT Program Application Long Texts PAT03 Hot packages
SEOCLASS ABAP Objects Class TPROT Tables to be logged
D020S/T Screen Short Description DBTABLOG Log Records of Table Changes
TSE05 ABAP Editor insert commands Transport Requests
DM42S Table relationship (sd11) E070 /E71K Header of Requests / Tasks (View: E070V)
T100 Messages E070C Source / Target Client of Requests / Tasks
TSTC-T Transaction Codes (= TC) TLOCK Lock Table
TSTCP Parameter for transactions
Variants (Reports & Jobs)
FILEPATH Logical file names
VARID/T Variant for Reports
PATH Physical paths / file names
TVARV Variables in selection criteria
SYST ABAP System Fields (structure)
VARI Variant storage (similar to INDX)
VBMOD Update function modules (Registered)
VARIS Assignment of variant to selection screen
VBDATA Update data
Text / Print / Spool / SAP Documentation SAP Office / Workflow
SOFM Folder contents
STXFADM Smart Forms: Administration
SOOS Send process
STXB Texts in non-SAP script format
SWWWIHEAD Header: All Work Item Types
STXH SAP script text file header
STXL SAP script text file lines SAP Tables - Without Category
TSP01 Spool Requests CDHDR Change document header
TSP02 Print Requests CDPOS Change document items
TST01/03 TemSe - header and data (= Temp. Sequential) JCDS / JEST Change Documents for System / User Status
TTXOB/T, Valid text objects, see TTXID for text IDs JSTO Status object information
DOKIL Index for Documentation Table DOKH ARCH_OBJ Objects for archiving and reorganization
DOKHL Documentation: Headers SNAP Snapshot for Runtime Errors (Dumps)
DOKTL Documentation - text lines TBTCO Job status overview
TBTCP Batch Input step overview
Number ranges
DDSHPVAL5 Personal Help Values
NRIV Number range intervals
TNRO Number range objects Currency
ALV (ABAP List Viewer) Layouts / Table Controls TCURC/T Currency codes (Report RFTBFF00)
TCURR Exchange Rates (View: V_CURC)
LTDX-T ALV display layouts
TCURX/F/V Decimal places / Conversion Factors / Types
LTDXD/S Default display variants
TCVIEW Table control views (user settings) Calendar Functions
User Administration / Authorizations T247 Month name and short text
T015M Names of the months
User master / address data (View
USR01/3 TFACD Factory calendar definition
V_ADDR_USR)
USR02 Logon data (including "Lock status") TTZZ/D Time Zones / Summer time rules
USR04/5 Authorizations / Parameter ID THOCI Public holiday calendar index
USR10 Authorization profiles House Banks
UST12 Authorizations T012-T House Banks
USR12 Authorization values T012A / B Allocation pmnt methods -> Bank transfer
USR21 Assign user address key [ADRP] T012C Terms for bank transactions
USR41 User logon data (sm04) T012D Parameter for DMEs and foreign PM
UST04 User -> Profile T012E EDI-compatible house banks / PM
DEVACCESS Table for development user / key T012K House Bank Accounts
USR40 Prohibited passwords T012O ORBIAN Detail: Bank Accounts, .
USOBT Transaction -> authorization object BNKA Bank Master
TSTCA Transaction -> authorizations TIBAN IBAN (International Bank Account Number)
TOBJ Authorization objects -> Class assignment Interests
General ledger (=G/L) accounts T056 Interest settlement
SKA1 / T G/L accounts (chart of accounts) T056G Interest calculation rules
SKAS Chart of accounts: key word list T056R Interest reference definition
SKB1 G/L accounts (company code) T056S Interest scale interest terms

https://www.system-overload.org/sap/tables.html 1/3
12/7/2020 SAP Tables — Overview
SKM1 / T Sample G/L accounts T056Z Interest Rates
SKPF Inventory Sampling T5DCX Calculation for Contribution Reimbursement
Orders (Cost Accounting) Taxes
AUFK Order master data T059A/B Type of Recipient for Vendors
AFKO Order header data PP orders T059C/D . per Withholding Tax Type
AFPO Order item T059E/G Income Types
Customer / Creditor T059F Formulas for Calc. Withholding Tax
KNA1 Customer Master T059K Withholding tax code; process. key
KNAS VAT registration numbers T059P/Z Withholding tax types / tax code; enhanced
KNB1/5 Company code / Dunning data T007A/S Tax Keys
KNB4 Customer payment history T007B Tax Processing in Accounting
KNBK Bank details Payment (= pmnt) Methods
KNC1/3 Transaction Posting figures / Special G/L T042 Parameters for payment transactions
Vendor / Debtor T042A Bank selection for payment program
LFA1 Vendor Master T042B Details on the company codes that pay
LFAS VAT registration numbers T042C Technical Settings: payment program
LFB1/5 Company code / Dunning data T042D Available amounts for payment program
LFBK Bank details T042E Company code-specific: payment methods
LFC1/3 Transaction figures / Special G/L T042F / H Payment method supplements
LFM1 Record purchasing organization T042G Groups of company codes (payment program)
T078K Transact.-depend. screen selection T042I Account determination for payment program
T042J Bank charges determination
SAP-FI: Accounting documents (postings) T042K Accounts for bank charges
BKPF Accounting documents T042N / L Bank transaction codes
BSEG Document line
Charges/expenses for automatic pmnt
BSID Accounting: Secondary index customers T042S
transactions
BSIK Accounting: Secondary index vendors T042V Value date for automatic payments
BSIP Vendor validation of double doc. T042W Permitted currency keys for payment method
BSIS Accounting: Secondary index for G/L T042Z Payment method for automatic payment
BSAD Customers (cleared items) Blocking reasons for automatic pmnt
BSAK Vendors (cleared items) T008
transactions
BSAS G/L accounts (cleared items)
Tolerance Groups (TG)
BSET Tax Data Document line
T043-T Assign Accounting Clerks > Tolerance Groups
BSEC One-Time Account Doc. Line / CpD T043G-T TG of Customers / Vendors
VBKPF Header for Document Parking T043I TG for persons proc. Inventory Differences
F111G Settings Payment Requests T043K Control of Payment Notices to C/V
AGKO Cleared Accounts T043S-T Tolerances for Groups of G/L Accounts
GLT0 G/L account transaction figures T043U Negative grace period
REGUH Settlement data payment program
REGUP Processed items payment program
Enterprise structure / SAP FI Basis Customizing
REGUT TemSe - Administration Data T000/1 Clients / Company Codes (= CC)
T880 Global Company Data
SAP-CO: Controlling / Cost center T003-T Document Types
CSKA Cost elements (chart of accounts) T004 Directory of Charts of Accounts
CSKB Cost elements (controlling area) T077S G/L account groups
CSKU Cost element texts T009 Fiscal Year Variants
CSLA/T Activity master T014 Credit control areas
CSKS/T Cost center: Master T010O/P Posting period variant
CSSK Cost center: Cost element T001B Permitted Posting Periods
CSSL Cost center: Activity
T002 Language Keys
COSP CO Object: Cost Totals for External Postings
T005-T Countries
COEP CO Object: Line Items (by Period)
T006 Units of Measurement
COBK CO Object: Document header
TGSB-T Business Areas
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

Tips & Tricks - SAP Tables

D O W N L O A D SAP T A B L E S C H E A T S H E E T - A S 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).

T A B L E -T Y P E S

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.

https://www.system-overload.org/sap/tables.html 2/3
12/7/2020 SAP Tables — Overview
2. Other tables contain basic commercial data (bank data, currency ...).
3. Tables for the organization of a company (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 - 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.

https://www.system-overload.org/sap/tables.html 3/3