I_MasterRecipeRelshpTypeText

DDL: I_MASTERRECIPERELSHPTYPETEXT SQL: IMRCRELTYPT Type: view_entity BASIC Package: VDM_PP_MD_MRC

Relationship Type Text

I_MasterRecipeRelshpTypeText is a Basic CDS View that provides data about "Relationship Type Text" in SAP S/4HANA. It reads from 1 data source (tcn2t) and exposes 5 fields with key field Language. It has 1 association to related views. Part of development package VDM_PP_MD_MRC.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
tcn2t tcn2t from

Associations (1)

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

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Relationship Type Text view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey PhaseRelationshipTypeKey view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language langu
PhaseRelationshipType aobkt
PhaseRelationshipTypeDesc aobtx
_RelshpType _RelshpType
_Language _Language 
//@AbapCatalog.sqlViewName: 'IMRCRELTYPT'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Relationship Type Text'
@VDM.viewType: #BASIC
//@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {usageType.serviceQuality: #A, usageType.dataClass: #META,usageType.sizeCategory: #S }
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.representativeKey: 'PhaseRelationshipTypeKey'
//define view I_MasterRecipeRelshpTypeText

define view entity I_MasterRecipeRelshpTypeText
  as select from tcn2t
  association        to parent I_MasterRecipeRelshpType as _RelshpType on $projection.PhaseRelationshipTypeKey = _RelshpType.PhaseRelationshipTypeKey
  association [0..1] to I_Language                      as _Language   on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_Language'
  key langu as Language,
      @ObjectModel.foreignKey.association: '_RelshpType'
  key case aobky
      when '1'
      then 'NF'
      when '2'
      then 'AF'
      when '3'
      then 'EF'
      when '4'
      then 'SF'
      end   as PhaseRelationshipTypeKey,
      aobkt as PhaseRelationshipType,
      @Search.defaultSearchElement: true
      aobtx as PhaseRelationshipTypeDesc, 
      _RelshpType,
      _Language
}

Learn More