CNVDMTABLEFKYC

Transparent Table Customizing Table
19 Fields 1 CDS Views

Conversion: Data Model Table Foreign Key Relation

CNVDMTABLEFKYC is an SAP database table in S/4HANA. Conversion: Data Model Table Foreign Key Relation. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ConversionTableForeignKey view_entity from BASIC Conversion Table Foreign Key

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY packid CNV_PACK Pack.no.
KEY cnvobj CNV_CNVOBJ Conversion Object
KEY tabalias CNV_TABALIAS Table Alias
KEY fieldname FIELDNAME Field Name
parent_tabalias CNV_PTABALIAS Parent Tabel Alias
parent_fieldname FIELDNAME Field Name
fkytype CNV_FKYTYPE FK Type
chdfld_offset CNV_FLDOFFSET offset
chdfld_length CNV_FLDLENGTH Length
prtfld_offset CNV_FLDOFFSET offset
prtfld_length CNV_FLDLENGTH Length
link_operator DMC_GATING_OPERATOR Linking Operator
logical_operator DMC_LOGICAL_OPERATOR Logical operator
createdby SYUNAME User Name
createdon TIMESTAMP Time Stamp
changedby SYUNAME User Name
changedon TIMESTAMP Time Stamp
source CNV_00001_CTRL_DATA_SOURCE Source

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.

-- Conversion: Data Model Table Foreign Key Relation
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CNVDMTABLEFKYC (
    MANDT,             -- Client [MANDT]
    PACKID,            -- Pack.no. [CNV_PACK]
    CNVOBJ,            -- Conversion Object [CNV_CNVOBJ]
    TABALIAS,          -- Table Alias [CNV_TABALIAS]
    FIELDNAME,         -- Field Name [FIELDNAME]
    PARENT_TABALIAS,   -- Parent Tabel Alias [CNV_PTABALIAS]
    PARENT_FIELDNAME,  -- Field Name [FIELDNAME]
    FKYTYPE,           -- FK Type [CNV_FKYTYPE]
    CHDFLD_OFFSET,     -- offset [CNV_FLDOFFSET]
    CHDFLD_LENGTH,     -- Length [CNV_FLDLENGTH]
    PRTFLD_OFFSET,     -- offset [CNV_FLDOFFSET]
    PRTFLD_LENGTH,     -- Length [CNV_FLDLENGTH]
    LINK_OPERATOR,     -- Linking Operator [DMC_GATING_OPERATOR]
    LOGICAL_OPERATOR,  -- Logical operator [DMC_LOGICAL_OPERATOR]
    CREATEDBY,         -- User Name [SYUNAME]
    CREATEDON,         -- Time Stamp [TIMESTAMP]
    CHANGEDBY,         -- User Name [SYUNAME]
    CHANGEDON,         -- Time Stamp [TIMESTAMP]
    SOURCE,            -- Source [CNV_00001_CTRL_DATA_SOURCE]
    PRIMARY KEY (MANDT, PACKID, CNVOBJ, TABALIAS, FIELDNAME)
);

Learn More