I_ProductHierarchyNodeText

DDL: I_PRODUCTHIERARCHYNODETEXT Type: view BASIC

Product Hierarchy Node Text

I_ProductHierarchyNodeText is a Basic CDS View that provides data about "Product Hierarchy Node Text" in SAP S/4HANA. It reads from 1 data source (t179t) and exposes 5 fields with key fields ProductHierarchyNode, Language. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
t179t t179t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_ProductHierarchyNode _ProductHierarchyNode $projection.ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode

Annotations (13)

NameValueLevelField
EndUserText.label Product Hierarchy Node Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IPORDHIERNDTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey ProductHierarchyNode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProductHierarchyNode prodh
KEY Language spras
ProductHierarchyNodeText vtext
_ProductHierarchyNode _ProductHierarchyNode
_Language _Language 
@EndUserText.label: 'Product Hierarchy Node Text' //same as DDL description

@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED //or #CHECK

@AbapCatalog:{
  sqlViewName: 'IPORDHIERNDTEXT',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel:{
  representativeKey: 'ProductHierarchyNode',
  usageType:{
    serviceQuality: #A,
    sizeCategory : #S,
    dataClass: #MASTER
  }
}  
@Metadata.ignorePropagatedAnnotations: true  
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_ProductHierarchyNodeText //must start with 'I_' and end with 'Text' or 'T'

  as select from t179t
  association [0..1] to I_Language             as _Language             on $projection.Language = _Language.Language
  association [1..1] to I_ProductHierarchyNode as _ProductHierarchyNode on $projection.ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode
{
      @ObjectModel.foreignKey.association: '_ProductHierarchyNode'
  key prodh as ProductHierarchyNode,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key spras as Language, //text views shall always be language dependent

      @Semantics.text: true
      vtext as ProductHierarchyNodeText,
      _ProductHierarchyNode,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T179T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_PRODUCTHIERARCHYNODE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More