I_MaintenancePlanText

DDL: I_MAINTENANCEPLANTEXT SQL: IMPLATEXT Type: view COMPOSITE

Maintenance Plan Long Text

I_MaintenancePlanText is a Composite CDS View that provides data about "Maintenance Plan Long Text" in SAP S/4HANA. It reads from 2 data sources (I_MaintenancePlanBasic, I_TextObject) and exposes 9 fields with key fields MaintenancePlan, Language. It has 3 associations to related views.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenancePlanBasic _MPLan from
I_TextObject _TextObjectInSessionLanguage inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MaintenancePlanBasic _MaintenancePlan $projection.MaintenancePlan = _MaintenancePlan.MaintenancePlan
[0..1] I_Language _Language _Language.Language = $projection.Language
[0..1] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = $projection.MaintenancePlan and _TextObjectPlainLongText.TextObjectType = 'LTXT' and _TextObjectPlainLongText.TextObjectCategory = 'MPLA' and _TextObjectPlainLongText.Language = $projection.Language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPLATEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Maintenance Plan Long Text view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey MaintenancePlan view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan I_MaintenancePlanBasic MaintenancePlan
KEY Language I_TextObject Language
TextObjectKey I_TextObject TextObjectKey
TextObjectCategory
TextObjectType
MaintenancePlanLongText _TextObjectPlainLongText PlainLongText
_MaintenancePlan _MaintenancePlan
_Language _Language
_TextObjectPlainLongText _TextObjectPlainLongText 
@AbapCatalog.sqlViewName: 'IMPLATEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Maintenance Plan Long Text'
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'MaintenancePlan'

@ObjectModel: {
   usageType.serviceQuality: #B,
   usageType.sizeCategory: #L,
   usageType.dataClass: #MASTER
}


define view I_MaintenancePlanText
as select from I_MaintenancePlanBasic as _MPLan inner join 
               I_TextObject      as _TextObjectInSessionLanguage      on  _TextObjectInSessionLanguage.TextObjectKey      = _MPLan.MaintenancePlan
                                                                                and _TextObjectInSessionLanguage.TextObjectType     = 'LTXT'
                                                                                and _TextObjectInSessionLanguage.TextObjectCategory = 'MPLA'
   association [1..1] to I_MaintenancePlanBasic  as _MaintenancePlan            on  $projection.MaintenancePlan = _MaintenancePlan.MaintenancePlan
   association [0..1] to I_Language        as _Language                         on  _Language.Language = $projection.Language
   association [0..1] to I_TextObjectPlainLongText  as _TextObjectPlainLongText on  _TextObjectPlainLongText.TextObjectKey      = $projection.MaintenancePlan
                                                                                and _TextObjectPlainLongText.TextObjectType     = 'LTXT'
                                                                                and _TextObjectPlainLongText.TextObjectCategory = 'MPLA'
                                                                                and _TextObjectPlainLongText.Language           = $projection.Language
 {
    
     key _MPLan.MaintenancePlan,
     @ObjectModel.foreignKey.association: '_Language'
     @Semantics.language: true
     key _TextObjectInSessionLanguage.Language  as Language,     
     _TextObjectInSessionLanguage.TextObjectKey as TextObjectKey,
                        
     cast( 'MPLA      ' as tdobject preserving type  )              as TextObjectCategory,
     
     cast( 'LTXT' as tdid preserving type )   as TextObjectType,
     
      _TextObjectPlainLongText.PlainLongText  as MaintenancePlanLongText,

      _MaintenancePlan,
      
      _Language,
      
      _TextObjectPlainLongText
          
}

Learn More