I_MaintOrderOpCompLongText

DDL: I_MAINTORDEROPCOMPLONGTEXT SQL: IMAINTORDCOMLTXT Type: view BASIC

Maintenance Order Op Component Long Text

I_MaintOrderOpCompLongText is a Basic CDS View that provides data about "Maintenance Order Op Component Long Text" in SAP S/4HANA. It reads from 3 data sources (I_MaintenanceOrderComponent, I_TextObjectPlainLongText, resb_text) and exposes 16 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintenanceOrderComponent, TextObjectType. It has 4 associations to related views.

3 data source(s) 16 fields

Data Sources (3)

SourceAliasJoin Type
I_MaintenanceOrderComponent I_MaintenanceOrderComponent inner
I_TextObjectPlainLongText I_TextObjectPlainLongText from
resb_text resb_text inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceOrder _MaintenanceOrder _MaintenanceOrder.MaintenanceOrder = $projection.MaintenanceOrder
[0..1] I_Language _Language _Language.Language = $projection.Language
[0..1] I_MaintenanceOrderComponent _MaintenanceOrderComponent _MaintenanceOrderComponent.MaintenanceOrder = $projection.MaintenanceOrder and _MaintenanceOrderComponent.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation and _MaintenanceOrderComponent.MaintenanceOrderSubOperation = $projection.MaintenanceOrderSubOperation and _MaintenanceOrderComponent.MaintenanceOrderComponent = $projection.MaintenanceOrderComponent
[0..*] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = $projection.TextObjectKey and _TextObjectPlainLongText.TextObjectCategory = 'AUFK' and ( _TextObjectPlainLongText.TextObjectType = 'MATK' or _TextObjectPlainLongText.TextObjectType = 'MATN' or _TextObjectPlainLongText.TextObjectType = 'MATC' or _TextObjectPlainLongText.TextObjectType = 'MATD' )

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTORDCOMLTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order Op Component Long Text view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MaintenanceOrderComponent view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintenanceOrderComponent MaintenanceOrder
KEY MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation
KEY MaintenanceOrderComponent
KEY TextObjectType I_TextObjectPlainLongText TextObjectType
KEY Language I_TextObjectPlainLongText Language
Reservation resb_text rsnum
ReservationItem resb_text rspos
ReservationType resb_text rsart
TextObjectKey resb_text tdname
OrderComponentLongText I_TextObjectPlainLongText PlainLongText
TextObjectCategory I_TextObjectPlainLongText TextObjectCategory
_MaintenanceOrderComponent _MaintenanceOrderComponent
_MaintenanceOrder _MaintenanceOrder
_TextObjectPlainLongText _TextObjectPlainLongText
_Language _Language 
@AbapCatalog.sqlViewName: 'IMAINTORDCOMLTXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.privilegedAssociations:['_TextObjectPlainLongText']
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Op Component Long Text'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MaintenanceOrderComponent'
define view I_MaintOrderOpCompLongText
  as select from I_TextObjectPlainLongText
    inner join   resb_text                   on resb_text.tdname = I_TextObjectPlainLongText.TextObjectKey
    inner join   I_MaintenanceOrderComponent on  I_MaintenanceOrderComponent.Reservation     = resb_text.rsnum
                                             and I_MaintenanceOrderComponent.ReservationItem = resb_text.rspos
                                             and I_MaintenanceOrderComponent.ReservationType = resb_text.rsart
  association [0..1] to I_MaintenanceOrder          as _MaintenanceOrder          on  _MaintenanceOrder.MaintenanceOrder = $projection.MaintenanceOrder
  association [0..1] to I_Language                  as _Language                  on  _Language.Language = $projection.Language
  association [0..1] to I_MaintenanceOrderComponent as _MaintenanceOrderComponent on  _MaintenanceOrderComponent.MaintenanceOrder             = $projection.MaintenanceOrder
                                                                                  and _MaintenanceOrderComponent.MaintenanceOrderOperation    = $projection.MaintenanceOrderOperation
                                                                                  and _MaintenanceOrderComponent.MaintenanceOrderSubOperation = $projection.MaintenanceOrderSubOperation
                                                                                  and _MaintenanceOrderComponent.MaintenanceOrderComponent    = $projection.MaintenanceOrderComponent
  association [0..*] to I_TextObjectPlainLongText   as _TextObjectPlainLongText   on  _TextObjectPlainLongText.TextObjectKey      = $projection.TextObjectKey
                                                                                  and _TextObjectPlainLongText.TextObjectCategory = 'AUFK'
                                                                                  and (
                                                                                     _TextObjectPlainLongText.TextObjectType      = 'MATK'
                                                                                     or _TextObjectPlainLongText.TextObjectType   = 'MATN'
                                                                                     or _TextObjectPlainLongText.TextObjectType   = 'MATC'
                                                                                     or _TextObjectPlainLongText.TextObjectType   = 'MATD'
                                                                                   )
{
  key I_MaintenanceOrderComponent.MaintenanceOrder,
  key cast(  I_MaintenanceOrderComponent.MaintenanceOrderOperation as maintenanceordersuboperation preserving type )   as MaintenanceOrderOperation,
  key cast( I_MaintenanceOrderComponent.MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) as MaintenanceOrderSubOperation,
  key cast( I_MaintenanceOrderComponent.MaintenanceOrderComponent    as maintenanceordercomponent preserving type )    as MaintenanceOrderComponent,
  key I_TextObjectPlainLongText.TextObjectType,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key I_TextObjectPlainLongText.Language,
      resb_text.rsnum                                                                                                  as Reservation,
      resb_text.rspos                                                                                                  as ReservationItem,
      resb_text.rsart                                                                                                  as ReservationType,

      resb_text.tdname                                                                                                 as TextObjectKey,
      I_TextObjectPlainLongText.PlainLongText                                                                          as OrderComponentLongText,
      I_TextObjectPlainLongText.TextObjectCategory,
      _MaintenanceOrderComponent,
      _MaintenanceOrder,
      _TextObjectPlainLongText,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDERCOMPONENT",
"I_TEXTOBJECTPLAINLONGTEXT",
"RESB_TEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_MAINTENANCEORDER",
"I_MAINTENANCEORDERCOMPONENT",
"I_TEXTOBJECTPLAINLONGTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More