I_SlowOrNonMovingMatlOPg

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_SlowOrNonMovingMatlOPg.
-- 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_DisplayCurrency : nsdm_display_currency, P_KeyDate : calendardate, P_NumberOfDays : int4, P_InventoryConsumptionGroup : inventory_consumption_group

CREATE VIEW I_SlowOrNonMovingMatlOPg AS
SELECT
  Material,
  Plant,
  StockIdentifyingBatch,
  SpecialStockIdfgSupplier,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  SpecialStockIdfgWBSElement,
  SpecialStockIdfgCustomer,
  SpecialStockIdfgStockOwner,
  InventorySpecialStockType,
  InventoryStockType,
  MaterialBaseUnit,
  cast(MatlWrhsStkQtyInMatlBaseUnit as nsdm_material_stock_in_buom) AS MatlWrhsStkQtyInMatlBaseUnit,
  cast(StockValueInCCCrcy as nsdm_stock_value_in_cccrcy) AS StockValueInCCCrcy,
  cast(Currency as waers) AS Currency,
  cast($parameters.P_DisplayCurrency as vdm_v_display_currency ) AS DisplayCurrency,
  cast(MatlDocLatestPostgDate as nsdm_date_of_last_posting) AS MatlDocLatestPostgDate,
  cast(NumberOfDaysSinceLastCnsmpn as nsdm_numofdaysinceconsumption) AS NumberOfDaysSinceLastCnsmpn,
  cast(NumberOfDaysSinceLastMovement as nsdm_numofdaysinceposting) AS NumberOfDaysSinceLastMovement,
  cast(ConsumptionQuantity as nsdm_consumption_quantity ) AS CnsmpnQtyInBaseUnitOnRefDate,
  cast(ConsumptionToStockRatio as nsdm_consumptiontostock_ratio preserving type ) AS ConsumptionToStockRatio,
  cast( (NumberOfBomCross + NumberOfBomPlant) as nsdm_number_of_bom_used_in ) AS NumberOfBOMUsingTheMaterial,
  cast($parameters.P_KeyDate as nsdm_reference_date) AS KeyDate,
  cast($parameters.P_NumberOfDays as nsdm_numofdaysoflowconsumption) AS NumberOfDays,
  cast( _Product.ProductGroup as matkl preserving type ) AS MaterialGroup,
  cast( _Product._ProductGroupText_2[1: Language=$session.system_language].ProductGroupName as nsdm_wgbez preserving type ) AS MaterialGroupName,
  cast( _Product.ProductType as mtart preserving type ) AS MaterialType,
  cast( _Product._ProductTypeName[1: Language=$session.system_language].MaterialTypeName as nsdm_mtbez preserving type ) AS MaterialTypeName,
  cast( _Product._Text[1: Language=$session.system_language].ProductName as maktx preserving type ) AS MaterialName,
  _PlantBasic.PlantName AS PlantName
FROM P_SlowOrNonMovingMatlBOMOPg
LEFT OUTER JOIN I_MatlDocMaterialVH AS _Material ON Material = _Material.Material AND Plant = _Material.Plant  -- association [0..1]
LEFT OUTER JOIN I_MatlDocPlantVH AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _PlantBasic ON Plant = _PlantBasic.Plant  -- association [0..1]
LEFT OUTER JOIN E_Product AS _ProductExt ON Material = _ProductExt.Product  -- association [0..1]
LEFT OUTER JOIN E_Productplant AS _ProductPlantExt ON Material = _ProductPlantExt.Product AND Plant = _ProductPlantExt.Plant  -- association [0..1]
;