P_MaterialStockTimeSerKPIICG

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_MaterialStockTimeSerKPIICG.
-- 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_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_PeriodType : nsdm_period_type, P_InventoryConsumptionGroup : inventory_consumption_group

CREATE VIEW P_MaterialStockTimeSerKPIICG AS
SELECT
  Main.PeriodType AS PeriodType,
  Main.StartDate AS StartDate,
  Main.YearPeriod AS YearPeriod,
  Main.Material AS Material,
  Main.Plant AS Plant,
  Main.StorageLocation AS StorageLocation,
  Main.Batch AS Batch,
  Main.Supplier AS Supplier,
  Main.SDDocument AS SDDocument,
  Main.SDDocumentItem AS SDDocumentItem,
  Main.WBSElementInternalID AS WBSElementInternalID,
  Main.Customer AS Customer,
  Main.InventoryStockType AS InventoryStockType,
  Main.InventorySpecialStockType AS InventorySpecialStockType,
  Main.FiscalYearVariant AS FiscalYearVariant,
  Main.MaterialBaseUnit AS MaterialBaseUnit,
  Main.CostEstimate AS CostEstimate,
  Main.CompanyCode AS CompanyCode,
  Main.Currency AS Currency,
  Main.MatlWrhsStkQtyInMatlBaseUnit AS MatlWrhsStkQtyInMatlBaseUnit,
  Main.MatlCnsmpnQtyInMatlBaseUnit AS MatlCnsmpnQtyInMatlBaseUnit,
  division(cast(Main.MatlStkQtySumInPeriod as abap.dec(25,3)), dats_days_between(Main.StartDate, Main.EndDate)+1, 2) AS MatlStkQtyAvg,
  CurrentInvtryPrice.InventoryPrice AS InventoryPrice,
  CurrentInvtryPrice.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  CurrentInvtryPrice.BaseUnit AS BaseUnit
FROM P_MaterialStockTimeSeriesICG
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_InventoryStockType AS _InventoryStockType ON InventoryStockType = _InventoryStockType.InventoryStockType  -- association [1..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_InvtryPrcBasicByKeyDate AS _InvtryPrcByPeriodEndDate ON CostEstimate = _InvtryPrcByPeriodEndDate.CostEstimate  -- association [0..1]
;