3750406 - Master data is not replicating from SF EC to ECC/S4

When replicating master data from SF EC to ECC/S4 you find an error in t-code SLG1 for object ECPAO_IN sub object GEN

• Technical error in response XML for query *********; contact technical support - Message no. ECPAO_IN_QUERY014
• Data was lost while copying a value. - Message no. ECPAO_IN_QUERY000
  
  

Additionally you might find a DUMP in t-code ST22:

• Category               ABAP programming error
  Runtime Errors         SAPSQL_DATA_LOSS
  Except.                CX_SY_OPEN_SQL_DATA_ERROR
  ABAP Program           CL_IDENTITY_DB_PERSISTENCE====CP
  Application Component  BC-SEC-USR-ADM

SAP SuccessFactors Employee Central integration to SAP Business Suite
Business Integration Builder (BIB)

• The data loss that the shortdump refers to occurs when you send from SF EC a user ID (IT0105 subtype 0001) value with more than 12 characters
• SU01 users in ABAP side can have at most 12 characters, so it is not possible to reference it successfully.

You need to either maintain the source fields in EC with only 12 characters, or truncate the values in BIB during the mapping with Generic Value Conversion (Formatting the Employee Central Fields by Value Conversion | SAP Help Portal)

dump, bib, master data, 0105, userid, CX_SY_OPEN_SQL_DATA_ERROR, SAPSQL_DATA_LOSS

KBA , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , Problem