P_AppJobStatus

@AbapCatalog.sqlViewName: 'PAPLJOBSTATUS'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Application Job Status'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_AppJobStatus
  as select from I_PurchasingDocSimulationJob as _SimulationJob
  //To get the real time status of the job

    inner join   tbtco                        as _tbtco on  _SimulationJob.ApplicationJobName = _tbtco.jobname
                                                        and _SimulationJob.ApplicationJob     = _tbtco.jobcount
{
  key _SimulationJob.ApplicationJobName,
  key _SimulationJob.ApplicationJob,
      //In order to get the status "Attended"

      case
          when _SimulationJob.ReferenceApplicationJobName is initial
          then _tbtco.status
          else 'X'
          end            as AsyncApplicationJobStatus,
      _tbtco.sdldate as CreationDate,
      _tbtco.sdltime as CreationTime
}

//as select from tbtco as _ApplicationLog

//{

//  key jobname  as ApplicationJobName,

//  key jobcount as ApplicationJob,

//

//      status   as StatusCode,

//      sdldate  as CreationDate,

//      sdltime  as CreationTime

//}

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