I_MrchdsCatHierNodeText

DDL: I_MRCHDSCATHIERNODETEXT Type: view_entity BASIC

Merchandise Cat Hier Node - Text

I_MrchdsCatHierNodeText is a Basic CDS View that provides data about "Merchandise Cat Hier Node - Text" in SAP S/4HANA. It reads from 2 data sources (klah, swor) and exposes 5 fields with key fields MrchdsCategoryHierarchyNode, Language. It has 2 associations to related views.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
klah MrchdsCatHiernode from
swor text inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MrchdsCategoryHierarchyNode _MrchdsCategoryHierarchyNode $projection.MrchdsCategoryHierarchyNode = _MrchdsCategoryHierarchyNode.MrchdsCategoryHierarchyNode
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey MrchdsCategoryHierarchyNode view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Merchandise Cat Hier Node - Text view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MrchdsCategoryHierarchyNode
KEY Language swor spras
MrchdsCatHierNodeText swor kschl
_MrchdsCategoryHierarchyNode _MrchdsCategoryHierarchyNode
_Language _Language 
@VDM: {
  viewType                          : #BASIC,
  lifecycle.contract.type           : #PUBLIC_LOCAL_API
}

@Analytics:{
  internalName                      : #LOCAL,
  dataExtraction                    : {
  enabled                           : true
} }

@AccessControl.authorizationCheck   : #CHECK
@ObjectModel: {
   representativeKey                : 'MrchdsCategoryHierarchyNode',
   dataCategory                     : #TEXT,
   supportedCapabilities            : [ #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #EXTRACTION_DATA_SOURCE,
                                        #LANGUAGE_DEPENDENT_TEXT
                                      ], 
   modelingPattern                  :  #LANGUAGE_DEPENDENT_TEXT,                                                            
   usageType                        : {serviceQuality: #A,sizeCategory: #M,dataClass: #MASTER }
 }
@Metadata :{
   ignorePropagatedAnnotations      : true
}
@EndUserText.label                  : 'Merchandise Cat Hier Node - Text'

define view entity I_MrchdsCatHierNodeText
  as select from klah as MrchdsCatHiernode
    inner join   swor as text on MrchdsCatHiernode.clint = text.clint
    
  association [0..1] to I_MrchdsCategoryHierarchyNode as _MrchdsCategoryHierarchyNode on $projection.MrchdsCategoryHierarchyNode = _MrchdsCategoryHierarchyNode.MrchdsCategoryHierarchyNode
  association [0..1] to I_Language                    as _Language                    on $projection.Language                    = _Language.Language
{
   @ObjectModel.foreignKey.association: '_MrchdsCategoryHierarchyNode'
   key cast(MrchdsCatHiernode.class as rfm_mrchdcathiernode preserving type ) as MrchdsCategoryHierarchyNode,
      @Semantics.language: true
      @ObjectModel.foreignKey.association:'_Language'
   key text.spras as Language,
      @Semantics.text: true
      text.kschl as MrchdsCatHierNodeText,
      _MrchdsCategoryHierarchyNode,
      _Language
}
where
 MrchdsCatHiernode.wwskz = '0'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KLAH",
"SWOR"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_MRCHDSCATEGORYHIERARCHYNODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More