topic Re: validation in Application Development and Automation Discussions

validation

Former Member — Tue, 28 Nov 2006 09:17:14 GMT

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

Re: validation

anversha_s — Tue, 28 Nov 2006 09:18:40 GMT

hi,

u r selecting only

 single

try this.

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

rgds

Anver

Re: validation

Former Member — Tue, 28 Nov 2006 09:20:45 GMT

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

Re: validation

Former Member — Tue, 28 Nov 2006 09:21:06 GMT

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.

Re: validation

Former Member — Tue, 28 Nov 2006 09:23:11 GMT

can i use variable instead of internal table

Re: validation

former_member404244 — Tue, 28 Nov 2006 09:23:24 GMT

Hi,

change the select statement.

select charg from mcha into table itab

where charg in s_charg.

Regards,

nagaraj

Re: validation

Former Member — Tue, 28 Nov 2006 09:23:38 GMT

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

Re: validation

Former Member — Tue, 28 Nov 2006 09:32:35 GMT

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.

Re: validation

Former Member — Tue, 28 Nov 2006 09:48:19 GMT

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.