FINS_MP_PACKAGE

@AbapCatalog.sqlViewName: 'FINSV_MP_PACKAGE'
@AbapCatalog.compiler.compareFilter: true
-- @ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@EndUserText.label: 'Mass packages of project'
define view FINS_MP_PACKAGE
  as select
    b.project_id   as project_id,
    a.set_id       as set_id,
    a.step_id      as step_id,
    package_key,
    a.run_id       as run_id,
    iteration,
    processing_order,
    processing_priority,
    start_processing,
    end_processing,
    a.jobname as jobname,
    a.jobcount as jobcount,
    appl_log_ext_id,
    appl_log_number,
    num_smsg,
    num_imsg,
    num_wmsg,
    num_emsg,
    a.x_reset,
    a.x_invalidated,                // on package level

    a.process as process,
    exec_run_id,
    b.status,
    b.status_time,
    b.status_uname,
    b.x_invalidated as invalidated,   // on run level

    c.status as jobstatus
  from   fins_masspackage as a
    join fins_mproj_runid as b on  a.mandt      = b.mandt
                               and a.set_id     = b.set_id
                               and a.run_id     = b.run_id  
                               and a.project_id = b.project_id    
    left outer join tbtco as c on  a.jobname    = c.jobname          
                               and a.jobcount   = c.jobcount 
                                       
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINS_MASSPACKAGE",
"FINS_MPROJ_RUNID",
"TBTCO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/