v_feb_fuzzy_view

@ClientDependent: ''
@AbapCatalog.sqlViewName: 'V_FEB_FUZZY'
// Search view for bank statement post-processing: 

// provide selected BSEG / BKPF columns in which the user

// lets the system search for text or number fragments 

// from the note-to-payee (bank statement memo line)

define view v_feb_fuzzy_view
as
  select 
      bseg.bukrs,
      bseg.belnr,
      bseg.gjahr,
      bseg.buzei,
      bkpf.xblnr,
      bseg.koart,
      bkpf.bktxt,
      bseg.sgtxt,
      bseg.kunnr,
      bseg.lifnr,
      bseg.rebzg,
      bseg.augbl,
      bseg.xref1,
      bseg.xref2,
      bseg.xref3,
      bseg.zuonr,
      bseg.vertn
    from bseg as bseg
    inner join bkpf as bkpf
    on  bkpf.bukrs = bseg.bukrs
    and bkpf.belnr = bseg.belnr
    and bkpf.gjahr = bseg.gjahr              
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"BKPF",
"BSEG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/