R_MaintOrderOpCompLongTextTP_2

DDL: R_MAINTORDEROPCOMPLONGTEXTTP_2 Type: view_entity TRANSACTIONAL

Maint Order Op Comp Long Text TP

R_MaintOrderOpCompLongTextTP_2 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_2) and exposes 12 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintOrderComponentInternalID, TextObjectType. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderOpCompLongText_2 I_MaintOrderOpCompLongText_2 from

Associations (1)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY 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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
KEY MaintenanceOrderOperation MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation
KEY MaintOrderComponentInternalID MaintOrderComponentInternalID
KEY TextObjectType TextObjectType
KEY Language Language
TextObjectKey TextObjectKey
TextObjectCategory TextObjectCategory
OrderComponentLongText OrderComponentLongText
MaintOrdLongTxtIsUpdtd
_MaintenanceOrder _MaintenanceOrder
_MaintenanceOrderComponent _MaintenanceOrderComponent 
@AccessControl.authorizationCheck: #MANDATORY
@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'
define view entity R_MaintOrderOpCompLongTextTP_2
  as select from I_MaintOrderOpCompLongText_2

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

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

{

  key MaintenanceOrder,
  key MaintenanceOrderOperation,
  key MaintenanceOrderSubOperation,
  key MaintOrderComponentInternalID,
  key TextObjectType,
  key Language,
      TextObjectKey,
      TextObjectCategory,
      OrderComponentLongText,
      cast( '' as maintordlongtxtisupdtd preserving type ) as MaintOrdLongTxtIsUpdtd,
      _MaintenanceOrder,
      _MaintenanceOrderComponent
}
where
      _MaintenanceOrderComponent._MaintenanceOrderOperation._StatusObjectActiveStatus [1: StatusCode = 'I0013'].StatusCode is null // mark for deletion based on system status

  and _MaintenanceOrderComponent.IsDeleted                                                                                 = ''

Learn More