P_PRODUCTVALUATIOND
draft
P_PRODUCTVALUATIOND is a CDS View in S/4HANA. draft. It contains 18 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_Productmlaccountwd | view | inner | COMPOSITE | Product ML Acocunt Union (draft) |
| P_ProductValuationWD | view | left_outer | COMPOSITE | union |
| P_ProductValuationWD | view | union_all | COMPOSITE | union |
Fields (18)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ActiveInventoryValuationType | ActiveInventoryValuationType | 1 |
| KEY | ActiveProduct | ActiveProduct | 1 |
| KEY | ActiveValuationArea | ActiveValuationArea | 1 |
| inventoryvaluationprocedure | inventoryvaluationprocedure | 1 | |
| isproducedinhouse | isproducedinhouse | 1 | |
| movingaverageprice | movingaverageprice | 1 | |
| ParentDraftKey | ParentDraftKey | 1 | |
| pricedeterminationcontrol | pricedeterminationcontrol | 1 | |
| priceunitqty | priceunitqty | 1 | |
| prodcostestnumber | prodcostestnumber | 1 | |
| productorigintype | productorigintype | 1 | |
| productusagetype | productusagetype | 1 | |
| standardprice | standardprice | 1 | |
| valuationarea | valuationarea | 2 | |
| valuationcategory | valuationcategory | 1 | |
| valuationclass | valuationclass | 1 | |
| valuationmargin | valuationmargin | 1 | |
| valuationtype | valuationtype | 2 |
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.
-- draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PRODUCTVALUATIOND (
ACTIVEINVENTORYVALUATIONTYPE,
ACTIVEPRODUCT,
ACTIVEVALUATIONAREA,
INVENTORYVALUATIONPROCEDURE,
ISPRODUCEDINHOUSE,
MOVINGAVERAGEPRICE,
PARENTDRAFTKEY,
PRICEDETERMINATIONCONTROL,
PRICEUNITQTY,
PRODCOSTESTNUMBER,
PRODUCTORIGINTYPE,
PRODUCTUSAGETYPE,
STANDARDPRICE,
VALUATIONAREA,
VALUATIONCATEGORY,
VALUATIONCLASS,
VALUATIONMARGIN,
VALUATIONTYPE,
PRIMARY KEY (ACTIVEINVENTORYVALUATIONTYPE, ACTIVEPRODUCT, ACTIVEVALUATIONAREA)
);
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