VALUE

23 Fields

VALUE is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CharcInternalID CharcInternalID 3
KEY CharcValuePositionNumber CharcValuePositionNumber 1
KEY VarConfignTblValueNumber VarConfignTblValueNumber 1
_Charc _Charc 1
CharcFromNumericValue CharcFromNumericValue 1
CharcFromNumericValueUnit CharcFromNumericValueUnit 1
CharcToNumericValue CharcToNumericValue 1
CharcToNumericValueUnit CharcToNumericValueUnit 1
CharcValue CharcValue 3
CharcValueIntervalType CharcValueIntervalType 1
Currency Currency 2
InventoryAmountChangeAmount InventoryAmountChangeAmount 2
IsDeleted IsDeleted 1
MvgAvgPrInvtryAmtChangeAmount MvgAvgPrInvtryAmtChangeAmount 1
PrevInvtryPriceInventoryAmount PrevInvtryPriceInventoryAmount 2
PreviousInventoryPrice PreviousInventoryPrice 2
PreviousMaterialPriceUnitQty PreviousMaterialPriceUnitQty 2
PreviousMovingAveragePrice PreviousMovingAveragePrice 2
PreviousProductPriceControl PreviousProductPriceControl 1
PreviousStandardPrice PreviousStandardPrice 1
PrevMvgAvgPriceInventoryAmount PrevMvgAvgPriceInventoryAmount 1
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 VALUE (
    CHARCINTERNALID,
    CHARCVALUEPOSITIONNUMBER,
    VARCONFIGNTBLVALUENUMBER,
    _CHARC,
    CHARCFROMNUMERICVALUE,
    CHARCFROMNUMERICVALUEUNIT,
    CHARCTONUMERICVALUE,
    CHARCTONUMERICVALUEUNIT,
    CHARCVALUE,
    CHARCVALUEINTERVALTYPE,
    CURRENCY,
    INVENTORYAMOUNTCHANGEAMOUNT,
    ISDELETED,
    MVGAVGPRINVTRYAMTCHANGEAMOUNT,
    PREVINVTRYPRICEINVENTORYAMOUNT,
    PREVIOUSINVENTORYPRICE,
    PREVIOUSMATERIALPRICEUNITQTY,
    PREVIOUSMOVINGAVERAGEPRICE,
    PREVIOUSPRODUCTPRICECONTROL,
    PREVIOUSSTANDARDPRICE,
    PREVMVGAVGPRICEINVENTORYAMOUNT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CHARCINTERNALID, CHARCVALUEPOSITIONNUMBER, VARCONFIGNTBLVALUENUMBER)
);

Learn More