Skip to Content
J M

Different types of output return different information - SAP Logon

Hello everyone,

I'm programming some Excel macros to download different transactions in SAP Logon. The best way I found to do that is to use "Type of output: inactive" (in the "Office integration" option) and to copy that information to the clipboard, and then paste it in my Excel sheet.

The problem is that now I have a transaction that, if I use "Type of output: MS Excel" returns me 42 columns and 3 sheets (with 30 rows each one), but if I choose "Type of output: inactive" it only returns 14 columns (i.e., 1/3 of the information) and all the rows in the same sheet. The number of rows is not a problem because it returns the 90 rows, but the number of columns is a big problem because I'm losing information.

What can I do? Putting "Type of output: MS Excel" in the macro is a big problem because I need someone to enable that the program opens an Excel file, and the code that SAP gives me (with the record option) is horrible.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers