High- Level Specification

Functional Overview

Syensqo uses Descartes (3rd party system) which is the market-leading global trade content for GTS that provides the most current regulatory data for Customs Classification Codes. HTS (Harmonized Tariff Schedule) codes are used to classify imported and exported goods. The first six digits are the international Harmonized System (HS) code, and the last four are specific to the U.S. and its import duties and statistical categories. New classification codes are always provided by Descartes on a regular basis via XML files.

The purpose of this integration specification is to automatize the process by, extracting the list of HTS (commodity & tariff codes) customs classification codes published by the Government from Descartes's website and upload it to GTS. The update should occur when a file is provided by Descartes. Updates can be received on a daily basis, hence the set up of the program will be marked as daily to do the file movement. The files will be taken from the directory path within Descartes website in a zip format. The files are supposed to the stored after successful upload to GTS system - audit purposes (the upload program to the GTS system is covered within FS: ERP-720).

Scope and Objectives

While GTS is the leading system for classification codes and product assignment, this step is the prerequisite before classifying any product and before any export can happen in the system. 

The emails that Descartes is sending to GTS IT team with the new classification codes will be replaced by this new automatization which follows one straight objective: to reduce the workload of man/hour which involves emails, dependency on an user action/availability or knowledge transfer within the team.

With the 3 different instances of GTS system for US, China and Rest of World, the HTS file must be available in all systems for the product-classification codes to happen.

Process Flow Diagram

eyJleHRTcnZJbnRlZ1R5cGUiOiIiLCJnQ2xpZW50SWQiOiIiLCJjcmVhdG9yTmFtZSI6IkVQQVNJTkdIRS1leHQsIEthcGlsYSIsIm91dHB1dFR5cGUiOiJibG9jayIsImxhc3RNb2RpZmllck5hbWUiOiJFUEFTSU5HSEUtZXh0LCBLYXBpbGEiLCJsYW5ndWFnZSI6ImVuIiwidWlDb25maWciOiJ7fSIsImRpYWdyYW1EaXNwbGF5TmFtZSI6IiIsInNGaWxlSWQiOiIiLCJhdHRJZCI6Ijk2MTM2NTMxNCIsImRpYWdyYW1OYW1lIjoiUHJvY2VzcyBGbG93IC0gU2VxdWVuY2UgRGlhZ3JhbSIsImFzcGVjdCI6IiIsImxpbmtzIjoiYXV0byIsImNlb05hbWUiOiJFUlAtNzE4IEludGVncmF0aW9uIFByb2Nlc3MgLSBVcGxvYWQgQ3VzdG9tcyAoSFRTKSBDbGFzc2lmaWNhdGlvbiBDb2RlcyBEZXNjYXJ0ZXMgdG8gR1RTIiwidGJzdHlsZSI6InRvcCIsImNhbkNvbW1lbnQiOmZhbHNlLCJkaWFncmFtVXJsIjoiIiwiY3N2RmlsZVVybCI6IiIsImJvcmRlciI6dHJ1ZSwibWF4U2NhbGUiOiIxIiwib3duaW5nUGFnZUlkIjo5NTI3MjA3NTgsImVkaXRhYmxlIjpmYWxzZSwiY2VvSWQiOjk1MjcyMDc1OCwicGFnZUlkIjoiIiwibGJveCI6dHJ1ZSwic2VydmVyQ29uZmlnIjp7ImVtYWlscHJldmlldyI6IjEifSwib2RyaXZlSWQiOiIiLCJyZXZpc2lvbiI6MSwibWFjcm9JZCI6IjZkZTBmYWVlLTQxZmQtNDE4Yi05MDllLTYwZDVkY2ZhMzUzNyIsInByZXZpZXdOYW1lIjoiUHJvY2VzcyBGbG93IC0gU2VxdWVuY2UgRGlhZ3JhbS5wbmciLCJsaWNlbnNlU3RhdHVzIjoiT0siLCJzZXJ2aWNlIjoiIiwiaXNUZW1wbGF0ZSI6IiIsIndpZHRoIjoiOTMxIiwic2ltcGxlVmlld2VyIjpmYWxzZSwibGFzdE1vZGlmaWVkIjoxNzY1NDYyNDY3MjYxLCJleGNlZWRQYWdlV2lkdGgiOmZhbHNlLCJvQ2xpZW50SWQiOiIifQ==

Assumptions

1. SAP Cloud Platform Integration connectivity is available.
2. SAP GTS E4H system is available at the time of extraction.

Dependencies

Descartes must published first the XML content for HTS codes.

Security, Integrity and Controls

