Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

REPORT

Former Member
0 Likes
519

Hi Guys,

i have a very critical requirement. Its required that i should create a Z report in which i should run MB5B in the background and capture the values of the output into an internal table of the Z report.

Then this Zreport will be furter created to fetch some other values like sales qty value etc.

can anyone tell me like how i can run this MB5B in the background of my report and get the data into an inetnal table of my report.

please reply urgently.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
491

Hi,

you can try this.

In your Z program, use

Submit RM07MLBD using selection-screen ... <WITH SELECTION-TABLE seltab > ( OR WITH p IN sel etc to pass your parameters ) EXPORTING LIST TO MEMORY AND RETURN.

Call 'LIST_FROM_MEMORY' to retrieve data ...

you have to read data line by line and you have to use offsets to retrieve your desired fields.

You can use this data to further select and display as per your requirement.

Regards,

Mohaiyuddin

3 REPLIES 3
Read only

Former Member
0 Likes
491

Hi

U can use CALL TRANSACTION.... IN BACKGROUND method.

Thanks

Vasudha

Read only

Former Member
0 Likes
492

Hi,

you can try this.

In your Z program, use

Submit RM07MLBD using selection-screen ... <WITH SELECTION-TABLE seltab > ( OR WITH p IN sel etc to pass your parameters ) EXPORTING LIST TO MEMORY AND RETURN.

Call 'LIST_FROM_MEMORY' to retrieve data ...

you have to read data line by line and you have to use offsets to retrieve your desired fields.

You can use this data to further select and display as per your requirement.

Regards,

Mohaiyuddin

Read only

Former Member
0 Likes
491

Hi,

No need to run the transaction.

You will get the data from the table MCHB. Give the keys as you give in MB5B and you can retrive the stock data. Take this into an internal table and then process further according to your requirement.

Hope this helps. Pls reward points if solved your issue.

Regards,

Renjith Michael.