I_SlowOrNonMovingMatlOPgHdr

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_SlowOrNonMovingMatlOPgHdr.
-- 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_SlowOrNonMovingMatlOPgHdr AS
SELECT
  Material,
  Plant,
  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(NumberOfDaysSinceFirstMovement as nsdm_numofdaysincefirstposting) AS NumberOfDaysSinceFirstMovement,
  cast(ConsumptionQuantity as nsdm_consumption_quantity ) AS CnsmpnQtyInBaseUnitOnRefDate,
  cast(ConsumptionToStockRatio as nsdm_consumptiontostock_ratio preserving type ) AS ConsumptionToStockRatio,
  cast($parameters.P_KeyDate as nsdm_reference_date) AS KeyDate,
  cast($parameters.P_NumberOfDays as nsdm_numofdaysoflowconsumption) AS NumberOfDays,
  P_SlowOrNonMovingMatlOPgHdr._Material.MaterialGroup AS MaterialGroup,
  cast( _Material._MaterialGroup._Text[1: Language=$session.system_language].MaterialGroupName as wgbez preserving type ) AS MaterialGroupName,
  P_SlowOrNonMovingMatlOPgHdr._Material.MaterialType AS MaterialType,
  _Material._MaterialType._Text[1: Language=$session.system_language].MaterialTypeName AS MaterialTypeName,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  P_SlowOrNonMovingMatlOPgHdr._Plant.PlantName AS PlantName
FROM P_SlowOrNonMovingMatlOPgHdr
;