topic Re: Regarding data retieval in Application Development and Automation Discussions

Regarding data retieval

sreeramkumar_madisetty — Wed, 04 Apr 2007 12:31:20 GMT

Hi dudes

I am facing 1 peculiar problem when date retreving.

I have 1 parameter(p_lifsk) in the selection screen ( Delivery Block).

When i was given some value in the selection-screen i am getting the result properly.

While I was left as empty I am not getting the results properly.

In debugging for p_lifsk space is not recognizing.

Can anyone please suggest me the needful.

Regards,

Sreeram

Former Member — Wed, 04 Apr 2007 12:33:44 GMT

Hi..

If u left the empty means.

It will took all datas what u specified in the select query.

Regards

Bala..

Former Member — Wed, 04 Apr 2007 12:36:18 GMT

Sree,

Change the parameter to a SELECT-OPTIONS

and use an IN statement in your WHERE clause

SELECT * from some_table

where lifsk IN s_lifsk.

You can use some properties of the SELECT-OPTIONS to hide the HIGH value box as well - if you need to.

Former Member — Wed, 04 Apr 2007 12:42:01 GMT

Change the parameter to a SELECT-OPTIONS

Use No INTERVALS, NO EXTENSION to make it equivalent to parameter

Also change the SELECT to have IN instead of EQ while using parameter

SELECT * from some_table

where lifsk IN s_lifsk.

EG:

TABLES: MARA.

SELECT-OPTIONS:

S_MATNR FOR MARA-MATNR NO INTERVALS NO-EXTENSION.

sreeramkumar_madisetty — Wed, 23 May 2007 07:52:38 GMT

It's Answered.