Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ALV export to excel problem

oliver_am
Active Participant
0 Kudos
1,495

Hello, all.

In one of our environments when trying to export an ALV to excel we get the following message:
0K064

And then we can see only these options to download with XXL:

This is happening in all the ALV of all the programs for all the users !!!

In other enviroments we have not this message and we have the normal export options:

We've checked table SALV_BS_ADMIN with program SALV_BS_ADMIN_MAINTAIN but cannot see any entry with an * in this client or something strange. Is there a problem if we delete all the entries of this table?

What can be the problem?

Cannot find any SAP note to solve this. I was reading this one but cannot find the solution:
1080608 - Definition of ABAP ALV export format for spreadsheet


Is talking about transaction SIMGH to change something at client level, but coudnt find the path. This transaction if for newer versions; We are in SAP_BASIS 701.

We have also tried with &RESET_EXCEL

Thanks in advance.

1 ACCEPTED SOLUTION

oliver_am
Active Participant
780

Ok, solved, there was a problem with table SALV_BS_ADMIN .
An entry with an * We dint see.

5 REPLIES 5

Yasin
Active Participant
0 Kudos
780

Hi,

it look like authorization issue, please check if they have access to Auth. Obj. S_GUI

Thanks

oliver_am
Active Participant
0 Kudos
780

Hi, Yasin.

Thanks for answer.

Is not an authoirization problem, we cannot see any problem in su53.
And this is happening since few days for all the users of the system with all the ALV of all the programs

Yasin
Active Participant
0 Kudos
780

maybe you need to check your alv layout parameters + alv display base on the ALV method which you are using

sometime if you are using empty cols or wrong data types you may get some issues

oliver_am
Active Participant
781

Ok, solved, there was a problem with table SALV_BS_ADMIN .
An entry with an * We dint see.

raymond_giuseppi
Active Contributor
780

Did you