List of Useful SAP Tables: ABAP, Data Dictionary, SAP-FI ...

1 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 / D010 SINF) VRSX Central Table: Version Management TMDIR Methods in a class CVERS Release Status of Software Components in System D010 TAB 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.

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

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

4 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 2013 Page 1 of 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 T5 DCX 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.

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

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

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

8 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 2013 Page 2 of 2.