R_MaintOrderOpCompLongTextTP

DDL: R_MAINTORDEROPCOMPLONGTEXTTP Type: view_entity TRANSACTIONAL

Maint Order Op Comp Long Text TP

R_MaintOrderOpCompLongTextTP is a Transactional CDS View that provides data about "Maint Order Op Comp Long Text TP" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderOpCompLongText) and exposes 11 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintenanceOrderComponent, TextObjectType. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderOpCompLongText I_MaintOrderOpCompLongText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_MaintenanceOrderTP _MaintenanceOrder $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #TEXT view
EndUserText.label Maint Order Op Comp Long Text TP view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor R_MaintOrderOpCompLongTextTP_2 view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
KEY MaintenanceOrderOperation MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation
KEY MaintenanceOrderComponent MaintenanceOrderComponent
KEY TextObjectType TextObjectType
KEY Language Language
TextObjectKey TextObjectKey
TextObjectCategory TextObjectCategory
OrderComponentLongText OrderComponentLongText
_MaintenanceOrder _MaintenanceOrder
_MaintenanceOrderComponent _MaintenanceOrderComponent 
@AccessControl.authorizationCheck: #CHECK
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@ObjectModel.dataCategory:#TEXT
@EndUserText.label: 'Maint Order Op Comp Long Text TP'

@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'R_MaintOrderOpCompLongTextTP_2'
define view entity R_MaintOrderOpCompLongTextTP
  as select from I_MaintOrderOpCompLongText

  association        to parent R_MaintOrderOpComponentTP as _MaintenanceOrderComponent on (
     $projection.MaintenanceOrderOperation        = _MaintenanceOrderComponent.MaintenanceOrderOperation
     and $projection.MaintenanceOrderSubOperation = _MaintenanceOrderComponent.MaintenanceOrderSubOperation
     and $projection.MaintenanceOrder             = _MaintenanceOrderComponent.MaintenanceOrder
     and $projection.MaintenanceOrderComponent    = _MaintenanceOrderComponent.MaintenanceOrderComponent
   )

  association [1..1] to R_MaintenanceOrderTP             as _MaintenanceOrder          on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder

{

  key MaintenanceOrder,
  key MaintenanceOrderOperation,
  key MaintenanceOrderSubOperation,
  key MaintenanceOrderComponent,
  key TextObjectType,
  key Language,
      TextObjectKey,
      TextObjectCategory,
      OrderComponentLongText,

      _MaintenanceOrder,
      _MaintenanceOrderComponent


}
where
      _MaintenanceOrderComponent._MaintenanceOrderOperation._StatusObjectActiveStatus [1: StatusCode = 'I0013'].StatusCode is null // mark for deletion based on system status

  and _MaintenanceOrderComponent.IsDeleted                                                                                 = ''

Learn More