Skip to Content
Former Member
Jun 12, 2009 at 05:41 AM

How to prepare excels based on records of internal table.


Hi abapers,

I have a scenario as follows:

In my internal table the records are as follows.

col1 col2 col3

1 a1 b1

2 a2 b1

3 a3 b2

4 a4 b3.

Now want i need is i have to break the records on the basis of col3 . All b1 rows are to be taken and dumped in a excel. b2 rows are to be taken and dumped in an excel and similarly for b3. And the name of excel will should be b1, b2 , b3 respectively.

How do i go for the case?

Help would be appreciated..


Navin C

Edited by: navin.c on Jun 12, 2009 7:41 AM