topic Re: select in Application Development and Automation Discussions

select

Former Member — Mon, 16 Jul 2007 09:46:38 GMT

Hi friends,

My selection screen fields are delivery number and item number output contains 4 records but third record contains document type remaining records contains document type as 000.. I need to fetch only third record document type. I wrote the following select query but it is not fetching properly.

Select single doctyp into x_doctyp from dbtable

Where docnum = s_docnum

And itemnumber = s_item num

And doctyp is not null.

Pl tell me the correct syntax.

Thanks.

Re: select

Former Member — Mon, 16 Jul 2007 09:48:32 GMT

Hello,

Change the code like this.


Select single doctyp into x_doctyp from dbtable
Where docnum = s_docnum
And itemnumber = s_item num
And doctyp ne space. " Check Here

Vasanth

Re: select

Former Member — Mon, 16 Jul 2007 09:48:43 GMT

Give the exact value of doc type in where condition.

Select single doctyp into x_doctyp from dbtable

Where docnum = s_docnum

And itemnumber = s_item num

And doctyp <> '0000'.

Reward points for useful Answers

Regards

Anji

Re: select

Former Member — Mon, 16 Jul 2007 09:50:01 GMT

hi,

change

Select single doctyp into x_doctyp from dbtable

Where docnum = s_docnum

And itemnumber = s_item num

And doctyp is not null.

Select single doctyp into x_doctyp from dbtable

Where docnum in s_docnum

And itemnumber in s_item num

And doctyp is not null.

Re: select

Former Member — Mon, 16 Jul 2007 09:51:52 GMT

First of all thanks but if I put space then it will fetch the records having document type 000 also but I don’t want like that I want the record having the document type is greater than zero. If I put 0000 it will take the 00000 record I don’t want like that.

Thanks

Re: select

former_member404244 — Mon, 16 Jul 2007 09:52:40 GMT

Hi,

Try like this

Select single doctyp into x_doctyp from dbtable

Where docnum = s_docnum

And itemnumber = s_item num

And doctyp NE SPACE.

In the above query it will pick only that record whose doctyp is not equal to space,that menas it has value.

regards,

Nagaraj

Re: select

Former Member — Mon, 16 Jul 2007 09:56:53 GMT

You can try like thi s

Select single doctyp into x_doctyp from dbtable
Where docnum = s_docnum
And itemnumber = s_item num
And doctyp is <> ' '.

Reward all helpfull answers

Regards

Pavan

Re: select

Former Member — Mon, 16 Jul 2007 11:03:36 GMT

hi bharat

try this.........

select single doctyp from dbtable into x_doctyp

where docnum = s_docnum and

itemnumber = s_item num and

doctyp = '000'.

reward if useful....!!