Data Applications → BlackLine Account Reconciliations for SAP S/4HANA

Using the Incorta BlackLine data application and data destination, you will have the edge to quickly ingest and integrate data using SAP S4HANA. Integrating SAP S/4HANA with BlackLine with packaged data templates for BlackLine Account Reconciliations will replace any manual processes and custom code, it will also refresh the data incrementally from the data source more frequently.

Through the Incorta BlackLine data application, you will have a consistent, single version of detailed data pulled up from multiple data sources. You can also drill down from summarized to detailed data.

Configure BlackLine as a data destination

Here are the steps to configure BlackLine as a data destination in Incorta:

  • Sign in to your Incorta cluster.
  • In the Navigation bar, select Data+ NewAdd New Data Destination.
  • Create a new BlackLine data destination. Refer to Concepts → Data Destination for more information.

Install the Incorta BlackLine data application

Here are the steps to install the Incorta BlackLine data application:

  • In the Navigation bar, select Marketplace.
  • Select the BlackLine Reconciliation for SAP S/4HANA data application.
  • Select Install.

SAPS4_BL_GL schema Schema Diagram

Available physical schemas and tables

The following describes the different schemas available in the data application and the usage for each table, along with its description and refresh mechanism:

Table NameDescriptionRefresh MechanismUsage
GL_PERIODSGL Periods Table (Source-CSV flat file)IncrementalUsed to Populate the Blackline Account Template
BL_ACCOUNTS_GROUPTable to store Account Groups details in Incorta from BlacklineFullUsed to enable drill from Blackline Accounts and Account Groups
FAGLFLEXT_BL MVMV populates GL Details from SAP S/4HANAIncrementalUsed to Populate the Blackline Account Template
FAGLFLEXT_SUMMARYMV consolidates GL DataIncrementalUsed to Populate the Blackline Account Template
T001Company Codes Master DataFullUsed to Populate the Blackline Account Template
T881Ledger MasterFullUsed to Populate the Blackline Account Template
SKB1GL Account Master (Company Codes)FullUsed to Populate the Blackline Account Template
CEPCProfit Center Master DataFullUsed to Populate the Blackline Account Template

Available views in the BlackLineDM business schema

Business View NameDescriptionUsage
AccountsA business view that has all the attributes needed in the Blackline reconciliation templateUsed in the dashboard to push Blackline accounts template data into Blackline SFTP location
AR TransactionsA business view that has all the attributes used in the GL details drill report for AR TransactionsUsed in the dashboard that drills down to GL details from Blackline Accounts or Account Groups
AP TransactionsA business view that has all the attributes used in the GL details drill report for AP TransactionsUsed in the dashboard that drills down to GL details from Blackline Accounts or Account Groups

Available Dashboards

The following describes the different dashboards available in the BlackLine data application and the usage for each dashboard along with its description:

Dashboard NameDescriptionUsage
Accounts for BlacklineA dashboard that has the data for the Blackline Account templateThis dashboard is used to format and schedule data transfers from SAP S4/HANA to the BlackLine data destination
AR TransactionsA dashboard has subledger drills for AR TransactionsThe dashboard that drills down to GL details from Blackline Accounts or Account Groups
AP TransactionsA dashboard has subledger drills for AP TransactionsThe dashboard that drills down to GL details from Blackline Accounts or Account Groups

Configurations

BlackLine additional configurations

If you need to enable additional navigation from BlackLine to Incorta to examine GL Journal details and sub-ledger drills.

Note

You must download the Enterprise version of the data application. Alternatively, you can use the SAP S4/HANA data application.

To achieve that, apply the following steps:

  • Use these schemas to create the joins in the following step:
    • SAPS4_AP
    • SAPS4_AR
  • In your BlackLine environment, do the following:
    • Download Group Accounts template from BlackLine (for all periods)
    • Go to reporting
    • Run the Account Template report
    • Select All Periods, then GL and Group Accounts
    • When the report complete, download it in a CSV format
  • Upload the file you downloaded in Incorta.
    Note

    For more information on how to upload the file, refer to Connectors → Data Files.

  • Load your data using full load mode

To maintain your data and keep it up-to-date, you must apply the following steps regularly:

  • In your BlackLine environment:
    • Download the Group Accounts template from BlackLine (for all current and previous periods only)
    • Go to reporting
    • Run the Account Template report
    • Select All Periods, then GL and Group Accounts
    • When the report complete, download it in a CSV format
  • Upload the file you downloaded in Incorta replacing the existing one
Recommendation

Apply these steps one or twice per week or whenever you have refreshed data.

Drill-down configurations in BlackLine

In your BlackLine environment, go to ERP Drill Down settings and apply the following step:

  • Add a drill down “SAP S/4HANA GL Detail BL Accounts” using the following URL:
http://<your_cluster_name>.incorta.com/incorta/#/dashboard/<your_GL_Journal_Details_dashboard_path>/params?filters=[{ "field": "BlackLineDM.AccountGroups.Entity_with_plus", "operator": "IN", "values": ["[BL-Seg1]”] },{ "field": "BlackLineDM.AccountGroups.ACCOUNT", "operator": "IN", "values": ["[BL-Seg2]”] },{ "field": "BlackLineDM.Accounts.SEGMENT3", "operator": "IN", "values": ["[BL-Seg3]"]},{ "field": "BL_EBS_GL.Mv_GL_Balances.LEDGER_ID”, "operator": "IN", "values": ["[BL-Seg4]"] },{ "field": "BlackLineDM.AccountGroups.LOB", "operator": "IN", "values": [“[BL-Seg5]"] }]&merge-filters=true
  • Add a drill down “SAP S/4HANA GL Detail BL Group” using the following URL:
https://<your_cluster_name>.incorta.com/incorta/#/dashboard/<your_GL_Journal_Details_dashboard_path>/params?filters=[{ "field": "BlackLineDM.AccountGroups.Entity_with_plus", "operator": "IN", "values": ["[BL-Seg1]”] },{ "field": "BlackLineDM.AccountGroups.Group_Account_with_plus", "operator": "IN", "values": ["[BL-Seg2]”] },{ "field": "BlackLineDM.Accounts.END_DATE”, "operator": "IN", "values": [“[BL-PeriodEnd]”] }]&merge-filters=true
Important

You must replace <your_cluster_name> with your cloud cluster name, and <your_GL_Journal_Details_dashboard_path> with your URL dashboard path.