Regarding data retieval

[sreeramkumar_madisetty]

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]

Hi..

If u left the empty means.

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

Regards

Bala..

[Former Member]

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]

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]

Hi

It's Answered.