topic Re: problem with repeated quantity in Application Development and Automation Discussions

problem with repeated quantity

Former Member — Thu, 26 Feb 2009 08:34:21 GMT

hi,

vendor materialno quantity receivedmaterial excess

(stpo-idnrk)

ROHV SUBFERT 150 SUBSCRAP 10

ROHV SUBFERT 150 SCRAP1 15

ROHV BATCHFINISH 200 SCRAP2 25

In the first two rows from the output,vendor-materialno-quantity are same except received material.

Excess is calculate with the difference between some other fields.In my thing I want 150 to come

only one time.If i clear that 150 while getting from selection,that excess calculation is not happening.

how to clear that 150.

loop at it_final.

write : / it_final-lifnr,it_final-matnr,it_final-menge,it_final-idnrk,it_final-excess.

endloop.

This is my internal table format.I am doing it in alv.

Regards,

Bathri..

Re: problem with repeated quantity

Former Member — Thu, 26 Feb 2009 08:38:32 GMT

Hi Bathri,

You can use where cluase in your loop statement like

loop at itab where w_num = 150.

something like this or You can delete adjacent duplicates.

For that first SORT the table and use delete adjacent duplicates.

Much Regards,

Amuktha.

Re: problem with repeated quantity

Former Member — Thu, 26 Feb 2009 08:40:18 GMT

Your question was bit confusing, you dont want to print 150 or you want to skip the second record.

If you want to skip the second records use at new quantity so that a unique record will come, if you dont want to print 150 again keep the write statement in at new in the loop which you are doing for the output.

Re: problem with repeated quantity

Former Member — Thu, 26 Feb 2009 08:43:47 GMT

Dear,

first sort your internal table on the basis of first three fields as u mentioned.

then use

delete adjacent duplicates comparing lifnr matnr menge.

your problem will be solved

regards

vijay

Re: problem with repeated quantity

Former Member — Thu, 26 Feb 2009 08:44:43 GMT

Hi,

I dont want to skip.In the second 150 i need 0.000.

Re: problem with repeated quantity

Former Member — Thu, 26 Feb 2009 09:29:12 GMT

in my case can any one tell about (at new matnr) move quantity to display.else move '0' to quantity.

how to write.

Re: problem with repeated quantity

Former Member — Fri, 06 Mar 2009 05:31:59 GMT

closed