I_CNSLDTNUNIT_3

CDS View

Consolidation Unit

I_CNSLDTNUNIT_3 is a CDS View in S/4HANA. Consolidation Unit. It contains 5 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 5 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_CnsldtnUnitValueHelp_3 view from CONSUMPTION Consolidation Unit Value Help
P_CnsldtnUnit_UnionByKey view union COMPOSITE
P_CnsldtnUnitOverview view from COMPOSITE
P_GLE_ADB_GR_01 view inner COMPOSITE
P_GLE_ADB_GR_FT_01 view_entity inner COMPOSITE Consolidation Average Daily Balance
P_PLANDATA_NRL_01 view inner COMPOSITE
P_REALTIMERPTDFINDATANRL_01 view inner COMPOSITE
P_RepFinData_RT_AggrNRL_02 view inner COMPOSITE
P_REPFINDATA_RT_AGGRSNRL_02 view inner COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY ConsolidationDimension ConsolidationDimension 6
KEY ConsolidationUnit ConsolidationUnit 6
ConsolidationUnitLink ConsolidationUnitLink 1
ConsolidationUnitLinkLabel ConsolidationUnitLinkLabel 1
Country Country 1 
@AbapCatalog:{
  sqlViewName: 'ICSCONSUNIT3',
  compiler.compareFilter: true,
  preserveKey: true
  }
@AccessControl.authorizationCheck: #CHECK
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}
@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #S},
  representativeKey: 'ConsolidationUnit',
  modelingPattern: #ANALYTICAL_DIMENSION,
  supportedCapabilities: [#CDS_MODELING_DATA_SOURCE,
                          #CDS_MODELING_ASSOCIATION_TARGET,
                          #SQL_DATA_SOURCE,
                          #ANALYTICAL_DIMENSION
                          ]
}
@VDM.viewType: #BASIC
@EndUserText.label: 'Consolidation Unit'

@VDM.lifecycle:{
  status: #DEPRECATED,
  successor: 'I_CnsldtnUnit_4'
  }

define view I_CnsldtnUnit_3
  as select from fincs_bunit

  association [1..1] to I_CnsldtnDimension  as _CnsldtnDimension on $projection.ConsolidationDimension = _CnsldtnDimension.ConsolidationDimension

  association [0..*] to I_CnsldtnUnitText_3 as _Text             on $projection.ConsolidationUnit = _Text.ConsolidationUnit

  association [1..1] to I_Country           as _Country          on $projection.Country = _Country.Country

  //association for company determination

  //--> must not be exposed

  association [0..1] to I_CnsldtnCompany    as _Company          on fincs_bunit.rcomp = _Company.Company

{

      @ObjectModel.text.association: '_Text'
  key bunit                                                    as ConsolidationUnit,

      @ObjectModel.foreignKey.association: '_Country'
      cntry                                                    as Country,

      link                                                     as ConsolidationUnitLink,

      linklabel                                                as ConsolidationUnitLinkLabel,

      @ObjectModel.foreignKey.association: '_CnsldtnDimension'
      dimen                                                    as ConsolidationDimension,

      cast(_Company.Company as fincs_company preserving type ) as Company, //only project existing companies


      @UI.hidden: true
      etag                                                     as ETag,


      _CnsldtnDimension,
      _Country,
      _Text

}
where
  dimen = 'Y1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNCOMPANY",
"FINCS_BUNIT"
],
"ASSOCIATED":
[
"I_CNSLDTNCOMPANY",
"I_CNSLDTNDIMENSION",
"I_CNSLDTNUNITTEXT_3",
"I_COUNTRY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More