C_ProductValuationCosting

DDL: C_PRODUCTVALUATIONCOSTING SQL: CPRDVALCOST Type: view CONSUMPTION
15 Fields 1 Data Sources 2 Associations

Consumption Product Valuation Costing

C_ProductValuationCosting is a Consumption CDS View that provides data about "Consumption Product Valuation Costing" in SAP S/4HANA. It reads from 1 data source (I_ProductValuationCostingTP) and exposes 15 fields with key fields Product, ValuationArea, ValuationType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProductValuationCostingTP ValuationCosting from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_Productvaluation _Valuation $projection.Product = _Valuation.Product and $projection.ValuationArea = _Valuation.ValuationArea and $projection.ValuationType = _Valuation.ValuationType
[1..1] C_Product _Product $projection.Product = _Product.Product

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPRDVALCOST view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption Product Valuation Costing view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductValuationCostingTP Product Product Sold
KEY ValuationArea I_ProductValuationCostingTP ValuationArea Valuation Area
KEY ValuationType I_ProductValuationCostingTP ValuationType Valuation Type
PlannedPrice1InCoCodeCrcy I_ProductValuationCostingTP PlannedPrice1InCoCodeCrcy
FuturePlndPrice1ValdtyDate I_ProductValuationCostingTP FuturePlndPrice1ValdtyDate
PlannedPrice2InCoCodeCrcy I_ProductValuationCostingTP PlannedPrice2InCoCodeCrcy
FuturePlndPrice2ValdtyDate I_ProductValuationCostingTP FuturePlndPrice2ValdtyDate
PlannedPrice3InCoCodeCrcy I_ProductValuationCostingTP PlannedPrice3InCoCodeCrcy
FuturePlndPrice3ValdtyDate I_ProductValuationCostingTP FuturePlndPrice3ValdtyDate
Currency Currency Valuation Crcy
IsMaterialCostedWithQtyStruc I_ProductValuationCostingTP IsMaterialCostedWithQtyStruc
CostOriginGroup I_ProductValuationCostingTP CostOriginGroup Origin Group
ControllingArea I_ProductValuationCostingTP ControllingArea Controlling Area
_Product _Product
_Valuation _Valuation

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 C_ProductValuationCosting.
-- 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.
-- SQL view name: CPRDVALCOST

CREATE VIEW C_ProductValuationCosting AS
SELECT
  ValuationCosting.Product AS Product,
  ValuationCosting.ValuationArea AS ValuationArea,
  ValuationCosting.ValuationType AS ValuationType,
  ValuationCosting.PlannedPrice1InCoCodeCrcy AS PlannedPrice1InCoCodeCrcy,
  ValuationCosting.FuturePlndPrice1ValdtyDate AS FuturePlndPrice1ValdtyDate,
  ValuationCosting.PlannedPrice2InCoCodeCrcy AS PlannedPrice2InCoCodeCrcy,
  ValuationCosting.FuturePlndPrice2ValdtyDate AS FuturePlndPrice2ValdtyDate,
  ValuationCosting.PlannedPrice3InCoCodeCrcy AS PlannedPrice3InCoCodeCrcy,
  ValuationCosting.FuturePlndPrice3ValdtyDate AS FuturePlndPrice3ValdtyDate,
  Currency,
  ValuationCosting.IsMaterialCostedWithQtyStruc AS IsMaterialCostedWithQtyStruc,
  ValuationCosting.CostOriginGroup AS CostOriginGroup,
  ValuationCosting.ControllingArea AS ControllingArea
FROM I_ProductValuationCostingTP AS ValuationCosting
LEFT OUTER JOIN C_Productvaluation AS _Valuation ON Product = _Valuation.Product AND ValuationArea = _Valuation.ValuationArea AND ValuationType = _Valuation.ValuationType  -- association [1..1]
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
;

Learn More