PROD_VALUATION

Transparent Table Application Table

I_PRODUCTWD I_PRODUCTVALUATIONWD

PROD_VALUATION is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTVALUATIONWD. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Productvaluationd view from EXTENSION Ext view prd val draft (PRD_valuation)

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
parentdraftuuid /BOBF/UUID Key
product PRODUCTNUMBER Product
valuationarea BWKEY Valuation Area
valuationtype BWTAR_D Valuation Type
prodcostestnumber CK_KALNR1 ProdCostEst.No.
valuationareaforedit BWKEY Valuation Area
valuationtypeforedit BWTAR_D Valuation Type
valuationclass BKLAS Valuation Class
pricedeterminationcontrol CK_ML_ABST Price Determ.
standardprice STPRS Standard price
priceunitqty PEINH Price unit
inventoryvaluationprocedure INVENTORYVALUATIONPROCEDURE Price Control
ismarkedfordeletion LVOBA DF Val. Type
movingaverageprice VERPR Moving price
valuationcategory BWTTY_D Valuation Cat.
productusagetype PRODUCTUSAGETYPE Product Usage
productorigintype PRODUCTORIGINTYPE Product Origin
isproducedinhouse J_1BOWNPRO Prod. in-house
valuationclasssalesorderstock EKLAS VC: Sal.Ord.Stk
projectstockvaluationclass QKLAS Project stk VC
pricelastchangedate LAEPR Last Price Chg.
currency WAERS Currency
issplitvaluation abap.char
valuationmargin BWSPA Val. Margin
baseunit MEINS Base Unit
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
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.

-- I_PRODUCTWD I_PRODUCTVALUATIONWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PROD_VALUATION (
    MANDT,                          -- Client [MANDT]
    DRAFTUUID,                      -- Key [/BOBF/UUID]
    PARENTDRAFTUUID,                -- Key [/BOBF/UUID]
    PRODUCT,                        -- Product [PRODUCTNUMBER]
    VALUATIONAREA,                  -- Valuation Area [BWKEY]
    VALUATIONTYPE,                  -- Valuation Type [BWTAR_D]
    PRODCOSTESTNUMBER,              -- ProdCostEst.No. [CK_KALNR1]
    VALUATIONAREAFOREDIT,           -- Valuation Area [BWKEY]
    VALUATIONTYPEFOREDIT,           -- Valuation Type [BWTAR_D]
    VALUATIONCLASS,                 -- Valuation Class [BKLAS]
    PRICEDETERMINATIONCONTROL,      -- Price Determ. [CK_ML_ABST]
    STANDARDPRICE,                  -- Standard price [STPRS]
    PRICEUNITQTY,                   -- Price unit [PEINH]
    INVENTORYVALUATIONPROCEDURE,    -- Price Control [INVENTORYVALUATIONPROCEDURE]
    ISMARKEDFORDELETION,            -- DF Val. Type [LVOBA]
    MOVINGAVERAGEPRICE,             -- Moving price [VERPR]
    VALUATIONCATEGORY,              -- Valuation Cat. [BWTTY_D]
    PRODUCTUSAGETYPE,               -- Product Usage [PRODUCTUSAGETYPE]
    PRODUCTORIGINTYPE,              -- Product Origin [PRODUCTORIGINTYPE]
    ISPRODUCEDINHOUSE,              -- Prod. in-house [J_1BOWNPRO]
    VALUATIONCLASSSALESORDERSTOCK,  -- VC: Sal.Ord.Stk [EKLAS]
    PROJECTSTOCKVALUATIONCLASS,     -- Project stk VC [QKLAS]
    PRICELASTCHANGEDATE,            -- Last Price Chg. [LAEPR]
    CURRENCY,                       -- Currency [WAERS]
    ISSPLITVALUATION,               -- abap.char
    VALUATIONMARGIN,                -- Val. Margin [BWSPA]
    BASEUNIT,                       -- Base Unit [MEINS]
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_VAL_INCL_EEW_PS,          -- MD Product valuation extension field element [VAL_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);