I_MAINTENANCEITEMCAUSETEXT
Maintenance Item Cause Long Text
I_MAINTENANCEITEMCAUSETEXT is a CDS View in S/4HANA. Maintenance Item Cause Long Text. It contains 6 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_MaintenanceItemCauseTextTP | view_entity | from | TRANSACTIONAL | Maintenance Item Cause Long Text |
Fields (6)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceItem | MaintenanceItem | 1 |
| KEY | NmbrOfMaintComplianceItems | NmbrOfMaintComplianceItems | 1 |
| _LongText | _LongText | 1 | |
| TextObjectCategory | TextObjectCategory | 1 | |
| TextObjectKey | TextObjectKey | 1 | |
| TextObjectType | TextObjectType | 1 |
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: ['_LongText']
@EndUserText.label: 'Maintenance Item Cause Long Text'
@VDM.viewType: #COMPOSITE
@ObjectModel.dataCategory:#TEXT
@Analytics.technicalName: 'IMAINTCAUSELT'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #L
define view entity I_MaintenanceItemCauseText
as select from I_MaintenanceCompliance
association [0..1] to I_TextObjectType as _TextObjectType on $projection.TextObjectType = _TextObjectType.TextObjectType
and $projection.TextObjectCategory = _TextObjectType.TextObjectCategory
association [0..1] to I_TextObjectCategory as _TextObjectCategory on $projection.TextObjectCategory = _TextObjectCategory.TextObjectCategory
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
association [0..*] to I_TextObjectPlainLongText as _LongText on _LongText.TextObjectCategory = 'MPCR'
and _LongText.TextObjectType = 'LTXT'
and _LongText.TextObjectKey = $projection.TextObjectKey
{
key MaintenanceItem,
key NmbrOfMaintComplianceItems,
@Semantics.language: true
@ObjectModel.foreignKey.association: '_Language'
key cast ( $session.system_language as sylangu preserving type ) as Language,
cast( concat(MaintenanceItem, NmbrOfMaintComplianceItems) as tdobname ) as TextObjectKey,
@ObjectModel.foreignKey.association: '_Textobjectcategory'
cast( 'MPCR ' as tdobject preserving type ) as TextObjectCategory,
@ObjectModel.foreignKey.association: '_TextobjectType'
cast( 'LTXT' as tdid preserving type ) as TextObjectType,
/* Local Association */
_TextObjectType,
_TextObjectCategory,
_Language,
_LongText
}
where
MaintComplianceHasLongText = 'X'
and MaintenanceComplianceIsDeleted <> 'X'