C_MatlLdgrPriceByTwoValuations

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_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 C_MatlLdgrPriceByTwoValuations AS
SELECT
  valueHelpDefinition: [{ entity: { name: 'C_MatlLdgrPrValnCurrencyRoleVH', element: 'MatlLdgrPrValnCrcyRoleSemKey' AS P_MaterialLedgerValuation1,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  MaterialPriceValidityEndDate,
  CompanyCode,
  MaterialPriceControl,
  CurPlanProjSlsOrdValnStrategy,
  MaterialPriceCostEstimateStage,
  InventoryValuationType,
  InvtryValnSpecialStockType,
  StkMaterialPriceValuationType,
  MaterialPriceExtReference,
  MaterialPriceExtRefCategory,
  MatlPrcValdtyStrtFsclYearPerd,
  MatlPrcValdtyEndFsclYearPeriod,
  cast(MatlPrcValidityStartFiscalYear as farr_from_fiscal_year preserving type ) AS MatlPrcValidityStartFiscalYear,
  MatlPrcValdtyStartFiscalPeriod,
  cast(MatlPrcValidityEndFiscalYear as farr_to_fiscal_year preserving type ) AS MatlPrcValidityEndFiscalYear,
  MatlPrcValdtyEndFiscalPeriod,
  Material,
  ValuationArea,
  SalesOrder,
  SalesOrderItem,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  Supplier,
  _Plant.Plant AS Plant,
  _PriceType._Text[1: Language = $session.system_language].MaterialPriceTypeName AS MaterialPriceTypeName,
  _MaterialPriceControl._Text[1: Language = $session.system_language].MaterialPriceControlName AS MaterialPriceControlName,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Plant.PlantName AS PlantName,
  _InvtryValnSpecialStockType._Text[1: Language = $session.system_language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  _MatlPriceCostEstimateStage._Text[1: Language = $session.system_language].MatlPriceCostEstimateStageName AS MatlPriceCostEstimateStageName,
  _StkMatlPriceValuationType._Text[1: Language = $session.system_language].StkMatlPriceValuationTypeName AS StkMatlPriceValuationTypeName,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  cast(0 as fml_valuation_view_type) AS ValuationViewType,
  cast('' as fml_valncrcyrolesemkey) AS MatlLdgrPrValnCrcyRoleSemKey,
  ValidOnDate,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  Currency,
  cast(MatlLdgrPrThresholdInPercent as fml_threshold_in_percent) AS MatlLdgrPrThresholdInPercent,
  MatlLdgrPriceDifferenceAmount,
  $parameters.P_MaterialLedgerValuation1 AS MaterialLedgerValuation1,
  $parameters.P_MaterialLedgerValuation2 AS MaterialLedgerValuation2
FROM P_MatlLedgerPriceByPriceType
;