row removal

[Former Member]

I have a report which shows the result of a audit .It have several items and material doc num , date, line item..ect.

Now if certain items dosent have a material document number , I want to remove those particular rows from the output, or else its taking in the value from the previos mat doc num and printing it beneath other items which dosent have a material document number.How do I eliminate those items which dosent have a material docu numer.

plant sloc mat doc num.

phy inv doc.

material

diff amt

diff qt.

123

ct

490000938

100000293

1000

23.56

10

123

ct

100000293

1000

23.56

10

123

ct

100000293

1000

23.56

10

123

ct

490000938

100000293

1000

23.56

10

123

ct

490000938

100000293

1000

23.56

10

Above is an example . I wnat to remove the rows 2nd and 3rd and any other which dosent have a mat doc num , as it still takes the diff amt of the above mat doc num and prins it .Kindly suggest how to eliminate those rows which dosent have mat doc num .

Thanks

[Former Member · Accepted solution]

Hi,

If this is your own infoset query then you can add simple coding to Record processing block. Go to SQ02, enter infoset designer in edit mode, press "Extras" in toolbar, then select "Code" tab, and there choose "Record processing" in Coding section listbox. In the code editor enter some check, e.g.CHECK NOT <material doc number> IS INITIAL.

Should work. This should eliminate records without material doc number.

[former_member156446]

Hi chak

Make a practice when you right the code to clear the work area or the header line, once appended or moved.

loop at lt_output.
delete lt_output where mat doc num is initial.
endloop.

Award points if helpful.