topic Re: Regarding select query in Application Development and Automation Discussions

Regarding select query

Former Member — Wed, 22 Oct 2008 14:52:25 GMT

Hi,

If value in a particular filed is empty ie.,space, then what will be the reselt of the select query?

For example,

SELECT SINGLE vbeln FROM likp INTO w_sto_delivery

WHERE vbeln = v_vbeln_vpobjkey.

in the above query, the field v_vbeln_vpobjkey is become empty during run time. now my question is, if this is the case, all the values of the vbeln from likp will be fetched into w_sto_delivery or the value which is blank in vbeln will be fetched?

Re: Regarding select query

ThomasZloch — Wed, 22 Oct 2008 14:55:04 GMT

> the value which is blank in vbeln will be fetched?

Yes, if there is any...

Re: Regarding select query

Former Member — Wed, 22 Oct 2008 14:56:11 GMT

Hi Subash,

Normally It should fetch all the records if you use only select statement.but, in this case you use select single.so,it retrieve the first record from likp table.

Prasad G.V.K

Edited by: PRASAD GVK on Oct 22, 2008 4:56 PM

Re: Regarding select query

Former Member — Wed, 22 Oct 2008 14:57:54 GMT

Hi,

If vbeln is blank then definitely it will be fetched.

Cheers!!

Balu

Re: Regarding select query

Former Member — Wed, 22 Oct 2008 14:59:48 GMT

Well, I doubt if there are any records in LIKP with VBELN = space, so I doubt if it will pick up any records.

Rob

Re: Regarding select query

Former Member — Wed, 22 Oct 2008 15:17:26 GMT

Hi Rob..my doubt is if any vbeln is blank in likp, only it will be fetched..is it right?

Re: Regarding select query

Former Member — Wed, 22 Oct 2008 15:25:21 GMT


> Hi Rob..my doubt is if any vbeln is blank in likp, only it will be fetched..is it right?

Well that's already been answered. I was just pointing out that this is a pretty remote possibility.

Rob