I_MaintenanceItemText

DDL: I_MAINTENANCEITEMTEXT SQL: IMAINTITEMTEXT Type: view COMPOSITE

Maintenance Item Long Text

I_MaintenanceItemText is a Composite CDS View that provides data about "Maintenance Item Long Text" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceItem, I_TextObject) and exposes 10 fields with key fields MaintenanceItem, Language. It has 4 associations to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceItem _MaintenanceItem from
I_TextObject _TextObject inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Language _Language _Language.Language = $projection.Language
[0..1] I_TextObjectType _TextObjectType _TextObjectType.TextObjectType = $projection.TextObjectType and _TextObjectType.TextObjectCategory = $projection.TextObjectCategory
[0..1] I_TextObjectCategory _TextObjectCategory _TextObjectCategory.TextObjectCategory = $projection.TextObjectCategory
[0..1] I_TextObjectPlainLongText _LongText _LongText.TextObjectCategory = 'MPOS' and _LongText.TextObjectType = 'LTXT' and _LongText.TextObjectKey = $projection.MaintenanceItem and _LongText.Language = $projection.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTITEMTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Maintenance Item Long Text view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey MaintenanceItem view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem I_MaintenanceItem MaintenanceItem
KEY Language
TextObjectKey
TextObjectCategory
TextObjectType
MaintenanceItemLongText _LongText PlainLongText
_LongText _LongText
_Language _Language
_TextObjectType _TextObjectType
_TextObjectCategory _TextObjectCategory 
@AbapCatalog.sqlViewName: 'IMAINTITEMTEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Maintenance Item Long Text'
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'MaintenanceItem'

@ObjectModel.dataCategory: #TEXT

@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #XL,
   usageType.dataClass: #MIXED
}

define view I_MaintenanceItemText
  as select from I_MaintenanceItem as _MaintenanceItem
    inner join   I_TextObject      as _TextObject on  _TextObject.TextObjectType     = 'LTXT'
                                                  and _TextObject.TextObjectCategory = 'MPOS'
                                                  and _TextObject.TextObjectKey      = _MaintenanceItem.MaintenanceItem

  association [0..1] to I_Language                as _Language           on  _Language.Language = $projection.Language


  association [0..1] to I_TextObjectType          as _TextObjectType     on  _TextObjectType.TextObjectType     = $projection.TextObjectType
                                                                         and _TextObjectType.TextObjectCategory = $projection.TextObjectCategory

  association [0..1] to I_TextObjectCategory      as _TextObjectCategory on  _TextObjectCategory.TextObjectCategory = $projection.TextObjectCategory

  association [0..1] to I_TextObjectPlainLongText as _LongText           on  _LongText.TextObjectCategory = 'MPOS'
                                                                         and _LongText.TextObjectType     = 'LTXT'
                                                                         and _LongText.TextObjectKey      = $projection.MaintenanceItem
                                                                         and _LongText.Language           = $projection.Language
{

  key     _MaintenanceItem.MaintenanceItem,

          @Semantics.language:true
          @ObjectModel.foreignKey.association: '_Language'
  key     cast( _TextObject.Language as spras preserving type ) as Language,

          cast( _MaintenanceItem.MaintenanceItem as tdobname )  as TextObjectKey,

          @ObjectModel.foreignKey.association: '_TextObjectCategory'
          cast( 'MPOS      ' as tdobject preserving type )      as TextObjectCategory,

          @ObjectModel.foreignKey.association: '_TextObjectType'
          cast( 'LTXT' as tdid preserving type )                as TextObjectType,

          @Semantics.text:true
          _LongText.PlainLongText                               as MaintenanceItemLongText,

          /* Local Association */
          _LongText,
          _Language,
          _TextObjectType,
          _TextObjectCategory

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

Learn More