Found 594 Articles for SAP Basis

Writing at the end of report without clearing current screen in SAP ABAP

Krantik Chavan
Updated on 30-Jul-2019 22:30:20

95 Views

Yes, it is possible. You would require using MODIFY LINE

Getting error- is not an internal table “OCCURS n” specification is missing in SAP method

Abhinanda Shri
Updated on 13-Jun-2020 06:08:18

2K+ Views

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

Join using CE functions in SAP HANA database

Nishtha Thakur
Updated on 18-Dec-2019 07:42:39

209 Views

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 vs multiple queries to fetch large number of rows in SAP HANA

Smita Kapse
Updated on 30-Jul-2019 22:30:20

1K+ Views

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.

Error while connection SAP HANA with .NET

Anvi Jain
Updated on 30-Jul-2019 22:30:20

148 Views

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

Inserting new line to the output using WS_Download in ABAP

Nitya Raut
Updated on 30-Jul-2019 22:30:20

714 Views

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.

Deleting subsequent heading from report in SAP system

Jennifer Nicholas
Updated on 09-Dec-2019 06:31:44

71 Views

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

Using combination of “AND” and “OR” in SELECT in ABAP

Vrundesha Joshi
Updated on 09-Dec-2019 06:32:33

8K+ Views

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’ ).

Getting class of given method using T-code SE80 in SAP

Rishi Rathor
Updated on 09-Dec-2019 06:34:59

2K+ Views

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.

Adapter properties dropdown not updated with list even after installation (SAP 7.2 adapter)

mkotla
Updated on 30-Jul-2019 22:30:20

85 Views

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.

Advertisements