Status

Owner
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

Implementing SystemS/4 HANA RoW, S/4 HANA CUI, S/4 HANA CHINA
Invoked by/InvokesLink to any Integration Process spec which is related to this System Interface, e.g. because it is invoking this interface, or because this interface is sending data to it. 
Business Process Reference09.07.01.05. Manage General Ledger Period Close


Functional Overview

BlackLine has been chosen as the application that will be used for account reconciliation post period-end in Syensqo. Account reconciliation is a process whereby G/L account balances will be substantiated and certified by accountants to ensure control of a company’s accounts. In Syensqo this only refer to balance sheet accounts. Each G/L will be assessed as to how often it needs to be reconciled based on the account’s perceived risk and the entity’s complexity.  This is performed as a monthly exercise for Syensqo company codes in SAP S/4 HANA

In order to enable account reconciliation in BlackLine, G/L account balances will be extracted from SAP S/4 HANA once the accounting period has been closed as part of the period-end process. 

There are three methods of integration between SAP S/4 HANA and BlackLine that available:

  1. File-Based Integration. This method is by exporting financial data in structured file formats (CSV, XML, or TXT) and transfers it to BlackLine via Secure File Transfer Protocol (SFTP). BlackLine then process this data for reconciliation and reporting. Although this is simpler to setup however it prone to error and requires robust error-handling mechanisms

  2. SAP Connector for BlackLine. BlackLine offers a pre-built SAP-certified connector that enables seamless integration with SAP S/4 HANA. This connector automates data extraction and transmission without manual file handling. In Syensqo this is the method that will be used and described in this document

  3. API-Based Integration. BlackLine also offer organizations that seek a more dynamic and real-time integration to use API. SAP S/4 HANA's RESTful APIs (SAP BTP, SAP API Business Hub) facilitates direct communication with BlackLine's API endpoints. In Syensqo the extraction is only once after period-end close hence it does not necessitate to have this method for real-time data processing

The purpose of the SAP Connector is to provide easy-to-use interface that enables configuration to automatically extract data from S/4 HANA systems and formats the data to be compatible with BlackLine. The SAP Connector retrieves data related to account balances and transactions from the SAP S/4 HANA instance. Once the G/L account balances are retrieved, the SAP Connector formats the data into BlackLine’s specifications in order for the data to be imported for use in BlackLine’s Account Reconciliation. 

Scope and Objectives

The execution of the account balances extraction will be scheduled as a centralised batch job running on after period end close (WD+3 – to be confirmed before batch job creation).

Process Flow Diagram

Step

Description

Comment

1

Work Day 3 (D3) 18:00 Local Time Period Close

The extraction will be triggered from AFC to run once G/L Accounting period for IFRS ledger is fully closed in S/4

2.1

Extract Account Balances (including subledgers) to BlackLine 

SAP Connector extracts and format the account balances from S/4 for the entities/region on the day accounting period has been closed in S/4

2.2

Receive data in BlackLine from S/4 

SAP Connector send the data from S/4 in pre-formatted result for BlackLine

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

It is assumed that business will not start with the preparation of account reconciliation before the periods have been closed in S/4. This has been endorsed from Signavio L4 process review with SME

Dependencies

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.

Month end closing needs to be completed before the extracts can be run. Extracts will be run centrally via a batch job after D3 18:00 Local Time to ensure the data is complete and final.

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.

S/4 HANA

Transaction codes and programs for configuring and extracting the data from S/4 HANA to BlackLine should only be granted to BlackLine administrator. As there are no standard Fiori Apps available for Blackline extract transaction codes, General Ledger Accountant will not be having access to these transaction codes. The batch job triggered from AFC will be executed by Remote Processing User Group that will have access to Blackline extractor programs

BlackLine


Configuration Requirements

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

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 the custom API design. The requirement can be for an API provider which means the API will be designed in the system or can be for an API consumer which means that an API will be consumed in the system.

API Use

Populate the type of the API use  in this section. Will the API be Consumed or Provided. 

Data Structure

The following fields will be used to provide the required data structure of the interface:

ParentFieldDescriptionMandatory (Y/N)Data Type











Calculation and Validation

Populate the table below to list the calculation and validation rules per field. Can be deleted if not needed.

ParentFieldRule TypeRule Instruction












eDocument mapping

Populate the table below to list the mapping for edocument implementations. Can be deleted if not needed.

GeneralSyensqo XML (Intermediate Target)SAP eDoc Standard Mapping (Source)Custom Mapping (Source)
S-NRFlow (SD/FI/MM/ALL)Target FieldTarget Field DetailsConditionSyensqo XML NodeSyensqo XML FieldSAP eDoc Standard NodeSAP eDoc Standard FieldFixed ValueCustom Logic




Conditional / Mandatory Header / Header Tax / Header Value / Header Extension / Sender / Sender Extension / Receiver / Receiver Extension / Item / Item Tax / Item Value / Item Extension















Processing Logic

Describe the processing requirement in the System


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, i.e. AIF

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. 

Sequencing

Please describe delivery requirements driven by message sequencing, i.e. specific order, impact of disruption of sequence, are duplicates allowed, etc.


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