R3_IMPORT_CALENDAR

Use the R3_IMPORT_CALENDAR script element to import calendars from an SAP system into an AE system. You can import factory calendars and public holiday calendars. The days from the SAP calendar are stored in a Calendar key of a Calendar object.

Interface: AE and Standard

Syntax

R3_IMPORT_CALENDAR CALENDAR_ID=...[,TYPE=...][,FOLDER=...][,UC4_CALE=...][,UC4_KEYWORD=...][,YEAR_FROM=...][,YEAR_TO=...]

Parameters

Parameter Description Format Allowed Values Default Value
CALENDAR_ID= ID of the SAP calendar to import. Must be exactly 2 characters. Script literal or AE name n.a. n.a.
TYPE=

(Optional)

Type of the SAP calendar to import Script literal or AE name
  • FACTORY — Factory calendar
  • HOLIDAY — Public holiday calendar
FACTORY
FOLDER=

(Optional)

Path of the folder in the AE client where the Calendar objects are stored.
Note: Specify the path without a leading root folder, in the format /<sub-folder>/.../<folder>.
Script literal or AE name n.a. Root folder of the AE client in which the job was started
UC4_CALE=

(Optional)

Name of the Calendar object. If the object does not yet exist, it is created. If it already exists, only the Calendar key is updated. Script literal or AE name n.a. CALE.FROM.%SID%
UC4_KEYWORD=

(Optional)

Name of the Calendar key used to store the days from the SAP calendar. If the Calendar key already exists, it is overwritten. When YEAR_FROM= and YEAR_TO= are specified, only the days within that period are deleted before the import. Script literal or AE name n.a. The ID of the SAP calendar
YEAR_FROM=

(Optional)

First year from which SAP calendar entries are imported Script literal or AE name n.a. Unlimited
YEAR_TO=

(Optional)

Last year until which SAP calendar entries are imported Script literal or AE name n.a. Unlimited

Examples

The following example imports the US public holiday calendar from SAP and stores the days for the year 2021 in the Calendar object CALE.US under the Calendar key USA.

R3_IMPORT_CALENDAR CALENDAR_ID='US',TYPE='HOLIDAY',FOLDER='/TEST/CALE',UC4_CALE='CALE.US',UC4_KEYWORD='USA',YEAR_FROM='2021',YEAR_TO='2021'

See also: