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

SUBMIT rep WITH FREE SELECTIONS

I created a report that displays a grid. From the grid you can click on a cell to drill down to another report.

When the user clicks on a hot spot, I build a submit call and call the drill down transaction with the following code:

SUBMIT rkaep000

WITH FREE SELECTIONS wtbl_rsds_texpr

WITH kostl = wa_kostl

WITH kstar = wa_kstar

WITH r_budat BETWEEN wa_budat AND lc_date_high

WITH p_usedb = 'X'

WITH p_usear = ' '

WITH p_tcode = p_tr

AND RETURN.

Everything worked fine until recently when the user wanted to further expand the selection criteria with a dynamic selection parameter. I found the appropriate statement WITH FREE SELECTIONS, created and populated the correct structure and added it to my submit statement above.

The SUBMIT handles all the parameters fine except WITH FREE SELECTIONS - this is ignored during the call.

I have read and reread the help section for WITH FREE SELECTIONS and am beginning to think that I may not be able to call a program and pass it dynamic select option.

Does anyone have any ideas on this.

Thanks in advance,

Marty K.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    Posted on Jan 13, 2005 at 07:51 AM

    Hi Martin,

    it's fine, that your problem is solved.

    So please say

    'Thanks the SDN way'. Click on the yellow star, and award suitable points.

    Check out this weblog:

    /people/mark.finnern/blog/2004/08/10/spread-the-love

    regards Andreas

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2005 at 08:40 PM

    Are you sure that you are appending to your internal table wtbl_rsds_texpr.

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2005 at 09:26 PM

    Hi Martin,

    It looks like you are on the right track here but I can't see why you are not able to pass on the dynamic selection values to the 'SUBMIT' statement.

    If I look at the documentation, it says that you are to fill in your dynamic selections in an internal table of type RSDS_TEXPR which you are doing. How are you filling this 'wtbl_rsds_texpr' table? There are some function modules suggested by the documentation. Are you using them?

    If possible could please paste the section of the code where you fill this internal table?

    Regards,

    Srinivas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2005 at 10:13 PM

    Thank you for the quick responses. Here are the data declarations and set-up of the structure.

    DATA l_expr TYPE rsds_expr.

    DATA l_etab TYPE rsds_expr_tab.

    DATA wa_etab TYPE LINE OF rsds_expr_tab.

    wa_etab-fieldname = 'BLDAT'.

    wa_etab-option = 'BT'.

    wa_etab-low = '19000101'.

    wa_etab-high = wa_bldat.

    APPEND wa_etab TO l_etab.

    l_expr-tablename = 'COOI'.

    l_expr-expr_tab = l_etab.

    INSERT l_expr INTO wtbl_rsds_texpr INDEX 1.

    The TR I am submitting to is KSB2. I found the code they used to build this structure and duplicated it. Our structures 'look' identical at runtime. I did see the FMs RS_REFRESH_FROM_DYNAMICAL_SEL and FREE_SELECTIONS_RANGE_2_EX but it looks to me like these would be used to extract parameters from a program you are in and use them to pass out. I need to create my select option from a hot spot on the grid and force the next report to use this dynamically. When I step through the submit and get to the form that sets up the dynamic selection there is no trace of my code in the calling programs like structure. So I am either passing this incorrectly or it just isn't possible

    I also thought about creating a dynamic variant but this also does not appear to welcome dynamic selection criteria.

    Thanks again in advance,

    Marty K

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Srinivas Adavi

      Hi Srinivas. In regards to your comments:

      l_expr-expr_tab = l_etab. <-- comment out this line

      l_expr-expr_tab[] = l_etab[] <------do this

      Since these 2 tables are defined WITHOUT header lines, these statements are equivalent although I do prefer to use the bracket notation to improve readability.

      Thanks for your posting.

  • Posted on Jan 10, 2005 at 11:33 AM

    Martin,

    i think abap rkaep000 has <b>no</b> free selections

    in terms of a logical database (ldb) !

    (i'll guess here's another procedurs as ldb )

    -> so you <b>can't</b> use the parameter

    with free selections !

    Andreas

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 11, 2005 at 09:15 AM

    Hi Martin ,

    here's another possible solution:

    in include RKAEPFOB there's an import of table

    table l_t_texpr

    form free_selection_mem

    ...

    WHEN 'I'.

    IMPORT ct_fields

    ct_free_selection

    ct_free_sel_ranges

    ct_expressions FROM MEMORY ID ls_memory_id.

    ...

    Just debug !

    Let's know, if this helps.

    regards Andreas

    Forum Home | Help | Search

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      To All who have been monitoring this post,

      I have implemented the solution Andreas suggested (using EXPORT TO MEMORY) and initial testing shows it to be working as designed.

      Thanks again to everyone for the assistance.

      Marty K

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.