I_PRODUCTVALUATION

CDS View

Product Valuation

I_PRODUCTVALUATION is a CDS View in S/4HANA. Product Valuation. It contains 17 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_ProductValuation view from COMPOSITE Valuation Area Data
C_PH_InventoryQuery view inner CONSUMPTION Ph Inventory Query Philippines
P_DDHistlBufProdStkInvtryPr4 view_entity from COMPOSITE Inventory price calculation for product
P_ProductValuationWD view from COMPOSITE union
P_Salesview_Fs view from COMPOSITE Private Factsheet - Sales View
P_SLLMINMAXRELEVANTPOITEMS view inner COMPOSITE PO history for min and max order price determination

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY Product ActiveProduct,Product 2
KEY ValuationArea ActiveValuationArea,ValuationArea 2
KEY ValuationType ActiveInventoryValuationType,ValuationType 2
Currency Currency 1
InventoryValuationProcedure InventoryValuationProcedure 2
IsProducedInhouse IsProducedInhouse 1
MovingAveragePrice MovingAveragePrice 2
PriceDeterminationControl PriceDeterminationControl 1
PriceUnitQty PriceUnit,PriceUnitQty 3
ProdCostEstNumber ProdCostEstNumber 1
ProductOriginType ProductOriginType 1
ProductUsageType ProductUsageType 1
StandardPrice StandardPrice 2
ValuationCategory ValuationCategory 1
ValuationClass ValuationClass 1
ValuationMargin ValuationMargin 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.

-- Product Valuation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTVALUATION (
    COMPANYCODE,
    PRODUCT,
    VALUATIONAREA,
    VALUATIONTYPE,
    CURRENCY,
    INVENTORYVALUATIONPROCEDURE,
    ISPRODUCEDINHOUSE,
    MOVINGAVERAGEPRICE,
    PRICEDETERMINATIONCONTROL,
    PRICEUNITQTY,
    PRODCOSTESTNUMBER,
    PRODUCTORIGINTYPE,
    PRODUCTUSAGETYPE,
    STANDARDPRICE,
    VALUATIONCATEGORY,
    VALUATIONCLASS,
    VALUATIONMARGIN,
    PRIMARY KEY (COMPANYCODE, PRODUCT, VALUATIONAREA, VALUATIONTYPE)
);