SAP table T003 (Document Types)

The SAP table T003 is an integral component within the SAP ERP system, serving as the repository for Document Types in the Financial Accounting (FI) module. Document Types are crucial in SAP as they define the characteristics of documents that are posted within the system, such as invoices, credit memos, payments, and other financial transactions. They help in distinguishing different types of accounting documents and control how these documents are processed and managed within the system.

In SAP, common accounting document types are predefined to handle various financial transactions. Each document type has specific functionalities and controls that help in processing and managing accounting documents accurately. Here are some of the most common accounting document types in SAP:

  1. SA (General Ledger Account Document):

    • Used for general ledger postings that do not fit into other specific document types.
    • Examples include adjustments, corrections, and manual entries.
  2. KR (Vendor Invoice):

    • Used for recording vendor invoices.
    • Ensures proper recording and tracking of liabilities and payables.
  3. KZ (Vendor Payment):

    • Used for recording payments made to vendors.
    • Helps in managing cash outflows and tracking payment statuses.
  4. DR (Customer Invoice):

    • Used for recording customer invoices.
    • Facilitates revenue recognition and tracking of receivables.
  5. DZ (Customer Payment):

    • Used for recording payments received from customers.
    • Aids in cash management and reconciliation of receivables.
  6. AB (Asset Posting):

    • Used for asset transactions, including acquisitions, retirements, and transfers.
    • Ensures accurate recording and management of fixed assets.
  7. AF (Depreciation Posting):

    • Used for recording depreciation of assets.
    • Important for asset accounting and financial reporting.
  8. RE (Recurring Entry):

    • Used for recurring transactions that occur at regular intervals.
    • Simplifies repetitive postings, such as monthly rent or utility expenses.
  9. RN (Reversal Document):

    • Used for reversing previously posted documents.
    • Ensures corrections are accurately tracked and documented.
  10. SB (G/L Account Clearing):

    • Used for clearing open items in general ledger accounts.
    • Helps in reconciliation and maintaining accurate account balances.
  11. CP (Controlling Document):

    • Used for internal postings within the Controlling (CO) module.
    • Includes cost allocations, internal orders, and activity allocations.
  12. FI (Invoice Verification):

    • Used in the Materials Management (MM) module for posting invoices verified against purchase orders.
    • Ensures accurate integration between procurement and financial accounting.
  13. MM (Goods Movement):

    • Used in the Materials Management (MM) module for recording goods movements, such as goods receipts and issues.
    • Helps in maintaining accurate inventory and financial records.

These document types help in categorizing and managing various financial transactions within the SAP system, ensuring that each transaction is processed according to predefined rules and controls. This categorization aids in accurate financial reporting, compliance, and effective financial management.

SAP table T003 has 2 primary key fields being MANDT,BLART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BLART Document Type CHAR 2 0 BLART
NUMKR Number Range CHAR 2 0 NUMKR
KOARS Account Types Allowed CHAR 5 0 KOARS_003
STBLA Document Type CHAR 2 0 T003 STBLA_003
XNETB Indicator: Document posted net ? CHAR 1 0 XNETB
XRVUP Indicator: Posting from SAP Billing Document? CHAR 1 0 XRVUP
XSYBL Indicator: Document Type Can Only Be Used in Batch Input CHAR 1 0 XSYBL
XVORK Indicator: Document Type for Initial Account Assignment? CHAR 1 0 XVORK
XKKPR Indicator: Only One Customer/Vendor Allowed CHAR 1 0 XKKPR
XGSUB Inter-Company Posting CHAR 1 0 XGSUB
XMGES Indicator: Trading Partner Can Be Entered Manually CHAR 1 0 XMGES
BRGRU Authorization Group CHAR 4 0 * BRGRU
RECID Debit Recovery Indicator CHAR 2 0 T8JW JV_RECINDD
RECIC Recovery Indicator Credit CHAR 2 0 T8JW JV_RECINDC
XMTXT Indicator: Document Header Text CHAR 1 0 XMTXT
XMREF Indicator: Reference Number CHAR 1 0 XMREF
XNGBK Indicator: Document Type for Posting Subsequent Adjustment CHAR 1 0 XNGBK
KURST Exchange Rate Type for Determining the Proposed Rate CHAR 4 0 TCURV KURST_003
XNEGP Indicator: Negative Postings Permitted CHAR 1 0 XNEGP_BLA
XKOAA Indicator: Are Postings to Assets Permitted? CHAR 1 0 XKOAA
XKOAD Indicator: Are Postings to Customer Permitted? CHAR 1 0 XKOAD
XKOAK Indicator: Are Postings to Vendor Permitted? CHAR 1 0 XKOAK
XKOAM Indicator: Are Postings to Material Account Permitted? CHAR 1 0 XKOAM
XKOAS Indicator: Are Postings to G/L Account Permitted? CHAR 1 0 XKOAS
XNMRL Document Type Relevant for Official Numbering CHAR 1 0 J_1ANUMREL
XAUSG Self-Issued Document CHAR 1 0 J_1ASELFIS
XDTCH Check Posting Date when Issuing Official Document Number CHAR 1 0 J_1ADATCHK
BLKLS Document Class CHAR 1 0 J_1ADOCCLS J_1ADOCCL_
XROLLUP Indicator: Document Type Allowed for Rollup CHAR 1 0 G_DOCTY_ROLLUP
XPLAN Indicator: Document Type Allowed for Planning CHAR 1 0 G_DOCTY_PLAN
XALLOCACT Indicator: Document Type Allowed for Actual Allocation CHAR 1 0 G_DOCTY_ALLOC_ACT
XALLOCPLAN Indicator: Document Type Allowed for Plan Allocation CHAR 1 0 G_DOCTY_ALLOC_PLAN
X_PP_PROCESS Indicator: Exchange Rate Diffs Partial Payments by Period CHAR 1 0 X_PP_PROCESS
XKURSX Indicator: Market Data Exchange Rate CHAR 1 0 X_FXR_RATEX
XPOSACC Indicator: Allow Posting to Position or Equivalent Accounts CHAR 1 0 X_MCA_POSACC
XUACPA Accounting Principle Assignment Is Unique in Document CHAR 1 0 XUACPA
XKOASECC Indicator: Are postings to secondary costs permitted? CHAR 1 0 XKOASECC
XMREF2 Long Invoice Reference Required CHAR 1 0 XMREF2

T003 foreign key relationships

Table Field Check Table Check Field
0 T003 BLKLS J_1ADOCCLS Official document class for Argentina MANDT
0 T003 BLKLS J_1ADOCCLS Official document class for Argentina J_1ACOCCLS
1 T003 KURST TCURV Exchange rate types for currency translation MANDT
1 T003 KURST TCURV Exchange rate types for currency translation KURST
0 T003 MANDT T000 Clients MANDT
1 T003 RECIC T8JW Internal Recovery Indicator MANDT
0 T003 RECID T8JW Internal Recovery Indicator MANDT
1 T003 STBLA T003 Document Types MANDT