I_EquipmentLongText

DDL: I_EQUIPMENTLONGTEXT SQL: IEQUILTXT Type: view COMPOSITE

Equipment Long Text

I_EquipmentLongText is a Composite CDS View that provides data about "Equipment Long Text" in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 8 fields with key field Equipment. It has 4 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_Equipment I_Equipment from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_TextObject _TextObjectInSessionLanguage _TextObjectInSessionLanguage.TextObjectKey = $projection.Equipment and _TextObjectInSessionLanguage.TextObjectType = 'LTXT' and _TextObjectInSessionLanguage.TextObjectCategory = 'EQUI' and _TextObjectInSessionLanguage.Language = $session.system_language
[0..1] I_TextObject _TextObjectInNotifLanguage _TextObjectInNotifLanguage.TextObjectKey = $projection.Equipment and _TextObjectInNotifLanguage.TextObjectType = 'LTXT' and _TextObjectInNotifLanguage.TextObjectCategory = 'EQUI' and _TextObjectInNotifLanguage.Language = $session.system_language
[1..1] I_Equipment _Equipment $projection.TextObjectKey = _Equipment.Equipment
[0..1] I_Language _Language _Language.Language = $projection.Language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEQUILTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Equipment Long Text view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment
TextObjectKey Equipment
TextObjectCategory
TextObjectType
EquipmentLongText
EquipmentLongTextForEdit
_Equipment _Equipment
_Language _Language 
@AbapCatalog.sqlViewName: 'IEQUILTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Equipment Long Text'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED} 
@VDM.viewType: #COMPOSITE 
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_EquipmentLongText as select from I_Equipment

  association [0..1] to I_TextObject              as _TextObjectInSessionLanguage on  _TextObjectInSessionLanguage.TextObjectKey      = $projection.Equipment
                                                                                  and _TextObjectInSessionLanguage.TextObjectType     = 'LTXT'
                                                                                  and _TextObjectInSessionLanguage.TextObjectCategory = 'EQUI'
                                                                                  and _TextObjectInSessionLanguage.Language           = $session.system_language
  association [0..1] to I_TextObject              as _TextObjectInNotifLanguage   on  _TextObjectInNotifLanguage.TextObjectKey      = $projection.Equipment
                                                                                  and _TextObjectInNotifLanguage.TextObjectType     = 'LTXT'
                                                                                  and _TextObjectInNotifLanguage.TextObjectCategory = 'EQUI'
                                                                                  and _TextObjectInNotifLanguage.Language           = $session.system_language
  association [1..1] to I_Equipment as _Equipment     on  $projection.TextObjectKey = _Equipment.Equipment
  association [0..1] to I_Language                as _Language                    on  _Language.Language = $projection.Language
  //association [0..1] to I_Indicator               as _LongTextIsNotChangeable     on  $projection.LongTextIsNotChangeable = _LongTextIsNotChangeable.IndicatorValue

 {
   key    Equipment,

         Equipment                                                                 as TextObjectKey,

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

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

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

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

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


         _Equipment,
         _Language
         //_LongTextIsNotChangeable

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

Learn More