Select

[Former Member]

plz let me know why this select query is not picking up the value..

SELECT RRP_TYPE

HEUR_ID

WHATBOM

FIXHZ

FROM /SAPAPO/MATLOC

INTO CORRESPONDING FIELDS OF TABLE I_TABLE

WHERE MATID = I_TABLE_MATID AND

LOCID = I_TABLE_LOCID.

Internal table i_table has a table type /SAPAPO/MATLOC_TAB which in turn has a line type /SAPAPO/MATLOC

Parameters i_table_matid & i_table_locid has a value in debugging mode.

Table /sapapo/matloc has data for this input.

[KalC · Accepted solution]

Hi use this code before using the select statement.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = I_TABLE_MATID

importing

output = I_TABLE_MATID .

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = I_TABLE_LOCID

importing

output = I_TABLE_LOCID.

Hope this helps.

Reward if helpful.

Regards,

Kalyan.

[Former Member]

Help me in this query..

[Former Member]

Conversion exits were not working out..

[Former Member]

Hi,

Try the code with Transaction SE30.

Steps:

1. Call transaction SE30.

2. Go to Tips&Tricks

3. Paste your code there

4. Try executing

Regards,

RM

[Former Member]

One reason could be there is a conversion exit for either MATID or LOCID; in that case your input parameter(s) have to be converted before executing the SELECT.

Regards,

John.

[Former Member]

Probably u shud use Conversion Exits while passing the values into the Query.

Awrd Points if useful

Bhupal