P_MaintOrderCompletionStatus

DDL: P_MAINTORDERCOMPLETIONSTATUS SQL: PMAINTORDCMPL Type: view CONSUMPTION

P_MaintOrderCompletionStatus is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrder) and exposes 1 field with key field MaintenanceOrder.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrder I_MaintenanceOrder from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMAINTORDCMPL view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder 
@AbapCatalog.sqlViewName: 'PMAINTORDCMPL'
@AccessControl.authorizationCheck: #NOT_REQUIRED

//@EndUserText.label: 'Confirmed Maintenance Order'


@VDM.viewType: #CONSUMPTION
@VDM.private: true

@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}


define view P_MaintOrderCompletionStatus
  as select from I_MaintenanceOrder
{
  key MaintenanceOrder,

      cast( case when _StatusObjectActiveStatus[1: StatusCode = 'I0009'].StatusCode != ''
        then 'X'
      else '' end as xfeld )  as MaintOrderIsFinallyConfirmed,

      cast( case when _StatusObjectActiveStatus[1: StatusCode = 'I0045'].StatusCode != ''
        then 'X'
      else '' end as xfeld )  as MaintenanceOrderIsCompleted,

      cast( case when _StatusObjectActiveStatus[1: StatusCode = 'I0076'].StatusCode != ''
        then 'X'
      else '' end as xfeld )  as MaintenanceOrderIsDeleted,

      cast( case when _StatusObjectActiveStatus[1: StatusCode = 'I0046'].StatusCode != ''
         then 'X'
       else '' end as xfeld ) as MaintOrderIsBusinessCompleted,

      cast( case when _StatusObjectActiveStatus[1: StatusCode = 'I0043'].StatusCode != ''
      then 'X'
      else '' end as xfeld )  as MaintOrderIsLocked,

      cast( case when _StatusObjectActiveStatus[1: StatusCode = 'I0002'].StatusCode != ''
      then 'X'
      else '' end as xfeld )  as MaintOrderIsReleased



}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDER",
"I_STATUSOBJECTACTIVESTATUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More