P_MatlLdgrPriceByTwoValuations

DDL: P_MATLLDGRPRICEBYTWOVALUATIONS Type: view_entity COMPOSITE
47 Fields 1 Data Sources 2 Associations

Price Comparison in Two Valuations

P_MatlLdgrPriceByTwoValuations is a Composite CDS View that provides data about "Price Comparison in Two Valuations" in SAP S/4HANA. It reads from 1 data source (P_MatlLdgrPrByPrTypeNoTblFunc) and exposes 47 fields with key fields CostEstimate, MaterialPriceType, MaterialPriceSubtype, MaterialPriceValidityStartDate, MaterialPriceValidityEndDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_MatlLdgrPrByPrTypeNoTblFunc P_MatlLdgrPrByPrTypeNoTblFunc from

Parameters (2)

NameTypeDefault
P_MaterialLedgerValuation1 fml_valuationtocompare1
P_MaterialLedgerValuation2 fml_valuationtocompare2

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_MatlLdgrPriceByValuation _Valuation1 $projection.CostEstimate = _Valuation1.CostEstimate and $projection.MaterialPriceType = _Valuation1.MaterialPriceType and $projection.MaterialPriceSubtype = _Valuation1.MaterialPriceSubtype and $projection.MaterialPriceValidityStartDate = _Valuation1.MaterialPriceValidityStartDate and $projection.MaterialPriceValidityEndDate = _Valuation1.MaterialPriceValidityEndDate and $projection.CompanyCode = _Valuation1.CompanyCode and $projection.MaterialLedgerValuation1 = _Valuation1.MatlLdgrPrValnCrcyRoleSemKey
[0..1] P_MatlLdgrPriceByValuation _Valuation2 $projection.CostEstimate = _Valuation2.CostEstimate and $projection.MaterialPriceType = _Valuation2.MaterialPriceType and $projection.MaterialPriceSubtype = _Valuation2.MaterialPriceSubtype and $projection.MaterialPriceValidityStartDate = _Valuation2.MaterialPriceValidityStartDate and $projection.MaterialPriceValidityEndDate = _Valuation2.MaterialPriceValidityEndDate and $projection.CompanyCode = _Valuation2.CompanyCode and $projection.MaterialLedgerValuation2 = _Valuation2.MatlLdgrPrValnCrcyRoleSemKey

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Price Comparison in Two Valuations view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
KEY MaterialPriceType MaterialPriceType Price Type
KEY MaterialPriceSubtype MaterialPriceSubtype
KEY MaterialPriceValidityStartDate MaterialPriceValidityStartDate
KEY MaterialPriceValidityEndDate MaterialPriceValidityEndDate
MatlPrcValdtyStrtFsclYearPerd MatlPrcValdtyStrtFsclYearPerd
MatlPrcValdtyEndFsclYearPeriod MatlPrcValdtyEndFsclYearPeriod
MatlPrcValidityStartFiscalYear MatlPrcValidityStartFiscalYear
MatlPrcValdtyStartFiscalPeriod MatlPrcValdtyStartFiscalPeriod
MatlPrcValidityEndFiscalYear MatlPrcValidityEndFiscalYear
MatlPrcValdtyEndFiscalPeriod MatlPrcValdtyEndFiscalPeriod
MaterialPriceControl MaterialPriceControl Price Control
CurPlanProjSlsOrdValnStrategy CurPlanProjSlsOrdValnStrategy
MaterialPriceCostEstimateStage MaterialPriceCostEstimateStage
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
CompanyCode CompanyCode Receiver Company Code
InvtryValnSpecialStockType InvtryValnSpecialStockType
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
WBSElementInternalID WBSElementInternalID WBS Internal ID
Supplier Supplier Supplier
StkMaterialPriceValuationType StkMaterialPriceValuationType
MaterialPriceExtRefCategory MaterialPriceExtRefCategory
MaterialPriceExtReference MaterialPriceExtReference
ValidOnDate ValidOnDate
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
MatlLdgrPrThresholdInPercent MatlLdgrPrThresholdInPercent
MatlLdgrPriceDifferenceAmount MatlLdgrPriceDifferenceAmount
Currency Currency Valuation Crcy
MaterialLedgerValuation1
MaterialLedgerValuation2
_CompanyCode _CompanyCode
_InvtryValnSpecialStockType _InvtryValnSpecialStockType
_Material _Material
_MaterialPriceControl _MaterialPriceControl
_MatlPriceCostEstimateStage _MatlPriceCostEstimateStage
_Plant _Plant
_PriceType _PriceType
_StkMatlPriceValuationType _StkMatlPriceValuationType
_WBSElementBasicData _WBSElementBasicData
_Valuation1 _Valuation1
_Valuation2 _Valuation2

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_MatlLdgrPriceByTwoValuations.
-- 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.
-- Parameters: P_MaterialLedgerValuation1 : fml_valuationtocompare1, P_MaterialLedgerValuation2 : fml_valuationtocompare2

CREATE VIEW P_MatlLdgrPriceByTwoValuations AS
SELECT
  CostEstimate,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  MaterialPriceValidityEndDate,
  MatlPrcValdtyStrtFsclYearPerd,
  MatlPrcValdtyEndFsclYearPeriod,
  MatlPrcValidityStartFiscalYear,
  MatlPrcValdtyStartFiscalPeriod,
  MatlPrcValidityEndFiscalYear,
  MatlPrcValdtyEndFiscalPeriod,
  MaterialPriceControl,
  CurPlanProjSlsOrdValnStrategy,
  MaterialPriceCostEstimateStage,
  Material,
  ValuationArea,
  InventoryValuationType,
  CompanyCode,
  InvtryValnSpecialStockType,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  Supplier,
  StkMaterialPriceValuationType,
  MaterialPriceExtRefCategory,
  MaterialPriceExtReference,
  ValidOnDate,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  MatlLdgrPrThresholdInPercent,
  MatlLdgrPriceDifferenceAmount,
  Currency,
  $parameters.P_MaterialLedgerValuation1 AS MaterialLedgerValuation1,
  $parameters.P_MaterialLedgerValuation2 AS MaterialLedgerValuation2
FROM P_MatlLdgrPrByPrTypeNoTblFunc
LEFT OUTER JOIN P_MatlLdgrPriceByValuation AS _Valuation1 ON CostEstimate = _Valuation1.CostEstimate AND MaterialPriceType = _Valuation1.MaterialPriceType AND MaterialPriceSubtype = _Valuation1.MaterialPriceSubtype AND MaterialPriceValidityStartDate = _Valuation1.MaterialPriceValidityStartDate AND MaterialPriceValidityEndDate = _Valuation1.MaterialPriceValidityEndDate AND CompanyCode = _Valuation1.CompanyCode AND MaterialLedgerValuation1 = _Valuation1.MatlLdgrPrValnCrcyRoleSemKey  -- association [0..1]
LEFT OUTER JOIN P_MatlLdgrPriceByValuation AS _Valuation2 ON CostEstimate = _Valuation2.CostEstimate AND MaterialPriceType = _Valuation2.MaterialPriceType AND MaterialPriceSubtype = _Valuation2.MaterialPriceSubtype AND MaterialPriceValidityStartDate = _Valuation2.MaterialPriceValidityStartDate AND MaterialPriceValidityEndDate = _Valuation2.MaterialPriceValidityEndDate AND CompanyCode = _Valuation2.CompanyCode AND MaterialLedgerValuation2 = _Valuation2.MatlLdgrPrValnCrcyRoleSemKey  -- association [0..1]
;

Learn More