FOP_AUTH_CANCEL

@AbapCatalog.sqlViewName: 'FOP_AUTHCANCEL'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #X

define view FOP_AUTH_CANCEL 
  as select from bsegc
    inner join bseg on bsegc.bukrs = bseg.bukrs and 
                       bsegc.gjahr = bseg.gjahr and
                       bsegc.belnr = bseg.belnr and
                       bsegc.rfzei = bseg.rfzei
    inner join  (
      t042zebpp inner join t042 on t042zebpp.zbukr = t042.zbukr ) 
      on bsegc.bukrs = t042.bukrs
{
 key bsegc.bukrs,
 key bsegc.gjahr,
 key bsegc.belnr,
 key bsegc.rfzei,
 bseg.kunnr,
 bseg.h_bldat as bldat,
 bseg.h_budat as budat
}

where t042.bukrs = bsegc.bukrs
  and t042zebpp.pmcla = 'C'
  and bsegc.aunum <> ''
  and bsegc.dp_token <> ''
  and bsegc.ccbtc = ''
  and bsegc.settl = ''
  and bsegc.dp_payid = ''
  and bseg.koart = 'D'
  and bseg.augbl = ''
  and bseg.zlsch = t042zebpp.zlsch
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BSEG",
"BSEGC",
"T042",
"T042ZEBPP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/