- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- Issues with Tcode MM60
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Issues with Tcode MM60
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2011 1:28 PM
Hi,
The user is using Transaction code MM60 for extracting Material List based on Material Number and Plant.
After receiving the output data in SAP screen, the user is unable to export the same date in MS Excel by pressing CtrlShiftF7
We can download the same output to Excel onto Desktop, however unable to see the same in SAP Excel format.
We dont find any missing authorizations, however we evem tried with SAP_ALL profile still the issue remains the same.
Please advice.
Regards.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2011 8:45 AM
We dont find any missing authorizations, however we evem tried with SAP_ALL profile still the issue remains the same.
Did you tried in other m/c
Edited : Check the parameter G_RW_DOCUMENT_TYPE in parameter tab
xls - Excel format always
Regards,
Arpan Paik
Edited by: P Arpan on Jun 28, 2011 2:13 PM
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2011 1:34 PM
It must be something related to SAP GUI... Try installing the latest GUI patch
or try this...
Open MS Excel
Menu --> Tools --> Macro --> Security --> Trusted publisher tab --> Select Checkbox "Trust access to Visual Basic Project"
-Muktar
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2011 8:45 AM
We dont find any missing authorizations, however we evem tried with SAP_ALL profile still the issue remains the same.
Did you tried in other m/c
Edited : Check the parameter G_RW_DOCUMENT_TYPE in parameter tab
xls - Excel format always
Regards,
Arpan Paik
Edited by: P Arpan on Jun 28, 2011 2:13 PM
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2011 10:45 AM
I had a similar problem with displaying data in Excel within SAP. This was resolved by making changes to settings in Excel depending on whether you are using Excel 2003 or 2007.
In Excel 2003:
use menu option Tools> Macro> Security--> there are two tabs:
Security level and Trusted partners. In the trusted partners tab make sure both checkboxes (trust access to VB content AND installed add-ins) are TICKED. This should most probably resolve the problem.
In Excel 2007:
Goto Excel Options. Select the Trust Center tab. Under Microsoft Office Excel trust Center click on the Trust Center Settings.
In the Trust Center Window select Macro Settings tab. Under that, enable Macros and tick Trust access to VBA project object model.
Hope this helps. This Solution is available on one of the SAP Notes. I can't remember which one though....
Regards,
Prashant
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2011 11:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2011 5:46 PM
Hi,
You didn't mention any thing about the SAP GUI patch level. Did you try updating the SAP GUI patch level. I also recommend you verify the below SAP Notes:
722513 - Desktop Office Integration: Maintenance information
696069 - No data when view Excel Inplace on ALV with Office
Best Regards,
Raghu
- SAP Managed Tags:
- Security
