topic Re: Submit statement with variant in Application Development and Automation Discussions

Submit statement with variant

former_member515329 — Wed, 20 Dec 2017 14:01:38 GMT

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.

Re: Submit statement with variant

RaymondGiuseppi — Wed, 20 Dec 2017 14:08:52 GMT

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.

Re: Submit statement with variant

former_member515329 — Wed, 20 Dec 2017 14:17:51 GMT

Hello Raymond - can you please elaborate more on this.

my sap Version - SAP NETWEAVER 7.5

thanks in advance

Re: Submit statement with variant

iftah_peretz — Wed, 20 Dec 2017 16:45:53 GMT

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).

Re: Submit statement with variant

Sandra_Rossi — Wed, 20 Dec 2017 17:54:15 GMT

The general way to retrieve ALV data has been discussed 100 times in the forum: please search CL_SALV_BS_RUNTIME_INFO

Re: Submit statement with variant

former_member515329 — Thu, 21 Dec 2017 09:23:14 GMT

Thanks Iftah for the reply..In below code i am able to get the list in list_tab..but the format is somewhat different..so how can i download this list_tab to excel and store it in the desktop.

SUBMIT RSUSR002 USING SELECTION-SET p_var1
                EXPORTING LIST TO MEMORY
                AND RETURN.
CALL FUNCTION 'LIST_FROM_MEMORY'
  TABLES
    listobject = list_tab
  EXCEPTIONS
    not_found  = 1
    OTHERS     = 2.

Re: Submit statement with variant

iftah_peretz — Thu, 21 Dec 2017 11:30:36 GMT

You loop over the result and adapt it to your needs, have it in any format that you want.

Re: Submit statement with variant

iftah_peretz — Wed, 27 Dec 2017 19:16:05 GMT

Using SPLIT command will do the job.

Here is a draft of the code (I assume your it_list_asci table has a column named data and that the excel has 3 columns) - I am not in front of an SAP system, so I can't check it and I couldn't see in the documentation if it clears the values or not (in case of no match), if it doesn't use option 1 otherwise option 2.

"Option 1
DATA: column1 TYPE string,
      column2 TYPE string,
      column3 TYPE string.
LOOP AT it_list_asci INTO DATA(excel_row).
  CLEAR: column1,column2,column3. 
  SPLIT excel_row-data AT '|' INTO column1 column2 column3. 
"coulumn1-3 contains what you need
"... Your logic... 
ENDLOOP.

"Option 2
LOOP AT it_list_asci INTO DATA(excel_row).
  SPLIT excel_row-data AT '|' INTO: DATA(column1) DATA(column2) 
  DATA(column3). 
"coulumn1-3 contains what you need
"... Your logic...
ENDLOOP.

Re: Submit statement with variant

former_member515329 — Thu, 28 Dec 2017 10:31:44 GMT

I have declared a new internal table with 11 fields(11 columns) - but still data is not coming in column wise separator in excel, it is coming as combined data in only 1 column.

LOOP AT it_list_asci INTO wa_list_asci."DATA(excel_row).
   CLEAR : wa_excel_format.
   shift wa_list_asci-line.
  SPLIT wa_list_asci-line AT '|' INTO wa_excel_format-line1
                                      wa_excel_format-line2
                                      wa_excel_format-line3
                                      wa_excel_format-line4
                                      wa_excel_format-line5
                                      wa_excel_format-line6
                                      wa_excel_format-line7
                                      wa_excel_format-line8
                                      wa_excel_format-line9
                                      wa_excel_format-line10
                                      wa_excel_format-line11.
  APPEND wa_excel_format TO it_excel_format.
  CLEAR : wa_list_asci.
ENDLOOP.

  CALL FUNCTION 'GUI_DOWNLOAD'
     EXPORTING
       filename             = gv_fullpath
       filetype             = 'ASC'
     TABLES
       data_tab              = it_excel_format[]   "it_list_asci[]        
       fieldnames            = git_fieldnames[]  
     EXCEPTIONS
       file_open_error       = 1                         "#EC ARGCHECKED
       file_write_error      = 2
       OTHERS                = 3.

Re: Submit statement with variant

iftah_peretz — Thu, 28 Dec 2017 11:10:41 GMT

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.