F1_Mmim_Matstockquanvalbydat3

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 F1_Mmim_Matstockquanvalbydat3.
-- 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 F1_Mmim_Matstockquanvalbydat3 AS
SELECT
  SourceConstantId,
  Material,
  Plant,
  StorageLocation,
  ResourceId,
  Batch,
  Supplier,
  SDDocument,
  SDDocumentItem,
  WBSElementInternalID,
  Customer,
  InventorySpecialStockType,
  CompanyCode,
  MaterialBaseUnit,
  Currency,
  InventoryValuationType,
  CurrentStock,
  QualityInspectionStockQuantity,
  ReturnsBlockedStockQuantity,
  TransferStockStorageLocQty,
  TransferStockPlantQuantity,
  StockInTransitQuantity,
  BlockedStockQuantity,
  RestrictedStockQuantity,
  TiedEmptiesStockQuantity,
  GoodsReceiptBlockedStockQty,
  cast(CurrentStockValue as mmim_currentstockval) AS CurrentStockValue,
  cast(QualityInspectionStockValue as mmim_qualityinspectionstval) AS QualityInspectionStockValue,
  cast(ReturnsBlockedStockValue as mmim_returnsblockedstockval) AS ReturnsBlockedStockValue,
  cast(TransferStockStorageLocValue as mmim_transferststorlocval) AS TransferStockStorageLocValue,
  cast(TransferStockPlantValue as mmim_transferstockplantval) AS TransferStockPlantValue,
  cast(StockInTransitValue as mmim_stockintransitval) AS StockInTransitValue,
  cast(BlockedStockValue as mmim_blockedstockval) AS BlockedStockValue,
  cast(RestrictedStockValue as mmim_restrictedstockval) AS RestrictedStockValue,
  cast(TiedEmptiesStockValue as mmim_tiedemptiesstockval) AS TiedEmptiesStockValue,
  cast(GoodsReceiptBlockedStockValue as mmim_goodsreceiptblockstval) AS GoodsReceiptBlockedStockValue,
  cast(CurrentStockCurVal as mmim_currentstockcurval) AS CurrentStockCurVal,
  cast(QualityInspectionStockCurVal as mmim_qualityinspectionstcurval) AS QualityInspectionStockCurVal,
  cast(ReturnsBlockedStockCurVal as mmim_returnsblockedstockcurval) AS ReturnsBlockedStockCurVal,
  cast(TransferStockStorageLocCurVal as mmim_transferststorloccurval) AS TransferStockStorageLocCurVal,
  cast(TransferStockPlantCurVal as mmim_transferstockplantcurval) AS TransferStockPlantCurVal,
  cast(StockInTransitCurVal as mmim_stockintransitcurval) AS StockInTransitCurVal,
  cast(BlockedStockCurVal as mmim_blockedstockcurval) AS BlockedStockCurVal,
  cast(RestrictedStockCurVal as mmim_restrictedstockcurval) AS RestrictedStockCurVal,
  cast(TiedEmptiesStockCurVal as mmim_tiedemptiesstockcurval) AS TiedEmptiesStockCurVal,
  cast(GoodsReceiptBlockedStockCurVal as mmim_goodsreceiptblockstcurval) as GoodsReceiptBlockedStockCurVal AS P_EndDateSourceConstantId,
  cast(GoodsReceiptBlockedStockCurVal as mmim_goodsreceiptblockstcurval) AS GoodsReceiptBlockedStockCurVal
FROM F51_Mmim_Matstockquanvalbydat3
-- UNION ALL with additional select branch(es): F_Mmim_Marc_Dval, F_Mmim_Mard_Dval, F_Mmim_Mchb_Dval, F_Mmim_Mcha_Dval, F52_Mmim_Matstockquanvalbydat3
;