Friday, September 6, 2024

T003: Document Types

T003 is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores Document Types data. There are total 39 fields in the table. The T003 table can be found in the Financial Accounting General Services ‘Basis’ (FBASCORE) package and is part of the Financial Accounting (FI) module.

SAP HANA Table Type Column Store
Buffering Permission Buffering switched on
Buffering Type Full buffering as specified by generic key

T003 Table Fields

The following is the list of fields that are available in SAP T003 table. The key fields of the table are highlighted in color.

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

Availability

The SAP HANA table T003 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Released
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for T003 table

We’re updating the content all the time, so check back regularly.