Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Transpose internal table single row to single column

deepak_kumar11
Participant
0 Kudos

hi all,

I am having one internal table which is dynamicaly genrated in program...now i want to have data of first row into single column. field name of internal table are dynamic ...its is described below

<b>present layout</b>

row/column field1 field2 field3 field4 ..........

data1 data2 data3 data4 ...........

<b>desired layout</b>

field

data1

data2

data3

date4

data5

.

.

.

.

.

no of fields are also not fixed..how it can be done..

Regards

Deepak

1 ACCEPTED SOLUTION

Former Member
0 Kudos

This should give you an idea on how to do that.

DATA spfli_wa TYPE spfli. 

FIELD-SYMBOLS: <wa>   TYPE ANY, 
               <comp> TYPE ANY. 

ASSIGN spfli_wa TO <wa>. 

SELECT SINGLE * 
       FROM spfli 
       INTO spfli_wa 
       WHERE carrid = 'LH' AND 
             connid = '400'. 

WHILE sy-subrc = 0. 
  ASSIGN COMPONENT sy-index OF STRUCTURE <wa> TO <comp>. 
  WRITE / <comp>. 
ENDWHILE.

2 REPLIES 2

Former Member
0 Kudos

This should give you an idea on how to do that.

DATA spfli_wa TYPE spfli. 

FIELD-SYMBOLS: <wa>   TYPE ANY, 
               <comp> TYPE ANY. 

ASSIGN spfli_wa TO <wa>. 

SELECT SINGLE * 
       FROM spfli 
       INTO spfli_wa 
       WHERE carrid = 'LH' AND 
             connid = '400'. 

WHILE sy-subrc = 0. 
  ASSIGN COMPONENT sy-index OF STRUCTURE <wa> TO <comp>. 
  WRITE / <comp>. 
ENDWHILE.

0 Kudos

Thanx ....