Query in Smartform

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi,

Once you have them in the internal table,

Just delete them using--

DELETE itab WHERE POSNR = '900001' and POSNR = '900002'.

Regards,

Sumit

[Former Member]

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!!!

[Former Member]

maybe

DELETE itab WHERE posnr BETWEEN '1' AND  '9000000'...

Edited by: Gabriele Montori on May 13, 2010 11:53 AM

[Former Member]

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

[Former Member]

Is your issue solved?

[Former Member]

Still waiting for the test results. Once the same will be there will update the same.

[Former Member]

Hi Vishal,

Have you got the out put according to your reqierment.

If the issue is solved, close the thread..

Regards

DKS

[Former Member]

This message was moderated.