topic where char field is empty ?? in Application Development and Automation Discussions

where char field is empty ??

Former Member — Wed, 10 Oct 2007 12:32:32 GMT

Hello !

How can I ask for:

WHERE EKPO-LOEKZ ist empty is not set (unset) .

EKPO-LOEKZ is a char field.

regards

erdem

Former Member — Wed, 10 Oct 2007 12:34:45 GMT

Hi,


WHERE LOEKZ NE 'X'


WHERE LOEKZ EQ ' '

The field can only be ' ' or 'X' if filled by SAP.

Hope this helps (please reward me if it does).

regards, Joerg

dev_parbutteea — Wed, 10 Oct 2007 12:35:57 GMT

Hi,

where EKPO-LOEKZ = space

Regards.

Former Member — Wed, 10 Oct 2007 12:35:59 GMT

hi,

WHERE EKPO-LOEKZ is initial.

Former Member — Wed, 10 Oct 2007 12:39:51 GMT

Hi erdem,

Since in ekpo table ,the data element for ekpo-loekz field is ELOEK , which is char and has length one.

so plz to check whether it is empty use

where EKPO-LOEKZ is intial.

where EKPO-LOEKZ = ' '.

Both will work.

plz reward if useful.

Thanks.