V_SFIAtOpActyMissingStatus

@AbapCatalog.sqlViewName: 'VMPSFIOPACTYMS'
@AbapCatalog.compiler.compareFilter:true 
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
define view V_SFIAtOpActyMissingStatus
  as select from    mpe_oa_instance  as oai
    inner join      mpe_oan_instance as oani on  oai.mandt           = oani.mandt
                                             and oai.oan_instance_id = oani.oan_instance_id
    inner join      afvc             as oper on  oani.mandt = oper.mandt
                                             and oani.aufpl = oper.aufpl
                                             and oani.aplzl = oper.aplzl
    inner join      t430             as t430 on  oper.mandt = t430.mandt
                                             and oper.steus = t430.steus
    inner join      mpe_sfi          as sfi  on  oani.mandt = sfi.mandt
                                             and oani.aufnr = sfi.aufnr
    inner join      mpe_oan_element  as el   on  oai.mandt              = el.mandt
                                             and oani.oan_id            = el.oan_id
                                             and oani.oan_version_no    = el.oan_version_no
                                             and oai.oan_element_number = el.oan_element_number
    inner join      mpe_oa           as oa   on  el.mandt              = oa.mandt
                                             and el.element_id         = oa.id
                                             and el.element_version_no = oa.version_no
    left outer join mpe_sfi_rwrk_op  as rwrk on  rwrk.mandt  = sfi.mandt
                                             and rwrk.sfi_id = sfi.sfi_id
                                             and rwrk.aufpl  = oper.aufpl
                                             and rwrk.aplzl  = oper.aplzl
    left outer join mpe_sfi_status   as sts  on  oai.mandt              = sts.mandt
                                             and sfi.sfi_id             = sts.sfi_id
                                             and oai.oan_instance_id    = sts.oan_instance_id
                                             and oai.oan_element_number = sts.oan_element_number

{
  key oai.mandt              as mandt,
  key oani.aufnr             as aufnr,
      oai.oan_instance_id    as oan_instance_id,
      oai.oan_element_number as oan_element_number,
      sfi.sfi_id             as sfi_id,
      oa.sfi_sasname         as sasname,
      oper.aufpl             as aufpl,
      oper.aplzl             as aplzl,
      t430.rework            as rework

}
where
       oani.sfi_conf          = 'X'
  and  sts.oan_element_number is null
  and(
       t430.rework            = ''
    or not rwrk.sfi_id        is null
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AFVC",
"MPE_OA",
"MPE_OAN_ELEMENT",
"MPE_OAN_INSTANCE",
"MPE_OA_INSTANCE",
"MPE_SFI",
"MPE_SFI_RWRK_OP",
"MPE_SFI_STATUS",
"T430"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/