PROD_VALUATION

Transparent Table Application Table
28 Fields 1 CDS Views

I_PRODUCTWD I_PRODUCTVALUATIONWD

PROD_VALUATION is an SAP database table in S/4HANA. I_PRODUCTWD I_PRODUCTVALUATIONWD. It contains 28 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 (28)

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

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]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More