topic Re: List -> Export -> Spreadsheet disabled in Application Development and Automation Discussions

List -> Export -> Spreadsheet disabled

Former Member — Mon, 11 Nov 2013 14:56:41 GMT

Hi,

My problem is that i was adjusting an abap program and when i was finished with this, this option is/was disabled, ( enabled at first )

I checked several things like authorisation , but this cant be the problem because i have SAP_ALL rights and before my adjustments this option was available.

I didn't changed anything that can be the cause of this disablement.

List-export-local file does work, and i can also select spreadsheet after this but the output isn't the same when i select spreadsheet via List-export-spreadsheet.

What can be the problem?

My ALV call looks like this( and i changed nothing 😞

* ALV aanroepen:

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_callback_program = lv_repid

i_bypassing_buffer = 'X'

it_fieldcat = it_fieldcat_alv

it_events = it_events

i_save = 'A'

is_variant = spec_variant

TABLES

t_outtab = it_detail.

Re: List -> Export -> Spreadsheet disabled

anupam_anand — Mon, 11 Nov 2013 15:51:29 GMT

Hi Ramon,

Can you pass I_BYPASSING_BUFFER as space?

Try this and see if it works. Also, can you share how do you populate SPEC_VARIANT?

Thanks,

Anupam

Re: List -> Export -> Spreadsheet disabled

Former Member — Mon, 11 Nov 2013 15:56:16 GMT

hi ramon,

can you check your output table format. usually, export spreadsheet is disable when there is a structure type in field value of the Output table.

There might be one field which is having structure as type.

Regards,

Kapil.

Re: List -> Export -> Spreadsheet disabled

Former Member — Wed, 13 Nov 2013 12:57:37 GMT

Thx, this was it , it used pernr ( as a field ) which was a structure on his own.