Summary
Learn about the SAP fields that MindBridge requires.
Note: SAP fields mentioned in this document are specified by {SAP Table Name}, {SAP Field Name}.
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.
Anything else on your mind? Chat with us or submit a request for further assistance.