I_MaintenanceOrderLongText

DDL: I_MAINTENANCEORDERLONGTEXT SQL: IMAINTORDLTXT Type: view BASIC

Maintenance Order Long Text

I_MaintenanceOrderLongText is a Basic CDS View that provides data about "Maintenance Order Long Text" in SAP S/4HANA. It reads from 3 data sources (afih, aufk_text, I_TextObjectPlainLongText) and exposes 8 fields with key fields MaintenanceOrder, TextObjectType, Language. It has 2 associations to related views.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
afih afih inner
aufk_text aufk_text inner
I_TextObjectPlainLongText I_TextObjectPlainLongText from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceOrder _MaintenanceOrder _MaintenanceOrder.MaintenanceOrder = $projection.MaintenanceOrder
[0..1] I_Language _Language _Language.Language = $projection.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTORDLTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order Long Text view
ObjectModel.usageType.serviceQuality #B 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 (8)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder aufk_text aufnr
KEY TextObjectType I_TextObjectPlainLongText TextObjectType
KEY Language I_TextObjectPlainLongText Language
TextObjectKey aufk_text tdname
MaintenanceOrderLongText I_TextObjectPlainLongText PlainLongText
TextObjectCategory I_TextObjectPlainLongText TextObjectCategory
_MaintenanceOrder _MaintenanceOrder
_Language _Language 
@AbapCatalog.sqlViewName: 'IMAINTORDLTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Long Text'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MaintenanceOrder'
define view I_MaintenanceOrderLongText
  as select from I_TextObjectPlainLongText
    inner join   aufk_text on aufk_text.tdname = I_TextObjectPlainLongText.TextObjectKey
    inner join   afih      on afih.aufnr = aufk_text.aufnr

  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
{
  key aufk_text.aufnr                         as MaintenanceOrder,
  key I_TextObjectPlainLongText.TextObjectType,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key I_TextObjectPlainLongText.Language,
      aufk_text.tdname                        as TextObjectKey,
      I_TextObjectPlainLongText.PlainLongText as MaintenanceOrderLongText,
      I_TextObjectPlainLongText.TextObjectCategory,
      _MaintenanceOrder,
      _Language
}

Learn More