‎2009 Oct 03 6:46 AM
Hi,
I am looking for an alternative to function module "MD_SALES_ORDER_STATUS_REPORT". We are running an extract to pull production orders. This function module is being called for every production order and causes a huge performance issue. We need an alternative to this FM to extract the lower level prod orders.
Please let me know if there are any alternatives available.
Regards
Anurita
‎2009 Oct 03 11:25 PM
Hi Anurita,
did you read the comment inside this function module?
* Rel. 4.70: new parameter MEMORY_ID
* with the following new function:
* if MEMORY_ID = 'ABBL' and DATA_IN_MEMORY = 'X' then
* the order report takes the planning situation (MDPSX) from the
* memory buffer. If they are not found in the memory then the
* order report reads from database and puts the result in the buffer.
* Useful for performance improvement in MD04,MD07,...
* if order report is done multiple times during the transacation.
* In MD04,MD05,MD06,MD07,.. this function can be switched on/off with a
* flag in the user parameters.
* The data is taken from the buffer only
* for Make-to-stock. Sales order segment / project segments are
* always read from the database.
* memory_id = ABBL --> use the buffer for stock req. list
* memory_id = PLHS --> use the buffer from simulative planning
* (old functionality used in sim. MD02,...)
* for compatibility the default is PLHS (which only makes sense
* in simulative MD02).
This could help.
Regards,
Clemens