topic Re: Conversion from One Internal table to another in Application Development and Automation Discussions

Conversion from One Internal table to another

Former Member — Mon, 22 Sep 2008 10:04:51 GMT

Hello,

I need to convert the below to the one I mention below that.

Row Column Value

1 1 X1

1 2 Y1

1 3 Z1

2 1 X2

2 2 Y2

2 3 Z3

Col_1 Col_2 Col_3

X1 Y1 Z1

X2 Y2 Z2

Is there any special ABAP statement or FM which does this already ?

Thanks,

Kiran

Re: Conversion from One Internal table to another

Former Member — Mon, 22 Sep 2008 10:07:10 GMT

Hi,

there is no ready made one .. you have to use logic.

use nested loop.

Regards,

Anirban

Re: Conversion from One Internal table to another

Former Member — Mon, 22 Sep 2008 10:08:22 GMT

Hi,

Except field name, data type and length are same, then you can directly use 'APPEND LINES OF ITAB1 TO ITAB2'.

Try this.

Regards,

R.Nagarajan.

Re: Conversion from One Internal table to another

Former Member — Mon, 22 Sep 2008 10:21:51 GMT

hi,

Iam giving u the code samples.

1.LOOP AT IT_EXCEL INTO WA_EXCEL.

ASSIGN COMPONENT WA_EXCEL-COL OF STRUCTURE WA_EKKO TO <FEX>.

MOVE WA_EXCEL-VALUE TO <FEX>.

AT END OF ROW.

APPEND WA_EXCEL TO IT_EXCEL.

CLEAR WA_EXCEL.

ENDAT.

ENDLOOP.

***SORT IT_EXCEL BY ROW COL.

***

***LOOP AT IT_EXCEL INTO WA_EXCEL.

***

***CASE WA_EXCEL-COL.

***

***WHEN 1.

***WA_EKKO-EBELN = WA_EXCEL-VALUE.

***

***WHEN 2.

***WA_EKKO-BUKRS = WA_EXCEL-VALUE.

***

***WHEN 3.

***WA_EKKO-BSTYP = WA_EXCEL-VALUE.

***

***WHEN OTHERS.

***

***ENDCASE.

***

***AT END OF ROW.

***APPEND IT_EKKO .

***CLEAR WA_EKKO.

***ENDAT.

***

***ENDLOOP.

Regards,

deepthi.

Re: Conversion from One Internal table to another

Former Member — Tue, 23 Sep 2008 09:56:05 GMT

Thanks all of you. That solved my problem