I_PRODUCTVALUATIONBASIC

CDS View
22 Fields 10 CDS Views

Product Valuation

I_PRODUCTVALUATIONBASIC is a CDS View in S/4HANA. Product Valuation. It contains 22 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_ResvnMaterialValuationTypeVH view_entity from CONSUMPTION Material Valuation Types for Reservation
I_CN_MaterialStockValuation view from COMPOSITE Material stock valuation for china turnover report
I_FldLogsValuationType view from COMPOSITE Field Logistics Valuation type
I_FlxMtPlObjVarModelPricing view from BASIC FMPO Model Based On Pricing
I_MaterialValuation view_entity from COMPOSITE Material Valuation
I_ProductByValuationVH view from COMPOSITE Product by Valuation
I_Productvaluationprices_Union view union COMPOSITE Product Valuation Prices Union
I_ProductValuationWD view from TRANSACTIONAL Product BO - Valuation Node (draft)
P_MaterialValuationTypesVH view_entity from COMPOSITE
R_ProductValuationTP view_entity from TRANSACTIONAL Product Valuation - TP

Fields (22)

KeyField CDS FieldsUsed in Views
KEY Product Product 4
KEY ValuationArea ValuationArea,ValuationAreaForEdit 4
KEY ValuationType InventoryValuationType,ValuationType,ValuationTypeForEdit 4
_Product _Product 1
BaseUnit BaseUnit 1
Currency Currency 2
InventoryValuationProcedure InventoryValuationProcedure 1
IsMarkedForDeletion IsMarkedForDeletion 1
IsProducedInhouse IsProducedInhouse 1
MovingAveragePrice MovingAveragePrice 2
PriceDeterminationControl PriceDeterminationControl 1
PriceLastChangeDate PriceLastChangeDate 1
PriceUnitQty PriceUnitQty 1
ProdCostEstNumber ProdCostEstNumber 1
ProductOriginType ProductOriginType 1
ProductUsageType ProductUsageType 1
ProjectStockValuationClass ProjectStockValuationClass 1
StandardPrice StandardPrice 2
ValuationCategory InventoryValuationCategory,ValuationCategory 2
ValuationClass ValuationClass 1
ValuationClassSalesOrderStock ValuationClassSalesOrderStock 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_PRODUCTVALUATIONBASIC (
    PRODUCT,
    VALUATIONAREA,
    VALUATIONTYPE,
    _PRODUCT,
    BASEUNIT,
    CURRENCY,
    INVENTORYVALUATIONPROCEDURE,
    ISMARKEDFORDELETION,
    ISPRODUCEDINHOUSE,
    MOVINGAVERAGEPRICE,
    PRICEDETERMINATIONCONTROL,
    PRICELASTCHANGEDATE,
    PRICEUNITQTY,
    PRODCOSTESTNUMBER,
    PRODUCTORIGINTYPE,
    PRODUCTUSAGETYPE,
    PROJECTSTOCKVALUATIONCLASS,
    STANDARDPRICE,
    VALUATIONCATEGORY,
    VALUATIONCLASS,
    VALUATIONCLASSSALESORDERSTOCK,
    VALUATIONMARGIN,
    PRIMARY KEY (PRODUCT, VALUATIONAREA, VALUATIONTYPE)
);

Learn More