P_RSHMaintCallOrderProcStatus

DDL: P_RSHMAINTCALLORDERPROCSTATUS SQL: PRSHCALLORDPRST Type: view CONSUMPTION

Processing Status for Maint. Call Orders

P_RSHMaintCallOrderProcStatus is a Consumption CDS View that provides data about "Processing Status for Maint. Call Orders" in SAP S/4HANA. It reads from 4 data sources (I_MaintenanceItem, I_OrderOperationBasic, I_MaintenanceOrder, I_RSHOperationProcessingStatus) and exposes 4 fields with key field MaintenanceOrderInternalID.

4 data source(s) 4 fields

Data Sources (4)

SourceAliasJoin Type
I_MaintenanceItem _MaintItem inner
I_OrderOperationBasic _Operation inner
I_MaintenanceOrder _Order from
I_RSHOperationProcessingStatus _ProcStatus inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRSHCALLORDPRST view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Processing Status for Maint. Call Orders view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrderInternalID MaintenanceOrderInternalID
MaintenanceOrder I_MaintenanceOrder MaintenanceOrder
ObjectInternalID I_MaintenanceItem ObjectInternalID
ProcessingStatus 
@AbapCatalog.sqlViewName: 'PRSHCALLORDPRST'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Processing Status for Maint. Call Orders'

/*
CONTRACT*************************************************************************************************************************
Name:                       Maint Plan/Item Call Order Processing Status Determination
Specification:              This view will calculate the Processing Status for orders called from maintenance plan
Requires:                   NA
Ensures:                    Processing Status per order is returned
Owners:                     CK
Contributors:
Unit Test required Y/N:     Y
Additional comments         Intended only for Maintenance Asset Board

END OF CONTRACT******************************************************************************************************************
*/

define view P_RSHMaintCallOrderProcStatus
  as select from I_MaintenanceOrder             as _Order
    inner join   I_MaintenanceItem              as _MaintItem  on _Order.MaintenanceItem     = _MaintItem.MaintenanceItem
    inner join   I_OrderOperationBasic          as _Operation  on _Operation.OrderInternalID = _Order.MaintOrderRoutingNumber
    inner join   I_RSHOperationProcessingStatus as _ProcStatus on _ProcStatus.StatusObject   = _Operation.ObjectInternalID
                                                               and(
                                                                 _ProcStatus.ProcessingStatus    = 20
                                                                 or _ProcStatus.ProcessingStatus = 30
                                                                 or _ProcStatus.ProcessingStatus = 40
                                                               )
{

  key MaintenanceOrderInternalID,
      _Order.MaintenanceOrder,
      _MaintItem.ObjectInternalID,
      min(_ProcStatus.ProcessingStatus) as ProcessingStatus

}
where
  _Order.MaintenanceItem is not initial 
group by
  MaintenanceOrderInternalID,
  _Order.MaintenanceOrder,
  _MaintItem.ObjectInternalID

Learn More