P_PhysInvtryProposal_L1

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_PhysInvtryProposal_L1.
-- 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 P_PhysInvtryProposal_L1 AS
SELECT
  cast(Stock.Material as matnr preserving type) AS Material,
  Stock.Plant AS Plant,
  cast(Stock.StorageLocation as lgort_d preserving type) AS StorageLocation,
  cast(Stock.Batch as charg_d preserving type) AS Batch,
  cast(Stock.Supplier as elifn preserving type) AS Supplier,
  cast(Stock.SDDocument as kdauf preserving type) AS SalesOrder,
  cast(Stock.SDDocumentItem as pi_sales_order_item preserving type) AS SalesOrderItem,
  cast(Stock.WBSElementInternalID as mat_pspnr preserving type) AS WBSElementInternalID,
  cast(Stock.Customer as ekunn preserving type) AS Customer,
  cast(Stock.SpecialStockIdfgStockOwner as pi_owner_of_stock preserving type) AS StockOwner,
  Stock.InventoryStockType AS InventoryStockType,
  Stock.InventorySpecialStockType AS InventorySpecialStockType,
  Stock.MaterialBaseUnit AS MaterialBaseUnit,
  cast( 'X' as materialispostedtostock preserving type ) AS MaterialIsPostedToStock,
  Stock.CostEstimate AS CostEstimate,
  cast(_BatchPlant.InventoryValuationType as bwtar_d preserving type ) AS InventoryValuationType,
  cast(ProdPlant.InventoryForCycleCountInd as mmim_cycle_count_type preserving type ) AS CycleCountType,
  ProdPlant.SerialNumberProfile AS SerialIdentifierAssgmtProfile,
  _BatchPlant.MatlBatchIsInRstrcdUseStock AS MatlBatchIsInRstrcdUseStock,
  $session.system_date AS CurrentDate,
  cast(sum(Stock.MatlWrhsStkQtyInMatlBaseUnit) as nsdm_stock_qty preserving type ) AS MatlWrhsStkQtyInMatlBaseUnit,
  max(_KeyFigures.PhysicalInventoryLastCountDate) AS PhysicalInventoryLastCountDate,
  case when ( _NotPostedMaterial.InventoryValuationType <> '' or _NotPostedMaterial.InventoryValuationType is not null ) then _DerivatingBatchValuation.ProdCostEstNumber when ( _NotPostedMaterial.ValuationCategory <> '' and _NotPostedMaterial.IsBatchManagementRequired = 'X' ) then _ValuatedProductValuation.ProdCostEstNumber else _NonValuatedProductValuation.ProdCostEstNumber end as CostEstimate AS ProdCostEstNumberendasCostEstimate,
  max(_KeyFigures.NumberOfPhysInventoryCounts) AS NumberOfPhysInventoryCounts
FROM I_MaterialStock_2 AS Stock
INNER JOIN P_ProductPlantBasic AS ProdPlant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BatchPlant AS _BatchPlant ON _BatchPlant.Material = Stock.Material AND _BatchPlant.Plant = Stock.Plant AND _BatchPlant.Batch = Stock.Batch  -- association [0..1]
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_PhysInvtryNotPosted_L3
;