P_PRODUCTVALUATIOND

CDS View

draft

P_PRODUCTVALUATIOND is a CDS View in S/4HANA. draft. It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_Productmlaccountwd view inner COMPOSITE Product ML Acocunt Union (draft)
P_ProductValuationWD view left_outer COMPOSITE union
P_ProductValuationWD view union_all COMPOSITE union

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ActiveInventoryValuationType ActiveInventoryValuationType 1
KEY ActiveProduct ActiveProduct 1
KEY ActiveValuationArea ActiveValuationArea 1
inventoryvaluationprocedure inventoryvaluationprocedure 1
isproducedinhouse isproducedinhouse 1
movingaverageprice movingaverageprice 1
ParentDraftKey ParentDraftKey 1
pricedeterminationcontrol pricedeterminationcontrol 1
priceunitqty priceunitqty 1
prodcostestnumber prodcostestnumber 1
productorigintype productorigintype 1
productusagetype productusagetype 1
standardprice standardprice 1
valuationarea valuationarea 2
valuationcategory valuationcategory 1
valuationclass valuationclass 1
valuationmargin valuationmargin 1
valuationtype valuationtype 2

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.

-- draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PRODUCTVALUATIOND (
    ACTIVEINVENTORYVALUATIONTYPE,
    ACTIVEPRODUCT,
    ACTIVEVALUATIONAREA,
    INVENTORYVALUATIONPROCEDURE,
    ISPRODUCEDINHOUSE,
    MOVINGAVERAGEPRICE,
    PARENTDRAFTKEY,
    PRICEDETERMINATIONCONTROL,
    PRICEUNITQTY,
    PRODCOSTESTNUMBER,
    PRODUCTORIGINTYPE,
    PRODUCTUSAGETYPE,
    STANDARDPRICE,
    VALUATIONAREA,
    VALUATIONCATEGORY,
    VALUATIONCLASS,
    VALUATIONMARGIN,
    VALUATIONTYPE,
    PRIMARY KEY (ACTIVEINVENTORYVALUATIONTYPE, ACTIVEPRODUCT, ACTIVEVALUATIONAREA)
);