I_CurrentMaterialValuations

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 I_CurrentMaterialValuations.
-- 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 I_CurrentMaterialValuations AS
SELECT
  md.CostEstimate AS CostEstimate,
  lvcr.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  lvcr.LegalCurrencyRole AS LegalCurrencyRole,
  lvcr.Ledger AS Ledger,
  lvcr.AccountingValuationView AS AccountingValuationView,
  lvcr.AccountingValuationSubview AS AccountingValuationSubview,
  lvcr.CurrencyRole AS CurrencyRole,
  lvcr.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  lvcr.AccountingValuationViewName AS AccountingValuationViewName,
  lvcr.AccountingValuationSubviewName AS AccountingValuationSubviewName,
  lvcr.AcctgValnVwSubviewCombinedName AS AcctgValnVwSubviewCombinedName,
  lvcr.LedgerName AS LedgerName,
  md.Material AS Material,
  md.ValuationArea AS ValuationArea,
  md.InventoryValuationType AS InventoryValuationType,
  _CompanyCode.ControllingArea AS ControllingArea,
  md.InvtryValnSpecialStockType AS InvtryValnSpecialStockType,
  md.SalesOrder AS SalesOrder,
  md.SalesOrderItem AS SalesOrderItem,
  md.Supplier AS Supplier,
  md.WBSElementInternalID AS WBSElementInternalID,
  md.WBSElementExternalID AS WBSElementExternalID,
  md.FuturePrice AS FuturePrice,
  md.FuturePriceValidityStartDate AS FuturePriceValidityStartDate,
  coalesce( _FSTDCE.MaterialPrice, cast(0 as fml_futureplannedprice)) AS FuturePlannedPrice,
  INVPR.MaterialPriceControl AS MaterialPriceControl,
  md.PriceDeterminationControl AS PriceDeterminationControl,
  INVPR.MaterialPrice AS InventoryPrice,
  case when INVPR.MaterialPriceControl = 'S' and md.PriceDeterminationControl = '2' then _MAP.MaterialPrice when INVPR.MaterialPriceControl = 'S' and md.PriceDeterminationControl = '3' then _ACT.MaterialPrice when INVPR.MaterialPriceControl = 'V' then INVPR.MaterialPrice end as MovingAveragePrice AS MaterialPriceendasMovingAveragePrice,
  case when INVPR.MaterialPriceControl = 'S' then INVPR.MaterialPrice when INVPR.MaterialPriceControl = 'V' then _STDPR.MaterialPrice end as StandardPrice AS MaterialPriceendasStandardPrice,
  INVPR.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  md.CompanyCode AS CompanyCode,
  lvcr.Currency AS Currency,
  cast(_CompanyCode.Currency as fis_hwaer) AS CompanyCodeCurrency,
  md.BaseUnit AS BaseUnit,
  md.ValuationQuantityUnit AS ValuationQuantityUnit,
  md.MaterialGroup AS MaterialGroup,
  md.MaterialType AS MaterialType,
  md.PlntMatlIsMarkedForDeletion AS PlntMatlIsMarkedForDeletion,
  md.AssemblyScrapPercent AS AssemblyScrapPercent,
  md.MaterialProcurementCategory AS MaterialProcurementCategory,
  md.MaterialProcurementProfile AS MaterialProcurementProfile,
  md.ProfitCenter AS ProfitCenter,
  md.HasProductionVersion AS HasProductionVersion,
  md.AlternativeBillOfMaterial AS AlternativeBillOfMaterial,
  md.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  md.TaskListGroup AS TaskListGroup,
  md.TaskListGroupCounter AS TaskListGroupCounter,
  md.CostingLotSize AS CostingLotSize,
  md.CostingMatProcurementProfile AS CostingMatProcurementProfile,
  md.IsCoProduct AS IsCoProduct,
  md.ComponentScrapInPercent AS ComponentScrapInPercent,
  md.IsBulkMaterial AS IsBulkMaterial,
  md.BillOfOperationsType AS BillOfOperationsType,
  md.CostingProductionVersion AS CostingProductionVersion,
  md.IsFixedPriceCoProduct AS IsFixedPriceCoProduct,
  md.IsBlockedForCosting AS IsBlockedForCosting,
  md.IsMatlOfValnTypeMarkedForDeltn AS IsMatlOfValnTypeMarkedForDeltn,
  md.MaterialUsabilityProfile AS MaterialUsabilityProfile,
  md.MaterialValuationClass AS MaterialValuationClass,
  md.ValuationClassInPrevPeriod AS ValuationClassInPrevPeriod,
  md.ValuationClassInPrevYear AS ValuationClassInPrevYear,
  md.CurrentFiscalYear AS CurrentFiscalYear,
  md.CurrentFiscalPeriod AS CurrentFiscalPeriod,
  md.PreviousFiscalPeriodFiscalYear AS PreviousFiscalPeriodFiscalYear,
  md.PreviousFiscalPeriod AS PreviousFiscalPeriod,
  md.PreviousFiscalYear AS PreviousFiscalYear,
  md.PreviousFiscalYearPeriod AS PreviousFiscalYearPeriod,
  md.InventoryValuationCategory AS InventoryValuationCategory,
  md.PriceLastChangeDate AS PriceLastChangeDate,
  md.TaxPricel1InCoCodeCrcy AS TaxPricel1InCoCodeCrcy,
  md.CommercialPrice1InCoCodeCrcy AS CommercialPrice1InCoCodeCrcy,
  md.TaxPrice3InCoCodeCrcy AS TaxPrice3InCoCodeCrcy,
  md.CommercialPrice3InCoCodeCrcy AS CommercialPrice3InCoCodeCrcy,
  md.PlannedPriceInCoCodeCrcy AS PlannedPriceInCoCodeCrcy,
  md.PlannedPrice1InCoCodeCrcy AS PlannedPrice1InCoCodeCrcy,
  md.PlannedPrice2InCoCodeCrcy AS PlannedPrice2InCoCodeCrcy,
  md.PlannedPrice3InCoCodeCrcy AS PlannedPrice3InCoCodeCrcy,
  md.FuturePlndPrice1ValdtyDate AS FuturePlndPrice1ValdtyDate,
  md.FuturePlndPrice2ValdtyDate AS FuturePlndPrice2ValdtyDate,
  md.FuturePlndPrice3ValdtyDate AS FuturePlndPrice3ValdtyDate,
  md.HasStdCostEstForFuturePeriod AS HasStdCostEstForFuturePeriod,
  md.HasStdCostEstForCurrentPeriod AS HasStdCostEstForCurrentPeriod,
  md.HasStdCostEstForPreviousPeriod AS HasStdCostEstForPreviousPeriod,
  md.IsLIFOAndFIFORelevant AS IsLIFOAndFIFORelevant,
  md.LIFOValuationPoolNumber AS LIFOValuationPoolNumber,
  md.CommercialPrice2InCoCodeCrcy AS CommercialPrice2InCoCodeCrcy,
  md.TaxPrice2InCoCodeCrcy AS TaxPrice2InCoCodeCrcy,
  md.DevaluationYearCount AS DevaluationYearCount,
  md.MaintenanceStatus AS MaintenanceStatus,
  md.FutrCostEstValuationVariant AS FutrCostEstValuationVariant,
  md.CurCostEstValuationVariant AS CurCostEstValuationVariant,
  md.PrevCostEstValuationVariant AS PrevCostEstValuationVariant,
  md.FutureCostEstCostingVersion AS FutureCostEstCostingVersion,
  md.CurrentCostEstCostingVersion AS CurrentCostEstCostingVersion,
  md.PreviousCostEstCostingVersion AS PreviousCostEstCostingVersion,
  md.CostOriginGroup AS CostOriginGroup,
  md.CostingOverheadGroup AS CostingOverheadGroup,
  md.FutureCostEstimateFiscalPeriod AS FutureCostEstimateFiscalPeriod,
  md.CurrentCostEstFiscalPeriod AS CurrentCostEstFiscalPeriod,
  md.PreviousCostEstFiscalPeriod AS PreviousCostEstFiscalPeriod,
  md.FutureCostEstFiscalYear AS FutureCostEstFiscalYear,
  md.CurrentCostEstFiscalYear AS CurrentCostEstFiscalYear,
  md.PreviousCostEstFiscalYear AS PreviousCostEstFiscalYear,
  md.IsMaterialCostedWithQtyStruc AS IsMaterialCostedWithQtyStruc,
  md.PreviousPlanPriceInCoCodeCrcy AS PreviousPlanPriceInCoCodeCrcy,
  md.CurrentPlanPriceInCoCodeCrcy AS CurrentPlanPriceInCoCodeCrcy,
  bal.TotStkValAtSlsPrcInCoCodeCrcy AS TotStkValAtSlsPrcInCoCodeCrcy,
  md.IsMaterialRelatedOrigin AS IsMaterialRelatedOrigin,
  md.PhysicalInventoryBlockInd AS PhysicalInventoryBlockInd,
  md.DateOfLastPostedCntUnRstrcdStk AS DateOfLastPostedCntUnRstrcdStk,
  md.InventoryForCycleCountInd AS InventoryForCycleCountInd,
  md.ValuationMargin AS ValuationMargin,
  md.FxdPortnOfPlanPrcInCoCodeCrcy AS FxdPortnOfPlanPrcInCoCodeCrcy,
  md.FxdPortOfPrevPlPrcInCoCodeCrcy AS FxdPortOfPrevPlPrcInCoCodeCrcy,
  md.FxdPortnOfFutPlPrcInCoCodeCrcy AS FxdPortnOfFutPlPrcInCoCodeCrcy,
  md.CurPlanProjSlsOrdValnStrategy AS CurPlanProjSlsOrdValnStrategy,
  md.PrevPlanProjSlsOrdValnStrategy AS PrevPlanProjSlsOrdValnStrategy,
  md.FutrPlanProjSlsOrdValnStrategy AS FutrPlanProjSlsOrdValnStrategy,
  md.ValuationClassSalesOrderStock AS ValuationClassSalesOrderStock,
  md.ProjectStockValuationClass AS ProjectStockValuationClass,
  md.ProductUsageType AS ProductUsageType,
  md.ProductOriginType AS ProductOriginType,
  md.IsProducedInhouse AS IsProducedInhouse,
  md.ValnIsBsdOnBatchSpecificUnit AS ValnIsBsdOnBatchSpecificUnit,
  md.TaxBasedPricesPriceUnitQty AS TaxBasedPricesPriceUnitQty,
  md.ValnClsForSpclStkAtVndr AS ValnClsForSpclStkAtVndr,
  fpi.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  dats_add_days(fpi.FiscalPeriodEndDate, 1, 'INITIAL') AS NextFiscalPeriodStartDate,
  lvcr.AccountingValuationView AS ControllingValuationType,
  _MaterialText.MaterialName AS MaterialName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  plt.Plant AS Plant,
  plt.PlantName AS PlantName,
  _CompanyCode._ControllingArea AS _ControllingArea
