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.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_Matrix_CnsldtdDataWthoutElim view inner COMPOSITE
P_Matrix_CP_GroupDerived_2 view inner COMPOSITE
P_Matrix_CP_GroupFilled_2 view inner COMPOSITE
P_Matrix_ElimData view inner COMPOSITE
P_Matrix_ElimDataWGroupDerived view inner BASIC
P_Matrix_GroupStructurePerYear view from COMPOSITE
P_Matrix_SFDWGroupDerived view inner COMPOSITE
P_Matrix_VecElim view inner COMPOSITE
P_Matrix_VecPCC view inner COMPOSITE
P_Matrix_VecSFD view inner COMPOSITE

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 bunit                                                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


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINCS_GRPSTR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/