Skip to Content
author's profile photo Former Member
Former Member

passing values to a select option through submit

hi all,

i am using the following code to submit report.

SUBMIT :rko7co88 USING SELECTION-SET 'ZTEST_PS'

WITH SELECTION-TABLE seltab

WITH perio = v_month

WITH gjahr = v_year

WITH vaart = c_1.

the table seltab is being populated as shown below.

LOOP AT i_aufnr INTO i_aufnr_wa.

seltab_wa-selname = 'AUFNR'.

seltab_wa-sign = 'I'.

seltab_wa-kind = 'S'.

seltab_wa-option = 'EQ'.

seltab_wa-low = i_aufnr_wa-aufnr.

APPEND seltab_wa TO seltab.

CLEAR seltab_wa.

ENDLOOP.

but when i run this program it gives a short dump saying program has excceded the maximum time permited.

the problem seems to be with passing table seltab to select option, because when i run the program witout that statemant "WITH SELECTION-TABLE seltab" . it works fine.

in seltab i have selected only open orders which r confirmed, when i run the program without passing seltab it takes all the orders and works fine but according to my requirement i have to run the program for only open orders.

pls suggest the way out.

thanks

pankaj sharma

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    Posted on Oct 19, 2006 at 11:04 AM

    Try to submit in background.

    Refer the following links:

    submit-a-program-to-execute-in-background

    to-run-a-program-in-background-using-submit

    Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 19, 2006 at 10:59 AM

    hi pankaj,

    chk this sample code.

    *Code used to populate 'select-options' & execute report

    DATA: seltab type table of rsparams,

    seltab_wa like line of seltab.

    seltab_wa-selname = 'PNPPERNR'.

    seltab_wa-sign = 'I'.

    seltab_wa-option = 'EQ'.

    • load each personnel number accessed from the structure into

    • parameters to be used in the report

    loop at pnppernr.

    seltab_wa-low = pnppernr-low.

    append seltab_wa to seltab.

    endloop.

    SUBMIT zreport with selection-table seltab

    via selection-screen.

    rgds

    anver

    if hlpful pls mark points

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 11:01 AM

    Hi

    Can you paste the selection-screen of the prg?

    Regards,

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 19, 2006 at 11:06 AM

    Hi,

    The structure of the internal table you are using seems strange. It is not the structre of the SELECT-OPTIONS. It has only option, low , high and sign components.

    I think you need to change that.

    Regards,

    Sesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 11:16 AM

    Hi pankaj,

    1. I tried the same thing, and now its working fine.

    2. I also used the extension of submit

    <b> via selection-screen.</b>

    to temporarily check what values are going in the screen.

    3. just copy paste to get a taste of it.

    4. Values 11111, 2222 will come in AUFNR.

    5.

    report abc.

    *----


    DATA : SELTAB LIKE RSPARAMS OCCURS 0 WITH HEADER LINE.

    *----


    SELTAB-SELNAME = 'AUFNR'.

    SELTAB-KIND = 'S'.

    SELTAB-SIGN = 'I'.

    SELTAB-OPTION = 'EQ'.

    SELTAB-LOW = '11111'.

    APPEND SELTAB.

    SELTAB-SELNAME = 'AUFNR'.

    SELTAB-KIND = 'S'.

    SELTAB-SIGN = 'I'.

    SELTAB-OPTION = 'EQ'.

    SELTAB-LOW = '222222'.

    APPEND SELTAB.

    *----


    submit RKO7CO88

    WITH perio = '001'

    WITH gjahr = '2006'

    WITH vaart = '1'

    WITH SELECTION-TABLE SELTAB

    via selection-screen.

    regards,

    amit m.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Amit,

      Thanks for your effort you put in for me.

      You have entered only 2 values in the select option , but in my case the AUFNR values are more than 5000, so please suggest is it possible to pass 5000+ values to a select option.

      because the report program is working fine if i dont give any values and in that case the number of records it process are more than 10000.

      please suggest.

  • Posted on Oct 19, 2006 at 11:55 AM

    Hi Pankaj,

    TRY like this..

    SELTAB-SELNAME = 'AUFNR'.

    SELTAB-KIND = 'S'.

    SELTAB-SIGN = 'I'.

    SELTAB-OPTION = BT''.

    SELTAB-LOW = '11111'.

    SELTAB-HIGH = '12000'.

    APPEND SELTAB.

    submit RKO7CO88

    WITH perio = '001'

    WITH gjahr = '2006'

    WITH vaart = '1'

    WITH SELECTION-TABLE SELTAB

    via selection-screen.

    regards,

    nagaraj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.