topic Re: How to insert one internal table into another internal table in Application Development and Automation Discussions

How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 05:18:59 GMT

Hi on the requirement of my report i have developed more internal tables so i want to reduce the usage of number of internal tables so can any one suggest any suggestion for reducing internal tables. Is there any loss by using this many internal tables in a program if yes can any one suggest me how to solve this problem

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 05:22:27 GMT

Hi Pavan,

There is no loss in Using IT when you require them.But if two internal tables have same data and to be taken from different DBtables then you can use appending the same internal table with the values needed.

-Priyanka.

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 05:22:38 GMT

Hi,

Try to deifne an internal table where you can accomodiate max of your fields , but this may not be the best solution because this may result in comlex seelct statements and other processing.

So better continue with the program the way are currently doing.

Regards

Arun

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 05:27:19 GMT

hi,

instead of reducing no of internal table try releasing memory space occupied by internal table once u finished using it.

for freeing memory use

statement.

i hope this will help u

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 05:35:28 GMT

already i had defined 5 r 6 internal tables in a program but i think it will increase the complexity of the program so can u say how to define an internal table in another internal table the problem here is i had defined an internal table for alv grid format and after that i had declared so many internal tables but now i have to transfer one of the internal tables into alv grid internal table but it was showing an error in that conversation i had tried like this

MOVE-CORRESPONDING IZNEW1 TO RTAB_ALV.

in which RTAB_ALV is internal table for alv grid and IZNEW1 is another internal table in which i had transfered ZNEW1 values to the internal table IZNEW1 and ZNEW1 is a database view i had created by comparing two tables EKKO,EKPO

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 05:36:26 GMT

MOVE-CORRESPONDING IZNEW1 TO RTAB_ALV.

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 05:36:46 GMT

MOVE-CORRESPONDING IZNEW1 TO RTAB_ALV.

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 05:39:13 GMT

same structure...

itab1[] = itab2[].

Different structures....

data: v_tabix like sy-tabix.

sort itab1 by key fields.

sort itab2 by key fields.

loop at itab1.

v_tabix = sy-tabix.

read table itab2 with key <keys>

if sy-subrc = 0.

itab1-field = itab2-field.

modify itab1 index v_tabix.

endif.

clear: itab1, itab2.

endloop.

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 05:41:44 GMT

Hi ,

Please rember that move-corrsponding does not work on tables it just works on structure.

So you will have to loop on table , then move corresponding and then anppend..

E.G.

Loop at IZNEW1 into wa1.
MOVE-CORRESPONDING wa1 TO wa2. 
append wa2 to RTAB_ALV.
clear wa2.
endloop.

Regards

Arun

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 06:07:05 GMT

HERE ONE ERROR IS COMING LIKE BELOW WHILE TRANSFERING DATA FROM ONME INTERNAL TABLE TO ANOTHER INTERNAL TABLE

KTAB AND RTAB ARE NOT MUTUALLY NOT CONVERTIBLE IN A UNICODE PROGRAME.

ACTUALLY WE R HAVING ONE DATABASE VIEW FROM VIEW WE R TAKNIG DATA AND WE WANT TO TRANSFER THAT DATA INTO INTERNAL TABLE

AND IN THIS REPORT WE R ALSO DOING SOME CALCULATION THAT CALCULATION ALSO NEED IN INTERNAL TABLE ALONG WITH VIEW DATA I

MEAN DATA BASE VIEW DATA AND CALCULATION DATA ALSO COMBINE IN ONE INTERNAL TABLE HOW CAN I DO IT.

SO PLEASE HELP ME.

THANKS IN ADVANCED.

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 06:26:45 GMT

plzzzzzz any one o ABAP gurus suggest me one solution

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 06:33:44 GMT

hi,

Try creating dynamic internal table instead of creating 5 or 6 internal table.

for more details

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 07:08:39 GMT

Hi Mr. Vickram keeping aside this internal tables for some time i have a doubt in internal tables

Actually i have created a interanl table for the output in the format of rtab_alv and after that i had created another internal table as iznew1 in which i had transfered all the values of a database view into that internal table iznew1 after that while i was trying to move the values of iznew1 to rtab_alv its not accepting it was showing an error as

rtab_alv and iznew1 are not mutually convertible in a unicode program so can u explain me what is the possible error in this and how to resolve it

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 09:44:13 GMT

plz can u explain me the possible solution

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 10:27:01 GMT

Please check the definition of both the internal table rtab_alv and iznew1..Or can you please paste the structure of both.

Regards

Anurag

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 10:34:26 GMT

This is for iznew1

DATA: IZNEW1 TYPE VECTOR,

RTAB_ALV LIKE IZNEW1 WITH HEADER LINE,
ED1 LIKE IZNEW1,

JTAB LIKE IZNEW1 WITH HEADER LINE.

and this is for rtab_alv

DATA:BEGIN OF RTAB_ALV OCCURS 30,

LIFNR LIKE EKKO-LIFNR,

EBELN LIKE EKKO-EBELN,

VGABE LIKE EKBE-VGABE,

EBELP LIKE EKBE-EBELP,

BELNR LIKE EKBE-BELNR,

MATNR LIKE EKPO-MATNR,

TXZ01 LIKE EKPO-TXZ01,

PS_PSP_PNR LIKE EKKN-PS_PSP_PNR,

KOSTL LIKE EKKN-KOSTL,

NAME1 LIKE LFA1-NAME1,

NAME2 LIKE LFA1-NAME2,

WERKS LIKE EKPO-WERKS,

NETWR LIKE EKPO-NETWR,

KNUMV LIKE EKKO-KNUMV,

GJAHR LIKE EKBE-GJAHR,

ED1(10) TYPE N,

END OF RTAB_ALV.

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 11:19:59 GMT

Define your JTAB similar to RTAB_ALV, thereby you would be able to move data between them.

Regards

Anurag

Re: How to insert one internal table into another internal table

Former Member — Wed, 20 Dec 2006 11:27:51 GMT

BUT HERE JTAB IS HAVING VALUES OF IZNEW1 SO I HAVE DECLARED JTAB IN IZNEW1 IT SELF