R_MaintOrderOpLongTextTP

DDL: R_MAINTORDEROPLONGTEXTTP Type: view_entity TRANSACTIONAL

Maintenance order operation long text TP

R_MaintOrderOpLongTextTP is a Transactional CDS View that provides data about "Maintenance order operation long text TP" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderOperationLongText) and exposes 12 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, TextObjectType, Language. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderOperationLongText I_MaintOrderOperationLongText from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_MaintenanceOrderTP _MaintenanceOrder $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
[0..1] I_Language _Language _Language.Language = $projection.Language

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 Maintenance order operation long text TP view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
KEY MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation
KEY TextObjectType TextObjectType
KEY Language
TextObjectKey TextObjectKey
OrderOperationLongText OrderOperationLongText
TextObjectCategory TextObjectCategory
MaintOrdLongTxtIsUpdtd
_MaintenanceOrder _MaintenanceOrder
_MaintenanceOrderOperation _MaintenanceOrderOperation
_Language _Language 
@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: 'Maintenance order operation long text TP'
define view entity R_MaintOrderOpLongTextTP
  as select from I_MaintOrderOperationLongText
  association        to parent R_MaintenanceOrderOperationTP as _MaintenanceOrderOperation on (
     $projection.MaintenanceOrderOperation        = _MaintenanceOrderOperation.MaintenanceOrderOperation
     and $projection.MaintenanceOrderSubOperation = _MaintenanceOrderOperation.MaintenanceOrderSubOperation
     and $projection.MaintenanceOrder             = _MaintenanceOrderOperation.MaintenanceOrder
   )
  association [1..1] to R_MaintenanceOrderTP                 as _MaintenanceOrder          on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
  association [0..1] to I_Language                           as _Language                  on _Language.Language = $projection.Language

{
  key MaintenanceOrder,
  key cast( _MaintenanceOrderSubOperation.MaintenanceOrderOperation    as maintenanceorderoperation preserving type )    as MaintenanceOrderOperation,
  key cast( _MaintenanceOrderSubOperation.MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) as MaintenanceOrderSubOperation,
  key TextObjectType,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key cast( Language  as spras preserving type )                                                                         as Language,
      TextObjectKey,
      OrderOperationLongText,
      TextObjectCategory,
      cast( '' as maintordlongtxtisupdtd preserving type )                                                               as MaintOrdLongTxtIsUpdtd,
      _MaintenanceOrder,
      _MaintenanceOrderOperation,
      _Language
}
where
  _MaintenanceOrderSubOperation._StatusObjectActiveStatus [1: StatusCode = 'I0013'].StatusCode is null // mark for deletion based on system status

Learn More