Read SAP tables text version

Overview of Important SAP Tables

ABAP / Data Dictionary

DD01L DD02L/T/V DD03L/T DD04L DD09L DD12L DD03VT TDEVC-T TFDIR TADIR TRDIR REPOSRC D010SINF D010TAB TAPLT ENLFDIR VARID/T SEOCLASS D020S/T TSE05 DM42S T100 TSTC-T FILEPATH SYST STXFADM STXB STXH STXL TSP01 TSP02 TST03 TTXOB/T NRIV TNRO LTDX-T LTDXD LTDXS TCVIEW USR01 USR02 USR03 USR04 USR05 USR10 UST12 USR12 USR21 USOBT TSTCA TOBJ TOBC DEVACCESS USR41 UST04 USR40 ADCP

Domains SAP Tables (se11) Table Fields Data elements Technical settings of tables Secondary Indices Fields of a table Packages (Development class) Function Module (se37) Directory of Repository Objects Programs Report Sources Add. Information for Repos. Obj. Use: Report<->Tables Program Application Long Texts Add. Attributes: Function Modules Variant for Reports ABAP Objects Class Screen Short Description ABAP Editor insert commands Table relationship (sd11) Messages Transaction Codes (= TC) Logical filenames ABAP System Fields (structure) Smart Forms: Administration Texts in non-SAP script format SAP script text file header SAP script text file lines Spool Requests Print Requests TemSe data (= Temp. Sequential) Valid text objects Number range intervals Number range objects ALV display layouts Default display variants SAP Default Display Variants Table control views (user settings) User master Logon data (including "Lock status") User address data User master authorizations User Master Parameter ID User master authorization profiles User master: Authorizations User Master Authorization Values Assign user address key [ADRP] Transaction > authorization object Transaction > authorizations Authorization Objects Class assignment of authorization objects Table for development user User logon data (sm04) User > Profile Prohibited passwords Person/Address Assignment

ADRP ADR2 BTCUEV/D BTCSEV/D BTCJSTAT CCCFLOW SDBAC VRSX CVERS

Persons Telephone Number Event ID for background process. System event ID for background p. Run-time statistics background p. Client Copy Control Flow Database Action Table Central Table: Version Management Release Status of Software Components in System

System Administration www.smart-words.org

E070 /E71K Transp.: Header of Requests/Tasks TLOCK Transport: Lock Table TPROT Tables to be logged DBTABLOG PAT03 Log Records of Table Changes Hot packages Folder contents Send process Header: All Work Item Types Status Transfers document header document items System / User Status for archiving and reorganization

SAP Office / Workflow

SOFM SOOS SWWWIHEAD PTREQ_STATUS_TRA

Without Category

CDHDR CDPOS JCDS / JEST ARCH_OBJ SNAP TBTCO TBTCP TVARV

Currency

Change Change Change Objects

Text / Print / Spool

Snapshot for Runtime Errors Job status overview Batch Input step overview Variables in selection criteria Currency codes Exchange Rates Decimal places for currencies Conversion Factors Exchange Rates Types Month name and short text Names of the months Factory calendar definition Time Zones Summer time rules Public holiday calendar index Interest Interest Interest Interest settlement calculation rules reference definition scale interest terms

TCURC/T TCURR TCURX TCURF TCURV T247 T015M TFACD TTZZ TTZD THOCI

Interests

Number ranges

Calendar functions

ALV layouts / Table Controls

User Administration / Authorization

T056 T056G T056R T056S T056Z T5DCX

Taxes

Interest Rates Calculation for Contribution Reimbursement Type of Recipient for Vendors ... per Withholding Tax Type Income Types Formulas for Calc. Withholding Tax Withholding tax code / process. key Withholding tax types Withholding tax code; enhanced Tax Keys Tax Processing in Accounting

T059A/B T059C/D T059E/G T059F T059K T059P T059Z T007A/S T007B

List of SAP tables (Customizing / Operational): Vendor, Customer, Banks, Taxes, Currency, SAP-CO, SAP-FI, System, Data Dictionary, Spool, User Authorizations, ALV Layouts

© 2010

Page 1 of 2

Overview of Important SAP Tables

House Bank

