Query deleting current processing record that doesn't meet a critiera.

Hello Query guru’s

I’m trying to delete the current processing record during the “record processing” phase of the SAP query.

My query starts as a simple three table join, then during the record processing coding section I added some ABAP code to perform a simple select statement of a four table. I sum up a field out of the fourth table and store it in a predefined additional field.

This all works great, now the hard part.

Now if the total in the predefined field does not equal X (say 1000) I want to delete the current processing record so it does not get printed out.

I’ve tried adding code to the “END-OF-SELECTION” (after List) where I delete %G00, but the I receive an error message saying %G00 is unknown.

Sorry Rob and Anji I must have hit enter before finishing the post.

Best Regard

John Huyghebaert

Message was edited by:

John Huyghebaert

Message was edited by:

John Huyghebaert