Quick ReferenceStart - Reference Cards

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
DD01LDomains
DD02L/T/VSAP Tables (se11)
DD03L/TTable Fields (View: DD03VT)
DD04L/TData elements
DD07LValues for the domains (View: DD07V)
DD09LTechnical settings of tables
DD12LSecondary Indices
TDEVC-TPackages (Development class)
TFDIR,TFTITFunction Module (se37) / FM short text
ENLFDIRAdd. Attributes: Function Modules
TADIR-TDirectory of Repository Objects
TRDIRPrograms / Sources (REPOSRC / D010SINF)
TMDIRMethods in a class
D010TABWhere Used: Report - Tables
TAPLTProgram Application Long Texts
SEOCLASSABAP Objects Class
D020S/TScreen Short Description
TSE05ABAP Editor insert commands
DM42STable relationship (sd11)
T100Messages
TSTC-TTransaction Codes (= TC)
TSTCPParameter for transactions
FILEPATHLogical file names
PATHPhysical paths / file names
SYSTABAP System Fields (structure)
VBMODUpdate function modules (Registered)
VBDATAUpdate data
Text / Print / Spool / SAP Documentation
STXFADMSmart Forms: Administration
STXBTexts in non-SAP script format
STXHSAP script text file header
STXLSAP script text file lines
TSP01Spool Requests
TSP02Print Requests
TST01/03TemSe - header and data (= Temp. Sequential)
TTXOB/T, Valid text objects, see TTXID for text IDs
DOKILIndex for Documentation Table DOKH
DOKHLDocumentation: Headers
DOKTLDocumentation - text lines
Number ranges
NRIVNumber range intervals
TNRONumber range objects
ALV (ABAP List Viewer) Layouts / Table Controls
LTDX-TALV display layouts
LTDXD/SDefault display variants
TCVIEWTable control views (user settings)
User Administration / Authorizations
USR01/3User master / address data (View V_ADDR_USR)
USR02Logon data (including "Lock status")
USR04/5Authorizations / Parameter ID
USR10Authorization profiles
UST12Authorizations
USR12Authorization values
USR21Assign user address key [ADRP]
USR41User logon data (sm04)
UST04User -> Profile
DEVACCESSTable for development user / key
USR40Prohibited passwords
USOBTTransaction -> authorization object
TSTCATransaction -> authorizations
TOBJAuthorization objects -> Class assignment
General ledger (=G/L) accounts
SKA1 / TG/L accounts (chart of accounts)
SKASChart of accounts: key word list
SKB1G/L accounts (company code)
SKM1 / TSample G/L accounts
SKPFInventory Sampling
Orders (Cost Accounting)
AUFKOrder master data
AFKOOrder header data PP orders
AFPOOrder item
Customer / Creditor
KNA1Customer Master
KNASVAT registration numbers
KNB1/5Company code / Dunning data
KNB4Customer payment history
KNBKBank details
KNC1/3Transaction Posting figures / Special G/L
Vendor / Debtor
LFA1Vendor Master
LFASVAT registration numbers
LFB1/5Company code / Dunning data
LFBKBank details
LFC1/3Transaction figures / Special G/L
LFM1Record purchasing organization
T078KTransact.-depend. screen selection
SAP-FI: Accounting documents (postings)
BKPFAccounting documents
BSEGDocument line
BSIDAccounting: Secondary index customers
BSIKAccounting: Secondary index vendors
BSIPVendor validation of double doc.
BSISAccounting: Secondary index for G/L
BSADCustomers (cleared items)
BSAKVendors (cleared items)
BSASG/L accounts (cleared items)
BSETTax Data Document line
BSECOne-Time Account Doc. Line / CpD
VBKPFHeader for Document Parking
F111GSettings Payment Requests
AGKOCleared Accounts
GLT0G/L account transaction figures
REGUHSettlement data payment program
REGUPProcessed items payment program
REGUTTemSe - Administration Data
SAP-CO: Controlling / Cost center
CSKACost elements (chart of accounts)
CSKBCost elements (controlling area)
CSKUCost element texts
CSLA/TActivity master
CSKS/TCost center: Master
CSSKCost center: Cost element
CSSLCost center: Activity
COSPCO Object: Cost Totals for External Postings
COEPCO Object: Line Items (by Period)
COBKCO Object: Document header
COSTCO Object: Price Totals
TKA01/2Controlling areas / assignment
KEKOProduct Costing - Header Data
KEPHCost Components for Cost of Goods Mfd
KALOCosting Run: Costing Objects (KVMK)
KANZSales order items - costing objects
CEPC-TProfit Center Master Data Table
CKPH-TMaster Record: Cost Object ID Number
SAP Business Address Services
ADCPPerson -> Address assignment
ADRPPersons
ADR2Telephone Number
ADRCAddresses (Business Address Service)
ADRCITYPostal cities
SAP Basis Administration
BTCUEV/DEvent ID for background process.
BTCSEV/DSystem event ID for background processing
BTCJSTATRun-time statistics background processing
CCCFLOWClient Copy Control Flow
SDBACDatabase Action Table
VRSXCentral Table: Version Management
CVERSRelease Status of Software Components within the SAP System
PAT03Hot packages
TPROTTables to be logged
DBTABLOGLog Records of Table Changes
Transport Requests
E070 /E71KHeader of Requests / Tasks (View: E070V)
E070CSource / Target Client of Requests / Tasks
TLOCKLock Table
Variants (Reports & Jobs)
VARID/TVariant for Reports
TVARVVariables in selection criteria
VARIVariant storage (similar to INDX)
VARISAssignment of variant to selection screen
SAP Office / Workflow
SOFMFolder contents
SOOSSend process
SWWWIHEADHeader: All Work Item Types
SAP Tables - Without Category
CDHDRChange document header
CDPOSChange document items
JCDS / JESTChange Documents for System / User Status
JSTOStatus object information
ARCH_OBJObjects for archiving and reorganization
SNAPSnapshot for Runtime Errors (Dumps)
TBTCOJob status overview
TBTCPBatch Input step overview
DDSHPVAL5Personal Help Values
Currency
TCURC/TCurrency codes (Report RFTBFF00)
TCURRExchange Rates (View: V_CURC)
TCURX/F/VDecimal places / Conversion Factors / Types
Calendar Functions
T247Month name and short text
T015MNames of the months
TFACDFactory calendar definition
TTZZ/DTime Zones / Summer time rules
THOCIPublic holiday calendar index
House Banks
T012-THouse Banks
T012A / BAllocation pmnt methods -> Bank transfer
T012CTerms for bank transactions
T012DParameter for DMEs and foreign PM
T012EEDI-compatible house banks / PM
T012KHouse Bank Accounts
T012OORBIAN Detail: Bank Accounts, .
BNKABank Master
TIBANIBAN (International Bank Account Number)
Interests
T056Interest settlement
T056GInterest calculation rules
T056RInterest reference definition
T056SInterest scale interest terms
T056ZInterest Rates
T5DCXCalculation for Contribution Reimbursement
Taxes
T059A/BType of Recipient for Vendors
T059C/D. per Withholding Tax Type
T059E/GIncome Types
T059FFormulas for Calc. Withholding Tax
T059KWithholding tax code; process. key
T059P/ZWithholding tax types / tax code; enhanced
T007A/STax Keys
T007BTax Processing in Accounting
Payment (= pmnt) Methods
T042Parameters for payment transactions
T042ABank selection for payment program
T042BDetails on the company codes that pay
T042CTechnical Settings: payment program
T042DAvailable amounts for payment program
T042ECompany code-specific: payment methods
T042F / HPayment method supplements
T042GGroups of company codes (payment program)
T042IAccount determination for payment program
T042JBank charges determination
T042KAccounts for bank charges
T042N / LBank transaction codes
T042SCharges/expenses for automatic pmnt transactions
T042VValue date for automatic payments
T042WPermitted currency keys for payment method
T042ZPayment method for automatic payment
T008Blocking reasons for automatic pmnt transactions
Tolerance Groups (TG)
T043-TAssign Accounting Clerks > Tolerance Groups
T043G-TTG of Customers / Vendors
T043ITG for persons proc. Inventory Differences
T043KControl of Payment Notices to C/V
T043S-TTolerances for Groups of G/L Accounts
T043UNegative grace period
Enterprise structure / SAP FI Basis Customizing
T000/1Clients / Company Codes (= CC)
T880Global Company Data
T003-TDocument Types
T004Directory of Charts of Accounts
T077SG/L account groups
T009Fiscal Year Variants
T014Credit control areas
T010O/PPosting period variant
T001BPermitted Posting Periods
T002Language Keys
T005-TCountries
T006Units of Measurement
TGSB-TBusiness 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):

SAP - Overview of SAP Tables (Basis, SAP-FI, SAP-CO

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:

  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 ...).
  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.