PROD_VALUATION
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_Productvaluationd | view | from | EXTENSION | Ext view prd val draft (PRD_valuation) |
Fields (34)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA