topic Re: Select statement not working in Application Development and Automation Discussions

Select statement not working

Former Member — Tue, 28 Feb 2012 12:37:17 GMT

Hi All,

We are facing an issue while performing a fetch from one our Z table.

We have several fields like Mantr , matkl ..etc with this we have one field for check box having values 'X' or ' '..But we are not getting the records,it is givng subrc = 4.

SELECT * INTO TABLE gt_yabc  FROM yuudf  WHERE gid = p_id
                                 AND vstel  = p_vstel
*                                AND aedat IN s_aedat
*                                AND aedat NE '00000000'
                                 AND statdat IN s_stadat
                                 AND statdat NE '00000000'
                                 AND confflag = p_confl
                                 AND ( status EQ 'A'
                                     or status EQ 'R' )
                                 AND delflag = ' ' 
                                 AND matnr IN p_matnr
                                 AND EU_STOR_REL =  ''.( problem is here)

they are several records having EU_STOR_REL as empty, but we are not getting records from above query , if we remove last condition ie EU_STOR_REL = ''. then records are getting selected.

Can anyone help on this.

Regards

Re: Select statement not working

Former Member — Tue, 28 Feb 2012 12:42:15 GMT

Hi,

Instead of trying like this AND EU_STOR_REL = ''.

try like this EU_STOR_REL IS INITIAL.

It should work. Otherwise please revert the problem.

Thanks and regards.

Aswath.

Re: Select statement not working

former_member189779 — Tue, 28 Feb 2012 12:50:09 GMT

Another way

remove AND EU_STOR_REL = ''.( problem is here)

After selection delete table ...where EU_STOR_REL = ' '

Re: Select statement not working

ThomasZloch — Tue, 28 Feb 2012 12:54:20 GMT

I assume that column EU_STOR_REL was added later to the existing table and now has NULL values in the existing rows as opposed to initial values.

If this is the case, you can try checking the "initial values" flag for the field in SE11, transport again and adjust the table via SE14 (if not done automatically by the import).

Thomas

Re: Select statement not working

Former Member — Wed, 29 Feb 2012 09:56:59 GMT

Hi Tomas ,

Yes your guess is 100% correct , we have to check the "Initial Value" check box in SE11 , the issue has been solved and points also awarded ..

Thanks a lot for valuable help.

Regards