P_MaterialKPIStocksForPhysInv

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_MaterialKPIStocksForPhysInv.
-- 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: PMATKPISTKPIN
-- Parameters: P_StartDate : nsdm_reference_startdate, P_EndDate : nsdm_reference_enddate

CREATE VIEW P_MaterialKPIStocksForPhysInv AS
SELECT
  Material,
  Plant,
  StorageLocation,
  Batch,
  Supplier,
  SDDocument,
  SDDocumentItem,
  WBSElementInternalID,
  Customer,
  SpecialStockIdfgStockOwner,
  InventoryStockType,
  InventorySpecialStockType,
  MaterialBaseUnit,
  CostEstimate,
  CompanyCode,
  sum(MatlWrhsStkQtyInMatlBaseUnit) AS MatlWrhsStkQtyInMatlBaseUnit,
  cast(sum( case when MatlDocLatestPostgDate < $parameters.P_StartDate then cast( MatlWrhsStkQtyInMatlBaseUnit as abap.dec(25,3)) * (dats_days_between($parameters.P_StartDate, $parameters.P_EndDate)+1) else cast( MatlWrhsStkQtyInMatlBaseUnit as abap.dec(25,3)) * (dats_days_between(MatlDocLatestPostgDate, $parameters.P_EndDate)+1) end ) as abap.dec(25,3)) as MatlStkQtySumInPeriod AS dec253asMatlStkQtySumInPeriod
FROM I_MaterialStock_2
;