How to get Overview Tree from MD04 with MD_SALES_ORDER_STATUS_REPORT FM
Recently I needed to get information from CO46 tcode to use in a custom development. More specifically, I needed Overview Tree from MD04.
The only FM to get this data is MD_SALES_ORDER_STATUS_REPORT, but this FM just open CO46 tcode.
So we have this NODISP parameter in the FM, but when enabled, it returns only the IIOELX table and any data from Overview Tree.
So, I did a huge workaround to get this information from this FM. As it is described below.
In the Z program we have to o the following:
Declare two variables:
DATA: lc_md_memory, gt_ord_outtab TYPE ty_io_struc_tab.
You can copy ty_io_struc_tab structure from program LM61TTOP.
In your code, before call MD_SALES_ORDER_STATUS_REPORT FM, you need to set some memory information.
Note that NODISP parameter is set to space as default.
lc_md_memory = cc_x. " Set var to export to memory EXPORT lc_md_memory TO MEMORY ID 'MDREPORT'. " Call FM with your parameters CALL FUNCTION 'MD_SALES_ORDER_STATUS_REPORT' EXPORTING edelet = ls_mdpsx-delet edelkz = ls_mdpsx-delkz edelnr = ls_mdpsx-del12 edelps = ls_mdpsx-delps ewerks = ls_mt61d-werks i_ignore_mtold = 'X' i_profid = 'SAP000000002' EXCEPTIONS error = 1 others = 2. " Import result table from memory IMPORT gt_ord_outtab FROM MEMORY ID 'MDREPORT'.
After this points, you should have your internal table GT_ORD_OUTTAB with the same information from Overview Tree, but to work we need to create another piece of this puzzle: an implicit enhancement.
Go to program LM61TF27, enable Enhance and Show Implicit Enhance Options.
In the end of form ord_create_tree, create an enhance implamentation to insert the following code:
DATA: lc_md_memory. IMPORT lc_md_memory FROM MEMORY ID 'MDREPORT'. IF lc_md_memory IS NOT INITIAL. EXPORT gt_ord_outtab TO MEMORY ID 'MDREPORT'. LEAVE PROGRAM. ENDIF.
In this code, we get lc_md_memory from memory to check if it is set from our calling program.
If is set, we export gt_ord_outtab to memory and finally leave current program to avoid open CO46 transaction.
It should be like this:
In our calling program, GT_ORD_OUTTAB will be populated as CO46.
Hope it helps!