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:
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.
KR (Vendor Invoice):
- Used for recording vendor invoices.
- Ensures proper recording and tracking of liabilities and payables.
KZ (Vendor Payment):
- Used for recording payments made to vendors.
- Helps in managing cash outflows and tracking payment statuses.
DR (Customer Invoice):
- Used for recording customer invoices.
- Facilitates revenue recognition and tracking of receivables.
DZ (Customer Payment):
- Used for recording payments received from customers.
- Aids in cash management and reconciliation of receivables.
AB (Asset Posting):
- Used for asset transactions, including acquisitions, retirements, and transfers.
- Ensures accurate recording and management of fixed assets.
AF (Depreciation Posting):
- Used for recording depreciation of assets.
- Important for asset accounting and financial reporting.
RE (Recurring Entry):
- Used for recurring transactions that occur at regular intervals.
- Simplifies repetitive postings, such as monthly rent or utility expenses.
RN (Reversal Document):
- Used for reversing previously posted documents.
- Ensures corrections are accurately tracked and documented.
SB (G/L Account Clearing):
- Used for clearing open items in general ledger accounts.
- Helps in reconciliation and maintaining accurate account balances.
CP (Controlling Document):
- Used for internal postings within the Controlling (CO) module.
- Includes cost allocations, internal orders, and activity allocations.
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.
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 |