I_MaintOrderOpCompLongText_2

DDL: I_MAINTORDEROPCOMPLONGTEXT_2 Type: view_entity BASIC

Maintenance Order Op Component Long Text

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

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_TextObjectPlainLongText I_TextObjectPlainLongText from
resb_text resb_text inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MaintenanceOrderComponent_2 _MaintenanceOrderComponent _MaintenanceOrderComponent.Reservation = $projection.Reservation and _MaintenanceOrderComponent.ReservationItem = $projection.ReservationItem and _MaintenanceOrderComponent.ReservationType = $projection.ReservationType
[0..1] I_MaintenanceOrder _MaintenanceOrder _MaintenanceOrder.MaintenanceOrder = $projection.maintenanceorder
[0..1] I_Language _Language _Language.Language = $projection.Language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Order Op Component Long Text view
VDM.viewType #BASIC view
ObjectModel.representativeKey MaintOrderComponentInternalID view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder
KEY MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation
KEY MaintOrderComponentInternalID
KEY TextObjectType I_TextObjectPlainLongText TextObjectType
KEY Language I_TextObjectPlainLongText Language
MaintenanceOrderComponent
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
_Language _Language 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Maintenance Order Op Component Long Text'
@VDM.viewType: #BASIC
@ObjectModel:{
  representativeKey: 'MaintOrderComponentInternalID',
  dataCategory: #TEXT,
  usageType : {
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #TRANSACTIONAL  } }
define view entity I_MaintOrderOpCompLongText_2
  as select from I_TextObjectPlainLongText
    inner join   resb_text on resb_text.tdname = I_TextObjectPlainLongText.TextObjectKey
  association [1..1] to I_MaintenanceOrderComponent_2 as _MaintenanceOrderComponent on  _MaintenanceOrderComponent.Reservation     = $projection.Reservation
                                                                                        and _MaintenanceOrderComponent.ReservationItem = $projection.ReservationItem
                                                                                        and _MaintenanceOrderComponent.ReservationType = $projection.ReservationType

  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 _MaintenanceOrderComponent[ inner ].MaintenanceOrder,
  key cast( _MaintenanceOrderComponent[ inner ].MaintenanceOrderOperation as maintenanceorderoperation preserving type )    as MaintenanceOrderOperation,
  key cast( _MaintenanceOrderComponent[ inner ].MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) as MaintenanceOrderSubOperation,
  key _MaintenanceOrderComponent[ inner ].MaintOrderComponentInternalID                                                        as MaintOrderComponentInternalID,
  key I_TextObjectPlainLongText.TextObjectType,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key I_TextObjectPlainLongText.Language,
      _MaintenanceOrderComponent[ inner ].MaintenanceOrderComponent                                                            as MaintenanceOrderComponent,
      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,
      _Language
}

Learn More