v_feb_fuzzy_view

DDL: V_FEB_FUZZY_DDL SQL: V_FEB_FUZZY Type: view Package: EA-FIN_EB_BSPROC_FUZZYSEARCH

Fuzzy Search for Bank Statement Postprocessing

v_feb_fuzzy_view is a CDS View that provides data about "Fuzzy Search for Bank Statement Postprocessing" in SAP S/4HANA. It reads from 1 data source (bkpf). Part of development package EA-FIN_EB_BSPROC_FUZZYSEARCH.

1 data source(s)

Data Sources (1)

SourceAliasJoin Type
bkpf bkpf inner

Annotations (2)

NameValueLevelField
ClientDependent view
AbapCatalog.sqlViewName 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

Learn More