05-13-2010 10:07 AM
Hi Folks,
I have a requirement. In the output of the Form of a delivery prsently example 5 line items are printing:
POSNR MATNR Quantity
10 A X
20 B X
90001 C X
90002 D X
Now business wants whenever POSNR with 900001 , 900002 etc. is there in the delivery then they dont want the same in OP of the form printing.
Please suggest how to filter the same.
05-13-2010 10:23 AM
Hi,
I already faced a similar problem, In my case - It was batch Split.
I think, you are fetching Item no. from LIPS table.
Take Item no from Invoice table - VBRP or SO - VBRP.
05-13-2010 10:34 AM
Hi,
Once you have them in the internal table,
Just delete them using--
DELETE itab WHERE POSNR = '900001' and POSNR = '900002'.
Regards,
Sumit
05-13-2010 10:50 AM
Thanks for the reply. But I dont want to delete the data starting from 900001... etc in Internal table... I want something where I can restrict it as 90000* where '*' will be from 1 to 99999.
Please help!!!
05-13-2010 10:50 AM
maybe
DELETE itab WHERE posnr BETWEEN '1' AND '9000000'...
Edited by: Gabriele Montori on May 13, 2010 11:53 AM
05-13-2010 11:26 AM
Hi Vishal,
No need to delete the record from internal table put the WHERE condition in DATA tab of your TABLE.
POSNR < (Less than) 90001
POSNR > (Greater than) 99999.
So your loop will restrict for the record where POSNR is in between this range.
Regards
Dillip
Edited by: Dillip Kumar Sahoo on May 13, 2010 4:10 PM
05-14-2010 5:50 AM
05-14-2010 9:46 AM
Still waiting for the test results. Once the same will be there will update the same.
06-19-2010 5:21 AM
Hi Vishal,
Have you got the out put according to your reqierment.
If the issue is solved, close the thread..
Regards
DKS
01-07-2011 1:49 PM