Questions? We have answers.

SAP: Map 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 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.BUDAT 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?

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

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.