R_FunctionalLocationLongTextTP

DDL: R_FUNCTIONALLOCATIONLONGTEXTTP Type: view_entity TRANSACTIONAL

Functional Location – Text

R_FunctionalLocationLongTextTP is a Transactional CDS View that provides data about "Functional Location – Text" in SAP S/4HANA. It reads from 2 data sources (I_FunctionalLocation, I_FunctionalLocationLongText) and exposes 8 fields with key field FunctionalLocation. It has 1 association to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_FunctionalLocation I_FunctionalLocation from
I_FunctionalLocationLongText I_FunctionalLocationLongText inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = $projection.FunctionalLocation and _TextObjectPlainLongText.TextObjectType = $projection.TextObjectType and _TextObjectPlainLongText.TextObjectCategory = $projection.TextObjectCategory and _TextObjectPlainLongText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Functional Location – Text view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation
FunctionalLocationLabelName _FunctionalLocation FunctionalLocationLabelName
TextObjectKey I_FunctionalLocationLongText TextObjectKey
Language I_FunctionalLocationLongText Language
TextObjectCategory I_FunctionalLocationLongText TextObjectCategory
TextObjectType I_FunctionalLocationLongText TextObjectType
FuncnlLocLongText _TextObjectPlainLongText PlainLongText
_FunctionalLocation _FunctionalLocation 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Functional Location – Text'

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED} 
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define  view entity R_FunctionalLocationLongTextTP as select from I_FunctionalLocation
                                           inner join I_FunctionalLocationLongText on  I_FunctionalLocation.FunctionalLocation = I_FunctionalLocationLongText.FunctionalLocation 
 association to parent R_FunctionalLocationTP as _FunctionalLocation on $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
 
   association [0..1] to I_TextObjectPlainLongText         as _TextObjectPlainLongText on  _TextObjectPlainLongText.TextObjectKey      = $projection.FunctionalLocation
                                                                             and _TextObjectPlainLongText.TextObjectType     = $projection.TextObjectType     
                                                                             and _TextObjectPlainLongText.TextObjectCategory = $projection.TextObjectCategory 
                                                                             and _TextObjectPlainLongText.Language           = $session.system_language

{
  
  key cast(I_FunctionalLocationLongText.FunctionalLocation as tplnr_unconverted  preserving type) as FunctionalLocation,  
  
      _FunctionalLocation.FunctionalLocationLabelName,
 
      I_FunctionalLocationLongText.TextObjectKey,

      I_FunctionalLocationLongText.Language,

      @Consumption.hidden: true
      I_FunctionalLocationLongText.TextObjectCategory,

      @Consumption.hidden: true
      I_FunctionalLocationLongText.TextObjectType,

      _TextObjectPlainLongText.PlainLongText  as FuncnlLocLongText,
      
      _FunctionalLocation   
}

Learn More