topic Re: REPORT in Application Development and Automation Discussions

REPORT

Former Member — Fri, 18 Jan 2008 04:40:35 GMT

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.

Re: REPORT

Former Member — Fri, 18 Jan 2008 04:58:11 GMT

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

Thanks

Vasudha

Re: REPORT

Former Member — Fri, 18 Jan 2008 04:59:12 GMT

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

Re: REPORT

Former Member — Fri, 18 Jan 2008 05:36:53 GMT

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.