P_EBPAO_WIPOverview

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_EBPAO_WIPOverview.
-- 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.
-- Parameters: P_Ledger : fins_ledger, P_ToFiscalYearPeriod : fins_fyearperiod, P_CurrencyRole : fis_curtp

CREATE VIEW P_EBPAO_WIPOverview AS
SELECT
  _WIPCost.Ledger AS Ledger,
  EvtBsdOrderAndItem.CompanyCode AS CompanyCode,
  EvtBsdOrderAndItem.OrderID AS OrderID,
  _WIPCost.OrderItem AS OrderItem,
  EvtBsdOrderAndItem.OrderType AS OrderType,
  EvtBsdOrderAndItem.OrderCategory AS OrderCategory,
  EvtBsdOrderAndItem.ControllingArea AS ControllingArea,
  EvtBsdOrderAndItem.Plant AS Plant,
  EvtBsdOrderAndItem.StorageLocation AS StorageLocation,
  EvtBsdOrderAndItem.ProfitCenter AS ProfitCenter,
  EvtBsdOrderAndItem.Product AS Product,
  EvtBsdOrderAndItem.ProductGroup AS ProductGroup,
  cast(_WIPCost.AmountInDisplayCurrency as abgbesges) AS TotalWIPAmountInDspCrcy
FROM P_EBPAO_AdjustedOrder4Cost AS EvtBsdOrderAndItem
INNER JOIN P_EBPAO_WIPOverview2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON _ProfitCenterText.ControllingArea = ControllingArea AND _ProfitCenterText.ProfitCenter = ProfitCenter AND _ProfitCenterText.ValidityStartDate <= $session.system_date AND _ProfitCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON _ProductText.Product = Product  -- association [0..*]
LEFT OUTER JOIN I_ProductGroupText AS _ProductGroupText ON _ProductGroupText.MaterialGroup = ProductGroup  -- association [0..*]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON _StorageLocation.Plant = Plant AND _StorageLocation.StorageLocation = StorageLocation  -- association [0..1]
;