CNVDMTABLEFKYC

Transparent Table Customizing Table
15 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 15 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 (15)

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
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]
    SOURCE,            -- Source [cnv_00001_ctrl_data_source]
    PRIMARY KEY (MANDT, PACKID, CNVOBJ, TABALIAS, FIELDNAME)
);

Learn More