T003

Transparent Table Customizing Table
39 Fields 6 CDS Views

Document Types

T003 is an SAP database table in S/4HANA. Document Types. It contains 39 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
FAC_DART_Z3_DOCUMENTTYPE view from Document Type Master Data
FISCDS_BLART_VH view from Journal Entry Type/Text
I_AccountingDocumentType view from BASIC Journal Entry Type
P_AccountingDocumentType view from BASIC
P_PAYTRCPTAcctgDocType view from BASIC
TSI_BSEGK_entry view left_outer

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY blart BLART Document Type
numkr NUMKR Number Range
koars KOARS_003 Account Types
stbla STBLA_003 Document Type
xnetb XNETB Net document type
xrvup XRVUP SAP Bill.Doc.
xsybl XSYBL BI Only
xvork XVORK Init.Acct Assignment
xkkpr XKKPR Cust/vend Check
xgsub XGSUB Inter-Company
xmges XMGES Enter Trading Part.
brgru BRGRU Authorization
recid JV_RECINDD Debit Rec.Indic
recic JV_RECINDC Rec.Ind. Credit
xmtxt XMTXT Document Header Text
xmref XMREF Reference Number
xngbk XNGBK For Subseq.Adjustmnt
kurst KURST_003 Exchange Rate Type for FC Documents
xnegp XNEGP_BLA Negative Postings Permitted
xkoaa XKOAA Assets
xkoad XKOAD Customer
xkoak XKOAK Supplier
xkoam XKOAM Material
xkoas XKOAS G/L Account
xnmrl J_1ANUMREL Official numbering
xausg J_1ASELFIS Self-issued doc.
xdtch J_1ADATCHK Check Date
blkls J_1ADOCCL_ Document Class
xrollup G_DOCTY_ROLLUP Rollup
xplan G_DOCTY_PLAN Planning
xallocact G_DOCTY_ALLOC_ACT Act.Allocation
xallocplan G_DOCTY_ALLOC_PLAN Plan.Allocation
x_pp_process X_PP_PROCESS ERD Part. Payts
xkursx X_FXR_RATEX MD Exchange Rate
xposacc X_MCA_POSACC Pos. Acccounts
xuacpa XUACPA AP Assgmnt Is Unique
xkoasecc XKOASECC Secondary Costs
xmref2 XMREF2 Reference required

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 (
    MANDT,         -- Client [MANDT]
    BLART,         -- Document Type [BLART]
    NUMKR,         -- Number Range [NUMKR]
    KOARS,         -- Account Types [KOARS_003]
    STBLA,         -- Document Type [STBLA_003]
    XNETB,         -- Net document type [XNETB]
    XRVUP,         -- SAP Bill.Doc. [XRVUP]
    XSYBL,         -- BI Only [XSYBL]
    XVORK,         -- Init.Acct Assignment [XVORK]
    XKKPR,         -- Cust/vend Check [XKKPR]
    XGSUB,         -- Inter-Company [XGSUB]
    XMGES,         -- Enter Trading Part. [XMGES]
    BRGRU,         -- Authorization [BRGRU]
    RECID,         -- Debit Rec.Indic [JV_RECINDD]
    RECIC,         -- Rec.Ind. Credit [JV_RECINDC]
    XMTXT,         -- Document Header Text [XMTXT]
    XMREF,         -- Reference Number [XMREF]
    XNGBK,         -- For Subseq.Adjustmnt [XNGBK]
    KURST,         -- Exchange Rate Type for FC Documents [KURST_003]
    XNEGP,         -- Negative Postings Permitted [XNEGP_BLA]
    XKOAA,         -- Assets [XKOAA]
    XKOAD,         -- Customer [XKOAD]
    XKOAK,         -- Supplier [XKOAK]
    XKOAM,         -- Material [XKOAM]
    XKOAS,         -- G/L Account [XKOAS]
    XNMRL,         -- Official numbering [J_1ANUMREL]
    XAUSG,         -- Self-issued doc. [J_1ASELFIS]
    XDTCH,         -- Check Date [J_1ADATCHK]
    BLKLS,         -- Document Class [J_1ADOCCL_]
    XROLLUP,       -- Rollup [G_DOCTY_ROLLUP]
    XPLAN,         -- Planning [G_DOCTY_PLAN]
    XALLOCACT,     -- Act.Allocation [G_DOCTY_ALLOC_ACT]
    XALLOCPLAN,    -- Plan.Allocation [G_DOCTY_ALLOC_PLAN]
    X_PP_PROCESS,  -- ERD Part. Payts [X_PP_PROCESS]
    XKURSX,        -- MD Exchange Rate [X_FXR_RATEX]
    XPOSACC,       -- Pos. Acccounts [X_MCA_POSACC]
    XUACPA,        -- AP Assgmnt Is Unique [XUACPA]
    XKOASECC,      -- Secondary Costs [XKOASECC]
    XMREF2,        -- Reference required [XMREF2]
    PRIMARY KEY (MANDT, BLART)
);

Learn More