I_FunctionalLocationLongText

@AbapCatalog.sqlViewName: 'IFLOCLTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Long Text for Functional Location'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_FunctionalLocationLongText
  as select from I_FunctionalLocation

  association [0..1] to I_TextObject         as _TextObjectInSessionLanguage on  _TextObjectInSessionLanguage.TextObjectKey      = $projection.FunctionalLocation
                                                                             and _TextObjectInSessionLanguage.TextObjectType     = 'LTXT'
                                                                             and _TextObjectInSessionLanguage.TextObjectCategory = 'IFLOT'
                                                                             and _TextObjectInSessionLanguage.Language           = $session.system_language
  association [0..1] to I_TextObject         as _TextObjectInNotifLanguage   on  _TextObjectInNotifLanguage.TextObjectKey      = $projection.FunctionalLocation
                                                                             and _TextObjectInNotifLanguage.TextObjectType     = 'LTXT'
                                                                             and _TextObjectInNotifLanguage.TextObjectCategory = 'IFLOT'
                                                                             and _TextObjectInNotifLanguage.Language           = $session.system_language
  association [1..1] to I_FunctionalLocation as _FunctionalLocation          on  $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
  association [0..1] to I_Language           as _Language                    on  _Language.Language = $projection.Language

-----Testing for LongText
  association [0..1] to I_TextObjectPlainLongText         as _TextObjectPlainLongText on  _TextObjectPlainLongText.TextObjectKey      = $projection.FunctionalLocation
                                                                             and _TextObjectPlainLongText.TextObjectType     = 'LTXT'
                                                                             and _TextObjectPlainLongText.TextObjectCategory = 'IFLOT'
                                                                             and _TextObjectPlainLongText.Language           = $session.system_language
-----
{
  key    cast(FunctionalLocation as eams_ui_oid_name preserving type) as FunctionalLocation,

         FunctionalLocation                                                         as TextObjectKey,

         @ObjectModel.foreignKey.association: '_Language'
         @Semantics.language: true
         cast( coalesce( _TextObjectInSessionLanguage.Language,
                   _TextObjectInNotifLanguage.Language ) as spras preserving type ) as Language,
         cast( 'IFLOT' as tdobject )                                                as TextObjectCategory,
         cast( 'LTXT' as tdid preserving type )                                     as TextObjectType,

----Commented for testing Long Text
//         @Semantics.text: true

//         @UI.multiLineText: true

//         cast('' as eams_ltext )                                                    as FuncnlLocLongText,

         
         _TextObjectPlainLongText.PlainLongText  as FuncnlLocLongText,
----Commented for testing Long Text


         @Semantics.text: true
         @UI.multiLineText: true
         cast('' as eams_ltext )                                                    as FuncnlLocLongTextForEdit,

         //@ObjectModel.foreignKey.association: '_LongTextIsNotChangeable'

         //cast( _MaintenanceNotification._PMNotificationType.LongTextIsNotChangeable as boole_d ) as LongTextIsNotChangeable,


         _FunctionalLocation,
         _Language,
         _TextObjectPlainLongText   --For Testing
         //_LongTextIsNotChangeable


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