RE:[sap-log-mm] Inventory report - MB52 in a batch job

Posted by Sap Land Thursday, 14 July 2011 22:39

Posted by RS_Sharma
on Jul 15 at 1:46 AM

Sir, please following these steps to generate MB52 report in excel format.....
MB52 - Report
Enrty required details then execute F8.

Then Click on Change Layout/current display variant
Click on View TAB
Select Microsoft excel then click on save .
Here windows open click on first line i.e.sap_om.xls.....select first line
Select then save
next window ..then Select the first object
Now open Microsoft Excel

Click on Tools Menu
Select Macro
Then Click on Security
GO TO PATH
Security Windown open
click on Trusted Publisher
Tick both Check Boxes on on the window
Click on OK...exist from MS Excel
GO back and run the report again. The report will be displayed in excel format this provision is available for all standard SAP reports

Hope this will solve your problem.

Ram Swarup Sharma

---------------Original Message---------------
From: Ravi Nadendla
Sent: Wednesday, July 13, 2011 8:58 PM
Subject: Inventory report - MB52 in a batch job

HT,

That part I know, but how to create output in excel format. If I run in foreground and give all input values (material code, plant, storage locations etc), when the system displays the output then I can create local file in excel format, but when I run in background how to create excel file. This is the question.

Thanks
Ravi

__.____._