Versions Compared

Version Old Version 5 New Version Current
Changes made by

Former user

Alec Berger

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Status
colourYellow
titleCUSTOMER GENERIC

Panel

Table of Contents

Disclaimer

...

You can either import a user-defined list of SAP calendar calendars using a csv file or all valid SAP calendarcalendars. The Calendar Import can be scheduled to be always in sync with SAP; for example, import all Calendar Calendars every day. It is also possible to import Calendars from a different SAP System.

Version Information


Template NameVersion
CS SAP Calendar Import1.3.0


Refer to Changelog for version history information.

Software Requirements

Software Requirements Universal Agents and Controller

  • Universal Agent for Linux or Windows Version 67.97.0.0 or later are required

Software Requirements Universal Controller

  • Universal Controller 67.97.0.0. or later is required

  • A Universal Controller license key with support for SAP connector is required

...

In order to connect to the SAP System, the SAP NetWeaver RFC SDK 7.50 libraries are required from SAP.

...

  • The Universal Task imports either a user defined csv-list or all SAP Factory- and related Holiday CalendarCalendars, which match the configured selection criteria into the Universal Controller.

  • The Calendar Import can be scheduled to be always in sync with SAP e.g. import all Calendar Calendars every day

  • The csv list is saved incl. Versioning into the Universal Controller script library

  • The Universal Task runs on Linux as well as Windows Universal Agents

  • The calendar export is done using the SAP certified XBP-RFC interface

  • SAP is always considered as the Master; Calendars are always export exported from SAP, never import imported to SAP.

  • You can configure if manually created Custom Days will remain when re-importing the calendar from SAP

  • All Calendar functionalities are support supported incl. Factory, Holiday and “Special Rules”

  • Calendar can be imported from different SAP System Systems - automatically the SID and Client of the SAP, where the import was done, is automatically added as a Postfix to the imported Calendar

  • You can set different log-levels for the Universal task, providing you more information in case of issues

  • Support for Application Server Connection and Destination Connection (nwrfc.ini) e.g. Load Balancer connections, SAP SNC, etc.

...

  1. This Universal Task requires the Resolvable Credentials feature. Check that the Resolvable Credentials Permitted system property has been set to true.

  2. Copy or Transfer the Universal Template file to a directory that can be accessed by the Universal Controller Tomcat user.

  3. In the Universal Controller UI, select Configuration > Universal Templates to display the current list of Universal Templates.

  4. Right-click any column header on the list to display an Action menu.

  5. Select Import from the menu, enter the directory containing the Universal Template file(s) that you want to import, and click OK.

...

| NRFWini )

Select the SAP Connection Type:

Application Server Connection or Destination Connection using the nwrfc.ini file.

Default location for the nwrfc.ini file
FieldDescription

Universal Controller URL

Universal Controller URL; for example,

Local Universal Controller:

http://192.168.88.10:8080/uc/

Stonebranch SaaS Cloud Universal Controller:

https://superstore.stonebranchdev.cloud/

Universal Controller Credentials

Credentials of the Universal Controller Webservice API

Import All Calendar

Yes | No

If “Yes” is selected, all SAP Calendar Calendars based on the selection criteria entered in the fields : Start Year and Years are imported.

If “No” is selected, the Calendar provided in the Calendar Input File will be imported to Universal Controller

Start Year

From this year onwards the Calendar will be imported from SAP.

Example: Start Year = 2020, Years = 2

will import all calendar calendars starting from 2020 until 2022

Years

Number of years to import starting from the year provide in the field Start Year.

First Day of Week

[ Monday,Tuesday, Wednesday, Thursday, Friday, Sunday ]

Set the first day of the week for the calendar

Calendar Input File

This field is only used when the choice field

import all calendar

Import All Calendar is set to No.

The Calendar Input File file has the following structure:

NOTE: If a factory calendar has no holiday calendar, then leave the filed empty; for example, 02, means extract factory calendar 02 without a holiday calendar.

The format is:

<Factory Calendar ID>,<Holiday Calendar ID>

Example: calendar_import.csv

factory_calid,holiday_calid
01,08
02,
AJ,04


Note
titleNote

If a factory calendar has no holiday calendar, then leave the field empty; for example, 02 means extract factory calendar 02 without a holiday calendar.


Language

SAP Language e.g. EN for English

Use SAP ConnectionCheckbox to select if a pre-configured Universal Controller SAP Connection should be used. 
SAP Connection

Universal Controller SAP Connection to use.

This field is only visible if Use SAP Connection is enabled.

SAP Connection Type

[ Application Server Connection

, SAPNWRFC.

INI Connection

]

The Universal Task supports SAP Application Server and SAPNWRFC.INI Destination connections.

Application Server Connection:

  • Client: SAP Client to connect to; for example, 100

  • SAP SysNr: SAP System Number; for example, 00

  • ASHOST: SAP Application Server hostname or IP; for example, walldorf

SAPNWRFC.INI Connection:

  • Client: SAP Client to connect to; for example, 100

  • Destination: name of the destination entry in the file sapnwrfc.ini; for example, walldorf

This field is only visible if Use SAP Connection is not enabled.


Note
titleNote

The file sapnwrfc.ini needs to be in the home directory of the user executing the task.

If no user credentials are provided, this is:

  • Linux: /opt/universal/uagsrv

  • Windows: C:\Program Files\Universal\UAGSrv


SAP Credentials

Credentials of the SAP System

SAP ASHOST

SAP Application to connect to.

This field is only visible in case of if Use SAP Connection is not enabled and SAP Connection Type = “Application Server Connection”Connection” 

SID

SAP System Identifier ( 3 digits ); for example, NPL

The Imported calendar will have the SID as prefix

Imported Calendar Name:

<SID>_<SAP CLIENT>_<SAP CALENDAR ID>

SAP CLIENT

SAP Client ( 3 digits ); for examaple, 100

The Imported calendar will have the SID as prefix

Imported Calendar Name:

<SID>_<SAP CLIENT>_<SAP CALENDAR ID>

SAP SysNr

SAP System Number ( 2 digits ) e.g. 00

SAP Destination

SAP Destination in the nwrfc.ini.

This field is only visible in case of if Use SAP Connection is not enabled and SAP Connection Type = “NRFW.ini Connection”

Loglevel

Universal Task logging settings [DEBUG | INFO| WARNING | ERROR | CRITICAL]

USAP loglevel

Loglevel of the Universal Connector for SAP

trace | audit | info | warn | error

Calendar Input File

This field is only used when the choice field import all calendar is set to No.

The Calendar Input File file has the following structure:

NOTE: If a factory calendar has no holiday calendar, then leave the filed empty; for example, 02, means extract factory calendar 02 without a holiday calendar.

The format is:

<Factory Calendar ID>,<Holiday Calendar ID>

Example: calendar_import.csv

factory_calid,holiday_calid
01,08
02,
AJ,04

Merge Custom DaysIf Merge Custom Days is enabled, manually created Custom Days will remain after re-importing the calendar from SAP.

Example: SAP Import SAP Calendar - Application Server Connection

Image RemovedImage Added

SAP Calendar Import Name

...

SID = NPL, CLIENT = 100, SAP Factory Calendar ID = 01



Changelog

 ut-sap-import-calendars-1.3.0 (2025-01-28)

Enhancements

  • Added: Support Variables for all Credentials and SAP Connection
  • Added: Support for Universal Controller SAP connection
  • Added: Keep manually created Custom Days when re-importing the calendar from SAP

ut-sap-import-calendars-1.0.0 (2021-05-26)

Initial Version