7/26/2019 ABAP on HANA Advanced

1/23

Usethistitleslideonlywithanim

age

ABAP on HANA - AdvanceManjunath Baburao

April 23, 2015

7/26/2019 ABAP on HANA Advanced

2/23

! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

Disclaimer

'his presentation outlines our general produt diretion and should not be relied on

purhase deision% 'his presentation is not subjet to your liense agreement or anywith "AP% "AP has no obligation to pursue any ourse o$ business outlined in this pr

de&elop or release any $untionality mentioned in this presentation% 'his presentatio

strategy and possible $uture de&elopments are subjet to hange and may be hang

time $or any reason without notie% 'his doument is pro&ided without a warranty o$ a

e*press or implied, inluding but not limited to, the implied warranties o$ merhantab

partiular purpose, or non+in$ringement% "AP assumes no responsibility $or errors or

doument, e*ept i$ suh damages were aused by "AP intentionally or grossly neg

7/26/2019 ABAP on HANA Advanced

3/23

HANA Text Search

7/26/2019 ABAP on HANA Advanced

4/23

! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

Typical Search Issues

Search helps currently

-e.uire orret spelling

-e.uire the searh term to be entered into the orret searh help $ield

7/26/2019 ABAP on HANA Advanced

5/23! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

Full Text Search in SAP HANA hat !an it Do "or #ou$

/ntegrated enterprise appliations deli&ered with "AP Business "uit

so$tware enable enterprises li(e yours to e*eute and optimie

business and /' strategies%

7/26/2019 ABAP on HANA Advanced

6/23! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

SAP HANA S%&' Text Search %uery

SELECT * FROM "MYTABLE" WHERE CONTAINS ("F1", 'SAP', EXA

olumn 'able

r 4iew 'ype oolumn

"pei$iation

"earh

"tring

"earh "tring options

7/26/2019 ABAP on HANA Advanced

7/23! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

Full-text Indexin(

A $ull+te*t inde* is de$ined on a table olumn

CREATEFULLTEXT INDEX[INDEX NAME]ON[SCHEMA].[TABLE]([COLUMN])

7/26/2019 ABAP on HANA Advanced

8/23! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

)ulti-column search

SELECT * FROM DOCUMENTS WHERE CONTAINS ( * ,'business s!#$%e'&

SELECT * FROM DOCUMENTS WHERE CONTAINS (("TITLE","ABSTRACT"),'busin

7/26/2019 ABAP on HANA Advanced

9/23! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

Search Types ' *xact Search and &in(uistic Search

SELECT * FROM "MESSAES"WHERE CONTAINS("MESSAE", 'businesses', EXACT&

SELECT * FROM "MESSAES"

WHERE CONTAINS("MESSAE", '', LINGUISTIC&

7/26/2019 ABAP on HANA Advanced

10/23! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

Search Type ' Fu++y Search

SELECT ")RODUCTID","NAME","DESCRI)TION" FROM "+)RODUCTS WHERE CONTAINS("DE's-%eeen',FUZZY(0.8)&

'erm ma

7/26/2019 ABAP on HANA Advanced

11/23

! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

,se Native S%& and ABAP Dataase !onnectivity API

Fast text search re.uires "ull-text

indexes an be reated using ABAP 8itionary

Text search .uery syntax is SAP

HANA-speci"ic

9o support in pen ":;Use nati&e":; again

SELECT ")RODUCTID","NAME","DESCRI)TION"

FROM "+)RODUCTS

WHERE CONTAINS(

"DESCRIPTION",'!###$',FUZZY(0.8))

7/26/2019 ABAP on HANA Advanced

12/23

! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

Search Helps /ith Type-Ahead

7/26/2019 ABAP on HANA Advanced

13/23

SAP A&0 IDA

7/26/2019 ABAP on HANA Advanced

14/23

! 2015 "AP "# or an "AP a$$iliate ompany% All rights reser&ed%

ABAP on HANA Paradi(m shi"t

alulations