2571477 - Invalid numeric value for parameter/column () source type DECIMAL, target type DECIMAL - SAP Landscape Transformation Replication Server

• Replication doesn't fail but data in some target table columns shifted or truncated.
• Initial load for a table (i.e  MARA)  fails right at the beginning
• Errors in Application log:
• SQL exception occurred in receiver system (rfc dest. NONE)
• Execution of program /1LT/DK2OLC_100000000062203 failed, return code 3
• Error 1 in SM21: 
• SQLCODE : -10802
• SQLERRTEXT : Invalid numeric value for parameter/column (211) source type DECIMAL, target type DECIMAL
• sc_p=9b2fbc8,no=209,idc_p=(nil),con=1,act=1,slen=4950,smax=5120,#vars=287,stmt=a599d70,table=/1CADMC/S0001533
• OR
• SQLCODE : -10802
• SQLERRTEXT : Invalid numeric value for parameter/column (211) source type DECIMAL, target type FIXED8
• sc_p=9b2fbc8,no=209,idc_p=(nil),con=1,act=1,slen=4950,smax=5120,#vars=287,stmt=a599d70,table=/1CADMC/S0001533
• Error 2 in SM21:
• invalid sign in BCD number: 0
• Error converting decimal:  000000000#0.00 HEX: 000000000C0000 input variable
• Fields XXX in table /ÍCADMC/10000000000XXXX<TABLE> is specified twice

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP Landscape Transformation Replication Server

SLT, DECIMAL, FIXED8, -10802, specified, twice , KBA , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , HAN-DP-LTR , Use CA-LT-SLT instead , Problem