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   
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNCTIONALLOCATION",
"I_FUNCTIONALLOCATIONLONGTEXT",
"I_TEXTOBJECTPLAINLONGTEXT",
"R_FUNCTIONALLOCATIONTP"
],
"ASSOCIATED":
[
"R_FUNCTIONALLOCATIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More