Summary
Learn about the methods and requirements for exporting data from SAP systems.
Configuration details
There are 2 methods for exporting data from SAP systems.
- Use the SE16N (General Table Display) transaction code to view and filter the SAP tables. You can then export the results to a spreadsheet format (.xlsx), or,
- Run queries against the database to get the required values.
Chart of accounts
| MindBridge column | SAP field | SAP description | Required | Notes |
|---|---|---|---|---|
| Account | SKAT.SAKNR | G/L Account Number | Y | – |
| Account Description | SKAT.TXT50 | G/L Account Long Text | Y | Can use SKAT.TXT20 instead |
| Account Tags | – | – | N | This is not an SAP data element. |
| MAC code | – | – | N | This is not an SAP data element. It can be used to map to a MAC code from within the file. |
General ledger
For general ledger data, you will need access to the following tables:
- BKPF – Accounting Document Header
- BSEG – Accounting Document Segment
| MindBridge column | SAP field | SAP description | Required | Used in analytics | Notes |
|---|---|---|---|---|---|
| Account ID | BSEG.HKONT | G/L account number | |||
| Account Number | BSEG.SAKNR | G/L Account Number | Y | Y | – |
| Account Description | SKAT.TXT50 | G/L Account Long Text | N | N |
Can be left out and picked up from the chart of accounts (above). Can use SKAT.TXT20 instead. |
| Amount |
BSEG.SHKZG BSEG.DMBTR |
Debit/Credit indicator Amount in local currency |
Y | Y |
If BSEG.SHKZG is "S (i.e.; Debit)" use BSEG.DMBTR. If BSEG.SHKZG is "H (i.e.; Credit)" use 0 - BSEG.DMBTR. If supplying line entry amounts via the Amount column, leave the Debit and Credit columns blank. |
| Debit |
BSEG.SHKZG BSEG.DMBTR |
Debit/Credit indicator Amount in local currency |
Y | Y |
If BSEG.SHKZG is "S (i.e.; Debit)" use BSEG.DMBTR, otherwise leave as 0 or blank. If supplying line entry amounts via the Debit and Credit columns, leave the Amount column blank. |
| Credit |
BSEG.SHKZG BSEG.DMBTR |
Debit/Credit indicator Amount in local currency |
Y | Y |
If BSEG.SHKZG is "H (i.e.; Credit)" use BSEG.DMBTR, otherwise leave as 0 or blank. If supplying line entry amounts via the Debit and Credit columns, leave the Amount column blank. |
| Entered Date | BKPF.BUDAT | Day on which accounting document was entered | Y | Y | Appears in format YYYY-MM-DD. |
| Effective Date | BKPF.BUDAT | Posting date in the document | Y | Y | Appears in format YYYY-MM-DD. |
| MAC code | – | – | N | Y | This is not an SAP data element. It can be used to map to a MAC code from within the file. |
| Manual Entry | – | – | N | Y |
SAP does not provide a field for manual entries. Configure the manual entry codes in the settings, then indicate whether each entry was entered manually or automatically (by batch). This may involve a combination of USNAM, BLART, and TCODE. |
| Memo |
BKPF.BKTXT and/or BSEG.SGTXT |
Document header text Item text |
N | Y | Depending on the data, you can use one or the other, or a concatenation of both. |
| Source | – | Indicates the entry's source ledger or subledger. | N | Y | Depending on SAP configuration, this data field may not be available. |
| Type | BKPF/BLART | Document type | N | Y | – |
| Transaction ID | BKPF.BELNR | Accounting document number | Y | Y | – |
| User ID | BKPF/USNAM | User name | N | N | While not used in analytics, you can use this to sort and filter results for reports. |
Anything else on your mind?
Log in to MindBridge to chat with us, email support@mindbridge.ai, or reach out to your assigned Customer Success Manager.
Comments
0 comments
Please sign in to leave a comment.