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.MaterialPrice AS FuturePrice,
  fmlt.MaterialPriceValidityStartDate 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.meins AS BaseUnit,
  ma.matkl AS MaterialGroup,
  ma.mtart AS MaterialType,
  mc.lvorm AS PlntMatlIsMarkedForDeletion,
  mc.mmsta AS MaterialUsabilityProfile,
  mc.ausss AS AssemblyScrapPercent,
  mc.beskz AS MaterialProcurementCategory,
  mc.sobsl AS MaterialProcurementProfile,
  mc.prctr AS ProfitCenter,
  mc.verkz AS HasProductionVersion,
  mc.stlal AS AlternativeBillOfMaterial,
  mc.stlan AS BillOfMaterialVariantUsage,
  mc.plnnr AS TaskListGroup,
  mc.aplal AS TaskListGroupCounter,
  mc.losgr AS CostingLotSize,
  mc.sobsk AS CostingMatProcurementProfile,
  mc.kausf AS ComponentScrapInPercent,
  mc.kzkup AS IsCoProduct,
  mc.schgt AS IsBulkMaterial,
  mc.plnty AS BillOfOperationsType,
  mc.fvidk AS CostingProductionVersion,
  mc.fxpru AS IsFixedPriceCoProduct,
  mc.ncost 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.TotStkValAtSlsPrcInCoCodeCrcy AS TotStkValAtSlsPrcInCoCodeCrcy,
  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]
;