cancel
Showing results for 
Search instead for 
Did you mean: 

Odata creation for standard reports(MB5B)

hussain_p
Participant
0 Kudos

HI Experts,

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

Please give me suggestions

Accepted Solutions (0)

Answers (2)

Answers (2)

EkanshCapgemini
Active Contributor
0 Kudos

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

EkanshCapgemini
Active Contributor
0 Kudos

Hi Hussain,

Were you able to achieve this?

Regards,
Ekansh

former_member184739
Contributor
0 Kudos

Hi Ekansh,

How will you stop the report execution. For instance report after submitting the output will be displayed in a ALV table or any error thenOData service flow will be stopped right ?

Please suggest. Thanks

EkanshCapgemini
Active Contributor
0 Kudos

Hi Prabaharan,

If you use the SUBMIT keyword with an addition of 'WITH RETURN' the flow will return to the calling program. This keyword works in the following way: You have a calling program ZTEST1 and another executable program(or report) ZTEST2 which would be called from ZTEST1. So while calling the other report, you have following options:

  • to pass the selection screen parameter values in the background
  • to return in the calling program after execution. This is achieved by WITH RETURN. This would hold the session value of calling program and would continue execution from the next statement after calling the program. So this way ALV would not get displayed.

Regards,

Ekansh

hussain_p
Participant
0 Kudos

Hi Ekansh,

Yes, it is one of the solution but we will get performance issue.

Thank You

EkanshCapgemini
Active Contributor
0 Kudos

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

former_member184739
Contributor
0 Kudos

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

hussain_p
Participant
0 Kudos

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?