topic Re: Query in Smartform in Application Development and Automation Discussions

Query in Smartform

Former Member — Thu, 13 May 2010 09:07:45 GMT

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.

Re: Query in Smartform

Former Member — Thu, 13 May 2010 09:23:48 GMT

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.

Re: Query in Smartform

Former Member — Thu, 13 May 2010 09:34:22 GMT

Hi,

Once you have them in the internal table,

Just delete them using--

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

Regards,

Sumit

Re: Query in Smartform

Former Member — Thu, 13 May 2010 09:50:36 GMT

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

Re: Query in Smartform

Former Member — Thu, 13 May 2010 09:50:38 GMT

maybe

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

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

Re: Query in Smartform

Former Member — Thu, 13 May 2010 10:26:58 GMT

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

Re: Query in Smartform

Former Member — Fri, 14 May 2010 04:50:26 GMT

Is your issue solved?

Re: Query in Smartform

Former Member — Fri, 14 May 2010 08:46:26 GMT

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

Re: Query in Smartform

Former Member — Sat, 19 Jun 2010 04:21:30 GMT

Hi Vishal,

Have you got the out put according to your reqierment.

If the issue is solved, close the thread..

Regards

DKS

Re: Query in Smartform

Former Member — Fri, 07 Jan 2011 13:49:43 GMT

This message was moderated.