Ansicht
Dokumentation
RFSCAL_UPLOAD - Load Public Holidays
PERFORM Short Reference SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
Purpose
You can use report RFSCAL_UPLOAD to upload public holidays received in file format from an external provider (such as Exchange Data International or Copp Clark) into the SAP system and overwrite or supplement the public holidays and public holiday and factory calendars defined in the Customizing activity Maintain Calendar.
This additional public holiday data is usually offered for financial centers.
The report supports the following alternatives:
- You upload an additional year to a calendar that already exists in the SAP system.
- You upload a calendar that does not currently exist in the SAP system.
- You upload an additional public holiday to a calendar that already exists in the SAP system.
- You delete a public holiday from a calendar that already exists in the SAP system.
- You adjust a public holiday in a calendar that already exists in the SAP system.
Integration
In order to minimize as far as possible the number of public holidays in the SAP system after a file has been imported and to allow reuse, the system identifies the public holidays by name using the Business Add-In (BAdI) FSCAL_HOLIDAY_IDENTIFICATION. For more information, see the documentation for the BAdI.
Prerequisites
- The file being imported has the file format .csv or .txt and has exactly the following structure: financial center ID, currency key, country key, financial center, location code, calendar year, date of public holiday, week day of public holiday, name of public holiday, file type. The fields must be separated from one another by a single-digit separator. A tab cannot be used as a separator.
- The file can contain a header. The header can appear any way you want.
- The file being imported contains all the public holidays for the entire calendar year.
- The public holidays and public holiday and factory calendars already entered in the SAP system are uniquely identified by an ID. If you want to enter new data for these calendars, you have to map the calendars in the file being imported to the calendars that already exist in the system. You have to do this in the mapping table using transaction FSCAL_MAP before you start importing data.
- When it creates new factory calendars in the SAP system, the report generates the calendars with working days from Monday to Friday. If you want to use the report to upload a calendar whose working days do not run from Monday to Friday you must first define a factory calendar with the relevant properties in the SAP system.
A row of the input file is split at the separator. The individual values are transferred to target fields with the following properties:
| Column | Type | Length | Example | Note |
|---|---|---|---|---|
| Financial Center ID | CHAR | 10 | 126 | |
| Currency Key | CUKY | 5 | JPY | |
| Country Key | CHAR | 2 | JP | |
| Financial Center | CHAR | 60 | Tokyo | |
| Location Code | CHAR | 5 | TYO | |
| Calendar Year | NUMC | 4 | 2021 | |
| Date of Public Holiday | DATS | 8 | 20210211 | Date in YYYYMMDD format |
| Week Day of Public Holiday | CHAR | 10 | Thu | |
| Name of Public Holiday | CHAR | 128 | National Foundation Day | |
| File Type | CHAR | 2 | B |
Example of a row in the file containing the above data (the separator is a comma):
- 126,JPY,JP,Tokyo,TYO,2021,20210211,Thu,National Foundation Day,B
- CenterID,ISOCurrencyCode,ISOCountryCode,FinancialCentre,UN/LOCODE,EventYear,EventDate,EventDayOfWeek,EventName,FileType
Features
Selection
Standard Variants
Output
Activities
- Use the file directory to select the file to be imported based on whether you are starting the report in dialog mode or as a background process (File Name (Present. Server) (dialog mode) or File Name (Application Server) (background process)).
- In the Separators field, specify which separators are used in the file being imported. A comma is entered by default.
- You can select a Shift ID.
- You can select either Load Calendar Data or Load Weekend Days as Work Days to indicate whether the file being imported contains new and changed public holidays and public holiday calendars or is only uploading working days on the weekend to a calendar.
- You need to enter a transport number only if you are running the report with the Load Calendar Data mode and as an update run. This then means that all the calendars are written to a workbench request.
Result
The system generates a log during both an update run and a test run. If there are no errors during an update run, the system updates the SAP standard calendar information in transaction SCAL.
The system creates all the new public holidays created during the file download with the type "Floating Public Holiday" (rule U).
Note: If a public holiday that does not have the type "Floating Public Holiday" is reused, the system ignores the data for this public holiday in the file being imported.
Example
General Material Data PERFORM Short Reference
This documentation is copyright by SAP AG.
Length: 7595 Date: 20240520 Time: 131304 sap01-206 ( 98 ms )
