DFKKORDER

Transparent Table Application Table
35 Fields 1 CDS Views

Requests: Header Data

DFKKORDER is an SAP database table in S/4HANA. Requests: Header Data. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SHSM_DFKKORDERPOS view from Ersatz für DFKKORDERPOS in Suchhilfe

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ordnr ORDNR_KK Request Number
ordcls ORDCLS_KK Request Class
ordtyp ORDTYP_KK Request Cat.
fikey FIKEY_KK Reconcil. Key
applk APPLK_KK ApplicationArea
doc_date BLDAT Document Date
opbel OPBEL_KK Document Number
post_date BUDAT_KK Posting Date
blart BLART Document Type
approved APPROVED_KK Approved
currency BLWAE_KK Currency
trans_date WWERT_D Translatn Date
revid REVID_KK Status
reversednr REVERSEDNR_KK Transfrd Req.
reversalnr REVERSALNR_KK Transfer Req.
ernam ERNAM Created By
cpudt CPUDT Entered On
cputm CPUTM Entered at
refdocnr XBLNR_KK Reference
awtyp AWTYP Ref. procedure
awkey AWKEY Reference Key
awsys AWSYS Logical System
aenam AENAM_REQ_KK Changed By
aedat AEDAT_KK Changed On
aetim AETIM_KK Time
xmultidoc XMULTIDOC_KK Document per Item
no_dialog X_NO_DIALOG_KK External Call
revid_next REVID_KK Status
wnper WNPER_KK Special Period
headertxt BKTXT Doc.Header Text
filenumber FILENUM_KK File Number
vatdate VATDATE_KK Tax Report Date
fulfilldate VATDATE2_KK Tax Settlement Date
classification CLASSIFICATION_KK Classification

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.

-- Requests: Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKORDER (
    MANDT,           -- Client [MANDT]
    ORDNR,           -- Request Number [ORDNR_KK]
    ORDCLS,          -- Request Class [ORDCLS_KK]
    ORDTYP,          -- Request Cat. [ORDTYP_KK]
    FIKEY,           -- Reconcil. Key [FIKEY_KK]
    APPLK,           -- ApplicationArea [APPLK_KK]
    DOC_DATE,        -- Document Date [BLDAT]
    OPBEL,           -- Document Number [OPBEL_KK]
    POST_DATE,       -- Posting Date [BUDAT_KK]
    BLART,           -- Document Type [BLART]
    APPROVED,        -- Approved [APPROVED_KK]
    CURRENCY,        -- Currency [BLWAE_KK]
    TRANS_DATE,      -- Translatn Date [WWERT_D]
    REVID,           -- Status [REVID_KK]
    REVERSEDNR,      -- Transfrd Req. [REVERSEDNR_KK]
    REVERSALNR,      -- Transfer Req. [REVERSALNR_KK]
    ERNAM,           -- Created By [ERNAM]
    CPUDT,           -- Entered On [CPUDT]
    CPUTM,           -- Entered at [CPUTM]
    REFDOCNR,        -- Reference [XBLNR_KK]
    AWTYP,           -- Ref. procedure [AWTYP]
    AWKEY,           -- Reference Key [AWKEY]
    AWSYS,           -- Logical System [AWSYS]
    AENAM,           -- Changed By [AENAM_REQ_KK]
    AEDAT,           -- Changed On [AEDAT_KK]
    AETIM,           -- Time [AETIM_KK]
    XMULTIDOC,       -- Document per Item [XMULTIDOC_KK]
    NO_DIALOG,       -- External Call [X_NO_DIALOG_KK]
    REVID_NEXT,      -- Status [REVID_KK]
    WNPER,           -- Special Period [WNPER_KK]
    HEADERTXT,       -- Doc.Header Text [BKTXT]
    FILENUMBER,      -- File Number [FILENUM_KK]
    VATDATE,         -- Tax Report Date [VATDATE_KK]
    FULFILLDATE,     -- Tax Settlement Date [VATDATE2_KK]
    CLASSIFICATION,  -- Classification [CLASSIFICATION_KK]
    PRIMARY KEY (MANDT, ORDNR)
);

Learn More