Summary
This guide will cover the process of importing a SAP DART general ledger into MindBridge.
Notes/Prerequisites
The general ledger column mapping section of this guide is based on data that has been formatted according to our transformation guide. Note that the SAP DART general ledger cannot be ingested into MindBridge without first formatting it.
Import data
- Import your general ledger file into MindBridge through the File Manager, or by importing directly to the General Ledger section on the Data page. For step-by-step instructions, follow our Import a general ledger guide until the Map Columns step.
- Map the SAP DART fields as follows:
|
MindBridge Column |
SAP DART Field |
Notes |
||
|
Account ID |
BSEG.HKONT |
Required |
Yes |
|
|
Effective Date |
BKPF.BUDAT |
Required |
Yes |
Appears in format YYYY-MM-DD |
|
Amount |
BSEG.DMBTR |
Required |
Yes |
|
|
BKPF.BELNR |
Recommended |
Yes |
|
|
|
Memo |
BKPF.BKTXT and/or BSEG.SGTXT |
Recommended |
Yes |
This will enable the Empty Text control point and allow you to see the memo field for each transaction/entry |
|
Account Description |
SKAT.TXT50 |
Optional |
No |
Can be left out as this field will be picked up from the Chart of Accounts |
|
Type |
BKPF/BLART |
Optional |
Yes |
|
|
User ID |
BKPF/USNAM |
Optional |
No |
Use to sort and filter results for reports |
|
Entered Date |
BKPF.CPUDT |
Optional |
Yes |
Appears in format YYYY-MM-DD |
|
Source |
n/a |
Optional |
Yes |
|
* Optional columns, even if not used in the analytics, can be included for filtering and other visualizations, as indicated under Notes.
Previous step: SAP DART: Transform the general ledger
What do you think of this guide? If you have any feedback, or you think you can help us improve it, then we would love to hear from you! Please contact us at support@mindbridge.ai. We are offering rewards for any information that leads to the improvement of a guide or the creation of a new one.
Anything else on your mind? Chat with us or submit a request for further assistance.