# Questions? We have answers.

## 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).<br>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<br>BSEG.DMBTR | Posting date in the document  | Yes          | Yes                   | If (BSEG.SHKZG = Debit)<br>Absolute (BSEG.DMBTR)<br>Else<br>0 |
| Credit                       | BSEG.SHKZG<br>BSEG.DMBTR | Debit/Credit indicator<br>Amount in local currency | Yes | Yes                   | If (BSEG.SHKZG = Credit)<br>Absolute (BSEG.DMBTR)<br>Else<br>0 |
| Memo                         | BKPF.BKTXT<br>and/or<br>BSEG.SGTXT | Document header text<br>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.

* * *