High- Level Specification

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's case, the extraction is only once after period-end close hence it does not necessitate to have this method for real-time data processing

Scope and Objectives

Scope of the SAP connector for Syensqo is to facilitate Account Reconciliation which is one directional flow from S/4 HANA to BlackLine system.  There are other BlackLine products (Journal Entry, Transaction Matching, etc) however they are either not use or not part of Syensqo's licensed

The objective of the implementing SAP Connector is to provide an 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 (including subledgers) 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.  

Process Flow Diagram

Assumptions

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

Month end closing needs to be completed before the extracts can be run. BlackLine extraction Batch jobs will be triggered automatically following successful completion of Full Closure task (planned on D3 18:00 local time) in Advance Financial Close (AFC) at month-end to ensure the data is complete and final.

Security, Integrity and Controls

S/4 HANA

Transaction codes and programs for configuring data from S/4 HANA to BlackLine should only be granted to BlackLine administrator.

Configuration transaction codes:

• /BLACKLIN/MENU            Blackline main configuration page
• /n/BLACKLIN/SRV_DIR     configuration to whitelist (register) the server path where the extracted file is placed  
• /n/BLACKLIN/BL00           configuration to enable segment combination 
• /n/BLACKLIN/BLUC          configuration to setup user-defined parameter categories
• /n/BLACKLIN/BLUV          configuration to setup user-defined parameter values

Transaction codes for extracting data from S/4 HANA to BlackLine are part of General Ledger Accountant role.  As there are no standard Fiori Apps available for Blackline extract transaction codes, Fiori wrappers will be created for those. It is mandatory for the General Ledger accountant to have access for these transactions in order to trigger automatic execution of extraction tasks as Processing User Groups in AFC.

Data extract transaction codes:

• /BLACKLIN/BL01               Standard G/L extract
• /BLACKLIN/BL10               AP Subledger extract
• /BLACKLIN/BL11               AR Subledger extract
• /BLACKLIN/BL12               AA Subledger extract
• /BLACKLIN/BLMM            MM Subledger extract

BlackLine

(Refer to Config Workbook DD - FUN - 030 Configuration Workbook (SAAS) - R2R - Blackline.docx)

Configuration Requirements

The SAP extractor programs provided by Blackline require some functional configurations. Functional configuration is setup by SyWay implementation team until go live and maintained by Syensqo BlackLine administrator going forward

• BlackLine - Segment Combination Configuration (T-code: /BLACKLIN/BL00)
  This transaction code provides the access within S/4 to define the Sort Order Mapping for the fields included in all data extracts. This configuration controls how the data is positioned within the extract files. These positions correspond to the Segment Combination Configuration setup in BlackLine application. This setup is generally a one-time setup. There are ten (10) sort positions which can be defined in the extract, in which sort order position #1 and #2 by default are company code (BUKRS) and G/L account (SAKNR).  Syensqo will be keeping the default position#1 and #2 with additional two sort order being: House Bank, and House Bank Account.  These sort order are setup as "Normal key Fields" which will appear in the extract transaction codes as "additional selection parameters".  These key fields will also be setup in BlackLine application as "Enabled and part of key" on Import Configuration setting under Segment Combination Configuration. Note: If the fields activated as “User defined parameters” as opposed to "Normal Key Fields", the field will appear as “Categories”
• BlackLine - User Defined Categories and Value (T-code: /BLACKLIN/BLUC and /BLACKLIN/BLUV)
  In conjunction with BlackLine - Segment Combination Configuration in S/4, if any of the fields are setup as "User Defined Parameters" then using these transaction codes, user can define the descriptions (labels) and values for those categories
  This is not being considered for SyWay as there is no requirement for enriched data

• BlackLine - Authorised server locations  (T-code: /BLACKLIN/SRV_DIR).  This transaction code is required to whitelist server path where the extract files will be placed into. Failing to update this configuration, the extraction will show an error as " Directory XXXXX is not whitelisted"

Special Requirements

Design Rationale

API Use 

N/A

Data Structure

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

Processing Logic

An extraction program needs to be run in the source systems with pre-defined selection variants to start the extraction of the data for the respective accounting period. Once executed the file with the transactional data in it shall be transmitted to Blackline via ftp-connection

Delta or Full Load Requirements

As this is a data extraction tool, it will always use a full load process. Extraction volume can be controlled via selection parameters in the selection screen of the extraction program.

Interface Alert & Monitoring

The extraction will be triggered from AFC at month-end.

