I_PRODUCTVALUATIONBASIC

CDS View
22 Fields 12 CDS Views

Product Valuation

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

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_MatlDocumentValuationTypeVH view_entity from CONSUMPTION Material Valuation Types for Reservation
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_CO_MaterialBalance view_entity inner COMPOSITE Colombia Material Balance
I_FldLogsValuationType view from COMPOSITE Field Logistics Valuation type
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 Valuation category by material plant
P_Matval_Manage_Bal_Split view_entity from COMPOSITE Base View for Mat.Val., Balances
R_ProductValuationTP view_entity from TRANSACTIONAL Product Valuation - TP
R_ProductValuationTP_2 view_entity from TRANSACTIONAL Product Valuation - TP

Fields (22)

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

Learn More