PRD_VALUATION

Transparent Table Application Table
38 Fields 1 CDS Views

Product: Draft Material Valuation Node

PRD_VALUATION is an SAP database table in S/4HANA. Product: Draft Material Valuation Node. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProductValuationD view from BASIC

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draftkey /BOBF/CONF_KEY NodeID
parentdraftkey /BOBF/CONF_KEY NodeID
hasactiveentity BOOLE_D TRUE
activeproduct PRODUCTNUMBER Product
activevaluationarea VALUATIONAREA Valuation area
activeinventoryvaluationtype VALUATIONTYPE Valuation type
valuationarea VALUATIONAREA Valuation area
valuationtype VALUATIONTYPE Valuation type
valuationclass VALUATIONCLASS Valuation Class
pricedeterminationcontrol PRICEDETERMINATIONCONTROL Price determ.
taxclassificationcategory MATERIALLEDGERSTATUS ML act.
valuationclassinprevyear VALUATIONCLASSINPREVYEAR Val. class PY
valuationclassinprevperiod VALUATIONCLASSINPREVPERIOD Val. class PP
fiscalmonthcurrentperiod FISCALMONTHCURRENTPERIOD Current period
fiscalyearcurrentperiod FISCALYEARCURRENTPERIOD Year cur.period
standardprice STANDARDPRICE Standard price
priceunitqty PRICEUNITQTY Price unit
inventoryvaluationprocedure INVENTORYVALUATIONPROCEDURE Price Control
futureevaluatedamountvalue FUTUREEVALUATEDAMOUNTVALUE Future price
futurepricevaliditystartdate FUTUREPRICEVALIDITYSTARTDATE Valid from
totalvalstockquantity TOTALVALSTOCKQUANTITY Total Stock
movingaverageprice MOVINGAVERAGEPRICE Moving price
totalvalstockprevperiod TOTALVALSTOCKPREVPERIOD Total stock PP
totalvalstockprevperiodvalue TOTALVALSTOCKPREVPERIODVALUE Total value PP
totalvalstockprevyear TOTALVALSTOCKPREVYEAR Total stock PY
totalvalstockprevyearvalue TOTALVALSTOCKPREVYEARVALUE Total value PY
valuationcategory VALUATIONCATEGORY Valuation Cat.
totalvalstockvalue TOTALVALSTOCKVALUE Tot. Val. Stock
productusagetype PRODUCTUSAGETYPE Product Usage
productorigintype PRODUCTORIGINTYPE Product Origin
isproducedinhouse ISPRODUCEDINHOUSE Prod. in-house
valnclsforspclstkatvndr VALNCLSFORSPCLSTKATVNDR VC: Vendor
prodcostestnumber PRODCOSTESTNUMBER ProdCostEst.No.
costestimatenumber COSTESTIMATENUMBER Cost EstimateNo
ismarkedfordeletion ISMARKEDFORDELETION Deletion Flag
valuationmargin VALUATIONMARGIN Val. margin
dummy_val_incl_eew_ps VAL_INCL_EEW MD Product valuation extension field element

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: Draft Material Valuation Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_VALUATION (
    CLIENT,                        -- Client [MANDT]
    DRAFTKEY,                      -- NodeID [/BOBF/CONF_KEY]
    PARENTDRAFTKEY,                -- NodeID [/BOBF/CONF_KEY]
    HASACTIVEENTITY,               -- TRUE [BOOLE_D]
    ACTIVEPRODUCT,                 -- Product [PRODUCTNUMBER]
    ACTIVEVALUATIONAREA,           -- Valuation area [VALUATIONAREA]
    ACTIVEINVENTORYVALUATIONTYPE,  -- Valuation type [VALUATIONTYPE]
    VALUATIONAREA,                 -- Valuation area [VALUATIONAREA]
    VALUATIONTYPE,                 -- Valuation type [VALUATIONTYPE]
    VALUATIONCLASS,                -- Valuation Class [VALUATIONCLASS]
    PRICEDETERMINATIONCONTROL,     -- Price determ. [PRICEDETERMINATIONCONTROL]
    TAXCLASSIFICATIONCATEGORY,     -- ML act. [MATERIALLEDGERSTATUS]
    VALUATIONCLASSINPREVYEAR,      -- Val. class PY [VALUATIONCLASSINPREVYEAR]
    VALUATIONCLASSINPREVPERIOD,    -- Val. class PP [VALUATIONCLASSINPREVPERIOD]
    FISCALMONTHCURRENTPERIOD,      -- Current period [FISCALMONTHCURRENTPERIOD]
    FISCALYEARCURRENTPERIOD,       -- Year cur.period [FISCALYEARCURRENTPERIOD]
    STANDARDPRICE,                 -- Standard price [STANDARDPRICE]
    PRICEUNITQTY,                  -- Price unit [PRICEUNITQTY]
    INVENTORYVALUATIONPROCEDURE,   -- Price Control [INVENTORYVALUATIONPROCEDURE]
    FUTUREEVALUATEDAMOUNTVALUE,    -- Future price [FUTUREEVALUATEDAMOUNTVALUE]
    FUTUREPRICEVALIDITYSTARTDATE,  -- Valid from [FUTUREPRICEVALIDITYSTARTDATE]
    TOTALVALSTOCKQUANTITY,         -- Total Stock [TOTALVALSTOCKQUANTITY]
    MOVINGAVERAGEPRICE,            -- Moving price [MOVINGAVERAGEPRICE]
    TOTALVALSTOCKPREVPERIOD,       -- Total stock PP [TOTALVALSTOCKPREVPERIOD]
    TOTALVALSTOCKPREVPERIODVALUE,  -- Total value PP [TOTALVALSTOCKPREVPERIODVALUE]
    TOTALVALSTOCKPREVYEAR,         -- Total stock PY [TOTALVALSTOCKPREVYEAR]
    TOTALVALSTOCKPREVYEARVALUE,    -- Total value PY [TOTALVALSTOCKPREVYEARVALUE]
    VALUATIONCATEGORY,             -- Valuation Cat. [VALUATIONCATEGORY]
    TOTALVALSTOCKVALUE,            -- Tot. Val. Stock [TOTALVALSTOCKVALUE]
    PRODUCTUSAGETYPE,              -- Product Usage [PRODUCTUSAGETYPE]
    PRODUCTORIGINTYPE,             -- Product Origin [PRODUCTORIGINTYPE]
    ISPRODUCEDINHOUSE,             -- Prod. in-house [ISPRODUCEDINHOUSE]
    VALNCLSFORSPCLSTKATVNDR,       -- VC: Vendor [VALNCLSFORSPCLSTKATVNDR]
    PRODCOSTESTNUMBER,             -- ProdCostEst.No. [PRODCOSTESTNUMBER]
    COSTESTIMATENUMBER,            -- Cost EstimateNo [COSTESTIMATENUMBER]
    ISMARKEDFORDELETION,           -- Deletion Flag [ISMARKEDFORDELETION]
    VALUATIONMARGIN,               -- Val. margin [VALUATIONMARGIN]
    DUMMY_VAL_INCL_EEW_PS,         -- MD Product valuation extension field element [VAL_INCL_EEW]
    PRIMARY KEY (CLIENT, DRAFTKEY)
);

Learn More