topic Re: SELECT statement and WHERE condition in Application Development and Automation Discussions

SELECT statement and WHERE condition

Former Member — Fri, 20 Jun 2008 09:09:34 GMT

Hi,

I need to select in VBAK where LIFSK = VA or empty.

SELECT vbeln FROM vbak

INTO CORRESPONDING FIELDS OF TABLE gt_item

WHERE auart IN s_auart AND

vkorg EQ p_vkorg AND

( lifsk EQ gc_lifsk OR

lifsk IS NULL ) AND

augru EQ p_augru.

But it comes out as sy-subrc =4.

Or there are several lines with field lifsk empty in table VBAK but no VA.

If I don't put lifsk conditions then it's working.

Can you tell me how to select properly when LIFSK is empty or = VA?

Tarick.

Re: SELECT statement and WHERE condition

ThomasZloch — Fri, 20 Jun 2008 09:12:49 GMT

wrong answer, stick with those below

Re: SELECT statement and WHERE condition

Former Member — Fri, 20 Jun 2008 09:13:00 GMT

Hi,

try using lifsk = gc_lifsk or lifsk = space.

Regards,

Himanshu

Re: SELECT statement and WHERE condition

christine_evans — Fri, 20 Jun 2008 09:14:10 GMT

Blank values in SAP tables are not always nulls; usually they have been defaulted to SPACE which is a string made up of white spaces which is not the same as null....try it with SPACE