I_CustUniversalHierarchyText

DDL: I_CUSTUNIVERSALHIERARCHYTEXT Type: view BASIC

Customer Hierarchy Directory - Text

I_CustUniversalHierarchyText is a Basic CDS View that provides data about "Customer Hierarchy Directory - Text" in SAP S/4HANA. It reads from 2 data sources (hrrp_directory, hrrp_directoryt) and exposes 6 fields with key fields Language, CustomerUniversalHierarchy, CustHierarchyValidityEndDate. It has 1 association to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
hrrp_directory dir inner
hrrp_directoryt text from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_CustUnivHierarchyBase _CustomerHierarchy $projection.CustomerUniversalHierarchy = _CustomerHierarchy.CustomerUniversalHierarchy

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTUHFDIRT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customer Hierarchy Directory - Text view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey CustomerUniversalHierarchy view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Language hrrp_directoryt spras
KEY CustomerUniversalHierarchy hrrp_directory hrysid
KEY CustHierarchyValidityEndDate hrrp_directoryt hryvalto
CustHierarchyValidityStartDate hrrp_directoryt hryvalfrom
CustomerUniversalHierarchyText hrytxt
_CustomerHierarchy _CustomerHierarchy 
@AbapCatalog: {
  sqlViewName: 'ICUSTUHFDIRT',
  compiler.compareFilter: true,
  preserveKey: true
  }
@VDM.viewType: #BASIC
@Analytics.internalName: #LOCAL
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Customer Hierarchy Directory - Text'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  representativeKey: 'CustomerUniversalHierarchy',
  dataCategory: #TEXT,
  usageType :{
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #XL
  }
}
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #LANGUAGE_DEPENDENT_TEXT
]

define view I_CustUniversalHierarchyText 
  as select from hrrp_directoryt as text
    inner join   hrrp_directory  as dir on  dir.hryid    = text.hryid
                                        and dir.hryver   = text.hryver
                                        and dir.hryvalto = text.hryvalto
  //temporal association

  association [1..*] to I_CustUnivHierarchyBase as _CustomerHierarchy on $projection.CustomerUniversalHierarchy = _CustomerHierarchy.CustomerUniversalHierarchy

{
      @Semantics.language: true
  key text.spras                                                as Language,
      @ObjectModel.foreignKey.association: '_CustomerHierarchy'
  key dir.hrysid                                                as CustomerUniversalHierarchy,
      @Semantics.businessDate.to: true
  key text.hryvalto                                             as CustHierarchyValidityEndDate,
      @Semantics.businessDate.from: true
      text.hryvalfrom                                           as CustHierarchyValidityStartDate,
      @Semantics.text: true
      hrytxt                                                    as CustomerUniversalHierarchyText,

      _CustomerHierarchy
}
where
     dir.hrytyp = 'CH02'
  or dir.hrytyp = 'CH01'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRRP_DIRECTORY",
"HRRP_DIRECTORYT"
],
"ASSOCIATED":
[
"I_CUSTUNIVHIERARCHYBASE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More