Skip to Content

Odata creation for standard reports(MB5B)

HI Experts,

Is there any better way to create the odata for critical & complex reports like (MB5B inventory related reports).

Please give me suggestions

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 28, 2015 at 01:23 PM

    Hi Hussain,

    There is one option that you can try is to call the standard report inside a FM and use that FM for creating a gateway service. The steps could be:

    • to create a RFC FM with import parameters as are in standard report and export parameter same as the final output table of the report.
    • call the report in the FM using SUBMIT keyword or CALL TRANSACTION . You can google it for more details and usage of it.
    • you will get the data of the final output table in the FM
    • create a gateway service using this FM. Some properties would be used as filter and rest would be the properties which are there in the export table. The required method is GET_ENTITYSET.

    Regards,
    Ekansh

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Hussain,

      I do not see any other direct method to use these reports for OData services. If you found any other options please share with us.

      Can you please be more specific about the performance issue in this approach?

      Regards,

      Ekansh

  • May 27, 2015 at 03:35 PM

    Hi Hussain,

    Please give us more details on what you are trying to create. We would be able to help you better if more details are posted.

    Regards

    Prabaharan Asokan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Prabaharan,


      Let assume i have requirement to dispaly the opening stock , closing stock, receipts ,issue

      for this we have already report MB5B, is there any posibility to use standard report with out ant performence issue?if yes how?