P_EnhPhysInvtryActvStkSep

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_EnhPhysInvtryActvStkSep.
-- 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: PENHACTVSTOCKSEP

CREATE VIEW P_EnhPhysInvtryActvStkSep AS
SELECT
  sep.Material AS Material,
  sep.Plant AS Plant,
  sep.StorageLocation AS StorageLocation,
  sep.Batch AS Batch,
  sep.Supplier AS Supplier,
  sep.SalesOrder AS SalesOrder,
  sep.SalesOrderItem AS SalesOrderItem,
  case when sep.WBSElementInternalID = '00000000' then '' else _WBSElement.WBSElement end AS WBSElement,
  sep.Customer AS Customer,
  sep.StockOwner AS StockOwner,
  sep.InventoryStockType AS InventoryStockType,
  sep.InventorySpecialStockType AS InventorySpecialStockType,
  sep.MaterialBaseUnit AS MaterialBaseUnit,
  sep.MaterialIsPostedToStock AS MaterialIsPostedToStock,
  cast( sep.CycleCountType as mmim_cycle_count_type ) AS CycleCountType,
  _CycleCounting.NmbrOfPhysInvtryPerFiscalYear AS NmbrOfPhysInvtryPerFiscalYear,
  _CycleCounting.PhysInvtryIntvlForCycCounting AS PhysInvtryIntvlForCycCounting,
  _CycleCounting.PhysInvtryFloatTimeCycCounting AS PhysInvtryFloatTimeCycCounting,
  sep.WBSElementInternalID AS WBSElementInternalID,
  ProductType,
  ProductGroup,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  _FiscalYear.FiscalYearEndDate AS FiscalYearEndDate,
  MatlWrhsStkQtyInMatlBaseUnit,
  CurrentDate,
  sum( case when MatDoc.PostingDate > CurrentDate then MatlStkChangeQtyInBaseUnit when MatDoc.PostingDate is null or MatDoc.PostingDate < PhysicalInventoryLastCountDate then 0 when MatDoc.PostingDate = PhysicalInventoryLastCountDate then cast(MatlStkChangeQtyInBaseUnit as abap.fltp) *0.5 / (1.0 + cast(dats_days_between( PhysicalInventoryLastCountDate, CurrentDate ) as abap.fltp)) else cast(MatlStkChangeQtyInBaseUnit as abap.fltp) * (0.5 + cast(dats_days_between( PhysicalInventoryLastCountDate, MatDoc.PostingDate ) as abap.fltp)) / (1.0 + cast(dats_days_between( PhysicalInventoryLastCountDate, CurrentDate ) as abap.fltp)) end ) as AvgStkQtySinceLastCountCorrect AS fltpendasAvgStkQtySinceLastCountCorrect
FROM P_PhysInvtryActvStkSeparator AS sep
LEFT OUTER JOIN P_MatDocRec AS MatDoc ON /* join condition not captured in parsed metadata */
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_FiscalYear AS _FiscalYear ON _FiscalYear.FiscalYearVariant = _CompanyCode.FiscalYearVariant AND _FiscalYear.FiscalYear = _CurrentPeriod.FiscalYear  -- 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]
LEFT OUTER JOIN I_CycleCountingSettings AS _CycleCounting ON _CycleCounting.CycleCountType = sep.CycleCountType AND _CycleCounting.Plant = Plant  -- association [0..1]
;