Data Applications → BlackLine Account Reconciliations for SAP ECC
Using the Incorta BlackLine data application and data destination, you will have the edge to quickly ingest and integrate data using SAP ECC. Integrating SAP ECC 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 → + New → Add 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 ECC data application.
- Select Install.
SAPECC_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 Name | Description | Refresh Mechanism | Usage |
|---|---|---|---|
| GL_PERIODS | GL Periods Table (Source-CSV flat file) | Incremental | Used to Populate the Blackline Account Template |
| BL_ACCOUNTS_GROUP | Table to store Account groups details in Incorta from Blackline | Full | Used to enable drill from Blackline Accounts and Account Groups |
| FAGLFLEXT_BL MV | MV populates GL Details from SAP ECC | Incremental | Used to Populate the Blackline Account Template |
| FAGLFLEXT_SUMMARY | MV consolidates GL Data | Incremental | Used to Populate the Blackline Account Template |
| T001 | Company Codes Master Data | Full | Used to Populate the Blackline Account Template |
| T881 | Ledger Master | Full | Used to Populate the Blackline Account Template |
| SKB1 | GL Account Master (Company Codes) | Full | Used to Populate the Blackline Account Template |
| CEPC | Profit Center Master Data | Full | Used to Populate the Blackline Account Template |
Available views in the BlackLineDM business schema
| Business View Name | Description | Usage |
|---|---|---|
| Accounts | A business view that has all the attributes needed in the Blackline reconciliation template | Used in the dashboard to push Blackline accounts template data into Blackline SFTP location |
| AR Transactions | A business view that has all the attributes used in the GL details drill report for AR Transactions | Used in the dashboard that drills down to GL details from Blackline Accounts or Account Groups |
| AP Transactions | A business view that has all the attributes used in the GL details drill report for AP Transactions | Used 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 Name | Description | Usage |
|---|---|---|
| Accounts for Blackline | A dashboard that has the data for the Blackline Account template | This dashboard is used to format and schedule data transfers from SAP ECC to the BlackLine data destination |
| AR Transactions | A dashboard has subledger drills for AR Transactions | The dashboard that drills down to GL details from Blackline Accounts or Account Groups |
| AP Transactions | A dashboard has subledger drills for AP Transactions | The 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.
You must download the Enterprise version of the data application. Alternatively, you can use the SAP ECC data application.
To achieve that, apply the following steps:
- Use these schemas to create the joins in the following step:
- SAPECC_AP
- SAPECC_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.
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
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 “SAPECC 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 “SAPECC 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
You must replace <your_cluster_name> with your cloud cluster name, and <your_GL_Journal_Details_dashboard_path> with your URL dashboard path.