APJ_V_JOB_STATUS_INT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| APJ_V_JOB_STATUS | view | from | Status eines Application Jobs lesen |
Fields (4)
| Key | Field | CDS Fields | Used 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":""
}
}*/