‎2008 Jan 18 4:40 AM
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.
‎2008 Jan 18 4:59 AM
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
‎2008 Jan 18 4:58 AM
Hi
U can use CALL TRANSACTION.... IN BACKGROUND method.
Thanks
Vasudha
‎2008 Jan 18 4:59 AM
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
‎2008 Jan 18 5:36 AM
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.