P_MaterialWarehouseStockCheck4

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_MaterialWarehouseStockCheck4.
-- 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: PMATLWHSESTKCHK4

CREATE VIEW P_MaterialWarehouseStockCheck4 AS
SELECT
  StockIdentifyingMaterial,
  Plant,
  StockIdfgStorageLocation,
  StockIdentifyingBatch,
  SpecialStockIdfgSupplier,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  SpecialStockIdfgWBSElement,
  SpecialStockIdfgCustomer,
  SpecialStockIdfgStockOwner,
  InventorySpecialStockType,
  InventoryStockType,
  MaterialBaseUnit,
  MaterialParallelUnit,
  MatlStkQtyInBaseUnit,
  MatlStkQtyInParUnit,
  cast( _CWM_UNIT.umrez as umrez preserving type ) AS PUoMNumerator,
  cast( _CWM_UNIT.umren as umren preserving type ) AS BUoMNumerator,
  cast ('%' as /cwm/percent) AS Percent,
  cast( $parameters.P_LowDevitionErrorThreshold as /cwm/lowdevitionerrorthld preserving type) AS LowDevitionErrorThreshold,
  cast(- $parameters.P_LowDevitionErrorThreshold as /cwm/lowdevitionerrorthld_s preserving type) AS LowThresholdSigned,
  cast( $parameters.P_HighDevitionErrorThreshold as /cwm/highdevitionerrorthld preserving type) AS HighDevitionErrorThreshold,
  CostEstimate,
  CompanyCode,
  Batch,
  _InventoryStockTypeT.InventoryStockTypeName AS InventoryStockTypeName,
  LastPostingDate,
  FiscalYearVariant,
  LastPostingPeriod,
  cast(dats_days_between(LastPostingDate, TodayDate ) as nsdm_numofdaysinceposting preserving type ) AS NumberOfDaysSinceLastMovement,
  TodayDate,
  cast(concat(_CWM_MARV.lfgja, concat('0',_CWM_MARV.lfmon)) as /cwm/current_period) AS CurrentPostingPeriod,
  cast(concat(_CWM_MARV.vmgja, concat('0',_CWM_MARV.vmmon)) as /cwm/previous_period) AS PreviousPostingPeriod
FROM P_MaterialWarehouseStockCheck2
LEFT OUTER JOIN mara AS _CWM_MARA ON StockIdentifyingMaterial = _CWM_MARA.matnr  -- association [0..1]
LEFT OUTER JOIN tcwqtolgr AS _ToleranceGroup ON ToleranceGroup = _ToleranceGroup.cwqtolgr  -- association [0..1]
LEFT OUTER JOIN marv AS _CWM_MARV ON CompanyCode = _CWM_MARV.bukrs  -- association [0..1]
LEFT OUTER JOIN marm AS _CWM_UNIT ON StockIdentifyingMaterial = _CWM_UNIT.matnr AND MaterialParallelUnit = _CWM_UNIT.meinh AND _CWM_UNIT.ty2tq = 'A'  -- association [0..1]
LEFT OUTER JOIN I_InventoryStockTypeT AS _InventoryStockTypeT ON _InventoryStockTypeT.InventoryStockType = InventoryStockType AND _InventoryStockTypeT.Language = $session.system_language  -- association [0..1]
;