P_GLE_ADB_PERIOD_LAST

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_GLE_ADB_PERIOD_LAST.
-- 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: PGADBPRLAST

CREATE VIEW P_GLE_ADB_PERIOD_LAST AS
SELECT
  GS.ConsolidationGroup AS cgrp,
  R.bunit AS cunit,
  R.rvers AS rvers,
  R.close_time AS ctime,
  R.fperi AS period,
  R.fyear AS yr,
  case when I_CnsldtnUnitByTimeVersion.FiscalYearVariant is not null and I_CnsldtnUnitByTimeVersion.FiscalYearVariant <> ' ' then I_CnsldtnUnitByTimeVersion.FiscalYearVariant when I_CnsldtnVersion.FiscalYearVariant is not null and I_CnsldtnVersion.FiscalYearVariant <> ' ' then I_CnsldtnVersion.FiscalYearVariant else 'K4' end as periv AS FiscalYearVariantelseK4endasperiv
FROM P_DataSubmitRequest AS R
INNER JOIN I_CnsldtnVersion ON /* join condition not captured in parsed metadata */
;