I_SupDmndAllDocPhysStk

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 I_SupDmndAllDocPhysStk.
-- 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.

CREATE VIEW I_SupDmndAllDocPhysStk AS
SELECT
  Stock.Material AS Material,
  Stock.Plant AS Plant,
  Stock.Batch AS Batch,
  Stock.StorageLocation AS StorageLocation,
  Stock.InventorySpecialStockType AS InventorySpecialStockType,
  Stock.SalesOrder AS SalesOrder,
  Stock.SalesOrderItem AS SalesOrderItem,
  Stock.Customer AS Customer,
  Stock.Supplier AS Supplier,
  Marc.MaterialGroup AS MaterialGroup,
  Marc.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  Marc.MaterialType AS MaterialType,
  mcha.StockSegment AS StockSegment,
  Marc.IsInternalBatchManaged AS IsInternalBatchManaged,
  UnrestrictedStkInStkUnit,
  QualityInspectionStockQuantity,
  TransferStockStorageLocQty,
  TransferStockPlantQuantity,
  StockInTransitQuantity,
  BlockedStockQuantity,
  RestrictedStockQuantity,
  TiedEmptiesStockQuantity,
  GoodsReceiptBlockedStockQty,
  TotalQuantity,
  BaseUnit,
  DocumentCurrency,
  NetPriceAmount,
  SupplyDeliveryDate
FROM P_SupDmndAllDocMatlStkAggrgd AS Stock
INNER JOIN I_SupDmndMaterialPlant AS Marc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupDmndOvwBatchSelection AS mcha ON /* join condition not captured in parsed metadata */
;