P_CnsldtnGroupStructureEnhcd

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_CnsldtnGroupStructureEnhcd.
-- 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_CnsldtnGroupStructureEnhcd AS
SELECT
  _Source.ConsolidationGroup AS ConsolidationGroup,
  _Source.ConsolidationUnit AS ConsolidationUnit,
  _Source.ConsolidationVersion AS ConsolidationVersion,
  cast( _Source.FromFiscalYearPeriod as fincs_groupstrucfromfyp preserving type ) AS GroupStrucFromFiscalYearPeriod,
  cast( _Source.ToFiscalYearPeriod as fincs_groupstructofyp preserving type ) AS GroupStrucToFiscalYearPeriod,
  _Source.PeriodOfFirstConsolidation AS PeriodOfFirstConsolidation,
  _Source.YearOfFirstConsolidation AS YearOfFirstConsolidation,
  cast( lpad( cast( cast( _Source.YearOfFirstConsolidation as abap.int2 ) - 1 as abap.char(11) ), 4, '0' ) as fincs_fiscalyear ) AS YearBeforeFirstConsolidation,
  cast( lpad( cast( cast( _Source.PeriodOfFirstConsolidation as abap.int2 ) - 1 as abap.char(11) ), 3, '0' ) as fc_perid ) AS PeriodBeforeFirstConsolidation,
  cast( concat( _Source.YearOfFirstConsolidation, _Source.PeriodOfFirstConsolidation ) as fincs_firstcnsldtnfyp ) AS FirstCnsldtnFiscalYearPeriod,
  _Source.FirstCnsldtnIsAtEndOfPeriod AS FirstCnsldtnIsAtEndOfPeriod,
  _Source.YearOfDivestiture AS YearOfDivestiture,
  _Source.PeriodOfDivestiture AS PeriodOfDivestiture,
  cast( lpad( cast( cast( _Source.YearOfDivestiture as abap.int2 ) + 1 as abap.char(11) ), 4, '0' ) as fincs_fiscalyear ) AS YearAfterDivestiture,
  cast( lpad( cast( cast( _Source.PeriodOfDivestiture as abap.int2 ) + 1 as abap.char(11) ), 3, '0' ) as fc_perid ) AS PeriodAfterDivestiture,
  cast( concat( _Source.YearOfDivestiture, _Source.PeriodOfDivestiture ) as fincs_divestiturefyp ) AS DivestitureFiscalYearPeriod,
  _Source.DivestitureIsAtBeginOfPeriod AS DivestitureIsAtBeginOfPeriod,
  _Source.DivestitureIsDueToMerger AS DivestitureIsDueToMerger,
  _Source.ETag AS ETag,
  cast( '999' as fc_perid preserving type ) AS FinalPeriod,
  cast( '001' as fc_perid preserving type ) AS FirstPeriod
FROM I_CnsldtnGroupStructure_2 AS _Source
;