Getting values based on where condition for space

[Former Member]

Hi everyone,

i have one situation ,

select extended_sort  from zgah into table  it where EXTENDED_SORT = ' '.

here zgah is a table and it is internal table and extended_sort is field in zgah.

In zgah table , extended sort field is having two values X and space ie ' ' . i want all space values but i am not getting

please help me out.

Thank you.

[pranay570708]

use EXTENDED_SORT <> 'X'.

[Former Member]

i have Tried <>,space but still it is not working

[pranay570708]

have you tried EXTENDED_SORT is NULL?

[Ashg1402]

Hi,

    your query is :- select extended_sort  from zgah into table  it where EXTENDED_SORT = ' '.

  This doesn't make any sense you are selecting the value for a field which is not having any value.

Can you post your full query.

Regards

Ashish

[Former Member]

Hi,

Just check if table ZGAH is having data or not? Run the table in SE16 for the same selection criteria and see the table behavior.

[Former Member]

hi,

please check your table and post your full requirement.

however you can try this also if your table does not have lots of data and if it does not affect your performance.

select extended_sort  from zgah into table  it .

delete it where extended_sort ne ' '.

[Former Member]

It's difficult to see what you are trying to do. From what you've said, you will end up with a table with one field and many empty rows.

Rob

[nikhil_kalawade]

Hi,

Let me take you via long way as per two points mentioned by Pranay it should work but anyway; do one thing fetch all data without where condition so you will get 'X' and '<space>' now delete the itab where <field> EQ 'X'.

Hope this will help you.

Regards

Nikhil

[VenkatRamesh_V]

field   extended_sort  is   not   key  field.  fetch   the   data is  internal table.   sort   the  itab  and  delete  itab   by condition.

Hope  it helpful,

Regards,

Venkat.

[Former Member]

What's the used data element / domain for the field? Can you show us the definition? How is the field defined in your table?

[former_member653066]

hi ,

i have pretty answers for this question..

you are selecting nothing from nothing..!

pity.. how can you expect there should be data?

question is logically wrong..!!!

try like this,

select * from zgah into table it where extended_sort = ' '.