I_MAINTORDEROPCOMPLONGTEXT
Maintenance Order Op Component Long Text
I_MAINTORDEROPCOMPLONGTEXT is a CDS View in S/4HANA. Maintenance Order Op Component Long Text. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_MaintOrderOpCompLongTextTP | view_entity | from | TRANSACTIONAL | Maint Order Op Comp Long Text TP |
@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
@Analytics.technicalName: 'IMAINTORDCOMLTXT'
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'MaintenanceOrderComponent'
define view entity I_MaintOrderOpCompLongText
as select from I_TextObjectPlainLongText
inner join I_OrderComponentLongText as resb_text on resb_text.TextObjectKey = I_TextObjectPlainLongText.TextObjectKey
association [1..1] to I_MaintenanceOrderComponent 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
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 _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 cast( _MaintenanceOrderComponent[ inner ].MaintenanceOrderComponent as maintenanceordercomponent preserving type ) as MaintenanceOrderComponent,
key I_TextObjectPlainLongText.TextObjectType,
@ObjectModel.foreignKey.association: '_Language'
@Semantics.language: true
key I_TextObjectPlainLongText.Language,
resb_text.Reservation as Reservation,
resb_text.ReservationItem as ReservationItem,
resb_text.RecordType as ReservationType,
resb_text.TextObjectKey as TextObjectKey,
I_TextObjectPlainLongText.PlainLongText as OrderComponentLongText,
I_TextObjectPlainLongText.TextObjectCategory,
_MaintenanceOrderComponent,
_MaintenanceOrder,
_TextObjectPlainLongText,
_Language
}