P_MATVAL_MANAGE_MD_FMLT

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_MATVAL_MANAGE_MD_FMLT.
-- 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: PMATVALMGMMDF

CREATE VIEW P_MATVAL_MANAGE_MD_FMLT AS
SELECT
  fmlt.CostEstimate AS CostEstimate,
  fmlt.Ledger AS Ledger,
  fmlt.CurrencyRole AS CurrencyRole,
  fmlt.Material AS Material,
  fmlt.ValuationArea AS ValuationArea,
  fmlt.CompanyCode AS CompanyCode,
  fmlt.InventoryValuationType AS InventoryValuationType,
  fmlt.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  fmlt.ValuationQuantityUnit AS ValuationQuantityUnit,
  fmlt.Currency AS Currency,
  cast(fmlt.MaterialPrice as fml_dzkprs) AS FuturePrice,
  cast(fmlt.MaterialPriceValidityStartDate as fml_zprsdat) AS FuturePriceValidityStartDate,
  xb.InvtryValnSpecialStockType AS InvtryValnSpecialStockType,
  xb.SalesOrder AS SalesOrder,
  xb.SalesOrderItem AS SalesOrderItem,
  xb.Supplier AS Supplier,
  _WBSElementBasicData.WBSElementInternalID AS WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  ma.BaseUnit AS BaseUnit,
  ma.ProductGroup AS MaterialGroup,
  ma.ProductType AS MaterialType,
  mc.IsMarkedForDeletion AS PlntMatlIsMarkedForDeletion,
  mc.ProfileCode AS MaterialUsabilityProfile,
  ppsp.AssemblyScrapPercent AS AssemblyScrapPercent,
  mc.ProcurementType AS MaterialProcurementCategory,
  ppsp.ProcurementSubType AS MaterialProcurementProfile,
  mc.ProfitCenter AS ProfitCenter,
  pws.HasProductionVersion AS HasProductionVersion,
  ppc.SourceBOMAlternative AS AlternativeBillOfMaterial,
  ppc.ProductBOMUsage AS BillOfMaterialVariantUsage,
  ppc.TaskListGroup AS TaskListGroup,
  ppc.TaskListGroupCounter AS TaskListGroupCounter,
  ppc.CostingLotSize AS CostingLotSize,
  ppc.CostingSpecialProcurementType AS CostingMatProcurementProfile,
  ppsp.ComponentScrapInPercent AS ComponentScrapInPercent,
  ppc.IsCoProduct AS IsCoProduct,
  ppsp.ProductIsBulkComponent AS IsBulkMaterial,
  ppc.TaskListType AS BillOfOperationsType,
  ppc.CostingProductionVersion AS CostingProductionVersion,
  ppc.IsFixedPriceCoProduct AS IsFixedPriceCoProduct,
  ppc.ProductIsCostingRelevant AS IsBlockedForCosting,
  xb.PriceDeterminationControl AS PriceDeterminationControl,
  xb.IsMatlOfValnTypeMarkedForDeltn AS IsMatlOfValnTypeMarkedForDeltn,
  xb.MaterialValuationClass AS MaterialValuationClass,
  xb.ValuationClassInPrevPeriod AS ValuationClassInPrevPeriod,
  xb.ValuationClassInPrevYear AS ValuationClassInPrevYear,
  marvld.CurrentFiscalYear AS CurrentFiscalYear,
  marvld.CurrentFiscalPeriod AS CurrentFiscalPeriod,
  marvld.PreviousFiscalPeriodFiscalYear AS PreviousFiscalPeriodFiscalYear,
  marvld.PreviousFiscalPeriod AS PreviousFiscalPeriod,
  marvld.PreviousFiscalYear AS PreviousFiscalYear,
  marvld.PrevFiscalYearLastFiscalPeriod AS PreviousFiscalYearPeriod,
  xb.InventoryValuationCategory AS InventoryValuationCategory,
  xb.PriceLastChangeDate AS PriceLastChangeDate,
  xb.TaxPricel1InCoCodeCrcy AS TaxPricel1InCoCodeCrcy,
  xb.CommercialPrice1InCoCodeCrcy AS CommercialPrice1InCoCodeCrcy,
  xb.TaxPrice3InCoCodeCrcy AS TaxPrice3InCoCodeCrcy,
  xb.CommercialPrice3InCoCodeCrcy AS CommercialPrice3InCoCodeCrcy,
  xb.PlannedPriceInCoCodeCrcy AS PlannedPriceInCoCodeCrcy,
  xb.PlannedPrice1InCoCodeCrcy AS PlannedPrice1InCoCodeCrcy,
  xb.PlannedPrice2InCoCodeCrcy AS PlannedPrice2InCoCodeCrcy,
  xb.PlannedPrice3InCoCodeCrcy AS PlannedPrice3InCoCodeCrcy,
  xb.FuturePlndPrice1ValdtyDate AS FuturePlndPrice1ValdtyDate,
  xb.FuturePlndPrice2ValdtyDate AS FuturePlndPrice2ValdtyDate,
  xb.FuturePlndPrice3ValdtyDate AS FuturePlndPrice3ValdtyDate,
  xb.HasStdCostEstForFuturePeriod AS HasStdCostEstForFuturePeriod,
  xb.HasStdCostEstForCurrentPeriod AS HasStdCostEstForCurrentPeriod,
  xb.HasStdCostEstForPreviousPeriod AS HasStdCostEstForPreviousPeriod,
  xb.IsLIFOAndFIFORelevant AS IsLIFOAndFIFORelevant,
  xb.LIFOValuationPoolNumber AS LIFOValuationPoolNumber,
  xb.CommercialPrice2InCoCodeCrcy AS CommercialPrice2InCoCodeCrcy,
  xb.TaxPrice2InCoCodeCrcy AS TaxPrice2InCoCodeCrcy,
  xb.DevaluationYearCount AS DevaluationYearCount,
  xb.MaintenanceStatus AS MaintenanceStatus,
  xb.FutrCostEstValuationVariant AS FutrCostEstValuationVariant,
  xb.CurCostEstValuationVariant AS CurCostEstValuationVariant,
  xb.PrevCostEstValuationVariant AS PrevCostEstValuationVariant,
  xb.FutureCostEstCostingVersion AS FutureCostEstCostingVersion,
  xb.CurrentCostEstCostingVersion AS CurrentCostEstCostingVersion,
  xb.PreviousCostEstCostingVersion AS PreviousCostEstCostingVersion,
  xb.CostOriginGroup AS CostOriginGroup,
  xb.CostingOverheadGroup AS CostingOverheadGroup,
  xb.FutureCostEstimateFiscalPeriod AS FutureCostEstimateFiscalPeriod,
  xb.CurrentCostEstFiscalPeriod AS CurrentCostEstFiscalPeriod,
  xb.PreviousCostEstFiscalPeriod AS PreviousCostEstFiscalPeriod,
  xb.FutureCostEstFiscalYear AS FutureCostEstFiscalYear,
  xb.CurrentCostEstFiscalYear AS CurrentCostEstFiscalYear,
  xb.PreviousCostEstFiscalYear AS PreviousCostEstFiscalYear,
  xb.IsMaterialCostedWithQtyStruc AS IsMaterialCostedWithQtyStruc,
  xb.PreviousPlanPriceInCoCodeCrcy AS PreviousPlanPriceInCoCodeCrcy,
  xb.CurrentPlanPriceInCoCodeCrcy AS CurrentPlanPriceInCoCodeCrcy,
  xb.IsMaterialRelatedOrigin AS IsMaterialRelatedOrigin,
  xb.PhysicalInventoryBlockInd AS PhysicalInventoryBlockInd,
  xb.DateOfLastPostedCntUnRstrcdStk AS DateOfLastPostedCntUnRstrcdStk,
  xb.InventoryForCycleCountInd AS InventoryForCycleCountInd,
  xb.ValuationMargin AS ValuationMargin,
  xb.FxdPortnOfPlanPrcInCoCodeCrcy AS FxdPortnOfPlanPrcInCoCodeCrcy,
  xb.FxdPortOfPrevPlPrcInCoCodeCrcy AS FxdPortOfPrevPlPrcInCoCodeCrcy,
  xb.FxdPortnOfFutPlPrcInCoCodeCrcy AS FxdPortnOfFutPlPrcInCoCodeCrcy,
  xb.CurPlanProjSlsOrdValnStrategy AS CurPlanProjSlsOrdValnStrategy,
  xb.PrevPlanProjSlsOrdValnStrategy AS PrevPlanProjSlsOrdValnStrategy,
  xb.FutrPlanProjSlsOrdValnStrategy AS FutrPlanProjSlsOrdValnStrategy,
  xb.ValuationClassSalesOrderStock AS ValuationClassSalesOrderStock,
  xb.ProjectStockValuationClass AS ProjectStockValuationClass,
  xb.ProductUsageType AS ProductUsageType,
  xb.ProductOriginType AS ProductOriginType,
  xb.IsProducedInhouse AS IsProducedInhouse,
  xb.ValnIsBsdOnBatchSpecificUnit AS ValnIsBsdOnBatchSpecificUnit,
  xb.TaxBasedPricesPriceUnitQty AS TaxBasedPricesPriceUnitQty,
  xb.ValnClsForSpclStkAtVndr AS ValnClsForSpclStkAtVndr
FROM I_MaterialLedgerPrice AS fmlt
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON xb.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
;