第 1 页 / 共 2 页
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 Page 1 of 2
| DBTABLOG | Log Records of Table Changes |
|---|---|
| Transports Copyright 2011 |
| VARIS | Assignment of variant to selection screen |
|---|---|
| SAP Office / Workflow |
| PTREQ_STATUS_TRA | Status Transfers |
|---|---|
| SAP Tables - Without Category |
| TNRO | Number range objects |
|---|---|
| ALV (ABAP List Viewer) layouts / Table Controls |
第 2 页 / 共 2 页
List of SAP tables (Customizing & Operational) – Sorted by Category Overview of Important SAP Tables
Interests Orders (Cost Accounting)
T056 Interest settlement AUFK Order master data
T056G Interest calculation rules AFKO Order header data PP orders
T056R Interest reference definition AFPO Order item
T056S Interest scale interest terms Customer / Creditor
T056Z Interest Rates KNA1 Customer Master
T5DCX Calculation for Contribution Reimbursement KNAS VAT registration numbers
Taxes KNB1/5 Company code / Dunning data
T059A/B Type of Recipient for Vendors KNB4 Customer payment history
T059C/D … per Withholding Tax Type KNBK Bank details
T059E/G Income Types KNC1/3 Transaction Posting figures / Special G/L
T059F Formulas for Calc. Withholding Tax Vendor / Debtor
T059K Withholding tax code; process. key LFA1 Vendor Master
T059P/Z Withholding tax types / tax code; enhanced LFAS VAT registration numbers
T007A/S Tax Keys LFB1/5 Company code / Dunning data
T007B Tax Processing in Accounting LFBK Bank details
Payment (= pmnt) Method LFC1/3 Transaction figures / Special G/L
T042 Parameters for payment transactions LFM1 Record purchasing organization
T042A Bank selection for payment program T078K Transact.-depend. screen selection
T042B Details on the company codes that pay SAP-FI: Accounting documents (postings)
T042C Technical Settings: payment program BKPF Accounting documents
T042D Available amounts for payment program BSEG Document line
T042E Company code-specific: payment methods BSID Accounting: Secondary index customers
T042F / H Payment method supplements BSIK Accounting: Secondary index vendors
T042G Groups of company codes (payment program) BSIP Vendor validation of double doc.
T042I Account determination for payment program BSIS Accounting: Secondary index for G/L
T042J Bank charges determination BSAD Customers (cleared items)
T042K Accounts for bank charges BSAK Vendors (cleared items)
T042N / L Bank transaction codes BSAS G/L accounts (cleared items)
T042S Charges/expenses for automatic pmnt transactions BSET Tax Data Document line
T042V Value date for automatic payments BSEC One-Time Account Doc. Line / CpD
T042W Permitted currency keys for payment method VBKPF Header for Document Parking
T042Z Payment method for automatic payment F111G Settings Payment Requests
T008 Blocking reasons for automatic pmnt transactions AGKO Cleared Accounts
Tolerance Groups (TG) GLT0 G/L account transaction figures
T043-T Assign Accounting Clerks > Tolerance Groups REGUH Settlement data payment program
T043G-T TG of Customers / Vendors REGUP Processed items payment program
T043I TG for persons proc. Inventory Differences REGUT TemSe - Administration Data
T043K Control of Payment Notices to C/V SAP-CO: Controlling / Cost center
T043S-T Tolerances for Groups of G/L Accounts CSKA Cost elements (chart of accounts)
T043U Negative grace period CSKB Cost elements (controlling area)
Enterprise structure / FI Basis Customizing CSKU Cost element texts
T000/1 Clients / Company Codes (= CC) CSLA/T Activity master
T880 Global Company Data CSKS/T Cost center: Master
T003-T Document Types CSSK Cost center: Cost element
T004 Directory of Charts of Accounts CSSL Cost center: Activity
T077S G/L account groups COSP CO Object: Cost Totals for External Postings
T009 Fiscal Year Variants COEP CO Object: Line Items (by Period)
T014 Credit control areas COBK CO Object: Document header
T010O/P Posting period variant COST CO Object: Price Totals
T001B Permitted Posting Periods TKA01/2 Controlling areas / assignment
T002 Language Keys KEKO Product Costing - Header Data
T005-T Countries KEPH Cost Components for Cost of Goods Mfd
T006 Units of Measurement KALO Costing Run: Costing Objects (KVMK)
TGSB-T Business Areas KANZ Sales order items - costing objects
General ledger (=G/L) accounts CEPC-T Profit Center Master Data Table
SKA1 / T G/L accounts (chart of accounts) CKPH-T Master Record: Cost Object ID Number
SKAS Chart of accounts: key word list Own Tables (Y, Z namespace)
SKB1 G/L accounts (company code)
SKM1 / T Sample G/L accounts
SKPF Inventory Sampling
Vendor, Customer, Banks, Taxes, Currency, SAP-CO, SAP-FI, Data Dictionary, Spool, User Authorizations – SAP Tables – Available from http://www.connexin.net/ © 2013 Page 2 of 2
| T5DCX | Calculation for Contribution Reimbursement |
|---|---|
| Taxes |
| KNC1/3 | Transaction Posting figures / Special G/L |
|---|---|
| Vendor / Debtor |
| T007B | Tax Processing in Accounting |
|---|---|
| Payment (= pmnt) Method |
| REGUT | TemSe - Administration Data |
|---|---|
| SAP-CO: Controlling / Cost center |
| T043U | Negative grace period |
|---|---|
| Enterprise structure / FI Basis Customizing |
| CKPH-T | Master Record: Cost Object ID Number |
|---|---|
| Own Tables (Y, Z namespace) |