I_MaintOrderOperationLongText

DDL: I_MAINTORDEROPERATIONLONGTEXT SQL: IMAINTORDOPLTXT Type: view BASIC

Maintenance Order Operation Long Text

I_MaintOrderOperationLongText is a Basic CDS View that provides data about "Maintenance Order Operation Long Text" in SAP S/4HANA. It reads from 3 data sources (afvc_text, I_MaintOrderOperAndSubOper, I_TextObjectPlainLongText) and exposes 12 fields with key fields MaintenanceOrder, MaintOrderRoutingNumber, MaintenanceOrderRoutingNode, TextObjectType, Language. It has 4 associations to related views.

3 data source(s) 12 fields

Data Sources (3)

SourceAliasJoin Type
afvc_text afvc_text inner
I_MaintOrderOperAndSubOper I_MaintOrderOperAndSubOper inner
I_TextObjectPlainLongText I_TextObjectPlainLongText from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceOrder _MaintenanceOrder _MaintenanceOrder.MaintenanceOrder = $projection.MaintenanceOrder
[0..1] I_Language _Language _Language.Language = $projection.Language
[0..1] I_MaintOrderOperAndSubOper _MaintenanceOrderSubOperation _MaintenanceOrderSubOperation.MaintenanceOrder = $projection.MaintenanceOrder and _MaintenanceOrderSubOperation.MaintOrderRoutingNumber = $projection.MaintOrderRoutingNumber and _MaintenanceOrderSubOperation.MaintOrderOperationCounter = $projection.MaintenanceOrderRoutingNode
[0..*] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = $projection.TextObjectKey and _TextObjectPlainLongText.TextObjectCategory = 'AUFK' and ( _TextObjectPlainLongText.TextObjectType = 'AVOT' or _TextObjectPlainLongText.TextObjectType = 'AVON' or _TextObjectPlainLongText.TextObjectType = 'AVOC' or _TextObjectPlainLongText.TextObjectType = 'AVOD' )

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTORDOPLTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order Operation 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 MaintenanceOrder view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintOrderOperAndSubOper MaintenanceOrder
KEY MaintOrderRoutingNumber afvc_text aufpl
KEY MaintenanceOrderRoutingNode afvc_text aplzl
KEY TextObjectType I_TextObjectPlainLongText TextObjectType
KEY Language I_TextObjectPlainLongText Language
TextObjectKey afvc_text tdname
OrderOperationLongText I_TextObjectPlainLongText PlainLongText
TextObjectCategory I_TextObjectPlainLongText TextObjectCategory
_MaintenanceOrderSubOperation _MaintenanceOrderSubOperation
_MaintenanceOrder _MaintenanceOrder
_TextObjectPlainLongText _TextObjectPlainLongText
_Language _Language 
@AbapCatalog.sqlViewName: 'IMAINTORDOPLTXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.privilegedAssociations:['_TextObjectPlainLongText']
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Operation 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: 'MaintenanceOrder'
//@ObjectModel.semanticKey:  [ 'MaintenanceOrder', 'MaintenanceOrderOperation', 'MaintenanceOrderSubOperation' ]

define view I_MaintOrderOperationLongText
  as select from I_TextObjectPlainLongText
    inner join   afvc_text                  on afvc_text.tdname = I_TextObjectPlainLongText.TextObjectKey

    inner join   I_MaintOrderOperAndSubOper on  I_MaintOrderOperAndSubOper.MaintOrderRoutingNumber    = afvc_text.aufpl
                                            and I_MaintOrderOperAndSubOper.MaintOrderOperationCounter = afvc_text.aplzl

  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_MaintOrderOperAndSubOper as _MaintenanceOrderSubOperation on  _MaintenanceOrderSubOperation.MaintenanceOrder           = $projection.MaintenanceOrder
                                                                                    and _MaintenanceOrderSubOperation.MaintOrderRoutingNumber    = $projection.MaintOrderRoutingNumber
                                                                                    and _MaintenanceOrderSubOperation.MaintOrderOperationCounter = $projection.MaintenanceOrderRoutingNode
  association [0..*] to I_TextObjectPlainLongText  as _TextObjectPlainLongText      on  _TextObjectPlainLongText.TextObjectKey      = $projection.TextObjectKey
                                                                                    and _TextObjectPlainLongText.TextObjectCategory = 'AUFK'
                                                                                    and (
                                                                                       _TextObjectPlainLongText.TextObjectType      = 'AVOT'
                                                                                       or _TextObjectPlainLongText.TextObjectType   = 'AVON'
                                                                                       or _TextObjectPlainLongText.TextObjectType   = 'AVOC'
                                                                                       or _TextObjectPlainLongText.TextObjectType   = 'AVOD'
                                                                                     )

{
  key I_MaintOrderOperAndSubOper.MaintenanceOrder,
  key afvc_text.aufpl                         as MaintOrderRoutingNumber,
  key afvc_text.aplzl                         as MaintenanceOrderRoutingNode,
  key I_TextObjectPlainLongText.TextObjectType,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key I_TextObjectPlainLongText.Language,
      afvc_text.tdname                        as TextObjectKey,
      I_TextObjectPlainLongText.PlainLongText as OrderOperationLongText,
      I_TextObjectPlainLongText.TextObjectCategory,
      _MaintenanceOrderSubOperation,
      _MaintenanceOrder,
      _TextObjectPlainLongText,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTORDEROPERANDSUBOPER",
"I_TEXTOBJECTPLAINLONGTEXT",
"AFVC_TEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_MAINTENANCEORDER",
"I_MAINTORDEROPERANDSUBOPER",
"I_TEXTOBJECTPLAINLONGTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More