Questions? We have answers.

Map SAP data to MindBridge

Article author
Jonathon Plowman-Samson
  • 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 Notes
Account SKAT.SAKNR G/L Account Number Y
Account Description SKAT.TXT50 G/L Account Long Text Y 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 Y Y
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.

Entered Date BKPF.BUDAT Posted date in the document Y Y Appears in format YYYY-MM-DD.
Effective Date BKPF.BUDAT Day on which accounting document was entered Y Y Appears in format YYYY-MM-DD.
Debit

BSEG.SHKZG

BSEG.DMBTR

Posting date in the document Y Y

If (BSEG.SHKZG = Debit)

Absolute (BSEG.DMBTR)

Else

0

Credit

BSEG.SHKZG

BSEG.DMBTR

Debit/Credit indicator

Amount in local currency

Y Y

If (BSEG.SHKZG = Credit)

Absolute (BSEG.DMBTR)

Else

0

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.
Type BKPF/BLART Document type N 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.
 

Other columns can be also included. They are not used in the analytics, but are displayed as Additional Details.

 

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.

Related articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.