C_MaintOrderWorkflowEmail

DDL: C_MAINTORDERWORKFLOWEMAIL Type: view_entity CONSUMPTION Package: EAM_WFL_MO

Maintenance Order Details for WF

C_MaintOrderWorkflowEmail is a Consumption CDS View that provides data about "Maintenance Order Details for WF" in SAP S/4HANA. It reads from 3 data sources (I_MaintenanceOrder, I_WorkflowTask, I_WorkflowTaskApplObject) and exposes 12 fields with key field WorkflowTaskInternalID. It has 1 association to related views. Part of development package EAM_WFL_MO.

3 data source(s) 12 fields

Data Sources (3)

SourceAliasJoin Type
I_MaintenanceOrder _MaintenanceOrder inner
I_WorkflowTask _Workflowtask from
I_WorkflowTaskApplObject _WorkflowTaskApplObject inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_TechObjMaintenanceOrder _Techobj _Techobj.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder and _Techobj.TechnicalObject <> ''

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Order Details for WF view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
MaintenanceOrder I_MaintenanceOrder MaintenanceOrder
MaintenanceOrderDesc I_MaintenanceOrder MaintenanceOrderDesc
MaintPriority I_MaintenanceOrder MaintPriority
MaintenancePlanningPlant I_MaintenanceOrder MaintenancePlanningPlant
MaintenancePlannerGroup I_MaintenanceOrder MaintenancePlannerGroup
MaintenanceOrderType I_MaintenanceOrder MaintenanceOrderType
MaintOrdBasicStartDate I_MaintenanceOrder MaintOrdBasicStartDate
MaintOrdBasicEndDate I_MaintenanceOrder MaintOrdBasicEndDate
TechnicalObject _Techobj TechnicalObject
TechObjIsEquipOrFuncnlLocDesc _Techobj TechObjIsEquipOrFuncnlLocDesc
TechnicalObjectDescription _Techobj TechnicalObjectDescription 
@AccessControl.authorizationCheck:#MANDATORY
@EndUserText.label: 'Maintenance Order Details for WF'
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking: #NOT_REQUIRED

@VDM.viewType : #CONSUMPTION
@ObjectModel.usageType : {
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@ObjectModel.supportedCapabilities: [ #OUTPUT_EMAIL_DATA_PROVIDER ]

define view entity C_MaintOrderWorkflowEmail
  as select from I_WorkflowTask           as _Workflowtask

    inner join   I_WorkflowTaskApplObject as _WorkflowTaskApplObject on  _WorkflowTaskApplObject.WorkflowTaskInternalID        = _Workflowtask.WorkflowTaskInternalID
                                                                     and _WorkflowTaskApplObject.WorkflowObjectRole            = '01'
                                                                     and _WorkflowTaskApplObject.SAPObjectNodeRepresentation   = 'MaintenanceOrder'
                                                                     and _WorkflowTaskApplObject.TechnicalWrkflwObjectCategory = 'CL'
    inner join   I_MaintenanceOrder       as _MaintenanceOrder       on _MaintenanceOrder.MaintenanceOrder = _WorkflowTaskApplObject.TechnicalWrkflwObject

  association [0..1] to C_TechObjMaintenanceOrder as _Techobj on  _Techobj.MaintenanceOrder =  _MaintenanceOrder.MaintenanceOrder
                                                              and _Techobj.TechnicalObject  <> ''

{

  key _Workflowtask.WorkflowTaskInternalID,
      _MaintenanceOrder.MaintenanceOrder,
      _MaintenanceOrder.MaintenanceOrderDesc,
      _MaintenanceOrder.MaintPriority,
      _MaintenanceOrder.MaintenancePlanningPlant,
      _MaintenanceOrder.MaintenancePlannerGroup,
      _MaintenanceOrder.MaintenanceOrderType,
      _MaintenanceOrder.MaintOrdBasicStartDate,
      _MaintenanceOrder.MaintOrdBasicEndDate,
      _Techobj.TechnicalObject,
      _Techobj.TechObjIsEquipOrFuncnlLocDesc,
      _Techobj.TechnicalObjectDescription
}

Learn More