SAP - Accounting file Integration

Created by Jenny Johansson, Modified on Thu, 25 Jan 2024 at 01:07 PM by Maria Appelquist

When setting up the SAP accounting file mappings, go to Autopilot/Integration and click on the plus sign Add integration.

Choose SAP Xml Exporter, give it a name and save. To be able to see the Settings, refresh the page.


In tab Settings you can decide if TS should send One file per coding, which means that for each transaction two or up to three files will be created. For example this is the case in a FX Cross like below where the accounting currency is SEK an the Original currency has bookings in three currencies, three files will be created. 


In Settings tab there is also a possibility to map Sender Port; Receiver Port etc. Its not mandatory, but check with SAP integrations team if it needs to be mapped. In the fields of Accounting type realized, Accounting type unrealized, and Accounting type reverse unrealized you set the file names for the different accounting types.



Document type settings is also up to each client what needs to be mapped here, so check with SAP integrations team internally. In the Interface settings set the start name of the file. 

For example it can look like below where the file name consists of TS+date+filenumber+coding number+which accounting type the file contains.



In tab Mappings the possible mappings for the different fields are added. Choose A, then all possible fields that can be mapped are shown. Map the ones needed and save, the unused fields will be taken away when saving.

The fields that can have different values when several files are created for one transaction are the following fields:

All other fields not marked above need to be exactly the same in all the files produced from one transaction.


More details

In the the section the grey marked fields are possible to map.


<E1BPACHE09 SEGMENT="1">

      <USERNAME>Test</USERNAME> max length 12

      <HEADER_TXT>SAP Treasury systems 25040-1</HEADER_TXT> Setting+global ID

      <COMP_CODE>100</COMP_CODE> Distinct max length 4

      <DOC_DATE>20240117</DOC_DATE> Accounting date

       <PSTNG_DATE>20231231</PSTNG_DATE> Due date

       <TRANS_DATE>20231231</TRANS_DATE>Due date

      <DOC_TYPE>ZX</DOC_TYPE> Setting

      <REF_DOC_NO>222493</REF_DOC_NO> Distinct max length 16

 

<E1BPACGL09 SEGMENT="1">

      <ITEMNO_ACC>1</ITEMNO_ACC>

      <GL_ACCOUNT>0000008413</GL_ACCOUNT>

      <ITEM_TEXT></ITEM_TEXT> max length 50

      <DOC_TYPE>ZX</DOC_TYPE> Setting

      <COMP_CODE>100</COMP_CODE> Distinct max length 4

      <VALUE_DATE>20231231</VALUE_DATE> Due date

      <COSTCENTER>999</COSTCENTER> max length 10

      <PROFIT_CTR>4000</PROFIT_CTR> max length 10

      <TRADE_ID>1000</TRADE_ID> max length 6

      <ALLOC_NMBR>222493SEK</ALLOC_NMBR> max length 18

      <REF_KEY_1></REF_KEY_1> max length 12

      <CS_TRANS_T></ CS_TRANS_T> max length 3


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article