Consuming HANA objects in ABAP

Question 1

SAP HANA procedure exporting parameters are always…

Answer 1

Tables

Question 2

Source code of HANA procedures are always written in…

Answer 2

SQLscript

Question 3

What does a parameter being passed to a calculation or analytical view look like?

Answer 3

(‘PLACEHOLDER’ = (‘$$param1$$, ‘param1value’),
‘PLACEHOLDER’ = (‘$$param2$$, ‘param2value’))
the parameter is enclosed in quotes and double dollar signs.

Question 4

In HANA studio what is the best way to preview the data?

Answer 4

Data preview which has three components
Raw data
Distinct rows
Interactive Graphical analysis

Question 5

Where are parameter details shown in HANA studio

Answer 5

The properties view

Question 6

How can a HANA procedure be tested in HANA Studio?

Answer 6

Hit the SQL button and enter the call statement.
e.g.
CALL "_SYS_BIC"."my400.demo/MY_PROCEDURE"('bobby',null, null)
Where _SYS_BIC is the schema
my400.demo is the package path
MY_PROCEDURE is the actual procedure
'bobby' is an import parameter
the two nulls are export parameters

Question 7

How can a HANA procedure be called in ABAP using HANA native SQL?
–is this a procedure or a view?

Answer 7

e.g.
SELECT fld1, fld2,cntflds
FROM
"my400.demo::COUNT_RECS"
WHERE MANDT = sy-mandt

Question 8

How can a HANA procedure be called from ABAP using HANA native SQL when mandatory parameters exist?

Answer 8

SELECT fld1, fld2,cntflds
FROM
"my400.demo::COUNT_RECS"
(PLACEHOLDER = ('\$\$PAR1\$\$','bob'), 
 PLACEHOLDER =('\$\$PAR2\$\$,fld2))
WHERE MANDT = sy-mandt

Question 9

How can I call a HANA procedure to just retrieve the results?

Answer 9

CALL “my400.demo::COUNT_RECS” WITH OVERVIEW

Question 10

When “WITH OVERVIEW” is requested, what is returned to the caller?

Answer 10

A table with two columns of type string

Question 11

What must happen in the calling program to view the OVERVIEW data?

Answer 11

A table with two columns of type string must be created
The created table must be referenced to a data object
The data object is assigned using the SET_PARAM_TABLE method of the call
The NEXT_PACKAGE method must be called
The CLOSE method must be called
So it looks like this
TYPES: begin of t_overview,
PARAM type string
VALUE type string
end of t_overview.

data lt_overview type table of t_overview,
lr_overview type t_overview.

Question 12

What is an external view?

Answer 12

A proxy for a HANA view that can easily be consumed in ABAP

Question 13

Can external views be used as data types in ABAP?

Answer 13

Yes

Question 14

Looking at the external view in ABAP it is possible to determine the tables being used by the HANA view?

Answer 14

No, the proxy is just a thin wrapper. Only the structure of the results is available

Question 15

External views can be created in the ABAP workbench?

Answer 15

No, only in ADT