Skip to Content
0
Former Member
Oct 14, 2009 at 07:08 AM

Read internal table

46 Views

Hi

I am uploading data from excel to internal table itab1.

below is my excel data

Dno	Lno	KNDNR	ARTNR	FKART	KAUFN	KDPOS	

1	1		12345			10

Itab structure is.

ROW   COL   VALUE
0001   0001   Dno                                                        
0001 0002     Lno                                                             
0001 0003     KNDNR                                                           
0001 0000     ARTNR                                                           
0001 0005     FKART                                                           
0001 0006     KAUFN                                                           
0001 0007    KDPOS     
0002 0001      1                                                                
0002 0002      1                                                                
0002 0004     12345                                                                
0002 0007     10

I want to modify the internal table structure like below

Dno           Lno     char        value
  1             1         ARTNR   12345
  1             1         KDPOS    10

How to achieve this. pls help me