I_CNSLDTNGROUPSTRUCTURE

CDS View

Consolidation Group Structure

I_CNSLDTNGROUPSTRUCTURE is a CDS View in S/4HANA. Consolidation Group Structure. It contains 4 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 4 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_Matrix_CnsldtdDataWthoutElim view inner COMPOSITE Matrix Consolidation: Consolidated Data Without Elim.
P_Matrix_CP_GroupDerived_2 view inner COMPOSITE Matrix Consolidation Periodic with derived Group
P_Matrix_CP_GroupFilled_2 view inner COMPOSITE Matrix Consolidation Periodic with filled Group
P_Matrix_ElimData view inner COMPOSITE Matrix Consolidation: Elimination Data (PL=20, 22)
P_Matrix_ElimDataWGroupDerived view inner BASIC Matrix Consolidation: Elim. Data with Group Derived
P_Matrix_GroupStructurePerYear view from COMPOSITE Matrix Consolidation: Group Structure Per Year
P_Matrix_SFDWGroupDerived view inner COMPOSITE Matrix Consolidation: SFD with Group Derived
P_Matrix_VecElim view inner COMPOSITE Matrix Consolidation: For Vec, PL20 with Group Derived
P_Matrix_VecPCC view inner COMPOSITE Matrix Consolidation: For Vec, PCC Data
P_Matrix_VecSFD view inner COMPOSITE Matrix Consolidation: For Vec, SFD with Group Derived

Fields (4)

KeyField CDS FieldsUsed in Views
ConsolidationDimension ConsolidationDimension 1
ConsolidationGroup ConsolidationGroup,rcongr 5
ConsolidationStructureVersion ConsolidationStructureVersion 1
ConsolidationUnit ConsolidationUnit 1 
@AbapCatalog.sqlViewName: 'ICSGRPSTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consolidation Group Structure'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true


@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #B,
  sizeCategory: #S
  }
define view I_CnsldtnGroupStructure
  as select from fincs_grpstr
{

  key dimen                                                    as ConsolidationDimension,
  key strvs                                                    as ConsolidationStructureVersion,
  key cast (fromyearper as fincs_fyearperiod_fr)               as FromFiscalYearPeriod,
  key congr                                                    as ConsolidationGroup,
  key cast( bunit as fincs_consolidationunit preserving type ) as ConsolidationUnit,

      cast(toyearper as fincs_fyearperiod_to)                  as ToFiscalYearPeriod


      //    fyear                                                as YearOfFirstConsolidation,

      //    fperi                                                as PeriodOfFirstConsolidation,

      //    feflg                                                as FirstCnsldtnIsAtEndOfPeriod,

      //    lyear                                                as YearOfDivestiture,

      //    lperi                                                as PeriodOfDivestiture,

      //    lbflg                                                as DivestitureIsAtBeginOfPeriod,

      //    coimeth                                              as ConsolidationMethod,

      //    coitp                                                as AccountingTechnique


}

Learn More