topic select query in Application Development and Automation Discussions

select query

Former Member — Fri, 18 Jan 2008 08:58:35 GMT

select single matnr

werks

into marc

from marc

where matnr = 'ETEST1'

and werks = '0001'.

Output comes as 1

whereas table contains values as shown, what could be the issue.

Re: select query

JozsefSzikszai — Fri, 18 Jan 2008 09:04:52 GMT

select single matnr

werks

into CORRESPONDING FIELDS OF marc

from marc

where matnr = 'ETEST1'

and werks = '0001'.

Re: select query

former_member404244 — Fri, 18 Jan 2008 09:06:36 GMT

Hi,

use CORRESPONDING FIELDS OF marc

Regards,

Nagaraj

Re: select query

arunkumar_yerram — Fri, 18 Jan 2008 09:20:05 GMT

Hi SV,

This scenario occurs for the following reason.

1. When there is conversion exit for either MATNR or WERKS. To check whether a conversion exit exists for these two, go to the domains for the above two.

To avoid this, do the following.

1. Declare variables for both Matnr & Werks.

2. Call the conversion functions for the above fields. Since there are two, you should be calling the conversion function modules (mostly 'CONVERSION_EXIT_ALPHA_INPUT') for each of them.

3. Pass these values in the where condition of the select query.

This should solve your purpose.

Regards,

Arun