P_CnsldtnGroupStructure

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_CnsldtnGroupStructure.
-- 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_CnsldtnGroupStructure AS
SELECT
  cast(_Source.congr as fincs_consolidationgroup preserving type ) AS ConsolidationGroup,
  cast(_Source.bunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  _CnsldtnVersionJ.ConsolidationVersion AS ConsolidationVersion,
  cast(_Source.fromyearper as fincs_groupstrucfromfyp ) AS GroupStrucFromFiscalYearPeriod,
  cast(_Source.toyearper as fincs_groupstructofyp ) AS GroupStrucToFiscalYearPeriod,
  cast(_Source.fyear as fincs_yearoffirstconsolidation preserving type ) AS YearOfFirstConsolidation,
  cast(_Source.fperi as fincs_periodoffirstcnsldtn preserving type ) AS PeriodOfFirstConsolidation,
  cast( concat(_Source.fyear,_Source.fperi ) as fincs_firstcnsldtnfyp ) AS FirstCnsldtnFiscalYearPeriod,
  cast(_Source.feflg as fincs_firstcnsldtnatendofperd preserving type ) AS FirstCnsldtnIsAtEndOfPeriod,
  cast(_Source.lyear as fincs_yearofdivestiture preserving type ) AS YearOfDivestiture,
  cast(_Source.lperi as fincs_periodofdivestiture preserving type ) AS PeriodOfDivestiture,
  cast( concat(_Source.lyear,_Source.lperi ) as fincs_divestiturefyp ) AS DivestitureFiscalYearPeriod,
  cast(_Source.lbflg as fincs_divestitureatbeginofperd preserving type ) AS DivestitureIsAtBeginOfPeriod,
  cast(' ' as fincs_investmentmethod preserving type ) AS ConsolidationMethod,
  cast('' as fincs_accountingtechnique preserving type ) AS AccountingTechnique,
  _Source.etag AS ETag
FROM fincs_grpstr AS _Source
INNER JOIN I_CnsldtnVersion AS _CnsldtnVersionJ ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CnsldtnVersion AS _CnsldtnVersion ON ConsolidationVersion = _CnsldtnVersion.ConsolidationVersion  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnGroup_3 AS _CnsldtnGroup ON ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _CnsldtnUnit ON ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnGroupStrucMethAssgmt AS _CnsldtnGroupStrucMethAssgmt ON ConsolidationGroup = _CnsldtnGroupStrucMethAssgmt.ConsolidationGroup AND ConsolidationUnit = _CnsldtnGroupStrucMethAssgmt.ConsolidationUnit AND ConsolidationVersion = _CnsldtnGroupStrucMethAssgmt.ConsolidationVersion AND GroupStrucFromFiscalYearPeriod = _CnsldtnGroupStrucMethAssgmt.GroupStrucFromFiscalYearPeriod  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnInvmtUtilznSetting AS _CnsldtnInvmtUtilznSetting ON _Source.dimen = _CnsldtnInvmtUtilznSetting.ConsolidationDimension  -- association [0..1]
;