validation

[Former Member]

SELECT SINGLE charg FROM mcha INTO l_charg

WHERE charg IN s_charg.

regarding this when i am validating the statement it accepting only low value but not high value any suggestions for this

[anversha_s]

hi,

u r selecting only

 single

try this.

SELECT charg FROM mcha INTO  TABLE itab
WHERE charg IN s_charg.

rgds

Anver

[Former Member]

since you are using the select option.

so always use the Select charg up to 1 rows from mcha into l_charg where charg in s_charg

endselect.

Message was edited by:

Lakshmi Sekhar Reddy

[Former Member]

Hi ,

You are only selecting single value from MCHA table into variable l_charg. So you are getting only low value.

Just use the following syntax.

SELECT SINGLE charg FROM mcha INTO table l_charg

WHERE charg IN s_charg.

Regards,

Chetan.

PS:Reward points if this is helpful.

[Former Member]

can i use variable instead of internal table

[Former Member]

If you use the variable.

The better practice is for select options

select charg up to 1 rows from MCHB into l_charg where charg in s_charg

endselect.

If you want all the values for the select option

Use the internal table

select charg from MCHB into table it_mchb where charg in s_charg.

[former_member404244]

Hi,

change the select statement.

select charg from mcha into table itab

where charg in s_charg.

Regards,

nagaraj

[Former Member]

Hi,

Since you are using the addition SINGLE , it fetches only a single record and it uses the value that is present in the Low field..

To correct the statement remove the single addition in your select statement.

Hope this answers your question.

Cheers

[Former Member]

Hi,

Try this.

IF s_charg[] IS NOT INITIAL.

SELECT charge

FROM mcha

UP TO 1 ROWS

INTO l_charg

WHERE charg IN s_charg.

ENDSELECT.