Improve the mapping of expense types from Amex to SAP for Sweden

[Former Member]

The assignment of credit card transactions (Amex transaction keys) to the correct travel expense type in SAP often fails because of the below reasons:

1. The current solution cannot distinguish between domestic and international receipts.

2. There is no "one to one" relationship between SAP travel expense types and transaction types from Amex.

This leads to confusions and misunderstandings for the traveller and time consuming corrections to avoid incorrect postings in accounting.

Credit Card Clearing Process - Amex credit card transactions which have been carried out by an employee can be imported manually as individual receipts from the document buffer to existing trips in the SAP system. This regards to credit card transactions which is sent in the daily file from Amex (KR1025). A program is used to upload the data to the system.

Please find attached the dump of T702B records for Amex - Sweden along with the travel expense types maintained. As per the current solution the same transaction key is assigned to domestic and international expense types.

Would need guidance on the below points:

1. Will only changing text for Amex transactions keys work? OR will it result in failed credit card transactions?

2. If any changes are made in table T702B then will the program that is used to upload the employee card transactions need to be changed.

Thanks in advance.

[Former Member · Accepted solution]

Hi,

normally you will not be able to have a "one by one" mapping from credit card iso codes to your defined expense types. SAP standard only allow to map iso code to one expense type directly.

Combination of different data from the credit card provider (file) to fine the correct expense type is not provided from my understanding in SAP standard.

If you like to get this done you need to enhance SAP standard function. From my knowledge the best was is to "modify" the file which then will be uploaded to the system.

Best regards,

Sigi

[Former Member · Accepted solution]

Closing the thread. System on EHP7 hence new configurations available for mapping.