VALUATION

VALUATION is an SAP database table in S/4HANA. It contains 28 fields.

Fields (28)

KeyField CDS FieldsUsed in Views
KEY bwkey ValuationArea 1
KEY bwtar ValuationType 1
KEY CharcInternalID CharacteristicInternalID,CharcInternalID 9
KEY CharcValuePositionNumber CharcValuePositionNumber,ClfnCharcValuePositionNumber 8
KEY ClassType ClassType 9
KEY matnr Product 1
_Characteristic _Characteristic 3
bklas ValuationClass 1
ChangeNumber ChangeNumber 5
CharacteristicAuthor CharacteristicAuthor 4
CharcFromAmount CharcFromAmount 8
CharcFromDate CharcFromDate 8
CharcFromDecimalValue CharcFromDecimalValue 8
CharcFromNumericValue CharcFromNumericValue 8
CharcFromNumericValueUnit CharcFromNumericValueUnit 8
CharcFromTime CharcFromTime 8
CharcToAmount CharcToAmount 8
CharcToDate CharcToDate 8
CharcToDecimalValue CharcToDecimalValue 8
CharcToNumericValue CharcToNumericValue 8
CharcToNumericValueUnit CharcToNumericValueUnit 8
CharcToTime CharcToTime 8
CharcValue CharcValue 8
CharcValueDependency CharcValueDependency,CharcValueIntervalType 8
ClfnObjectID ClfnObjectID 3
Currency Currency 9
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VALUATION (
    BWKEY,
    BWTAR,
    CHARCINTERNALID,
    CHARCVALUEPOSITIONNUMBER,
    CLASSTYPE,
    MATNR,
    _CHARACTERISTIC,
    BKLAS,
    CHANGENUMBER,
    CHARACTERISTICAUTHOR,
    CHARCFROMAMOUNT,
    CHARCFROMDATE,
    CHARCFROMDECIMALVALUE,
    CHARCFROMNUMERICVALUE,
    CHARCFROMNUMERICVALUEUNIT,
    CHARCFROMTIME,
    CHARCTOAMOUNT,
    CHARCTODATE,
    CHARCTODECIMALVALUE,
    CHARCTONUMERICVALUE,
    CHARCTONUMERICVALUEUNIT,
    CHARCTOTIME,
    CHARCVALUE,
    CHARCVALUEDEPENDENCY,
    CLFNOBJECTID,
    CURRENCY,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BWKEY, BWTAR, CHARCINTERNALID, CHARCVALUEPOSITIONNUMBER, CLASSTYPE, MATNR)
);