P_CURMATLVALNPRICE_CR_JOIN

CDS View
7 Fields 2 CDS Views

P_CURMATLVALNPRICE_CR_JOIN is a CDS View in S/4HANA. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_CURRENTMATLVALNPRICE view from BASIC
P_CURRENTMATLVALNPRICEDEX view from BASIC

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 2
Currency Currency 2
InventoryPrice InventoryPrice 1
MaterialPriceControl MaterialPriceControl 2
MaterialPriceUnitQty MaterialPriceUnitQty 2
MovingAveragePrice MovingAveragePrice 1
StandardPrice StandardPrice 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 P_CURMATLVALNPRICE_CR_JOIN (
    COSTESTIMATE,
    CURRENCY,
    INVENTORYPRICE,
    MATERIALPRICECONTROL,
    MATERIALPRICEUNITQTY,
    MOVINGAVERAGEPRICE,
    STANDARDPRICE,
    PRIMARY KEY (COSTESTIMATE)
);

Learn More