APJ_V_JOB_STATUS

@AbapCatalog.sqlViewName: 'APJ_V_JOB_STAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Status eines Application Jobs lesen'
define view APJ_V_JOB_STATUS 
         as select from APJ_V_JOB_STATUS_INT as runs
         left outer join dd07t as text on  runs.status  = text.domvalue_l
                                              and text.domname = 'APJ_STATUS'
                                              and text.as4local = 'A'
                                              and text.as4vers = '0000'
                                              and text.ddlanguage = $session.system_language
         left outer join dd07t as text_e on  runs.status  = text_e.domvalue_l
                                              and text_e.domname = 'APJ_STATUS'
                                              and text_e.as4local = 'A'
                                              and text_e.as4vers = '0000'
                                              and text_e.ddlanguage = 'E'                                     

{
     key runs.jobname                 as jobname,
     key runs.jobcount                as jobcount,
     
//         runs.status_tech             as status_tech,

         runs.status                  as status,
         
         coalesce(text.ddtext,text_e.ddtext)  as  statustext,
         runs.created_by              as created_by
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"APJ_V_JOB_STATUS_INT",
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/