Skip to Content
Author's profile photo Siva kumar Devana

Procedure to upload an excel data into an internal table while debugging in SAP ABAP.

Hello SCN Members,

Good Morning,

I have faced a situation, where in SAP Development system does not have data and Testing system has data. So, i am trying to add data on the internal table manually and it is taking much time. so, i tried to copy only changed data in a row from 3rd column to end of the column on the excel sheet. Like that i have done many times and after that i have got an idea and do as below:

While debugging, wherever i need to fill data to an internal table i put  break point and filled the data by uploading the excel which was downloaded from the Test server and the process is as follows:

First put a break-point where we need to fill data to an internal table. So, break point was stopped.see the below picture in debugging – standard tab,services on the Tool as high lighted below and click on the internal table you will get the data as below:

/wp-content/uploads/2015/02/sample1_640901.png

you will get the data as above,

go to services on the tool icon as high lighted below: Internal table here is Lt_Final with 6 records.

/wp-content/uploads/2015/02/sample2_640902.png

you will get the pop-up as below: Under Table display services, Services<Standard<

sample 3.png

Double click on it to upload the test server data, you will get the below pop-up message, click on yes button as below.

/wp-content/uploads/2015/02/sample4_640914.png

after that again you will get the below pop-up message and click on ‘Allow’.

sample 5.png

After that it will fill the data to that particular internal table .(here in this case internal table (LT_Final with 40 records).

With that, i did my program changes successfully. This blog will be benefited to our members a lot i hope.

I have used the above process in EHP6 FOR SAP ERP 6.0 version.

Regards,

Siva kumar.

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Valeriy Zauzolkov
      Valeriy Zauzolkov

      Hi!

      Remark - you didn't mention the version of NW where this tool exist 🙂

      For example, there's no "upload from file" in NW 7.0.

      Regards,
      Valeriy.

      Author's profile photo Former Member
      Former Member

      As far as I remember, it was introduced in EhP2, like many other advanced debugging features.

      You may read a short overview in Displaying Internal Tables in the Debugger in NetWeaver 7.0 EHP2.

      Author's profile photo Siva kumar Devana
      Siva kumar Devana
      Blog Post Author

      Hi Valeriy,

      I have tried the above proces in EHP6 FOR SAP ERP 6.0 version.

      Regards,

      Siva kumar.

      Author's profile photo Former Member
      Former Member

      Hi, Siva kumar!

      Could you tell me if any configuration is required for the "upload from file" appears ?

      Tks!

      Author's profile photo Siva kumar Devana
      Siva kumar Devana
      Blog Post Author

      Hi Ivan BB vegas,

      no need of any configuration.

      just do as per the screen shots given on that document. you will be able to upload.ok.

      Regards,

      Siva kumar.