Regarding select query

[Former Member]

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?

[ThomasZloch]

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

Yes, if there is any...

[former_member230674]

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.

by

Prasad G.V.K

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

[Former Member]

Hi,

If vbeln is blank then definitely it will be fetched.

Cheers!!

Balu

[Former Member]

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

Rob

[Former Member]

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

[Former Member]

>

> 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