Pulling data from a columns of a grid to excel

[Former Member]

Hi All,

I am new to SAP Script recording feature. In fact I am very happy to come across this as it could save a lot of time by creating macros.

What I am trying to do is:

1) Execute a TCode using a criteria.

2) Pull specific column from grid output to an excel column.

I am able to pull it only till around 59th row, but the grid has around 511 rows of data.

Can someone tell me what is wrong in my code (I am pasting a picture of my code as I am not able to paste the text)

[holger_khn · Accepted solution]

Hello.

As you have not all ALV rows in Memory you Need To scroll List.

one Option is To count Visible rows and use MOD function To identify when you Need to set Current cell and First visible to actuall Counter. Them Memory got refreshed with new Data.

[Former Member · Accepted solution]

Hi Holger Kohn,

I didn't know that all rows won't be in the memory.

Is it always like the first 60 rows that will be in memory?

I will try your logic.

Thanks a lot

Regards

Krishna Kumar