Skip to Content
avatar image
-1
Former Member

Changing MB52 report output display.

Hi Experts,

Requirement:

To interchange rows into columns of the fields stock type quantity (unrestricted ,quality,Blocked stock,stock in transit etc) and storage location from MB52 report without disturbing the MATNR field.

(ie) We have to display storage location as column and stock type quantity (unrestricted ,quality,Blocked stock,stock in transit etc to be displayed as rows.

Pl let me know is it possible via custom report.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 15, 2017 at 09:18 AM

    wouldn't be an Excel as Pivot-table resolve the requirement with a few clicks?

    first execute MB52 with the selection as non-hierarchical display

    when seeing the result then click the Excel button and keep the radio button in Pivot table.

    finally drag your storage location to the header

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 07:25 AM

    Did you try to press this button ?

    Fred

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2017 at 07:13 AM

    Hi Kumar,

    it's "normal", there could have several values in an item field, how to set these values into 1 field in the header line ?

    you have to put Header data into the Header line & Items into the item line

    regards

    Fred

    Add comment
    10|10000 characters needed characters exceeded