P_PhysInvtryProposal_L2

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_L2.
-- 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_L2 AS
SELECT
  L1.Material AS Material,
  L1.Plant AS Plant,
  L1.StorageLocation AS StorageLocation,
  L1.Batch AS Batch,
  L1.Supplier AS Supplier,
  L1.SalesOrder AS SalesOrder,
  case when L1.SalesOrderItem is null then '000000' else L1.SalesOrderItem end AS SalesOrderItem,
  case when L1.WBSElementInternalID = '00000000' then '' else _WBSElement.WBSElement end AS WBSElement,
  L1.Customer AS Customer,
  L1.StockOwner AS StockOwner,
  L1.InventoryStockType AS InventoryStockType,
  L1.InventorySpecialStockType AS InventorySpecialStockType,
  L1.MaterialBaseUnit AS MaterialBaseUnit,
  L1.MaterialIsPostedToStock AS MaterialIsPostedToStock,
  L1.CostEstimate AS CostEstimate,
  L1.InventoryValuationType AS InventoryValuationType,
  L1.RealProductBatch AS RealProductBatch,
  L1.CycleCountType AS CycleCountType,
  L1.SerialIdentifierAssgmtProfile AS SerialIdentifierAssgmtProfile,
  L1.MatlBatchIsInRstrcdUseStock AS MatlBatchIsInRstrcdUseStock,
  L1.WBSElementInternalID AS WBSElementInternalID,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  L1.CurrentDate AS CurrentDate,
  L1.MatlWrhsStkQtyInMatlBaseUnit AS MatlWrhsStkQtyInMatlBaseUnit,
  cast(L1.PhysicalInventoryLastCountDate as pi_last_count_date preserving type) AS PhysicalInventoryLastCountDate,
  sum( case when MatDoc.PostingDate > L1.CurrentDate then cast( MatDoc.MatlStkChangeQtyInBaseUnit as abap.fltp) when MatDoc.PostingDate is null or MatDoc.PostingDate < L1.PhysicalInventoryLastCountDate then cast( 0 as abap.fltp) when MatDoc.PostingDate = L1.PhysicalInventoryLastCountDate then cast(MatDoc.MatlStkChangeQtyInBaseUnit as abap.fltp) *0.5 / (1.0 + cast(dats_days_between( L1.PhysicalInventoryLastCountDate, L1.CurrentDate ) as abap.fltp)) else cast(MatDoc.MatlStkChangeQtyInBaseUnit as abap.fltp) * (0.5 + cast(dats_days_between( L1.PhysicalInventoryLastCountDate, MatDoc.PostingDate ) as abap.fltp)) / (1.0 + cast(dats_days_between( L1.PhysicalInventoryLastCountDate, L1.CurrentDate ) as abap.fltp)) end ) as AvgStkQtySinceLastCountCorrect AS fltpendasAvgStkQtySinceLastCountCorrect
FROM P_PhysInvtryProposal_L1 AS L1
INNER JOIN I_CompanyCode AS _CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_AdjmtPostingMovementType AS _AdjmtPostingMovementTypeS ON MatDoc.GoodsMovementType = _AdjmtPostingMovementTypeS.PhysInvtryIncreasingQtyMvtType AND MatDoc.InventorySpecialStockType = _AdjmtPostingMovementTypeS.InventorySpecialStockType AND _AdjmtPostingMovementTypeS.PhysicalInventoryStockType <> ''  -- association [0..1]
LEFT OUTER JOIN I_AdjmtPostingMovementType AS _AdjmtPostingMovementTypeD ON MatDoc.GoodsMovementType = _AdjmtPostingMovementTypeD.PhysInvtryDecreasingQtyMvtType AND MatDoc.InventorySpecialStockType = _AdjmtPostingMovementTypeD.InventorySpecialStockType AND _AdjmtPostingMovementTypeD.PhysicalInventoryStockType <> ''  -- association [0..1]
;