SAP ABAP 核心数据表速查手册：按模块分类的常用表清单
SAP 系统中存在成千上万张数据表，掌握各模块的核心表及其关系，是 ABAP 开发、报表查询、接口设计和故障排查的基础。本文按模块分类整理 SAP 常用数据表，并说明关键表的作用与关联关系。
List of SAP tables (Customizing & Operational) – Sorted by Category Overview of Important SAP Tables
ABAP / Data Dictionary 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 Data elements ADRC Addresses (Business Address Service)
DD07L Values for the domains (View: DD07V) ADRCITY Postal cities
DD09L Technical settings of tables SAP System 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 CVERS Release Status of Software Components in System
D010TAB Use: Report<->Tables PAT03 Hot packages
TAPLT Program Application Long Texts TPROT Tables to be logged
SEOCLASS ABAP Objects Class DBTABLOG Log Records of Table Changes
D020S/T Screen Short Description Transports Copyright 2011
TSE05 ABAP Editor insert commands E070 /E71K Header of Requests / Tasks (View: E070V)
DM42S Table relationship (sd11) E070C Source / Target Client of Requests / Tasks
T100 Messages TLOCK Lock Table
TSTC-T Transaction Codes (= TC) Variants Source - ww.connexin.net
TSTCP Parameter for transactions VARID/T Variant for Reports
FILEPATH Logical file names TVARV Variables in selection criteria
PATH Physical paths / file names VARI Variant storage (similar to INDX)
SYST ABAP System Fields (structure) VARIS Assignment of variant to selection screen
VBMOD Update function modules (Registered) SAP Office / Workflow
VBDATA Update data SOFM Folder contents
Text / Print / Spool / SAP Documentation SOOS Send process
STXFADM Smart Forms: Administration SWWWIHEAD Header: All Work Item Types
STXB Texts in non-SAP script format PTREQ_STATUS_TRA Status Transfers
STXH SAP script text file header SAP Tables - Without Category
STXL SAP script text file lines CDHDR Change document header
TSP01 Spool Requests CDPOS Change document items
TSP02 Print Requests JCDS / JEST Change Documents for System / User Status
TST01/03 TemSe - header and data (= Temp. Sequential) JSTO Status object information
TTXOB/T, Valid text objects, see TTXID for text IDs ARCH_OBJ Objects for archiving and reorganization
DOKIL Index for Documentation Table DOKH SNAP Snapshot for Runtime Errors (Dumps)
DOKHL Documentation: Headers TBTCO Job status overview
DOKTL Documentation - text lines TBTCP Batch Input step overview
Number ranges DDSHPVAL5 Personal Help Values
NRIV Number range intervals Currency
TNRO Number range objects TCURC/T Currency codes (Report RFTBFF00)
ALV (ABAP List Viewer) layouts / Table Controls TCURR Exchange Rates (View: V_CURC)
LTDX-T ALV display layouts TCURX/F/V Decimal places / Conversion Factors / Types
LTDXD/S Default display variants Calendar functions
TCVIEW Table control views (user settings) T247 Month name and short text
User Administration / Authorization T015M Names of the months
USR01/3 User master / address data (View V_ADDR_USR) TFACD Factory calendar definition
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 Bank
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
Vendor, Customer, Banks, Taxes, Currency, SAP-CO, SAP-FI, Data Dictionary, Spool, User Authorizations – SAP Tables – Available from http://www.connexin.net/ © 2013
DD02L/T/V | SAP Tables (se11)
ADRP | Persons
DD04L | Data elements
ADRC | Addresses (Business Address Service)
DD09L | Technical settings of tables
TDEVC-T | Packages (Development class)
BTCSEV/D | System event ID for background processing
ENLFDIR | Add. Attributes: Function Modules
CCCFLOW | Client Copy Control Flow
TRDIR | Programs / Sources (REPOSRC / D010SINF)
VRSX | Central Table: Version Management
D010TAB | Use: Report<->Tables
PAT03 | Hot packages
SEOCLASS | ABAP Objects Class
DBTABLOG | Log Records of Table Changes
Transports Copyright 2011 |
TSE05 | ABAP Editor insert commands
E070C | Source / Target Client of Requests / Tasks
T100 | Messages
TSTCP | Parameter for transactions
TVARV | Variables in selection criteria
PATH | Physical paths / file names
VARIS | Assignment of variant to selection screen
SAP Office / Workflow |
VBMOD | Update function modules (Registered)
SOOS | Send process
STXB | Texts in non-SAP script format
PTREQ_STATUS_TRA | Status Transfers
SAP Tables - Without Category |
STXL | SAP script text file lines
CDPOS | Change document items
TSP02 | Print Requests
JSTO | Status object information
TTXOB/T, | Valid text objects, see TTXID for text IDs
SNAP | Snapshot for Runtime Errors (Dumps)
DOKHL | Documentation: Headers
TBTCP | Batch Input step overview
TNRO | Number range objects
ALV (ABAP List Viewer) layouts / Table Controls |
TCURR | Exchange Rates (View: V_CURC)
LTDXD/S | Default display variants
T015M | Names of the months
USR02 | Logon data (including “Lock status”)
TTZZ/D | Time Zones / Summer time rules
USR10 | Authorization profiles
USR12 | Authorization values
T012A / B | Allocation pmnt methods -> Bank transfer
USR41 | User logon data (sm04)
T012D | Parameter for DMEs and foreign PM
T012K | House Bank Accounts
USR40 | Prohibited passwords
BNKA | Bank Master
TSTCA | Transaction > authorizations
...
