topic Re: Selection Screen in Application Development and Automation Discussions

Selection Screen

Former Member — Mon, 14 Jan 2013 11:34:49 GMT

Hi,

Following query runs based selection screen. When we do not enter single value S_AUFNR which has to pull based on s_date wise or including S_Aufnr wise. We have an option like radio-button.. is there any option to do?

SELECT ap~dwerk
             ak~aufnr
            ak~plnbez
            ak~gamng
            ak~gltri
            ak~aufld
    INTO CORRESPONDING FIELDS OF TABLE gt_afko
    FROM afko AS ak INNER JOIN
         afpo AS ap
    ON ak~aufnr EQ ap~aufnr
    WHERE ap~dwerk EQ p_dwerk

AND ak~gltri IN s_gltri "Date

AND ak~aufnr EQ s_aufnr "Single value

regards

Shree

Re: Selection Screen

former_member491621 — Mon, 14 Jan 2013 11:38:01 GMT

Hi Shree,

just change the code as below

AND ak~aufnr IN s_aufnr.

It will work for single value also.

Re: Selection Screen

former_member391265 — Mon, 14 Jan 2013 11:38:43 GMT

can you please clearly tell your problem, What exactly you want to do?

Re: Selection Screen

Former Member — Mon, 14 Jan 2013 11:38:45 GMT

Hi, try with ak~aufnr EQ s_aufnr-LOW ?

Re: Selection Screen

Former Member — Mon, 14 Jan 2013 11:39:59 GMT

Hi, No you mean..Multiple selection values..I need single where we can use EQ symbol only...

Re: Selection Screen

former_member491621 — Mon, 14 Jan 2013 11:41:26 GMT

the you can use

AND ak~aufnr EQ s_aufnr-low.

why don;t you use parameter instead?

and even if you enter single value in select-options, the system automatically takes oonly single value.

Re: Selection Screen

Former Member — Mon, 14 Jan 2013 11:44:00 GMT

yes, Used Parameter

Re: Selection Screen

Former Member — Mon, 14 Jan 2013 11:45:54 GMT

Hi,

If you ignore the parameter which has to pull value based on S_DATE or if you use the S_aufnr based single value with date wise...Thanks

Re: Selection Screen

former_member491621 — Mon, 14 Jan 2013 11:46:26 GMT

Hi Shree,

If you could please close the thread and change it to answered

Re: Selection Screen

former_member391265 — Mon, 14 Jan 2013 11:48:18 GMT

Try using this if you want select options and restrict to one box

SELECT-OPTIONS : s_aufnr FOR aufk-aufnr NO INTERVALS

Re: Selection Screen

Former Member — Mon, 14 Jan 2013 11:49:47 GMT

Hi Shree,

Use IN insted of EQ in below code:

AND ak~aufnr EQ s_aufnr "Single value

AND ak~aufnr IN s_aufnr " Single Value

Re: Selection Screen

Former Member — Mon, 14 Jan 2013 11:53:18 GMT

When i ignore the parameter S_AUFNR...Need result based on S_date wise then you would get multiple AUFNR values on output...When you use S_AUFNR only single value

Re: Selection Screen

former_member491621 — Mon, 14 Jan 2013 11:56:49 GMT

Can you please clarify more?

Using the code below suffices all the requirements, whether you give single value,a range or ignore it, the below code works

AND ak~aufnr EQ s_aufnr

Why don;t you use the below code and debug to see

Re: Selection Screen

former_member195270 — Mon, 14 Jan 2013 11:58:23 GMT

Hi Shree,

if you want that your code should work for single and multiple order then use following code.

TABLES afko.

data gt_afko TYPE STANDARD TABLE OF afko.

PARAMETERS p_dwerk TYPE dwerk.

SELECT-OPTIONS: s_gltri for afko-gltri,

                s_aufnr for afko-aufnr.

IF lines( s_aufnr[] ) EQ 1 AND s_aufnr-high is INITIAL.

SELECT ap~dwerk

             ak~aufnr

            ak~plnbez

            ak~gamng

            ak~gltri

            ak~aufld

    INTO CORRESPONDING FIELDS OF TABLE gt_afko

    FROM afko AS ak INNER JOIN

         afpo AS ap

    ON ak~aufnr EQ ap~aufnr

    WHERE ap~dwerk EQ p_dwerk

    AND ak~gltri IN s_gltri "Date

    AND ak~aufnr EQ s_aufnr-low. "Single value

else.

SELECT ap~dwerk

             ak~aufnr

            ak~plnbez

            ak~gamng

            ak~gltri

            ak~aufld

    INTO CORRESPONDING FIELDS OF TABLE gt_afko

    FROM afko AS ak INNER JOIN

         afpo AS ap

    ON ak~aufnr EQ ap~aufnr

    WHERE ap~dwerk EQ p_dwerk

    AND ak~gltri IN s_gltri "Date

    AND ak~aufnr EQ s_aufnr.

endif.

Re: Selection Screen

former_member491621 — Mon, 14 Jan 2013 11:59:28 GMT

Hi Umar,

I don't think using EQ works in case of select-options

Re: Selection Screen

former_member195270 — Mon, 14 Jan 2013 12:01:16 GMT

Use as below.Now it will work.

Re: Selection Screen

former_member491621 — Mon, 14 Jan 2013 12:01:48 GMT

When we use select-options in a query and a single value is entered on the selection screen, the system automatically changes the value of S_XXXX-LOW to IEQ<value>. We don't have to do anything except using it as normal select-options

Re: Selection Screen

Former Member — Mon, 14 Jan 2013 12:03:44 GMT

Every one of their aspect is right...But ketan bhajni is right...We can use no intervals, it would satisfy both condition... thank you all..

Re: Selection Screen

former_member491621 — Mon, 14 Jan 2013 12:05:06 GMT

You could have declared it as parameter rather than select-options if you wanted single value

Re: Selection Screen

Former Member — Mon, 14 Jan 2013 12:08:11 GMT

Hi aniket,

I declared parameter only but when i leave the input values then it has to satisfy s_date wise...Now i use selection-option no intervals.... you are also right.....