Status

OwnerROWLINSON-ext, Kerry 
StakeholdersThe business stakeholders involved in making, reviewing, and endorsing this decision. Type @ to mention people by name
Jira Request ID

Jira Development ID

High- Level Specification

ParameterValue
Application System (Source)Icertis Contract Intelligence
Application System ( Target)SAP ERP (PF2) & SAP ERP (WP2)
Business Process Reference03.04.04.01. Manage Outline Agreements (R2)

Functional Overview

The functional design of the Integration Process defines both inbound and outbound interfaces. An integration defines a specific physical interaction that will need to occur between the system and an external application in response to some business event. 

Icertis Contract Intelligence is the contract management and authoring application for Syensqo's purchase contracts. Purchase orders are created in S/4 HANA with reference to purchase contracts (outline agreements). The key information from the legal contract which is relevant for procurement forms the basis of the purchase contract or outline agreement in S/4 HANA.  For release 4, the integration between Icertis and S/4 HANA will be more complete and automated. However, for release 2 the option for a 'light' integration was decided due to the limitations of the two SAP ECC systems and in particular the substantial existing custom logic which needed to remain unaffected by any changes.

The 'light' integration consists of three main parts:

  1. Maintaining the relationship between the Icertis Contract ID and the SAP outline agreement number.
  2. The ability to report where there are inconsistencies in the data between the two systems.
  3. The ability for users to update the Icertis Contract ID on the SAP outline agreement.

When an agreement in Icertis is executed an event in ICertis is initiated and the agreement data is received to CPI (Cloud Platform Integration). Events for Amendment Execution, Renewal and Termination require development within Icertis in order to be initiated and for the data to be received to CPI and then to the SAP ECC systems (PF2 and WP2). 

??? How to describe the method by which the data makes its way to Z table


Scope and Objectives

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)

The objective of the interface for release 2 is to provide a functional relationship between the Icertis Contract and the SAP outline agreement to enable consistency of the data to be reported and therefore maintained. The business users will manually create and change the outline agreements as a result of contract executions, amendments, renewals and contract terminations.

The entry and update of the contract data in the custom table enables:

  1. Validation that the correct Icertis Contract ID is entered on the outline agreement.
  2. Reporting any key header data from the outline agreement which is not aligned with the corresponding data in Icertis.
  3. Enables identification of orphan outline agreements which do not have an Icertis Contract ID assigned.

Process Flow Diagram


Insert the flowchart and fill in the steps

just up to the Z table entries

just steps - link

Step

Description

System

Comment

1

A purchase contract is executed in Icertis

Icertis

A legal purchase contract is executed in Icertis

2

Line items are downloaded from Icertis

Icertis

The user downloads the line item details from Icertis to assist in the future upload of the outline agreement

3

New entry in custom table for the Icertis Contract

SAP ECC

Integration automatically creates the Icertis Contract record in custom table in both SAP ECC systems (WP2 & PF2) with the Icertis Contract ID and the relevant data fields from the contract header.

4

An amendment to a contract in Icertis is executed

Icertis

An amendment for an existing contract is executed in Icertis.

5

Change entry in custom table for the parent contract of the amendment

SAP ECC

The existing entry in the table for the parent agreement of the amendment is located and the relevant fields in the table are overwritten with the values provided in the amendment.

6

A renewal of an existing contract in Icertis is made.

Icertis

An existing purchase contract in Icertis is renewed which updates the overall value and the validity end date.

7

The entry in the custom table for the contract is updated.

SAP ECC

The existing entry in the table for the purchase contract is updated to reflect the changes to the overall value and the validity end date.

8

An existing purchase contract in Icertis subject to automatic renewal is renewed.

Icertis

An existing purchase contract in Icertis is renewed automatically when the renewal date comes due which updates the validity end date.

9

The entry in the custom table for the contract is updated.

SAP ECC

The existing entry in the table for the purchase contract is updated to reflect the changes to the validity end date.

10

An existing purchase contract in Icertis is terminated.

Icertis

An existing purchase contract in Icertis is terminated which updates the validity end date and the status in Icertis.

11

The entry in the custom table for the contract is updated.

SAP ECC

The existing entry in the table for the purchase contract is updated to reflect the changes to the validity end date.

Assumptions

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

ERP-151 : Small adjustment based on DOA changes 

In order to correctly fill the target value ERP-151 enhancement is being made in Icertis to consolidate the total value of the amendments. In addition to ensure the currency of the contract is passed to SAP, the logic is being adjusted so that it uses the local agreed currency instead of defaulting to EURO.



Security, Integrity and Controls

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

There are no specific configuration requirements for this interface.

Special Requirements

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
put labels name
if a standard field get it's correct label and name and put technical field name in

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)Description

Target 
Table

API or Portlet Name

Target Field

(Label)

Required (Y/N)DescriptionRule TypeRule Instruction


ICM Tenant IDYUnique ID that defines purchase contracts within IcertisZ*
Icertis Tenant IDY

middleware rule - filtering, dates formatting


CONTRACTTYPENAMEY
Z*
Contract TypeYIN TARGET FIELD put the label for the field from SAP



NAMEY
Z*
Contract NameY




ICMAGREEMENTCODEN
Z*
Contract IDN




SYSIDN
Z*
System IDN




PARENT SYS IDN
Z*
Parent System IDN




PARENT AGREEMENTN
Z*
Parent Contract IDN




ICMSUPPLIERSAPIDN
Z*
Supplier's Account NumberN




ICMEFFECTIVEDATEN
Z*
Start of Validity PeriodN




ICMEXPIRYN
Z*
End of Validity PeriodN




ICMTARGETVALUEN
Z*
Target Value for Header Area per DistributionN




ICMCURRENCYN
Z*
Currency KeyN




ICMLEGALENTITYCODEN
Z*
Company CodeN




ICMPURCHASINGGROUPN
Z*
Purchasing GroupN




ICMPURCHASINGORGN
Z*
Purchasing OrganizationN




ICMCONTRACTOWNERN
Z*
Contract OwnerN




ICMINCOTERMN
Z*
IncotermsN




ICMPAYMENTTERMSN
Z*
Terms of Payment KeyN


Processing Logic

Processing within Source


Describe the processing requirement from Source System

check with Wytse if there is any in Icertis


Processing within Middleware


Describe the processing requirement within Middleware Layer

refer to the mapping sheet


Processing within Target


Describe the processing requirement from Target System

not applicable

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