DFKKODNREP

Transparent Table Application Table
22 Fields 1 CDS Views

Official Document Number for Reporting

DFKKODNREP is an SAP database table in S/4HANA. Official Document Number for Reporting. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_IT_VATOdnRep view_entity from BASIC VAT register ODN Report

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY exkey exkey_kk Official doc no. key
KEY exkid exkid_kk Key ID
opbel opbel_kk Document Number
opupk opupk_kk Item
opupw opupw_kk Repetition Item
opupz opupz_kk Subitem
blart blart_kk Document Type
bukrs bukrs Company Code
budat budat Posting Date
bldat bldat Document Date
gjahr gjahr Fiscal Year
num char20 Char20
ds ds_kk Generate Digital Sig
land odncntry_kk CtryReg ISO Cd
seoclsname seoclsname Type Name
item_odn boole_d TRUE
source char1 Single-Character Flag
odnformat odnformat_kk Off.Doc.No. Format
subid doccls_subid_kk Sub-ID
chr_num odn_chr_kk Chr.No.
doccls doccls_kk Document Class

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.

-- Official Document Number for Reporting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKODNREP (
    MANDT,       -- Client [mandt]
    EXKEY,       -- Official doc no. key [exkey_kk]
    EXKID,       -- Key ID [exkid_kk]
    OPBEL,       -- Document Number [opbel_kk]
    OPUPK,       -- Item [opupk_kk]
    OPUPW,       -- Repetition Item [opupw_kk]
    OPUPZ,       -- Subitem [opupz_kk]
    BLART,       -- Document Type [blart_kk]
    BUKRS,       -- Company Code [bukrs]
    BUDAT,       -- Posting Date [budat]
    BLDAT,       -- Document Date [bldat]
    GJAHR,       -- Fiscal Year [gjahr]
    NUM,         -- Char20 [char20]
    DS,          -- Generate Digital Sig [ds_kk]
    LAND,        -- CtryReg ISO Cd [odncntry_kk]
    SEOCLSNAME,  -- Type Name [seoclsname]
    ITEM_ODN,    -- TRUE [boole_d]
    SOURCE,      -- Single-Character Flag [char1]
    ODNFORMAT,   -- Off.Doc.No. Format [odnformat_kk]
    SUBID,       -- Sub-ID [doccls_subid_kk]
    CHR_NUM,     -- Chr.No. [odn_chr_kk]
    DOCCLS,      -- Document Class [doccls_kk]
    PRIMARY KEY (MANDT, EXKEY, EXKID)
);

Learn More