Questions? We have answers.

SAP: Map data to MindBridge

  • Updated

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.


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?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.

Was this article helpful?