I_CLFNOBJECTCHARCVALUEBASIC

CDS View
27 Fields 4 CDS Views

Clfn Obj Characteristic Valuation Basic

I_CLFNOBJECTCHARCVALUEBASIC is a CDS View in S/4HANA. Clfn Obj Characteristic Valuation Basic. It contains 27 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ClfnObjectCharcValue view from BASIC Clfn Characteristic Value of Object
I_ClfnObjectCharcValueDEX view_entity from BASIC Clfn Characteristic Value of Object DEX
I_MCHierNodeCVRstrn view_entity inner BASIC MCHN Characteristic Value Restriction
I_MrchdsCatCharcValRstrcn view_entity inner BASIC Charcteristic Value Restriction

Fields (27)

KeyField CDS FieldsUsed in Views
KEY CharcInternalID CharcInternalID 2
KEY CharcValuePositionNumber CharcValuePositionNumber,ClfnCharcValuePositionNumber 4
KEY ClassType ClassType 2
KEY ClfnObjectType ClfnObjectType 2
KEY TimeIntervalNumber TimeIntervalNumber 2
ChangeNumber ChangeNumber 2
CharacteristicAuthor CharacteristicAuthor,CharcAuthor 2
CharcFromAmount CharcFromAmount 4
CharcFromDate CharcFromDate 4
CharcFromDecimalValue CharcFromDecimalValue 4
CharcFromNumericValue CharcFromNumericValue 4
CharcFromNumericValueUnit CharcFromNumericValueUnit 4
CharcFromTime CharcFromTime 4
CharcToAmount CharcToAmount 4
CharcToDate CharcToDate 4
CharcToDecimalValue CharcToDecimalValue 4
CharcToNumericValue CharcToNumericValue 4
CharcToNumericValueUnit CharcToNumericValueUnit 4
CharcToTime CharcToTime 4
CharcValue CharcValue 4
CharcValueIntervalType CharcValueDependency,CharcValueIntervalType 4
CharcValueSortPosition CharcValueSortPosition 2
ClfnObjectID ClfnObjectID 2
Currency Currency 4
IsDeleted IsDeleted 4
ValidityEndDate ValidityEndDate 2
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 Obj Characteristic Valuation Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CLFNOBJECTCHARCVALUEBASIC (
    CHARCINTERNALID,
    CHARCVALUEPOSITIONNUMBER,
    CLASSTYPE,
    CLFNOBJECTTYPE,
    TIMEINTERVALNUMBER,
    CHANGENUMBER,
    CHARACTERISTICAUTHOR,
    CHARCFROMAMOUNT,
    CHARCFROMDATE,
    CHARCFROMDECIMALVALUE,
    CHARCFROMNUMERICVALUE,
    CHARCFROMNUMERICVALUEUNIT,
    CHARCFROMTIME,
    CHARCTOAMOUNT,
    CHARCTODATE,
    CHARCTODECIMALVALUE,
    CHARCTONUMERICVALUE,
    CHARCTONUMERICVALUEUNIT,
    CHARCTOTIME,
    CHARCVALUE,
    CHARCVALUEINTERVALTYPE,
    CHARCVALUESORTPOSITION,
    CLFNOBJECTID,
    CURRENCY,
    ISDELETED,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CHARCINTERNALID, CHARCVALUEPOSITIONNUMBER, CLASSTYPE, CLFNOBJECTTYPE, TIMEINTERVALNUMBER)
);

Learn More