Extract of CM01 Output data

[Former Member]

Hi,

My Requirement is to store CM01 report output to application server in excel format at 15 min interval. There is no manual interpretation in this process.

I tried to execute SAP standard report SAPCRP01, but once this report got executed, we need to manual read job results & store the data.

I tried to create some batch program, it is working fine in Foreground, but not in background.

Can any one got same scenario or any suggestions ?

Thanks in advance.

[Former Member · Accepted solution]

Hi,

I got one simple solution.

* Create variant(Job Name) for the report sapcrp01 in CM01 for

* processing Capacity Requirements (Select Background Processing button)

   SUBMIT sapcrp01 USING SELECTION-SET 'ZCM01_CAP_REQ' AND RETURN.

* Create BDC recording program for CM01->planning->Background Processing->Read Job Results

* Select Detailed Cap. List

   SUBMIT zxxxx

          AND RETURN EXPORTING LIST TO MEMORY

          USING SELECTION-SET 'ZTEST'.

* Import the data which got exported from program MC65AFL1

* EXPORT DETLS TO MEMORY ID 'KAP'.

   IMPORT detls TO lt_int_s000 FROM MEMORY ID 'KAP'.

[anne_angsmann]

I know this is an older thread, but in case somebody is looking for the solution on how to get the same data as in CM01:
Try function module CY01_EXTERNAL_INTERFACE. This is also used in transactions CM25 and CM55, for example, if you want to debug it.

It is important to pass these input parameters:
Function = 'INIT', SAVE_POPUP_IMP = ' ', RESET_ALL_TABLES_IMP = 'X', and most importantly, not any profile (parameter PROFILE_ID), but a profile that does a capacity requirement check. This is the case for the standard profile SAPMPSG006, and you can base your own profiles on this one and influence the time frame by choosing different time profiles inside your new profile. The profiles can be created via customizing, and are stored in table TCY30.
Furthermore, you need to fill table FIL_TAB with values for CRHDWERKS and ARBPL.

If you have passed an appropriate profile, you should get the required results in tables BED_GRU, PER_TAB and PER_BED. It takes some time to understand the output.
In table BED_GRU, the field INDEX corresponds to the KAPID in table CRCA. (From there, you can also find the work centers via table CRHD.) The field BED_GRU-KOMBI is the link to table PER_BED.
Table PER_TAB contains the period "names" and their start and end dates
Table PER_BED contains the capacities and requirements; it is linked to table BED_GRU via the field KOMBI, and in addition, field INDEX corresponds to the line number in table PER_TAB.

[MarianoCabalen]

Hello,

You will need to copy CM01 into a custom program in order to do that. The new program can save the result in a custom table, or save an excel file in the application server, etc.. etc..

There is no SAP function to simplify this requirement.

Kind Regards,

Mariano