I_CnsldtnMatlGrpHierDir

DDL: I_CNSLDTNMATLGRPHIERDIR Type: view BASIC

Consolidation Material Group Hier Dir

I_CnsldtnMatlGrpHierDir is a Basic CDS View that provides data about "Consolidation Material Group Hier Dir" in SAP S/4HANA. It reads from 2 data sources (fincs_addlcharcx, hrrp_directory) and exposes 4 fields with key field AdditionalMasterDataHierarchy. It has 1 association to related views.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
fincs_addlcharcx _Configuration cross
hrrp_directory _HierarchyDirectory from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CnsldtnMatlGrpHierDirT _HierarchyDirectoryText $projection.AdditionalMasterDataHierarchy = _HierarchyDirectoryText.AdditionalMasterDataHierarchy

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICSMATGRPHD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey AdditionalMasterDataHierarchy view
EndUserText.label Consolidation Material Group Hier Dir view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY AdditionalMasterDataHierarchy hrrp_directory hryid
LastChangedByUser hrrp_directory upduser
LastChangeDateTime hrrp_directory updtime
_HierarchyDirectoryText _HierarchyDirectoryText 
@AbapCatalog:{
  sqlViewName: 'ICSMATGRPHD',
  compiler.compareFilter: true,
  preserveKey: true
  }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata:{
  ignorePropagatedAnnotations: true
  }
@VDM.viewType: #BASIC
@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #S},
  representativeKey: 'AdditionalMasterDataHierarchy'
}
@EndUserText.label: 'Consolidation Material Group Hier Dir'

define view I_CnsldtnMatlGrpHierDir
  as select from hrrp_directory   as _HierarchyDirectory

    cross join   fincs_addlcharcx as _Configuration

  association [0..*] to I_CnsldtnMatlGrpHierDirT as _HierarchyDirectoryText on $projection.AdditionalMasterDataHierarchy = _HierarchyDirectoryText.AdditionalMasterDataHierarchy

{
      @ObjectModel.text.association: '_HierarchyDirectoryText'
  key _HierarchyDirectory.hryid   as AdditionalMasterDataHierarchy,

      @Semantics.user.lastChangedBy: true
      _HierarchyDirectory.upduser as LastChangedByUser,
      
      @Semantics.systemDateTime.lastChangedAt: true
      _HierarchyDirectory.updtime as LastChangeDateTime,       

      // associations

      _HierarchyDirectoryText
}
where
      _HierarchyDirectory.hrytyp              = 'CS22'
  and _Configuration.cnsldtnaddlcharcfldname  = 'MATKL_MM'
  and _Configuration.cnsldtnaddlmdhierisinuse = 'X' // only display when hierarchy usage is enabled in customizing

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINCS_ADDLCHARCX",
"HRRP_DIRECTORY"
],
"ASSOCIATED":
[
"I_CNSLDTNMATLGRPHIERDIRT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More