P_RSHMaintSchedSmltdDueStatus

DDL: P_RSHMAINTSCHEDSMLTDDUESTATUS SQL: PRSHMTSCSTAT Type: view CONSUMPTION

Processing Status

P_RSHMaintSchedSmltdDueStatus is a Consumption CDS View that provides data about "Processing Status" in SAP S/4HANA. It reads from 3 data sources (I_StatusObjectStatusBasic, I_OrderOperationBasic, I_RSHMaintScheduleOperations) and exposes 2 fields. It has 1 association to related views.

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
I_StatusObjectStatusBasic _ExclStatusObj left_outer
I_OrderOperationBasic OperationDetails inner
I_RSHMaintScheduleOperations SimulatedOperations from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_StatusObjectStatusBasic _InclStatusObj _InclStatusObj.StatusObject = OperationDetails.ObjectInternalID and _InclStatusObj.StatusIsInactive = '' and ( _InclStatusObj.StatusCode = 'I0010' or _InclStatusObj.StatusCode = 'I0117' or _InclStatusObj.StatusCode = 'I0002' or _InclStatusObj.StatusCode = 'I0001' )

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRSHMTSCSTAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Processing Status view

Fields (2)

KeyFieldSource TableSource FieldDescription
MaintOrderRoutingNumber I_RSHMaintScheduleOperations MaintOrderRoutingNumber
MaintOrderOperationCounter I_RSHMaintScheduleOperations MaintOrderOperationCounter 
@AbapCatalog.sqlViewName: 'PRSHMTSCSTAT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Processing Status'

/*
CONTRACT*************************************************************************************************************************
Name:                       Maintenance Scheduling Simulation Operations Status
Specification:              This view will return the status of the operations added for scheduling
Requires:                   NA
Ensures:                    Status of Operations of Maintenance Scheduling Simulations are returned
Owners:                     CF
Contributors:               AN
Unit Test required Y/N:     N
Additional comments         None

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

define view P_RSHMaintSchedSmltdDueStatus
  as select from    I_RSHMaintScheduleOperations as SimulatedOperations
    inner join      I_OrderOperationBasic        as OperationDetails on  OperationDetails.OrderInternalID          = SimulatedOperations.MaintOrderRoutingNumber
                                                                     and OperationDetails.OrderOperationInternalID = SimulatedOperations.MaintOrderOperationCounter
                                                                     and OperationDetails.OperationConfirmation    = SimulatedOperations.MaintOrderConfirmation
    left outer join I_StatusObjectStatusBasic    as _ExclStatusObj   on  _ExclStatusObj.StatusObject     = OperationDetails.ObjectInternalID
                                                                     and _ExclStatusObj.StatusIsInactive = ''
                                                                     and (
                                                                        _ExclStatusObj.StatusCode        = 'I0013' //DELETED

                                                                        or _ExclStatusObj.StatusCode     = 'I0045' //CONFIRMED (TECO)

                                                                        or _ExclStatusObj.StatusCode     = 'I0009' //CONFIRMED (CNF)

                                                                        or _ExclStatusObj.StatusCode     = 'I0043' //LOCKED

                                                                        or _ExclStatusObj.StatusCode     = 'I0046' //CLOSED  (Business Closed)

                                                                      )


  association [0..*] to I_StatusObjectStatusBasic as _InclStatusObj on  _InclStatusObj.StatusObject     = OperationDetails.ObjectInternalID
                                                                    and _InclStatusObj.StatusIsInactive = ''
                                                                    and (
                                                                       _InclStatusObj.StatusCode        = 'I0010' //PART. CONFIRMED

                                                                       or _InclStatusObj.StatusCode     = 'I0117' //DISPATCHED

                                                                       or _InclStatusObj.StatusCode     = 'I0002' //RELEASED

                                                                       or _InclStatusObj.StatusCode     = 'I0001' //CREATED

                                                                     )



{

  SimulatedOperations.MaintOrderRoutingNumber,
  SimulatedOperations.MaintOrderOperationCounter,

  max( case _InclStatusObj.StatusCode
              when 'I0010' then 40 //PART. CONFIRMED

              when 'I0117' then 30 //DISPATCHED

              when 'I0002' then 20 //RELEASED

              when 'I0001' then 20 //CREATED

              end )                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             as                       ProcessingStatus

}
where
  _ExclStatusObj.StatusObject is null
group by
  SimulatedOperations.MaintOrderRoutingNumber,
  SimulatedOperations.MaintOrderOperationCounter
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORDEROPERATIONBASIC",
"I_RSHMAINTSCHEDULEOPERATIONS",
"I_STATUSOBJECTSTATUSBASIC"
],
"ASSOCIATED":
[
"I_STATUSOBJECTSTATUSBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More