topic MB51 - layout in Application Development and Automation Discussions

MB51 - layout

Former Member — Thu, 19 Apr 2007 08:46:05 GMT

Hello all,

Good Morning!!!

Tx = MB51

When we execute MB51

The Material Document List is displayed as all SAP LAYOUT reports.

When I click button LIST DETAIL (Ctrl + Shift + F12), the list is displayed as EXCEL FORMAT.

The user wants:

- When he executes the MB51 he wants the List (report) is displayed straight as Excel Format.

Is that possible as STANDARD? Or to get that we have to develop?

This is Urgent.

Thanks,

Amanda

Re: MB51 - layout

Former Member — Thu, 19 Apr 2007 08:53:24 GMT

Hello!

This cannot be performed with the standard MB51 list.

But you can modify the standard or copy it to a Z one.

In your Z program, right before the list appears, you can give an OK-CODE, what the detail list is requesting, and this will made the program to show the detail list instead of the standard one.

Of coourse with this case you have to program the BACK button also, to skip the normal report.

Regards

Tamá

Re: MB51 - layout

Former Member — Thu, 19 Apr 2007 08:54:12 GMT

Hi,

Copy the Std report of MB51 to a report and modify.

Remove the code to display report.

Just take the final Internal Table data and pass to the fun module

EXCEL_OLE_STANDARD_DAT, so that the data will be displayed straight as a EXCEL file.

reward if useful

regards,

ANJI

Re: MB51 - layout

Former Member — Thu, 19 Apr 2007 08:59:57 GMT

U need to create a custom program as copy of RM07DOCS and update the routine output_list in order to replace the fm REUSE_ALV_HIERSEQ_LIST_DISPLAY with REUSE_ALV_GRID_DISPLAY

Max