Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

where char field is empty ??

Former Member
0 Likes
2,082

Hello !

How can I ask for:

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

EKPO-LOEKZ is a char field.

regards

erdem

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,400

Hi,


WHERE LOEKZ NE 'X'

or


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

Hi,


WHERE LOEKZ NE 'X'

or


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

4 REPLIES 4
Read only

Former Member
0 Likes
1,401

Hi,


WHERE LOEKZ NE 'X'

or


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

Read only

dev_parbutteea
Active Contributor
0 Likes
1,400

Hi,

where EKPO-LOEKZ = space

Regards.

Read only

Former Member
0 Likes
1,400

hi,

WHERE EKPO-LOEKZ is initial.

    • reward if useful**

Read only

Former Member
0 Likes
1,400

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.

OR

where EKPO-LOEKZ = ' '.

Both will work.

plz reward if useful.

Thanks.