• Connection to Descartes to retrieve files will use SAP Integration Suite Middleware CPI (download zip, unzip, upload) using secure protocols.

Configuration Requirements

N/A

Special Requirements

Overwriting should be possible. Whenever there is an emergency and cannot wait for the interface program to run, the GTS IT user can login to the FTP server, download the XML file and then upload the file to GTS manually.. However, at the next run of the program this should overwrite the entries stated by the GTS IT user.

Design Rationale

Existing process is a manual upload of HTS XML files on a regularly basis into GTS and it needs to be replaced by this automated solution (run on a daily basis).

• The CPI middleware will handle the file from FTP and push it to GTS (S/4 instance).
• Connection details:
  • SFTP Server: sftp://download.custominfo.com
  • Directory Path: /E4H/<Country Name> - i.e. all subfolders except for E4H/Dual User and LDR
  • Filename: E4H_HS*_<EXP/IMP>_EN_v*_U*.zip - See table below for the file list for each country

• Inside each of the relevant .zip files there are XML named such as this example "E4H_HSCH13VL_IMP_EN_DTR_v00172_U_001003". Do no take pick up these XML for upload, as they will all fail, the upload program is different as they are custom duty rates relevant - i.e. Any file with "DTR" should be ignored. 

Note1: Any future country that might show up on E4H directory which is not listed below should also be picked up too; if the case, and same applies for the .zip files inside the subfolders.

• The parent directory contains all XMLs stored in format .zip. 
• The program should download the .zip folders, unzip it and upload the XML files one by one or multiple files at once in GTS.
• If error appears during integration process, a notification should be send to the GTS IT users (see Interface Alert & Monitoring chapter).
• Once files are successfully uploaded, these should be archived inside GTS system.

Note2: always upload the latest version of the zip file. If at the time of the extraction the version number is same as per the last run program should end - no action.

Data Structure

N/A

Source Structure

The following fields will be used to provide the required information for this interface:

Target Structure

The following fields will be used to provide the required information for this interface:

Mapping and Calculation

N/A

Processing Logic

Processing within Source

For this integration there will be no processing within the Source. 

Processing within Middleware

CPI will pass the file without modification or transformation.

Processing within Target

The files will not be modified in the target but placed directly in the file server without any transformation. This interface will also trigger the custom proxy developed as part of ERP-720.

The files fetched from the data provider will be uploaded to GTS system using standard transaction /n/SAPSLL/LLNS_UPL101.

Interface Dependency

N/A

Interface Constraints

Upon polling, if CPI finds an updated file in Data Provider (Descartes) SFTP, it will be processed. The check is required to be done on a daily basis.

Descartes does not provide a Test or Dev tenant, so all CPI and GTS tenants will connect and access the Production Descartes SFTP.

Delivery Requirements

This interface should work like a batch program which runs on the same time every day (TBD the time of the daily run).

Delta or Full Load Requirements

During cutover activities, the first upload will be considered as the initial upload for HTS XML classification codes.

After that, the rest are considered delta, whenever new codes shows up or changes, where this custom integration process will be used.

Interface Alert & Monitoring

Technical alerts are sent to the GTS IT super user team listed under sco-digops-gts@syensqo.com in case the interface face any issues. 

CALM interface alerts are send out if the interface has an issue allowing users to monitor and manage system.

Interface Reporting

N/A

Language Requirements

English

User Interface Requirements

N/A

Volumetrics

The zip files can be up to 10MB. 

Daily load must take place for all the XML files available under the folders specified within Design rationale chapter. At this moment is known that for Japan, Europe and Korea there will be 2 files/day (note that this can vary depending on the content provider website). In total there are around 26 countries for the execution.

Performance Consideration

For the XML size, reach out to the owner of the FS to get the details to login to Descartes website and to do the technical check.

Error Handling

When a file has errors during upload the file is not archived from the directory. A notification is sent to the GTS IT user to check the error. Worst case, the user must upload manually the XML and do correction manually in GTS.

Log requirements (Is there a log that shows the job has run?):

1. Extract - Not able to access folder → notification via Fiori Launchapd to the GTS IT users
2. No file available at the time when the custom program is scheduled to run →  End program.
3. Always upload the latest version of the zip file. If at the time of the extraction the version number is same as per the last run  → End program.

Testing

How to Test

The Integration depends on the files in Descartes Production system are updated. Therefore testing of the integration will be limited to the initial run of files. Once Descartes provides updated files, the data can be validated

Test Conditions and Expected Results

Test Considerations/Dependencies

Test the file interface program and then test the standard transaction to upload the file to GTS system.

Other Information

Development Details

Package

Other Development Objects

Appendix

See also

Change log