topic Re: Select query for char data type in Application Development and Automation Discussions

Select query for char data type

Former Member — Tue, 01 Feb 2011 09:13:20 GMT

Hi Gurus,

I am trying to fetch records from Z table.

Below the select query.

lv_low = '0900001'

lv_high = '0900002'

select matnr sernr into table lt_sernr

from zsd_upd_deldoc

where sernr >= lv_low and sernr <= lv_high.

but out put shows

9000010

9000011

900002

900001

9000010

9000019

9000018

9000017

9000014

9000018

9000017

Expecting O/P

900001

900002

Regards

Vinayak Sapkal

Re: Select query for char data type

Former Member — Tue, 01 Feb 2011 09:14:45 GMT

table zsd_upd_deldoc-sernr length is 18.

Regards

Vinayak Sapkal

Re: Select query for char data type

Former Member — Tue, 01 Feb 2011 09:17:16 GMT

hi,

Try to use the IN operator instead.

Re: Select query for char data type

Former Member — Tue, 01 Feb 2011 09:19:20 GMT

I tried with select-options and IN, but it shows similar result.

Regards

Vinayak Sapkal

Re: Select query for char data type

Former Member — Tue, 01 Feb 2011 09:23:04 GMT

hi, try like this

select matnr sernr into table lt_sernr

from zsd_upd_deldoc

where sernr in ('9000','9001').

select option mean all the values between low n high.

n previously also you were trying BETWEEN AND operator.

Re: Select query for char data type

Former Member — Tue, 01 Feb 2011 09:27:09 GMT

tables: zsd_upd_deldoc.

data: begin of lt_table occurs 0,

sign(1),

option(2),

low(18),

high(18),

end of lt_table.

DATA: ls_doc_id_range LIKE LINE OF lt_table.

FIELD-SYMBOLS: <fs> LIKE LINE OF lt_table.

ls_doc_id_range-sign = 'I'.

ls_doc_id_range-option = 'BT'.

ls_doc_id_range-low = lv_low.

ls_doc_id_range-high = lv_high.

INSERT ls_doc_id_range INTO TABLE lt_table.

select matnr sernr into table lt_sernr
from zsd_upd_deldoc
where sernr >= lv_low and sernr <= lv_high.

select matnr sernr into table lt_sernr

from zsd_upd_deldoc

where sernr in lt_table.

loop at lt_sernr assigning <fs_sernr>.

write: / <fs_sernr>-sernr.

endloop.

O/P

9000010

9000011

900002

900001

9000010

9000019

9000018

9000017

9000014

9000018

9000017

Regards

Vinayak Sapkal

Re: Select query for char data type

Former Member — Tue, 01 Feb 2011 09:40:43 GMT

Hi,

Try to do like below and try with the same code.

ls_doc_id_range-option = 'EQ'.

Regards,

Sreenivas.

Re: Select query for char data type

Former Member — Tue, 01 Feb 2011 09:43:53 GMT

Not succeed ...result shows as below.

O/P

900001

Regards

Vinayak Sapkal

Re: Select query for char data type

kesavadas_thekkillath — Tue, 01 Feb 2011 11:26:46 GMT

This is same as this question which i had some time ago

Re: Select query for char data type

Former Member — Tue, 01 Feb 2011 12:04:09 GMT

Database field sernr is type of gernr(Char-18).

If i use numc it will not search record '0900001' it will searches for '000000000000900001'

Regards

Vinayak Sapkal

Re: Select query for char data type

kesavadas_thekkillath — Tue, 01 Feb 2011 12:09:29 GMT

As mentioned by Mark in my thread, type c will create such problems when it access the data via querying ( <,> etc ).

Re: Select query for char data type

Former Member — Tue, 01 Feb 2011 12:35:31 GMT

Hi,

define the low and high variables with reference to the Z table and pass the values into that. Also check the data base table for how the values have been stored into that. Accordingly write your select query. If you have any conversion routines for that variable use that conversion FM before passing the values to that variables.

Thanks,

Sreeni.

Re: Select query for char data type

Former Member — Wed, 02 Feb 2011 09:18:42 GMT

Hi Vinayak,

Make lv_low and lv_high of type zsd_upd_deldoc-sernr as given below :

DATA : lv_low TYPE zsd_upd_deldoc-sernr,

lv_high TYPE zsd_upd_deldoc-sernr.

As sernr is of NUMC type you can assign numbers or char string to it.

lv_low = 900001.

lv_high = 900002.

Now write a select query

select matnr sernr into table lt_sernr

from zsd_upd_deldoc

where sernr >= lv_low and sernr <= lv_high.

Regards,

Pranjali

Re: Select query for char data type

Former Member — Wed, 02 Feb 2011 09:33:30 GMT

still shows result as given below.

O/P

9000010

9000011

900002

900001

9000010

9000019

9000018

9000017

9000014

9000018

9000017

Regards

Vinayak Sapkal