R_MaintenanceItemCauseTextTP

DDL: R_MAINTENANCEITEMCAUSETEXTTP Type: view_entity TRANSACTIONAL Package: VDM_EAM_MAINTENANCEITEM

Maintenance Item Cause Long Text

R_MaintenanceItemCauseTextTP is a Transactional CDS View that provides data about "Maintenance Item Cause Long Text" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceItemCauseText) and exposes 10 fields with key fields MaintenanceItem, NmbrOfMaintComplianceItems, Language. It has 2 associations to related views. Part of development package VDM_EAM_MAINTENANCEITEM.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceItemCauseText _MaintenanceItemCauseText from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TextObjectPlainLongText _LongText _LongText.TextObjectCategory = 'MPCR' and _LongText.TextObjectType = 'LTXT' and _LongText.TextObjectKey = $projection.TextObjectKey and _LongText.Language = $projection.Language
[1..1] R_MaintenanceItemTP _MaintenanceItem $projection.MaintenanceItem = _MaintenanceItem.MaintenanceItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Item Cause Long Text view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem I_MaintenanceItemCauseText MaintenanceItem
KEY NmbrOfMaintComplianceItems I_MaintenanceItemCauseText NmbrOfMaintComplianceItems
KEY Language _TextObject Language
TextObjectKey I_MaintenanceItemCauseText TextObjectKey
TextObjectCategory I_MaintenanceItemCauseText TextObjectCategory
TextObjectType I_MaintenanceItemCauseText TextObjectType
PlainLongText _LongText PlainLongText
_LongText I_MaintenanceItemCauseText _LongText
_MaintenanceItem _MaintenanceItem
_MaintenanceItemCause _MaintenanceItemCause 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Item Cause Long Text'
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #L

define view entity R_MaintenanceItemCauseTextTP
  as select from            I_MaintenanceItemCauseText as _MaintenanceItemCauseText
    left outer to many join I_TextObject               as _TextObject on  _TextObject.TextObjectType     = 'LTXT'
                                                                      and _TextObject.TextObjectCategory = 'MPCR'
                                                                      and _TextObject.TextObjectKey      = _MaintenanceItemCauseText.TextObjectKey

  association [0..1] to I_TextObjectPlainLongText       as _LongText             on  _LongText.TextObjectCategory = 'MPCR'
                                                                                 and _LongText.TextObjectType     = 'LTXT'
                                                                                 and _LongText.TextObjectKey      = $projection.TextObjectKey
                                                                                 and _LongText.Language           = $projection.Language
  association [1..1] to R_MaintenanceItemTP             as _MaintenanceItem      on  $projection.MaintenanceItem = _MaintenanceItem.MaintenanceItem
  association        to parent R_MaintenanceItemCauseTP as _MaintenanceItemCause on  $projection.MaintenanceItem            = _MaintenanceItemCause.MaintenanceItem
                                                                                 and $projection.NmbrOfMaintComplianceItems = _MaintenanceItemCause.NmbrOfMaintComplianceItems

{

  key  _MaintenanceItemCauseText.MaintenanceItem,
  key  _MaintenanceItemCauseText.NmbrOfMaintComplianceItems,
  key  _TextObject.Language,
       _MaintenanceItemCauseText.TextObjectKey,
       _MaintenanceItemCauseText.TextObjectCategory,
       _MaintenanceItemCauseText.TextObjectType,
       _LongText.PlainLongText,

       /* Associations */
       _MaintenanceItemCauseText._LongText,

       /* Local Association */
       _MaintenanceItem,
       _MaintenanceItemCause
}
where _MaintenanceItemCause.MaintenanceComplianceTypeCode = 'C'

Learn More