topic Re: Looping problem please help in Application Development and Automation Discussions

Looping problem please help

Former Member — Fri, 08 Feb 2008 07:31:50 GMT

Hello Gurus,

I have a prob please help.

var=mat1.

IQC Material

01 mat1

6030 mat1

100 mat2

04 mat3

if Material field = mat1 then

output should be like this:

var1 = 01, 6030

how do i code this?

thanks!

Re: Looping problem please help

former_member386202 — Fri, 08 Feb 2008 07:35:38 GMT

Hi,

Try like this

Loo at itab.

if ITab-matnr = mat1.

write : /itab-var1.

endif.

endloop.

Regards,

Prashant

Re: Looping problem please help

Former Member — Fri, 08 Feb 2008 07:37:10 GMT

Hi,

Use the VAR1 variable as a string varaible or char variaable..

When ever the condition satisfies u can concatenate them like as follows

here both v_lang and v_lang1 are char(70).

clear : v_lang1 ,v_lang.

loop at it_lang where materail = 'MAT1'.

v_lang1 = itab-<fieldname>

concatenate v_lang1 ',' v_lang into v_lang.

endloop.

REWARD IF USEFUL

Re: Looping problem please help

Former Member — Fri, 08 Feb 2008 07:46:07 GMT

IQC Material

01 mat1

6030 mat1

100 mat2

04 mat3

is in ur itab den

data : var(255) type c,
         matf      type matnr,
         f.

move var to matf.
clear var.

loop at itab where material = matf.
if f <> 'X'.
move itab-material to var.
else.
concatenate var ',' itab-material into var.
endif.
move 'X' to f.
endloop.

Re: Looping problem please help

Former Member — Fri, 08 Feb 2008 08:16:30 GMT

field ITAB is unknown..

Re: Looping problem please help

kesavadas_thekkillath — Fri, 08 Feb 2008 08:43:39 GMT

data:begin of itab occurs 0,

matnr type marc-matnr,

var(50) type c,

end of itab.

consider the above as your itab with matnr as first field.

sort itab by matnr ascending.

data:wk_var(50).

loop at itab.

concatenate wk_var itab-var ',' into wk_var.

condense wk_var.

at end of matnr.

write at 10 itab-matnr.

write:/ 25 wk_var.

clear wk_var.

endat.

If u donot want to wite the value..move it to another itab.

Re: Looping problem please help

Former Member — Sat, 09 Feb 2008 05:37:29 GMT

ok let me revise my question:

example i got the material JPQ11

table is kinda like this:

table: QMAT

Number Material

1020 JPQ11

3040 JPaaa

1090 JPQ11

1970 JP12e

8667 JPttta

Now since there is 2 JPQ11 in field Material, I wanted to get is corresponding field Number

Output should be like this:

1020, 1090

hope everyone understand thanks!

Re: Looping problem please help

Former Member — Sat, 09 Feb 2008 08:33:36 GMT

Hi,

You can try the below code, but it may be bit difficult :

declare itab1 and itab2 similar to itab.

sort itab by material.

loop at itab.

loop at itab1 where itab-matnr.

move : itab1 to itab2.

append itab2.

clear itab2.

endloop.

describe table itab2 lines sy-tfill.

if sy-tfill GE 2.

loop at itab2.

write : / itab2-number.

endloop.

endif.

Refresh itab2.

Clear itab2.

endloop.

Thanks,

Sriram Ponna.

Re: Looping problem please help

Former Member — Mon, 11 Feb 2008 08:19:22 GMT

thank you all!