P_MltplMatlStk_L4_ALL

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_MltplMatlStk_L4_ALL.
-- 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_EndDate : sydate

CREATE VIEW P_MltplMatlStk_L4_ALL AS
SELECT
  Material,
  Plant,
  StorageLocation,
  Batch,
  Supplier,
  SDDocument,
  SDDocumentItem,
  WBSElementInternalID,
  Customer,
  ResourceID,
  InventorySpecialStockType,
  cast('02' as mmim_sourceid) AS MatlWithStockPostingsCode,
  CompanyCode,
  MaterialBaseUnit,
  InventoryValuationType,
  Currency,
  sum(VltdUnrestrictedUseStkQty) AS VltdUnrestrictedUseStkQty,
  sum(QualityInspectionStockQuantity) AS QualityInspectionStockQuantity,
  sum(ReturnsBlockedStockQuantity) AS ReturnsBlockedStockQuantity,
  sum(TransferStockStorageLocQty) AS TransferStockStorageLocQty,
  sum(TransferStockPlantQuantity) AS TransferStockPlantQuantity,
  sum(StockInTransitQuantity) AS StockInTransitQuantity,
  sum(BlockedStockQuantity) AS BlockedStockQuantity,
  sum(RestrictedStockQuantity) AS RestrictedStockQuantity,
  sum(TiedEmptiesStockQuantity) AS TiedEmptiesStockQuantity,
  sum(GoodsReceiptBlockedStockQty) AS GoodsReceiptBlockedStockQty,
  sum(CurrentStockCurVal) AS CurrentStockCurVal,
  sum(QualityInspectionStockCurVal) AS QualityInspectionStockCurVal,
  sum(ReturnsBlockedStockCurVal) AS ReturnsBlockedStockCurVal,
  sum(TransferStockStorageLocCurVal) AS TransferStockStorageLocCurVal,
  sum(TransferStockPlantCurVal) AS TransferStockPlantCurVal,
  sum(StockInTransitCurVal) AS StockInTransitCurVal,
  sum(BlockedStockCurVal) AS BlockedStockCurVal,
  sum(RestrictedStockCurVal) AS RestrictedStockCurVal,
  sum(TiedEmptiesStockCurVal) AS TiedEmptiesStockCurVal,
  sum(GoodsReceiptBlockedStockCurVal) AS GoodsReceiptBlockedStockCurVal,
  sum(CurrentStockValue) AS CurrentStockValue,
  sum(QualityInspectionStockValue) AS QualityInspectionStockValue,
  sum(ReturnsBlockedStockValue) AS ReturnsBlockedStockValue,
  sum(TransferStockStorageLocValue) AS TransferStockStorageLocValue,
  sum(TransferStockPlantValue) AS TransferStockPlantValue,
  sum(StockInTransitValue) AS StockInTransitValue,
  sum(BlockedStockValue) AS BlockedStockValue,
  sum(RestrictedStockValue) AS RestrictedStockValue,
  sum(TiedEmptiesStockValue) AS TiedEmptiesStockValue,
  sum(GoodsReceiptBlockedStockValue) AS GoodsReceiptBlockedStockValue
FROM P_MltplMatlStk_L3_ALL
;