cancel
Showing results for 
Search instead for 
Did you mean: 

LT22 - Confirmation Status is appearing as symbol after exporting in excel

Former Member
0 Kudos

Hi Experts,

Please recently we have upgraded to EHP 7 and we facing issue with LT22 report as confirmation status symbol is appearing as symbol after exporting to excel.

Previously it will show symbol in report and after export to excel it will text. Please advice.

Regards,

Karthik Angappan.

Accepted Solutions (0)

Answers (1)

Answers (1)

anand_sagarsethi
Contributor
0 Kudos

You can create a layout without  = sign first save it. Now run the report on that layout and export it to excel, that column will not come.

Thanks

Anand

Former Member
0 Kudos

Hi,

Please guide me how can i create without = Sign.

And i have created a new layout and tries. Still getting the symbol

Regards,

Karthik Angappan,

Former Member
0 Kudos

Hi,

If my understanding is correct, I have executed the report and removed the column of CS and saved the layout. Again i have added the CS and exported to excel still it shows with symbol.

Please correct me if above step is wrong.

Regards,

Karthik Angappan.

anand_sagarsethi
Contributor
0 Kudos

Remove CS as shown below and export the file.

Former Member
0 Kudos

Hi,

Please our requirement is to export with confirmation status. In pre-upgrade system after exporting the CS will converted into text.am attaching the file for reference.

In upgraded system it fails to convert to text from symbol.please help

Regards,

Karthik Angappan

anand_sagarsethi
Contributor
0 Kudos

What do you see currently in LT22..? Can you share its screenshot.

Thanks

Anand

Former Member
0 Kudos

Hi,

Please below is the current situation, After exporting to excel.

Regards,

Karthik Angappan.

JL23
Active Contributor
0 Kudos

What is actually the problem that you face in Excel if that is an icon?

I don't think that this "issue" has anything to do with Logistics Execution, it most probably a general feature with the Excel export. Maybe it can be turned off by your basis admins, maybe there is an individual option for you based on the way your export. Can you explain the steps you do?

Former Member
0 Kudos

Hi,

Please currently in LT22 as per below.

Regards,

Karthik Angappan.

After export to excel also same.

Former Member
0 Kudos

Hi,

Please after exporting to excel, when do pivot/Filter the CS text is not appearing. which we unable to filter whether TO is "confirmed with difference or without difference"

Regards,

Karthik Angappan

JL23
Active Contributor
0 Kudos

How do you export, please tell the exact steps  and what you select, I have eventually an option in mind, but since I don't know EHP7 it is better you start (even when your screen looks equal to mine in a lower release)

Former Member
0 Kudos

Hi,

Please below is the steps followed.

1) Selecting the boxed icon

2) Export to excel and save

3) Please we use EHP7 as my sap tool is older

**************************************

when i use the below export option, Am not able to get it exported.

1) Port to excel

2) Select text to tab (New in EHP instead of spredsheet)

After Tick below is the screen

Generate

Regards,

Karthik Angappan

anand_sagarsethi
Contributor
0 Kudos

Just save it as xls... dont add 'X' after it, your problem should be solved.

Former Member
0 Kudos

Hi,

As you said i made as XLS. and exported - Now CS column is blank. Below is the snap shot after porting to excel

Major issue is after exporting we need to see the text instead of symbol.

Regards,

Karthik Angappan.

anand_sagarsethi
Contributor
0 Kudos

I only know that in XLSX.. What you see is what you get..

I still have a doubt in my mind when you were in previous version of Enhancement pack do you see CS with = in SAP( the way you see it now ) or Confirmed quantity with difference / ( Text ) that was visible when it was exported...?

Because i can not think of anything, or suggest you try all the options you have in saving it into file ( unconverted, HTML etc) and if anything might help.

Thanks

Anand

Former Member
0 Kudos

Hi,

In previous version we see = in report and after export it convert to text.

Tried all the option for export, Still Same.

Regards,

Karthik Angappan

JL23
Active Contributor
0 Kudos

when you are in the ALV list in LT22, then enter &RESET_EXCEL

into the command field to reset your default format.

After this you should get again the selection pop-up

then try other formats e.g. the XXL format

Former Member
0 Kudos

Hi,

Please above screen is not appearing while am exporting. Please advice

Regards,

Karthik Angappan.

JL23
Active Contributor
0 Kudos

had you done the &RESET_EXCEL ?

anand_sagarsethi
Contributor
0 Kudos

Try what Juergen said..

Also tell me when you on step 2 (from top of your thread) of your screenshot where you select Spreadsheet button and it ask you file name and Save as type (XLSX) & save..

Do you have option to change save as type (XLSX) to XLS..?

Thanks

Anand

Former Member
0 Kudos

Hi Jurgen,

Please the screen shot which you mention is not appearing. Instead the below screen shot appears when export to excel.

Regards,

Karthik Angappan

Former Member
0 Kudos

Hi,

Please am getting 1 selection option as XLSX. Unable to change.

Regards,

Karthik Angappan

JL23
Active Contributor
0 Kudos

this is far beyond. What happens when you do the command? What do you see in the status bar?

You may also check this wiki as it has 2 other options: https://www.google.de/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwji0ovVu_bNA...

Former Member
0 Kudos

Thank you Jurgen

Former Member
0 Kudos

Thank you Anand