T012-T T012A / B T012C T012D T012E T012K T012O BNKA ADRC ADRCITY TIBAN T042 T042A T042B T042C T042D T042E T042F / H T042G T042I T042J T042K T042N / L T042S T042V T042W T042Z T008 T043-T T043G-T T043I T043K T043S-T T043U T000 T001 T880 T003-T T004 T077S T009 T014 T010O/P T001B T002 T005-T T006 TGSB-T AUFK AFKO

House Banks Allocation pmnt methods -> Bank transfer Terms for bank transactions Parameter for DMEs and foreign PM EDI-compatible house banks / PM House Bank Accounts ORBIAN Detail: Bank Accounts, ... Bank Master Addresses (Business Address Service) Postal cities IBAN (International Bank Account Number) Parameters for PM Bank selection for payment p. Details on the company that pays Technical Settings: Payment p. Available amounts for payment p. Company Code-Specific Payment method supplements Groups of com. codes :payment p. Acc. determination for payment p Bank charges determination Accounts for bank charges Bank transaction codes Charges/expenses for automatic p. Value date for automatic payments Permitted currency keys for PM PM for Automatic Payment Blocking reasons for payment t. Assign Accounting Clerks > TG TG of Customers / Vendors TG for Persons Proc. Inventory Diff. Control of Payment Notices to C/V Tolerances for Groups of G/L Accounts Negative grace period Clients Company Codes (= CC) Global Company Data Document Types Directory of Charts of Accounts G/L account groups Fiscal Year Variants Credit control areas Posting period variant Permitted Posting Periods Language Keys Countries Units of Measurement Business Areas Order master data Order header data PP orders

KNB4 KNB5 KNBK KNC1 KNC3

Vendor

Customer payment history Dunning data Bank details Transaction figures Special G/L transaction figures Vendor Master VAT registration numbers Company code Dunning data Bank details Transaction figures Special G/L transaction figures Record purchasing organization Transact.-depend. screen selection G/L accounts (chart of accounts) chart of accounts: key word list G/L accounts (company code) Sample G/L accounts Inventory Sampling Accounting documents Document line Accounting: Sec. index customers Accounting: Sec. index vendors Vendor validation of double doc. Accounting: Sec. index for G/L Customers (cleared items) Vendors (cleared items) G/L accounts (cleared items) Tax Data Document line One-Time Account Doc. Line Header for Document Parking Settings Payment Requests Cleared Accounts G/L account transaction figures Settlement data payment program Processed items payment program TemSe - Administration Data Cost elements (chart of accounts) Cost elements (controlling area) Cost element texts Activity master Cost center master Cost center: Cost element Cost center: Activity Cost Totals for External Postings Line Items (by Period) Document header Price Totals Controlling areas Assignment to company code Product-costing header Cost components for cost of ... Costing objects Sales order items - costing objects Profit Center Master Data Table Master Record: Cost Object ID Number

LFA1 LFAS LFB1 LFB5 LFBK LFC1 LFC3 LFM1 T078K SKA1/T SKAS SKB1 SKM1/T SKPF BKPF BSEG BSID BSIK BSIP BSIS BSAD BSAK BSAS BSET BSEC VBKPF F111G AGKO GLT0 REGUH REGUP REGUT CSKA CSKB CSKU CSLA/T CSKS/T CSSK CSSL COSP COEP COBK COST TKA01 TKA02 KEKO KEPH KALO KANZ CEPC-T CKPH-T

Payment Method (= PM)

General ledger (=G/L) accounts

FI: Accounting documents (postings)

Tolerance Groups

Enterprise structure / FI Basis Customizing

CO: Controlling / Cost center

Orders (Cost Accounting)

AFPO Order item JSTO / JEST Status object information JCDS Order item

Customer

KNA1 KNAS

KNB1

Customer Master VAT registration numbers

Company code

List of SAP tables (Customizing / Operational): Vendor, Customer, Banks, Taxes, Currency, SAP-CO, SAP-FI, System, Data Dictionary, Spool, User Authorizations, ALV Layouts

© 2010

Page 2 of 2

Information

SAP tables

2 pages

Report File (DMCA)

Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

Report this file as copyright or inappropriate

26876


You might also be interested in

BETA
Architecting EDI with SAP IDocs
SAP tables