Summary
Learn about the SAP fields that MindBridge requires.
Chart of accounts
| MindBridge column | SAP field | SAP description | Required | Used in analytics | Notes |
|---|---|---|---|---|---|
| Account | SKAT.SAKNR | G/L Account Number | Yes | Yes | — |
| Account Description | SKAT.TXT50 | G/L Account Long Text | Yes | Yes | Can use SKAT.TXT20 instead |
General ledger
| MindBridge column | SAP field | SAP description | Required | Used in analytics | Notes |
|---|---|---|---|---|---|
| Transaction ID | BKPF.BELNR | Accounting document number | Yes | Yes | — |
| Account Number | BSEG.SAKNR | G/L Account Number | Yes | Yes | — |
| Account Description | SKAT.TXT50 | G/L Account Long Text | No | No |
Can be left out and picked up from the chart of accounts (above). Can use SKAT.TXT20 instead. |
| Entered Date | BKPF.CPUDT | Posted date in the document | Yes | Yes | Appears in format YYYY-MM-DD. |
| Effective Date | BKPF.BUDAT | Day on which accounting document was entered | Yes | Yes | Appears in format YYYY-MM-DD. |
| Debit |
BSEG.SHKZG BSEG.DMBTR |
Posting date in the document | Yes | Yes |
If (BSEG.SHKZG = Debit) Absolute (BSEG.DMBTR) Else 0 |
| Credit |
BSEG.SHKZG BSEG.DMBTR |
Debit/Credit indicator Amount in local currency |
Yes | Yes |
If (BSEG.SHKZG = Credit) Absolute (BSEG.DMBTR) Else 0 |
| Memo |
BKPF.BKTXT and/or BSEG.SGTXT |
Document header text Item text |
No | Yes | Depending on the data, you can use one or the other, or a concatenation of both. |
| Type | BKPF/BLART | Document type | No | Yes | — |
| User ID | BKPF/USNAM | User name | No | No | While not used in analytics, you can use this to sort and filter results for reports. |
You can include other columns, which will not be used in the analytics, and are displayed as Additional Details.
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.