topic Re: PARAMETER? in Application Development and Automation Discussions

PARAMETER?

Former Member — Wed, 05 Sep 2007 13:25:13 GMT

Hi all,

I have a parameter in selection-screen..i.e,,P_CDATE...it is optional.

I have to fetch some data from MARA based on this field.

SELECT MATNR

ERSDA

AENAM

FROM MARA INTO TABLE INT_OUTTAB

WHERE ERSDA EQ P_CDATE.

If P_CDATE is initial....i am not getting the entire data...based on this condition.

can any one help me regarding this....

vkr.

Former Member — Wed, 05 Sep 2007 13:27:48 GMT

HI vkr,

1. Instead of parameter,

<b>use SELECT OPTION.</b>

2. And also use IN inside the query (instead of 😃

WHERE ERSDA IN P_CDATE

3. Then it will get all data, even if the field (select option)

is blank.

regards,

amit m.

Former Member — Wed, 05 Sep 2007 13:29:17 GMT

use select-option instead of parameter... if parameter is initial u wont get the data

Thanks

Former Member — Wed, 05 Sep 2007 13:30:37 GMT

Hi VKR,

With

PARAMETERS

in WHERE condition we dont get all entries.

Only with

SELECT-OPTIONS

in WHERE condition we get all entries even if it is initial.

WHERE ERSDA IN s_date.

<b>Reward points for helpful answers</b>.

Best Regards,

Ram.