I_CnsldtnUnitForElimination

DDL: I_CNSLDTNUNITFORELIMINATION Type: view COMPOSITE

Cnsldtn Unit for Elimination Purpose

I_CnsldtnUnitForElimination is a Composite CDS View (Dimension) that provides data about "Cnsldtn Unit for Elimination Purpose" in SAP S/4HANA. It reads from 1 data source (P_CnsldtnUnitForElimination) and exposes 5 fields with key fields ConsolidationDimension, ConsolidationUnit. It has 3 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_CnsldtnUnitForElimination P_CnsldtnUnitForElimination from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CnsldtnDimension _Dimension $projection.ConsolidationDimension = _Dimension.ConsolidationDimension
[0..*] I_CnsldtnUnitHierNodeForElim _UnitHierNode $projection.ConsolidationDimension = _UnitHierNode.ConsolidationDimension and $projection.ConsolidationUnit = _UnitHierNode.ConsolidationUnit
[0..*] I_CnsldtnUnitForEliminationT _Text $projection.ConsolidationDimension = _Text.ConsolidationDimension and $projection.ConsolidationUnit = _Text.ConsolidationUnit

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICCUNITFORELIM view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey ConsolidationUnit view
VDM.viewType #COMPOSITE view
EndUserText.label Cnsldtn Unit for Elimination Purpose view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationDimension ConsolidationDimension
KEY ConsolidationUnit
_Dimension _Dimension
_UnitHierNode _UnitHierNode
_Text _Text 
@AbapCatalog:{
  sqlViewName: 'ICCUNITFORELIM',
  compiler.compareFilter: true
  }
@Analytics: {
  dataCategory: #DIMENSION,
  internalName: #LOCAL
}
@AccessControl:{
  authorizationCheck: #MANDATORY
  }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata:{
  allowExtensions:true,
  ignorePropagatedAnnotations: true
  }
@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #M},
  representativeKey: 'ConsolidationUnit'
}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Cnsldtn Unit for Elimination Purpose'

define view I_CnsldtnUnitForElimination
  as select from P_CnsldtnUnitForElimination

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

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

  association [0..*] to I_CnsldtnUnitForEliminationT as _Text         on  $projection.ConsolidationDimension = _Text.ConsolidationDimension
                                                                      and $projection.ConsolidationUnit      = _Text.ConsolidationUnit
{
      @ObjectModel.foreignKey.association: '_Dimension'
  key ConsolidationDimension,

      @ObjectModel.text.association: '_Text'
      @ObjectModel.hierarchy.association: '_UnitHierNode'
  key cast(ConsolidationUnit as fincs_elimination_member preserving type ) as ConsolidationUnit,


      _Dimension,
      _UnitHierNode,
      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CNSLDTNUNITFORELIMINATION"
],
"ASSOCIATED":
[
"I_CNSLDTNDIMENSION",
"I_CNSLDTNUNITFORELIMINATIONT",
"I_CNSLDTNUNITHIERNODEFORELIM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More