SAP: Map data to MindBridge

Jonathon Plowman-Samson

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}.

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

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.