SAP Basis Articles - Page 39 of 60

You need to define the et_flights parameter as of type SFLIGHT. As per method defined, you have this type as structure type and also declare transparent table SFLIGHT at the same time.You should use an already available dictionary table type with row structure of SFLIGHT for et_flight.You should declare et_flights inside the method in class definition as a private member or as a return value of the method.class myclass definition.    public section.    types ty_mytable type standard table of sflight.    methods mymethod exporting mydata type ty_mytable. endclass. class myclass implementation.     method mymethod.       ... Read More

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.