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 |
@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
}