Skip to Content
avatar image
Former Member

Submit statement with variant

Hi All,

I am using program RSUSR002 - here i have 4 variants - i want to execute all the 4 variants one by one using SUBMIT statement.and i want to download the list into spreadsheet (using menu options ->list->Export->spreadsheet).

Is it possible to automate this program with 4 variant and to download all 4 output(spreadsheets) in desktop without manual intervention?

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 20, 2017 at 02:08 PM

    Depending on your version, set the hidden parameter listmark in your submit statement, then import data from memory id 'USERLIST' or use class to get ALV data back in caller report.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2017 at 04:45 PM

    Hi,

    There are many ways of going at it.

    I'll illustrate just one (not sure it's the optimal one for you - not much information in your question):

    You'll need to use the variant option in the SUBMIT command. Then you'll need to have the list exported to memory (you can Google examples, like this one). And, as suggested in the last link I provided, you can go over the list and export it to excel (many options, like abap2xlsx).

    Add comment
    10|10000 characters needed characters exceeded

    • I misunderstood you. You are in the phase were you want to take the output of the alv and export it to an excel and have it in a certain way, you are not using what I recommended, please search how to create excel from internal table, there's a lot of data there - I have already supplied you with links for that.