P_MaterialWarehouseStockCheck2

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_MaterialWarehouseStockCheck2.
-- 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: PMATLWHSESTKCHK2

CREATE VIEW P_MaterialWarehouseStockCheck2 AS
SELECT
  matbf AS StockIdentifyingMaterial,
  werks AS Plant,
  lgort_sid AS StockIdfgStorageLocation,
  charg_sid AS StockIdentifyingBatch,
  lifnr_sid AS SpecialStockIdfgSupplier,
  mat_kdauf AS SpecialStockIdfgSalesOrder,
  mat_kdpos AS SpecialStockIdfgSalesOrderItem,
  mat_pspnr AS SpecialStockIdfgWBSElement,
  kunnr_sid AS SpecialStockIdfgCustomer,
  disub_owner_sid AS SpecialStockIdfgStockOwner,
  sobkz AS InventorySpecialStockType,
  lbbsa_sid AS InventoryStockType,
  meins AS MaterialBaseUnit,
  /cwm/meins_sid AS MaterialParallelUnit,
  cast ( sum( stock_qty ) as nsdm_stock_qty preserving type ) AS MatlStkQtyInBaseUnit,
  cast ( sum( /cwm/stock_qty ) as /cwm/stock_qty preserving type ) AS MatlStkQtyInParUnit,
  cast ( max( budat ) as nsdm_last_mvt_posting_date preserving type) AS LastPostingDate,
  cast ( max( gjper ) as nsdm_last_mvt_posting_period preserving type) AS LastPostingPeriod,
  cast ( max( bukrs ) as bukrs preserving type) AS CompanyCode,
  cast ( max( periv ) as periv preserving type) AS FiscalYearVariant,
  kalnr AS CostEstimate,
  charg_whs_sg AS Batch,
  cast( $session.system_date as sydatum preserving type ) AS TodayDate
FROM matdoc
;