P_CHMPCurrentMatlPrByCostEst

DDL: P_CHMPCURRENTMATLPRBYCOSTEST Type: view_entity COMPOSITE Package: ODATA_ML_CHANGEMATERIALPRICES
20 Fields 1 Data Sources 2 Associations

WBS Valuation

P_CHMPCurrentMatlPrByCostEst is a Composite CDS View that provides data about "WBS Valuation" in SAP S/4HANA. It reads from 1 data source (P_CHMPMaterialValuation) and exposes 20 fields with key field CostEstimate. It has 2 associations to related views. Part of development package ODATA_ML_CHANGEMATERIALPRICES.

Data Sources (1)

SourceAliasJoin Type
P_CHMPMaterialValuation MaterialValuation from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
[0..1] I_Plant _Plant $projection.ValuationArea = _Plant.Plant

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate P_CHMPMaterialValuation CostEstimate Cost EstimateNo
Material P_CHMPMaterialValuation Material Vehicle Model
ValuationArea P_CHMPMaterialValuation ValuationArea Valuation Area
InventoryValuationType P_CHMPMaterialValuation InventoryValuationType Valuation Type
InventoryPrice P_CHMPMaterialValuation InventoryPrice Price
Currency P_CHMPMaterialValuation Currency Valuation Crcy
MaterialPriceUnitQty P_CHMPMaterialValuation PriceUnit Fixation Set Grp UoM
BaseUnit P_CHMPMaterialValuation BaseUnit Unit of Measure
MaterialPriceControl P_CHMPMaterialValuation PriceControl
InventoryValuationCategory P_CHMPMaterialValuation InventoryValuationCategory Valuation Cat.
PriceDeterminationControl P_CHMPMaterialValuation PriceDeterminationControl Price Determ.
WBSElementInternalID
InventorySpecialStockType P_CHMPMaterialValuation InventorySpecialStockType Special Stock Type
SDDocument P_CHMPMaterialValuation SDDocument SD Document
SDDocumentItem P_CHMPMaterialValuation SDDocumentItem
ValuationTypeOrigin ValuationTypeOrigin
_WBSElementBasicData _WBSElementBasicData
_Plant _Plant
_Product _Product
_Material _Material

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_CHMPCurrentMatlPrByCostEst.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_CHMPCurrentMatlPrByCostEst AS
SELECT
  MaterialValuation.CostEstimate AS CostEstimate,
  MaterialValuation.Material AS Material,
  MaterialValuation.ValuationArea AS ValuationArea,
  MaterialValuation.InventoryValuationType AS InventoryValuationType,
  MaterialValuation.InventoryPrice AS InventoryPrice,
  MaterialValuation.Currency AS Currency,
  MaterialValuation.PriceUnit AS MaterialPriceUnitQty,
  MaterialValuation.BaseUnit AS BaseUnit,
  MaterialValuation.PriceControl AS MaterialPriceControl,
  MaterialValuation.InventoryValuationCategory AS InventoryValuationCategory,
  MaterialValuation.PriceDeterminationControl AS PriceDeterminationControl,
  cast(MaterialValuation.WBSElement as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  MaterialValuation.InventorySpecialStockType AS InventorySpecialStockType,
  MaterialValuation.SDDocument AS SDDocument,
  MaterialValuation.SDDocumentItem AS SDDocumentItem,
  ValuationTypeOrigin
FROM P_CHMPMaterialValuation AS MaterialValuation
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON ValuationArea = _Plant.Plant  -- association [0..1]
;

Learn More