Status

OwnerTATARU-ext, Eugenia 
Stakeholders

CASTELEIRA, Patricia @Massimo Lietaert

Jira Request IDERP-496
Jira Development IDERP-716

High- Level Specification

ParameterValue
Application System (Source)Descartes FTP Website
Application System ( Target)SAP GTS E4H
Business Process Reference12.02.01.01. Manage Classification Codes

Functional Overview

Syensqo uses Descartes which is the market-leading global trade content for GTS to provide the most current regulatory data for Compliance Classification Codes Export Control on EARUS. This data provider is a 3rd party system for SAP GTS. New classification codes are provided by Descartes regularly within XML files.

The purpose of this interface is to automatize the process, by pulling & uploading the list of EARUS compliance classification codes published by the Government into SAP GTS. The update should occur when a file is provided by Data provider Descartes. Updates can be received on a weekly basis, hence the set up of the program will be marked as weekly.

Whenever an error occurs via the automatic interface, IT GTS users will get a notification within Fiori Launchpad in order to troubleshoot the problem (manual intervention).

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 EARUS file must be available in all systems for the product-classification codes to happen.

Detail the functional scope and objectives of the Interface. Please also describe the gap that will be addressed by this interface (Compared to SAP Standard)

Process Flow Diagram

Insert the flowchart and fill in the steps

Step

Description

Comment

1

EARUS XML codes published by Descartes


2

File interface program to fetch the EARUS XML file and place it in the application server


3

Upload to GTS system using the standard transaction /n/SAPSLL/LLNS_UPL002


4

Notification is send to the GTS IT users if successful/failed


5

If upload fails, log the details of the upload and GTS IT users to troubleshoot the error


Assumptions

  1. SAP GTS E4H system will be available at the time of execution.
  2. SPL legal regulation will be configured in GTS system.
  3. Upload logs will be generated.
  4. Notification functionality will be handled by standard GTS Fiori Launchpad.

Describe any assumptions that have been made in the process of completing this design. What functionality is expected of configuration or other developments that pass information to this development and/ or retrieve the information processed by it (performance, triggers, exceptions, etc.)

Dependencies

Descartes must published the XML for EARUS.

Indicate any dependencies or constraints that may impact development, in terms of requirements from internal or external applications or teams, limited access to legacy systems, time constraints or data restrictions. Also, please specify schedule dependencies e.g. interface or batch jobs that must run prior to execution.

Security, Integrity and Controls

Security Considerations for the Integration are:

  • Connection to Descartes to retrieve files will use SAP Integration Suite Middleware (zip, unzip, download).
  • Uploading the file to an accessible file server (to be accessed by the Standard Program) is to be done securely through Cloud Connector.

To detail the security requirements for processing this object, any data integrity issues associated with the object and the teams that will be responsible for processing the object, i.e. authorization/roles required to who can execute the interface, encryption requirement, etc.

Configuration Requirements

You have made the following settings in Customizing for the GTS system:

  • You have defined numbering schemes in Customizing for the general settings. The numbering scheme contains the underlying structure for the numbers. 

  • You have defined and configured the necessary legal regulations in Customizing and activated them for the application areas.

  • You have set up system communication.

  • You transferred products from your feeder system to the GTS system.

Specify the configuration requirements for this object. Like in case of substitution/ routine specify the configuration needed

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.

Specify any special requirements or considerations that may impact the interface based on specific locations, regulatory compliance or system limitations. Clearly outline requirements e.g. localization rules for countries like China

If the interface interacts with third-party systems such as Icertis, describe any additional integration, security or authentication considerations that must be taken into account.


Design Rationale

This template section may be used to specify an integration flow design between two systems.

Data Structure

Source Structure

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

FieldDescription





Target Structure

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

FieldDescription




Mapping and Calculation

Populate the table below to list the target / source data field mapping between the Source system and Target system

Source TableAPI or Portlet NameSource FieldRequired (Y/N)DescriptionTarget FieldAPI or Portlet NameTarget FieldRequired (Y/N)DescriptionRule TypeRule Instruction




































Processing Logic

Processing within Source

Describe the processing requirement from Source System


Processing within Middleware

Describe the processing requirement within Middleware Layer


Processing within Target

Describe the processing requirement from Target System

Interface Dependency

Please describe any dependency to other interfaces, e.g. messages of interface x need to be processed before message processing of interface y can start.

Interface Constraints

Please describe any limitations on source and targets. i.e. target system can only accept maximum 100mb files, first-in-first-out, etc.

Delivery Requirements

Please describe delivery requirements driven by business. i.e. real time, batch, scheduled, synchronous, triggering requirement, push or pull, etc.

Delta or Full Load Requirements

Please describe change tracking requirements, i.e. transferring only delta, or always full load

Interface Alert & Monitoring

Please describe any alert & monitoring requirement for business users and support organization

Interface Reporting

Please describe any reporting requirement that is expected to be provided in support of this interface

Language Requirements

Specify multi language requirements

User Interface Requirements

Capture the requirements for the user interface (UI) associated with the interface. It should provide a clear description of how users will interact with the interface and how information will be presented to ensure usability and accuracy.


Volumetrics

Provide volumetrics details: Initial load volumes, Number of Records, Expected Frequency, Expected Long term Growth)



Performance Consideration

Specify if there are any specific performance factors that need to be taken into consideration during development i.e. interface must be able to handle 100 posting per-hour, etc.



Error Handling

Detail how errors will be handled: Notification, Restart/ Recovery and Re-Processing Procedures



Testing

How to Test

Please provide some guidance and/or test data to help the developer unit test the interface. Please include both positive and negative testing (to validate error situations handling)

The developer will need to test repeatedly, so where appropriate provide instructions to reverse the actions performed so the test may be run again, or explain how to create new input data to the test. In particular, the developer will need logons for test users representing the various roles within the approval process.

Test Conditions and Expected Results

IDConditionExpected Results






Test Considerations/Dependencies

List any considerations essential for application test planning (e.g., test this before ABC along with DEF separate from GHI). If the development encompasses a user interface, explain how to test it. List any insights as to how this component could be tested the most efficiently.



Other Information


Development Details

Package

Package NameParent Package




Other Development Objects

Object TypeObject NamePurpose/High Level LogicDesign Rationale Reference









Appendix


See also

Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.


Change log