topic Re: Select Query problem in Application Development and Automation Discussions

Select Query problem

Former Member — Mon, 01 Oct 2007 04:29:36 GMT

Hi,

I am using,

SELECT SINGLE * FROM ska1 WHERE

ktopl = 'TIPF'

AND saknr = gs_line_item-newko.

IF sy-subrc = 0.

...

endif.

here sy subrc always gives 4. But when i check from databse....the particular entry is present.

Re: Select Query problem

Former Member — Mon, 01 Oct 2007 04:31:21 GMT

Hi Anurodh,

It can't happen.

There must be some wrong in the data you provided.

Just hard code the value of SAKNR also and try.

Regards,

Atish

Re: Select Query problem

Former Member — Mon, 01 Oct 2007 04:32:15 GMT

if not gs_line_item is initial.

SELECT SINGLE * FROM ska1

for all entries in gs_line_item

WHERE

ktopl = 'TIPF'

AND saknr = gs_line_item-newko.

endif.

Re: Select Query problem

former_member189629 — Mon, 01 Oct 2007 04:33:20 GMT

Anu,

Try this...

READ TABLE gs_line_item." WITH KEY newko = specify key if needed

if sy-subrc = 0.

SELECT SINGLE * FROM ska1 WHERE

ktopl = 'TIPF'

AND saknr = gs_line_item-newko.

IF sy-subrc = 0.

...

endif.

reward if helpful,

Karthik

Re: Select Query problem

Former Member — Mon, 01 Oct 2007 04:33:43 GMT

i have done that also...but no change....still sy-subrc = 0.

my saknr is 30010.

Re: Select Query problem

former_member189629 — Mon, 01 Oct 2007 04:35:51 GMT

have u done the READ or FOR ALL ENTRIES?

Re: Select Query problem

Former Member — Mon, 01 Oct 2007 04:37:24 GMT

Hi,

Use SAKNR as '0000030010'.

Regards,

Atish

Re: Select Query problem

Former Member — Mon, 01 Oct 2007 04:37:58 GMT

thanks atish...its done.

Re: Select Query problem

Former Member — Mon, 01 Oct 2007 04:38:44 GMT

Hi,

You need to use FM 'CONVERSION_EXIT_ALPHA_INPUT'.

Pass the SAKNR as importing as well as exporting parameter to this FM.

Then use that in your select query.

Regards,

Atish

Re: Select Query problem

Former Member — Mon, 01 Oct 2007 04:40:10 GMT

Hi,

Just UNPACK the value of saknr before select,

i.e. UNPACK gs_line_item-newko INTO gs_line_item-newko.

Since saknr is of length 10, your value of saknr should be of length 10 during selection.

UNPACK would fill leading spaces with zero.

Regards,

Raghavendra