APJ_V_JOB_STATUS_INT

CDS View

konvertiert internen in externen Status

APJ_V_JOB_STATUS_INT is a CDS View in S/4HANA. konvertiert internen in externen Status. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
APJ_V_JOB_STATUS view from Status eines Application Jobs lesen

Fields (4)

KeyField CDS FieldsUsed in Views
KEY jobcount jobcount 1
KEY jobname jobname 1
created_by created_by 1
status status 1
@AbapCatalog.sqlViewName: 'APJ_V_JSTAT_INT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'konvertiert internen in externen Status'
define view APJ_V_JOB_STATUS_INT
            as select from apj_d_job_exe as jobs
            inner join APJ_V_JOB_RUN_OVERVIEW as runs on jobs.job_name = runs.job_name
{
     key runs.job_name                 as jobname,
     key runs.job_run_count            as jobcount,
//         coalesce(jobc.status,runs.status)  as status_tech,



         runs.job_run_status           as status,

         jobs.created_by               as created_by

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