I_ProdUniversalHierarchyText_2

DDL: I_PRODUNIVERSALHIERARCHYTEXT_2 Type: view BASIC Package: VDM_MD_PRODUCT_HIERARCHY

Product Hierarchy - Text

I_ProdUniversalHierarchyText_2 is a Basic CDS View that provides data about "Product Hierarchy - Text" in SAP S/4HANA. It reads from 2 data sources (hrrp_directory, hrrp_directoryt) and exposes 8 fields with key fields Language, ProdUnivHierarchy, ProdHierarchyValidityEndDate. It has 2 associations to related views. Part of development package VDM_MD_PRODUCT_HIERARCHY.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
hrrp_directory dir inner
hrrp_directoryt text from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_ProdUnivHierarchyBasic _ProductHierarchy $projection.ProdUnivHierarchy = _ProductHierarchy.ProdUnivHierarchy
[0..*] I_LanguageText _LanguageText $projection.Language = _LanguageText.Language

Annotations (15)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Language hrrp_directoryt spras
KEY ProdUnivHierarchy
KEY ProdHierarchyValidityEndDate hrrp_directoryt hryvalto
ProdHierarchyValidityStartDate hrrp_directoryt hryvalfrom
ProdUnivHierarchyText hrytxt
HierarchyType hrrp_directory hrytyp
_ProductHierarchy _ProductHierarchy
_LanguageText _LanguageText 
@AbapCatalog: {
  sqlViewName: 'IPRDUNIVHRYT2',
  compiler.compareFilter: true,
  preserveKey: true
  }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product Hierarchy - Text'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  representativeKey: 'ProdUnivHierarchy',
  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,
                                      #EXTRACTION_DATA_SOURCE
]
@Analytics:{  
    internalName: #LOCAL,
    dataExtraction: {
        enabled: true
    } 
}
define view I_ProdUniversalHierarchyText_2
  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
  //                                      and dir.hrytyp   = 'MD01'

  //temporal association

  association [1..*] to I_ProdUnivHierarchyBasic as _ProductHierarchy on $projection.ProdUnivHierarchy = _ProductHierarchy.ProdUnivHierarchy
  //                                                                    and $projection.ProdHierarchyValidityEndDate = _ProductHierarchy.ProdHierarchyValidityEndDate

association [0..*] to I_LanguageText as _LanguageText on $projection.Language = _LanguageText.Language
{
      //hrrp_directoryt

      @Semantics.language: true
  key text.spras                                           as Language,
      @ObjectModel.foreignKey.association: '_ProductHierarchy'
  key cast(substring(text.hryid, 6, 26 ) as prod_hier_id ) as ProdUnivHierarchy,
      //  key hryver,

      @Semantics.businessDate.to: true
  key text.hryvalto                                        as ProdHierarchyValidityEndDate,
      @Semantics.businessDate.from: true
      text.hryvalfrom                                      as ProdHierarchyValidityStartDate,
      @Semantics.text: true
      hrytxt                                               as ProdUnivHierarchyText,
      dir.hrytyp                                           as HierarchyType,
      _ProductHierarchy,
      _LanguageText 
}
where
     dir.hrytyp = 'MD01'
  or dir.hrytyp = 'MD02'

Learn More