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. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_UtilsProdSlsScenCharcValT view_entity from CONSUMPTION Utils Prod Sls Scen Charc Value - Text
CRMS4_IU_C_PRDCV view_entity left_outer Product Characteristic Value
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 from COMPOSITE

Fields (9)

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

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 (
    CHARCINTERNALID,
    CHARCVALUEPOSITIONNUMBER,
    LANGUAGE,
    VALIDITYENDDATE,
    CHANGENUMBER,
    CHARCVALUEDESCRIPTION,
    ISDELETED,
    TIMEINTERVALNUMBER,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CHARCINTERNALID, CHARCVALUEPOSITIONNUMBER, LANGUAGE, VALIDITYENDDATE)
);