P_EBWObjectMaxStatus

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_EBWObjectMaxStatus.
-- 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: PFIEBWOBJMAXSTAT
-- Parameters: P_ToFiscalYearPeriod : fins_fyearperiod

CREATE VIEW P_EBWObjectMaxStatus AS
SELECT
  _aufk.objnr AS ControllingObject,
  _aufk.aufnr AS OrderID,
  _aufk.kokrs AS ControllingArea,
  _aufk.bukrs AS CompanyCode,
  _aufk.autyp AS OrderCategory,
  _afpo.matnr AS Material,
  _aufk.werks AS Plant,
  _aufk.auart AS OrderType,
  _aufk.abgsl AS ResultsAnalysisKey,
  _aufk.kalsm AS CostingSheet,
  _afpo.amein AS ProductionUnit,
  _aufk.prctr AS ProfitCenter,
  _FiscalYearForCC.FiscalPeriodEndDate AS VDM_V_KEY_DATE,
  max( case when _ObjectStatus.StatusCode = 'I0012' and _afpo.ltrmi <= _FiscalYearForCC.FiscalPeriodEndDate then _ObjectStatus.StatusCode when _ObjectStatus.StatusCode = 'I0045' and _aufk.idat2 <= _FiscalYearForCC.FiscalPeriodEndDate then _ObjectStatus.StatusCode else 'I0002' end ) as StatusCode AS StatusCodeelseI0002endasStatusCode
FROM aufk AS _aufk
INNER JOIN afpo AS _afpo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalYearForCC ON _aufk.bukrs = _FiscalYearForCC.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_COActivityTypeTotalsByPeriod AS _ATT ON _aufk.objnr = _ATT.ControllingObject  -- association [1..1]
;