SAP HANA Articles - Page 49 of 69

You can try using projection node as followsExampletable1 = CE_PROJECTION(:T1,["ACCT_ID","SALARY"]); table2 = CE_PROJECTION(:T2,["EMPL_ID" AS “ACCT_ID”,"ADD","ZIP","STATE"]); var_out = CE_JOIN(:table1,:table2,[“ACCT_ID”])Using Projection node, you can rename the column names. Note that EMPL_ID has been renamed to ACCT_ID

Single query would always be better than the multiple queries. The number of rows does not impact much on performance. It is the way query is written and the data to be fetched which makes the difference. Also, the table should be indexed.

You would require installing both the 32 bit and 64 bit SAP HANA client software as Microsoft Visual operates on a 32 bit application.

First of all, don’t use WS_DOWNLOAD as this is obsolete.You can use a character type field and set it to cl_abap_char_utilities=>cr_lf. Now use this field at places where you want to insert the new line.

You need to add “NO STANDARD PAGE HEADING” as followsREPORT l_report MESSAGE-ID l_message NO STANDARD PAGE HEADING.

You can use the following query:SELECT * FROM my_table WHERE condition 1 AND condition 2 AND ( id EQ '2' or id EQ ‘3’ ).Note: There should be space after and before bracket.Alternatively you can use IN statement as below:SELECT * FROM my_table WHERE condition 1 AND condition 2 AND EQ IN ('2', ‘3’ ).

You would require calling transaction SE80 and then looking into Repository info system. Under that go to the class library and then to methods. You can specify selection criteria under standard selections.

I have experienced something similar in the past. What I noticed was a part of the installer, the assembly responsible for Microsoft adapter properties is not deployed over to the group.I had to perform the step manually. So I had to copy the dll (BizTalkPropertySchema) manually so that the options in dropdown starts coming.Also, make sure the Global assembly cache is synced while adding.

The answer is there is no such single table where you can find everything pertaining to qualifications as they are stored in PD tables as well.Basically, they are of object type ‘Q’ and are stored under HRP1000. HRP10001 will capture the relation between the qualification and employee.  We do have qualification rating and scales which you can find in HRPAD31 and T77TP respectively. T77TS stores the text with an id of qualification.You can also go ahead with function module ‘RHPP_Q_PROFILE_READ’ which you can use.

Note that sap.ui.commons is an old desktop library and sap.m is old mobile library.There are various JavaScript and CSS libraries that you can use in combination for the application development. SAPUI5 can use these libraries in combination and they are called SAPUI5 control libraries.Sap.m is the most common control library and is used for mobile devices and desktop.Note that with new release, few of the controls in sap.ui.commons.layout have been replaced by the new dedicated layout library called sap.ui.layout, and it runs on same platform “sap.m”.Few of the old controls have been made available again through the non-deprecated sap.ui.unified library, which ... Read More