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