01-07-2015 6:57 AM
Hi All,
While exporting the data from ALV output.
Code level nothing is being changed.
Previosly while exporting to excel, in the generated excel data and the date used to come on the left top.
Now i am getting the data alone, missing the date.
I searched in SCN but couldnot get any solution.
PFA old and new screen shots.
I have highlighted the the date in Yellow mark.
Our system get upgraded recently. Is this related.
Please suggest.
Regards,
Munu
01-08-2015 12:59 PM
01-08-2015 1:05 PM
may be your SAP system is upgraded and if so then you have to search a note for that upgrade
01-08-2015 1:22 PM
Hi Munu,
Can you provide below information:
1) What statement is used to print date?
2) Upgrade is done from what to what version?
Warm Regards,
Shyam Agrawal
01-11-2015 11:35 AM
Hi Shyam,
If you export the ALV to excel then by default you will get the date and the text "Dynamic list display".
Currently I am not getting the date and the time.
So any suggestion.
Regards,
Munu
01-13-2015 8:41 AM
01-12-2015 3:56 AM
Hi ,
Check whether the date format that u are using in the Excel and the system date format are same if they are different then this kind of issue may occur.
Regards,
Vinodkumar.
01-12-2015 4:23 AM
Hi Munu,
Good day,
Enter &reset_excel into the command line (for ABAP Lists only) to reset the default Excel File Format and try to export.
Hope it may be helpful and let me know if any issues.
Thanks & Regards,
Seshadri.
01-13-2015 6:01 AM
Hi Seshadri,
I ma using ALV grid diplay.
And the output is coming as well.
But during exporting the date and the text 'Dynamic List Display' in the file is missing which used to come by default.
Try exporting to Ecxel from ALV and you will get my issue.
Thanks,
Munu
01-12-2015 2:58 PM
When you press the Excel button, there will be a popup that lets you select different formats. Press F1 on one of the fields to help you decide which format to use.
Rob
01-13-2015 5:59 AM
Hi Rob,
I used to select the Export then the Spreadsheet.
The thing is that the date and text 'Dynamic List Display' in the file is missing.
So any suggetsion.
Thanks,
Munu
05-04-2015 9:16 AM
Hi Manu,
Did you manage to find the solution?
After SP upgrade we are facing with the same issue. Dynamic list display with the date and time is missing in excel files.
Thanks,
Bojan.
10-16-2015 7:41 AM
Dear Manu,
This line was disabled with the note correction 1912127, you can reenable this line with the implementation of the note 2090822.
Br,
Gyorgy