• When the task execution in AFC for BlackLine extracts are completed in error, General Ledger accountant (Processing Users) need to review the error log in AFC. If the error is technical error, users need to raise an Incident ticket to Syensqo SAP support. 
• When the task execution in AFC for BlackLine extracts are completed successfully, BlackLine Preparer roles will receive an email notification from BlackLine that the file is ready for account reconciliation. However if there is no notification received, BlackLine Business Admin will need to raise an Incident ticket to Syensqo SAP support  

See error handling section below

Language Requirements

The extraction program will always be executed as a batch job in the background by a batch user or as an ad-hoc run started by the Blackline administrator in SAP. As such it is not required to translate the selection screens of the provided program into other logon languages. The selection screen should contain meaningful field names in English only.

User Interface Requirements

Sequencing

Volumetrics

Per extraction run the volume of records will remain relatively stable. Increases to the data volume are only expected in case new company codes have gone into operation or new B/S G/L accounts are added to the operational Chart of Accounts used in S/4. Both are events that will not occur in a high frequency or have a material impact.
Volumetrics per extraction:
•    Number of Records: 30,000 records per extraction (Approx. 75 entities x 400 GL Balance Sheet accounts) for GL
•    Number of Records: XXX records per extraction for Subledgers (AP, AR, AA, MM)
•    Expected Frequency: monthly
•    Expected Long Term Growth: Records will grow by a factor of 400+additional records for each entity added.

Performance Consideration

Interface will only be required to extract data once a month. The account balances will be read from one source table and additional data will be read from a few master data related tables. The complexity of the extraction program is therefore very limited and as such no negative impact on system performance is expected.

Error Handling

Scenario 01 - Error during extraction 
Extraction Task ended in "error" state in AFC.  
Action: Review the error log in AFC. Rectify the issue and re-execute the program in AFC. If the error is technical error in nature (e.g. server path not whitelisted, unable to write to the server, etc), raise an Incident ticket to Syensqo SAP Support. Upon resolution from support team, the task to be re-executed from AFC to get status of the task as "Completed" 

Scenario 02 - Extraction file(s) available in dedicated server path (AL11), however no file(s) received at BlackLine
"Balance Loaded for New Period - Preparers" alert is not received by preparer. 
The expectation is that once the extraction tasks are completed successfully (AFC task shows Completed without Error), the file will be received in BlackLine instantly and BlackLine "Balance Loaded for New Period - Preparers" alert will be triggered and email received by Preparer. 
Resolution: Raise an Incident Ticket to Syensqo SAP Support. Support team to check outbound log and SAP OData API / RFC-enabled function module. Correct the error and resend the file by Syensqo SAP Support if the file stuck at middleware

Scenario 03 - Extraction file(s) received successfully in BlackLine however data is not complete / inconsistent
Upon reconciliation, preparers identify some data are missing (e.g. due to late adjustment posted after period is closed) 
Resolution: BlackLine Business Admin to re-initiate the ad-hoc extraction (may limit to the specific company code in issue) in S/4, confirm the new file received in BlackLine. 

Scenario 04 - If the issue requires BlackLine Support, raise the Incident via SAP Support Portal 
Syensqo account is licensed as an SAP Solution Extension (Solex) user. For Solex products, SAP manages the entire support process as the primary point of contact. This is part of the partnership agreement under which the solution is sold. Therefore, direct case creation in the BlackLine portal is not available for Solex users. The correct and official channel is to log all support requests directly through your SAP Support Portal. This process ensures that every issue is properly triaged by SAP first. If they determine the issue lies with the BlackLine component, SAP will escalate it directly to BlackLine specialized support engineers on Syensqo behalf. This structure prevents being bounced between support teams and ensures the issue is handled by the right experts from the start.

Testing

How to Test

Tests can be performed by running the extraction program to check whether the data file gets created and saved in the application server. From there a web service or any other file transfer protocol service can pick up the file and transfer it to the Blackline server. An import job can be started there to import the data sets into Blackline’s Account Reconciliation module. 
Quality of the extracted data in Blackline must be checked by functional consultant, this would be the end result of testing. i.e. that S/4 GL data is extracted correctly and agrees to the Blackline balances

Test Conditions and Expected Results

Test Considerations/Dependencies

• AFC Task List released for execution 
• Any S/4 company codes can be used as source data based on availability and completeness, ideally from a closed accounting period to verify the account balances after transmission

Other Information

Data Encryption

Blackline provides a encryption/decryption mechanism for the extracted data. This encryption ensures that the data extracted is the same data imported into Blackline. i.e. It cannot be manipulated.

Development Details

Package

Other Development Objects

Appendix

See also

Change log