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:

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.

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

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

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

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.

5 Comments

You must be Logged on to comment or reply to a post.

Valeriy Zauzolkov February 13, 2015 at 8:21 am

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.

like (0)
1. Shai Sinai February 22, 2015 at 11:54 am
  
  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.
  
  like (0)
2. Siva kumar Devana Post authorMarch 3, 2015 at 6:46 am
  
  Hi Valeriy,
  
  I have tried the above proces in EHP6 FOR SAP ERP 6.0 version.
  
  Regards,
  
  Siva kumar.
  
  like (0)
Ivan Brandespim Bassoli Vegas April 14, 2015 at 2:25 pm

Hi, Siva kumar!

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

Tks!

like (0)
1. Siva kumar Devana Post authorApril 17, 2015 at 1:41 pm
  
  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.
  
  like (0)