FROM P_MATVAL_MANAGE_MD_FMLT AS md
LEFT OUTER JOIN I_MaterialLedgerPrice AS _STDPR ON _STDPR.CostEstimate = md.CostEstimate AND _STDPR.Ledger = md.Ledger AND _STDPR.CurrencyRole = md.CurrencyRole AND _STDPR.MaterialPriceType = 'STDPR' AND _STDPR.MaterialPriceSubtype = '' AND _STDPR.MatlPrcValdtyEndFsclYearPeriod = '9999012' AND _STDPR.Material = md.Material AND _STDPR.CompanyCode = md.CompanyCode AND _STDPR.ValuationArea = md.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _ACT ON _ACT.CostEstimate = md.CostEstimate AND _ACT.CurrencyRole = md.CurrencyRole AND _ACT.Ledger = md.Ledger AND _ACT.MaterialPriceType = 'ACT' AND _ACT.MaterialPriceSubtype = 'ACT' AND _ACT.MatlPrcValdtyEndFsclYearPeriod = '9999012' AND _ACT.Material = md.Material AND _ACT.CompanyCode = md.CompanyCode AND _ACT.ValuationArea = md.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _MAP ON _MAP.CostEstimate = md.CostEstimate AND _MAP.CurrencyRole = md.CurrencyRole AND _MAP.Ledger = md.Ledger AND _MAP.MaterialPriceType = 'MAP' AND _MAP.MaterialPriceSubtype = '' AND _MAP.MatlPrcValdtyEndFsclYearPeriod = '9999012' AND _MAP.Material = md.Material AND _MAP.Material = md.Material AND _MAP.CompanyCode = md.CompanyCode AND _MAP.ValuationArea = md.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _FSTDCE ON _FSTDCE.CostEstimate = md.CostEstimate AND _FSTDCE.CurrencyRole = md.CurrencyRole AND _FSTDCE.Ledger = md.Ledger AND _FSTDCE.MaterialPriceType = 'FSTDCE' AND _FSTDCE.MaterialPriceSubtype = '' AND _FSTDCE.Material = md.Material AND _FSTDCE.Material = md.Material AND _FSTDCE.CompanyCode = md.CompanyCode AND _FSTDCE.ValuationArea = md.ValuationArea AND _FSTDCE.MatlPrcValidityStartFiscalYear = md.CurrentFiscalYear AND _FSTDCE.MatlPrcValdtyStartFiscalPeriod = md.CurrentFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
;