I_CLFNCHARCVALUEDESC

CDS View

Clfn Characteristic Value Description

I_CLFNCHARCVALUEDESC is a CDS View in S/4HANA. Clfn Characteristic Value Description. It contains 9 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ClfnCharcValueDescDEX view_entity from BASIC Clfn Charc Value Description DEX
I_ClfnCharcValueDescForKeyDate view from COMPOSITE Desc of Clfn Charc Val for Key Date
P_CharcCtlgClfnCValueDesc view_entity from COMPOSITE Charac Catalog Classification Charac Value Descriptions
R_ClfnHistlClChVlDscOvrwrtnTP view_entity from TRANSACTIONAL Clfn Histl Class Charc Val Desc Overwritten - TP

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ChangeNumber ChangeNumber 3
KEY CharcInternalID CharcInternalID,OverwrittenCharcInternalID 2
KEY CharcValuePositionNumber CharcValuePositionNumber 3
KEY Language Language 3
KEY ValidityEndDate ValidityEndDate 3
CharcValueDescription CharcValueDescription 4
IsDeleted IsDeleted 2
TimeIntervalNumber TimeIntervalNumber 2
ValidityStartDate ValidityStartDate 3

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.

-- Clfn Characteristic Value Description
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CLFNCHARCVALUEDESC (
    CHANGENUMBER,
    CHARCINTERNALID,
    CHARCVALUEPOSITIONNUMBER,
    LANGUAGE,
    VALIDITYENDDATE,
    CHARCVALUEDESCRIPTION,
    ISDELETED,
    TIMEINTERVALNUMBER,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CHANGENUMBER, CHARCINTERNALID, CHARCVALUEPOSITIONNUMBER, LANGUAGE, VALIDITYENDDATE)
);