P_PhysInvtryActvStkSeparator

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_PhysInvtryActvStkSeparator.
-- 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: PPIACTVSTOCKSEP

CREATE VIEW P_PhysInvtryActvStkSeparator AS
SELECT
  cast(StockSep.StockIdentifyingMaterial as matnr preserving type) AS Material,
  StockSep.Plant AS Plant,
  cast(StockSep.StockIdfgStorageLocation as lgort_d preserving type) AS StorageLocation,
  cast(StockSep.StockIdentifyingBatch as charg_d preserving type) AS Batch,
  cast(StockSep.SpecialStockIdfgSupplier as elifn preserving type) AS Supplier,
  cast(StockSep.SpecialStockIdfgSalesOrder as kdauf preserving type) AS SalesOrder,
  cast(StockSep.SpecialStockIdfgSalesOrderItem as pi_sales_order_item preserving type) AS SalesOrderItem,
  StockSep.SpecialStockIdfgWBSElement AS WBSElementInternalID,
  cast(StockSep.SpecialStockIdfgCustomer as ekunn preserving type) AS Customer,
  cast(StockSep.SpecialStockIdfgStockOwner as pi_owner_of_stock preserving type) AS StockOwner,
  StockSep.InventoryStockType AS InventoryStockType,
  StockSep.InventorySpecialStockType AS InventorySpecialStockType,
  StockSep.MaterialBaseUnit AS MaterialBaseUnit,
  cast( 'X' as materialispostedtostock preserving type ) AS MaterialIsPostedToStock,
  max(ProdPlant.InventoryForCycleCountInd) AS CycleCountType,
  max(ProdPlant.CycleCountingIndicatorIsFixed) AS CycleCountingIndicatorIsFixed,
  max(prod.ProductType) AS ProductType,
  max(prod.ProductGroup) AS ProductGroup,
  cast(sum(StockSep.MatlStkChangeQtyInBaseUnit) as nsdm_stock_qty ) AS MatlWrhsStkQtyInMatlBaseUnit,
  max(_KeyFigures.PhysicalInventoryLastCountDate) AS PhysicalInventoryLastCountDate,
  max(_KeyFigures.NumberOfPhysInventoryCounts) AS NumberOfPhysInventoryCounts,
  $session.system_date AS CurrentDate
FROM P_MaterialDocumentExtract AS StockSep
LEFT OUTER JOIN P_MappedPhysInvtryItem AS PiItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PhysInvtryKeyFiguresBase AS _KeyFigures ON _KeyFigures.Material = Material AND _KeyFigures.Plant = Plant AND _KeyFigures.StorageLocation = StorageLocation AND _KeyFigures.Batch = Batch AND _KeyFigures.Supplier = Supplier AND _KeyFigures.SalesOrder = SalesOrder AND _KeyFigures.SalesOrderItem = SalesOrderItem AND _KeyFigures.WBSElementInternalID = WBSElementInternalID AND _KeyFigures.Customer = Customer AND _KeyFigures.StockOwner = StockOwner AND _KeyFigures.InventoryStockType = InventoryStockType AND _KeyFigures.InventorySpecialStockType = InventorySpecialStockType AND _KeyFigures.MaterialBaseUnit = MaterialBaseUnit  -- association [0..1]
-- UNION ALL with additional select branch(es): P_PhysInvtryNotPostedMaterial
;