Advanced Subjects

Question 1

A delivery unit is a way to….

Answer 1

Transport HANA objects

Question 2

In a delivery unit, individual components of a package can be selected to be transported?

Answer 2

False, all content of the package is included in the delivery unit

Question 3

When using a delivery unit to transport HANA objects, the delivery unit is automatically imported with the ABAP transport?

Answer 3

False. The delivery unit must be manually imported

Question 4

In NW 7.31 SAP introduced the HTC, HANA transport container. What problem did this solve?

Answer 4

The need to manually import the HANA Delivery unit. The delivery unit was included in the hana transport container which was in turn included in the workbench request

Question 5

In NW 7.40 SAP introduced the HANA Transport for ABAP (HTA). What did this allow?

Answer 5

The ability to select individual objects from a HANA package and include them in an HTA which is then included in a workbench request

Question 6

When comparing the ability to re-import objects if a failure occurs; what is the difference between an HTA and an HTC

Answer 6

If an import of an HTC fails a new transport must be created.
If an import of an HTA fails, the transport can be re-imported.

Question 7

What transaction can be used to add HTAs to an ABAP workbench request?

Answer 7

SCTS_HCA is used to select HANA package objects to be added to a workbench transport

Question 8

Under what circumstances might an HTA require manual import? How would the manual import be accomplished?

Answer 8

If an error occurred during the implicit import or if the import requires pre-work (indicated by type P in the deployment mode).
The manual import would be accomplished using t-code SCTS_HANA_DEPLOY

Question 9

what two types of full text search does HANA support?

Answer 9

Full text and Linguistic

Question 10

What is the default fuzzy search threshold?

Answer 10

.8 (a perfect match is 1.0)

Question 11

Full text search is enabled thru…?

Answer 11

The creation of full text indexes?

Question 12

Full text fields are automatically created for what column data types?

Answer 12

Text or short text.

Question 13

since NW 7.4 full text indexes can be created for table columns of what data type?

Answer 13

nvarchar

Question 14

Can full text indexes be created for columns of row stored tables?

Answer 14

No, only column store tables

Question 15

What is the downside to creating full text indexes?

Answer 15

They take up space and they can slow down table modification operations.

Question 16

Where do the full text indexes exist?

Answer 16

As a hidden column of the table the index is created for

Question 17

What three ABAP types are actually nvarchar?

Answer 17

char, string, sstring

Question 18

How is a full text index used in a select statement?

Answer 18

Using the CONTAINS( ) in the WHERE clause
SELECT name, address FROM stab
WHERE CONTAINS( “NAME”, ‘HEIDE’, FUZZY/LINGUISTIC)
After FUZZY a threshold can be set between 0 and 1 such as FUZZY(0.8)

Question 19

If I want the order of the returned results of a fuzzy search to be returned by threshold, what can I do?

Answer 19

order by SCORE( ) DESC/ASC

Question 20

Open SQL supports the CONTAINS keyword of a WHERE clause?

Answer 20

No, only native SQL

Question 21

How can a native SQL statement be used from ABAP?

Answer 21

Use the class CL_SQL_STATEMENT along with CL_SQL_RESULT_SET

Question 22

In OpenSQL the fuzzy search index is still accessed when using which keyword in the where clause?

Answer 22

LIKE

Question 23

What three things in an elementary search help must be set for a search help to have type ahead work?

Answer 23

Proposal search for input fields must be switched on
Multi column Fulltext search must be switched on
Accuracy value can be set

Question 24

What is the reference for the ALV with IDA

Answer 24

IF_SALV_GUI_TABLE_IDA

Question 25

Can parameters be passed to a ALV IDA?

Answer 25

Yes, either thru the set_ranges for tables and views, or the set_parameters when the ALV source is a CDS