topic Re: data in itab in Application Development and Automation Discussions

data in itab

Former Member — Tue, 06 Jun 2006 11:47:58 GMT

i have itab .

in the itab i have field P.order for all order i have number of material.

i made

loop at itab.

select matnr

from mara

where ebeln = itab-ebeln (for example only)

endloop.

i have 1 row and now i will get more rows how i do it?

how i select the matirel for all p.order

and show it in alv.

example:

order material

1 222222

33333

55555

2 33333

4444

Re: data in itab

Former Member — Tue, 06 Jun 2006 11:50:46 GMT

hi Liat,

Use for all entries statement in select statement..

i.e, select .... for all entries in ITAB1..

Regards,

Santosh

Re: data in itab

Former Member — Tue, 06 Jun 2006 11:52:10 GMT

Hi,

You can use

select matnr from mara

for all entries in itab

into corresponding fields of table itab2

where ebeln = itab-ebeln.

instead of

loop at itab.

select matnr from mara

into table itab2

where ebeln = itab-ebeln.

endloop.

then use FM reuse_alv_list_display to display itab2 in alv.

Re: data in itab

Manohar2u — Tue, 06 Jun 2006 11:52:27 GMT

If I understand correctly, you need to use

select statement with for all entries.

Regds

Manohar

Re: data in itab

Former Member — Tue, 06 Jun 2006 11:53:39 GMT

hi,

just use

select matnr

from mara

into table lit_mara

for all entries in itab

where ebeln = itab-ebeln.

then u can merge both the table data in to 3rd table .

loop itab.

loop lit_mara where itab-ebeln.

itab3-field1 = itab-field1.

itab3-field1 = itab-field2.

itab3-field1 = lit_mara-field1.

itab3-field1 = lit_mara-field2.

...................

append itab3.

endloop.

pass it to the alv.

this is what u want.

Message was edited by: Manoj Gupta

Re: data in itab

Former Member — Tue, 06 Jun 2006 11:54:16 GMT

use select f1 f2 f3 ..

from mara

into corresponding fields of itab_new

for all entries in itab

where field = itab-field.

Re: data in itab

Former Member — Tue, 06 Jun 2006 11:56:16 GMT

Hi Liat,

Using select statement within a Loop statement may cause Performance issues..Better avoid using it.

If you are not using a small database, go for FOR ALL ENTRIES...

For eg:

select CARRID FROM SPFLI INTO TABLE ITAB.

select FLDATE PRICE FROM SFLIGHT INTO OTAB FOR ALL ENTRIES IN ITAB WHERE CARRID = ITAB-CARRID.

Regards,

SP.

Re: data in itab

Former Member — Tue, 06 Jun 2006 11:57:48 GMT

if i understand

you say i ned to make 2 itabs

and how i merge between them

Re: data in itab

Former Member — Tue, 06 Jun 2006 11:59:34 GMT

hi liat,

YES U NEED 2 ITABS

u can give

select matnr from mara

for all entries in itab into table itab1

where ebeln = itab-ebeln.

and itab1 is

data:begin of itab occurs with header line,

matnr like mara-matnr,

end of itab.

in ur code u didnot give into itab... so u r fetching only one record.

OR GIVE

loop at itab.

select matnr

from mara

INTO TABLE ITAB1

FOR ALL ENTRIES IN ITAB

where ebeln = itab-ebeln (for example only)

endloop.

HOPE THIS HELPS,

PRIYA.

Message was edited by: Priya