T003_I
Document types
T003_I is an SAP database table in S/4HANA. Document types. It contains 12 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AR_DocumentTypeClass | view_entity | from | BASIC | Document Class For Self Issued Documents |
| I_CountrySpecificDocumentType | view | from | BASIC | Determining Country Specific Doc Type |
| I_DocTypeOfclDocClassAssgmt | view | from | BASIC | Document Type Official Doc Class Assgmt |
| I_TW_DeterminedDocumentClass | view | from | BASIC | Determined Document Class |
| I_TW_DeterminedDocumentClass | view | union | BASIC | Determined Document Class |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | land1 | LAND1 | Country/Reg. | |||
| KEY | blart | BLART | Document Type | |||
| doccls | DOCCLS | Doc.class | ||||
| xausg | J_1ASELFIS | Self-issued doc. | ||||
| xdtch | J_1ADATCHK | Check Date | ||||
| xin68 | J_1BIN68REL | Check IN68 Relevant | ||||
| xoptyp | J_1BOPERTYP | IN86 Operation Type | ||||
| xin86 | J_1BIN86REL | Check IN86 Relevant | ||||
| xforce | J_1AFORCENUM | Force Numbering | ||||
| xcirel | J_1ACIREL | Credit Invoice | ||||
| offnrel | J_1AOFFNREL | Official Doc.Number |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Document types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T003_I (
MANDT, -- Client [MANDT]
LAND1, -- Country/Reg. [LAND1]
BLART, -- Document Type [BLART]
DOCCLS, -- Doc.class [DOCCLS]
XAUSG, -- Self-issued doc. [J_1ASELFIS]
XDTCH, -- Check Date [J_1ADATCHK]
XIN68, -- Check IN68 Relevant [J_1BIN68REL]
XOPTYP, -- IN86 Operation Type [J_1BOPERTYP]
XIN86, -- Check IN86 Relevant [J_1BIN86REL]
XFORCE, -- Force Numbering [J_1AFORCENUM]
XCIREL, -- Credit Invoice [J_1ACIREL]
OFFNREL, -- Official Doc.Number [J_1AOFFNREL]
PRIMARY KEY (MANDT, LAND1, BLART)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA