I_CNSLDTNUNIT

CDS View

Consolidation Unit

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

Used by 6 CDS view(s) 4 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_CnsldtnUnitValueHelp view from CONSUMPTION Consolidation Unit Value Help
FINCS_MD_TF16X view from
P_CnsldtnUnit_UnionByKey view from COMPOSITE
P_RealTimeRptdFinData_06 view inner COMPOSITE
P_RepFinData_RT_Aggr_07 view inner COMPOSITE
P_RFD_RT_AGGR_simple_07 view inner COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ConsolidationDimension ConsolidationDimension 4
KEY ConsolidationUnit ConsolidationUnit 4
Country Country 1
DocumentEntryIsInGroupCurrency DocumentEntryIsInGroupCurrency 1 
@AbapCatalog: {
  sqlViewName: 'ICCUNIT',
  compiler.compareFilter: true,
  preserveKey: true,
  buffering:{
    status: #ACTIVE,
    type: #FULL }
}
@AccessControl:{
  authorizationCheck: #CHECK,
  privilegedAssociations: [ '_UnitHierNode' ]
  }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata:{
  allowExtensions:true,
  ignorePropagatedAnnotations: true
  }
@ObjectModel:{
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #C,
    sizeCategory: #M},
  representativeKey: 'ConsolidationUnit',
  modelingPattern: #ANALYTICAL_DIMENSION,
  supportedCapabilities: [#CDS_MODELING_DATA_SOURCE,
                          #CDS_MODELING_ASSOCIATION_TARGET,
                          #SQL_DATA_SOURCE,
                          #ANALYTICAL_DIMENSION ]
}
@Analytics: {
  dataCategory: #DIMENSION
}
@VDM.viewType: #BASIC
@EndUserText.label: 'Consolidation Unit'

define view I_CnsldtnUnit
  as select from    tf160

    left outer join tf162 on  tf162.dimen = 'Y1'
                          and tf162.bunit = tf160.bunit

  association [0..*] to I_CnsldtnUnitT        as _Text         on  $projection.ConsolidationDimension = _Text.ConsolidationDimension
                                                               and $projection.ConsolidationUnit      = _Text.ConsolidationUnit

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


  association [0..*] to I_CnsldtnUnitHierNode as _UnitHierNode on  $projection.ConsolidationDimension = _UnitHierNode.ConsolidationDimension
                                                               and $projection.ConsolidationUnit      = _UnitHierNode.ConsolidationUnit

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

{
      @ObjectModel.foreignKey.association: '_Dimension'
  key tf160.dimen as ConsolidationDimension,


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

      //      // @Remove

      //      bunit as CnsldtnUnit,

      //      // @Remove

      //      dimen as CnsldtnDimension,


      tf160.gcind as DocumentEntryIsInGroupCurrency,
      tf162.cntry as Country,


      _Dimension,
      _UnitHierNode,
      _Text,
      _Country
}
where
      tf160.dimen = 'Y1'
  and tf160.roind = '';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TF160",
"TF162"
],
"ASSOCIATED":
[
"I_CNSLDTNCOUNTRY",
"I_CNSLDTNDIMENSION",
"I_CNSLDTNUNITHIERNODE",
"I_CNSLDTNUNITT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More