Importing SAP Calendars

This procedure describes how to import single or multiple SAP calendars into your Control-M environment.

Begin

1. Do one of the following:

   • Windows: From a Control-M/Agent machine , open the command prompt, and navigate to AgentFolder\CM\SAP\EXE\

   • UNIX: Log in as a Control-M/Agent user.

2. Type one of the following commands:

   • To import a single SAP calendar to Windows:

     ctmr3req.exe -SAPR3-ACTION IMPORT_CLNDR_JSON -SAPR3_EXP_CLNDR_PATH <output_path> [-SAPR3-ACCOUNT <connection profile> -SAPR3-CALENDAR_NAME <calendar name> -SAPR3-CALENDAR_YEAR <calendar year>] [-SAPR3_CALENDAR_DESCRIPTION <calendar description>]

   • To import a single SAP calendar to UNIX:

     ctmr3req -SAPR3-ACTION IMPORT_CLNDR_JSON -SAPR3_EXP_CLNDR_PATH <output_path> [-SAPR3-ACCOUNT <connection profile> -SAPR3-CALENDAR_NAME <calendar name> -SAPR3-CALENDAR_YEAR <calendar year>] [-SAPR3_CALENDAR_DESCRIPTION <calendar description>]

   • To import multiple SAP calendars to Windows:

     ctmr3req.exe -SAPR3-ACTION IMPORT_CLNDR_JSON -SAPR3_EXP_CLNDR_PATH <output_path> [SAPR3-CLNDR_FILE <file in JSON format> ]

   • To import multiple SAP calendars to UNIX:

     ctmr3req -SAPR3-ACTION IMPORT_CLNDR_JSON -SAPR3_EXP_CLNDR_PATH <output_path> [SAPR3-CLNDR_FILE <file in JSON format> ]

     A successful import returns a 0.

     An unsuccessful import returns an appropriate error message, such as Connection profile not found.

     • You can import an unlimited amount of SAP calendars in one JSON file.

     • Even if errors occur for specific SAP calendars, all SAP calendars that can be imported are imported.

     A payroll controller wants to import existing SAP calendars to Control-M running on Windows. The calendars are used to calculate appropriate payment for days when employees are paid for a half day of work (holiday eve), and when employees are paid in full (holiday).

     Example command:

     ctmr3req.exe -SAPR3-ACTION IMPORT_CLNDR_JSON -SAPR3-EXP_CLNDR_PATH C:\Users\user\Documents\Calendars -SAPR3-CLNDR_FILE C:\Users\user\Desktop\SAPHolidaysCal.txt

     Example contents of the JSON file:

     Copy

     {
         "Calendars" :
          [
             {
                 "cp": "PAYROLL",
                 "years" : ["2021","2022"],
                 "name" : "IL",
                 "alias" : "Hol_Eve",
                 "description" : "Half day paid leave"
             },
             {
                 "cp": "PAYROLL",
                 "years" : ["2021","2022","2023"],
                 "name" : "US",
                 "alias" : "Full_Hol",
                 "description" : "Full day paid leave"
             }
         ]
     }

Single SAP Calendar Import Parameters

The following table lists the parameters to specify in the ctmr3req command when you import a single SAP calendar:

Parameter	Description
-SAPR3-EXP_CLNDR_PATH	Defines the output path for the SAP calendar.
-SAPR3-ACCOUNT	Defines the connection profile name to use for exporting the SAP calendar.
-SAPR3-CALENDAR_NAME	Defines the name of the SAP calendar.
-SAPR3-CALENDAR_YEAR	Defines the year that the SAP calendar refers to.
-SAPR3-CALENDAR_DESCRIPTION	Describes the purpose of the SAP calendar. Optional. Max length: 4000 characters

Multiple SAP Calendars Import Parameters

The following table lists the parameters to specify in the ctmr3req command when you import multiple SAP calendars:

Parameter	Description
-SAPR3-EXP_CLNDR_PATH	Defines the output path to send the SAP calendars.
-SAPR3-CLNDR_FILE	Specifies the JSON file that contains multiple calendars. See the example below. Parameters: cp: Defines the connection profile name to use for exporting the SAP calendar. years: Defines the year or years that the SAP calendar refers to. name: Defines the name of the SAP calendar. alias: Defines a code-name given by the user. Maximum 8 characters. description: Describes the purpose of the SAP calendar.