R_FUNCTIONALLOCATIONLONGTEXTTP

CDS View

Functional Location – Text

R_FUNCTIONALLOCATIONLONGTEXTTP is a CDS View in S/4HANA. Functional Location – Text. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_FunctionalLocationLongText view_entity projection COMPOSITE Functional Location Text
I_FunctionalLocationLongTextTP view_entity projection TRANSACTIONAL FL Long Text - TP 
@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