SQL ( IS NULL )

[Former Member]

How Do Everyone.

I have in my ABAP code:

SELECT ....

FROM payr

WHERE .....

AND voidd IS NULL

AND bancd IS NULL

AND .....

Does anybody know how can I replicate the 'IS NULL' part in the select

options when I run the program?

Cheers

Andy

[Former Member]

Hi,

Use voidd = space and bancd = space.

Regards

Subramanian

[Former Member]

try this

AND voidd eq '  '
AND bancd eq '  '
AND .....
or 
AND voidd is initial
AND bancd is initial
AND .....

regards,

vijay

[Former Member]

SELECT ....

FROM payr

WHERE .....

AND voidd IS INITIAL

AND bancd IS INITIAL

AND .....

OR YOU CAN USE

VOIDD = ''.

OR SPACE.

REGARDS

SHIBA DUTTA

[Former Member]

Hi Andy ,

Is your requirement to change the where clause of the select statement at run time and in palce of IS NULL use some other value.

Regards

Arun

[Former Member]

Please check if this what you are looking for:

tables: vbak.

select-options: s_vbeln for vbak-vbeln.

initialization.
  s_vbeln-sign = 'I'.
  s_vbeln-option = 'EQ'.
  s_vbeln-low = space.
  append s_vbeln.

Regards

Eswar

[Former Member]

Many thanks for all your replies.

I think the answer may be :

AND ( voidd = ' ' OR voidd IS NULL )

AND ( bancd = ' ' OR bancd IS NULL )

[Former Member]

I THINK THIS WILL SERVE UR PURPOSE - JUST COPY N PASTE THIS CODE AND TRY IT OUT.

tables payr.

data begin of itab occurs 0.

include structure payr.

data end of itab.

ranges r1 for payr-bancd.

RANGES R2 FOR PAYR-VOIDD.

r1-sign = 'I'.

r1-option = 'EQ'.

APPEND R1.

r2-sign = 'I'.

r2-option = 'EQ'.

APPEND R2.

select * from payr into table itab where bancd IN R1 AND VOIDD IN R2.

if sy-subrc = 0.

loop at itab.

write:/ itab-zbukr.

endloop.

endif.