topic Getting values based on where condition for space in Application Development and Automation Discussions

Getting values based on where condition for space

Former Member — Wed, 27 Apr 2016 09:44:25 GMT

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.

Re: Getting values based on where condition for space

pranay570708 — Wed, 27 Apr 2016 09:48:28 GMT

use EXTENDED_SORT <> 'X'.

Re: Getting values based on where condition for space

Former Member — Wed, 27 Apr 2016 09:50:28 GMT

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

Re: Getting values based on where condition for space

pranay570708 — Wed, 27 Apr 2016 09:53:45 GMT

have you tried EXTENDED_SORT is NULL?

Re: Getting values based on where condition for space

Ashg1402 — Wed, 27 Apr 2016 09:55:53 GMT

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

Re: Getting values based on where condition for space

Former Member — Wed, 27 Apr 2016 10:34:24 GMT

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.

Re: Getting values based on where condition for space

Former Member — Wed, 27 Apr 2016 13:31:12 GMT

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 ' '.

Re: Getting values based on where condition for space

Former Member — Wed, 27 Apr 2016 14:05:12 GMT

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

Re: Getting values based on where condition for space

nikhil_kalawade — Wed, 27 Apr 2016 14:22:53 GMT

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

Re: Getting values based on where condition for space

VenkatRamesh_V — Wed, 27 Apr 2016 17:33:33 GMT

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.

Re: Getting values based on where condition for space

Former Member — Thu, 28 Apr 2016 07:15:04 GMT

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

Re: Getting values based on where condition for space

former_member653066 — Thu, 28 Apr 2016 09:19:33 GMT

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 = ' '.