Duplicate entries exported from SAP - error occurs in a RDBMS

Symptom: duplicate entries re exported and some external systems do not tolerate duplicate records.

 

Example: table TPART:

 

 

Reason: a possible problem can be that the particular field has a conversion exit defined (example: Partner Function ):

 

 

The conversion exit may change the data value stored in the database to something different that is displayed on the SAP GUI screen. Sometimes this may create duplicate entries:

 

Example: Conversion exit PARVW reads table TPAUM, where there is a possibility that two different values will be converted to the same value by the standard SAP code:

 

 

Solution: go to the Field Catalog Extension screen and set the Extraction Method to "Bypass conversion routine". If you want to bypass the conversion routine for all data sources, make an entry in table /VDB/T_EXM_DEF using transaction /VDB/CUST_EXM, for example: