DFKKBIX_MD

Transparent Table Application Table
13 Fields 1 CDS Views

Master Data ID

DFKKBIX_MD is an SAP database table in S/4HANA. Master Data ID. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CAMasterDataID view_entity from BASIC Stammdaten ID

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY md_id BIX_MD_ID_KK Master Data ID
crname AS4USER Last Changed By
crdate AS4DATE Date
crtime AS4TIME Time
gpart GPART_KK Bus. Partner
vkont VKONT_KK Contract Acct
vtref VTREF_KK Contract
subap SUBAP_KK Subapplication
vtpos VTPOS_KK Contract Item
vtpid VTPID_KK Contr.Item ID
access_userid ACCESS_USERID_KK Consumer ID
access_serviceid ACCESS_SERVICEID_KK Service ID

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.

-- Master Data ID
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKBIX_MD (
    MANDT,             -- Client [MANDT]
    MD_ID,             -- Master Data ID [BIX_MD_ID_KK]
    CRNAME,            -- Last Changed By [AS4USER]
    CRDATE,            -- Date [AS4DATE]
    CRTIME,            -- Time [AS4TIME]
    GPART,             -- Bus. Partner [GPART_KK]
    VKONT,             -- Contract Acct [VKONT_KK]
    VTREF,             -- Contract [VTREF_KK]
    SUBAP,             -- Subapplication [SUBAP_KK]
    VTPOS,             -- Contract Item [VTPOS_KK]
    VTPID,             -- Contr.Item ID [VTPID_KK]
    ACCESS_USERID,     -- Consumer ID [ACCESS_USERID_KK]
    ACCESS_SERVICEID,  -- Service ID [ACCESS_SERVICEID_KK]
    PRIMARY KEY (MANDT, MD_ID)
);

Learn More