Digits exceed the maximum when loading numeric from BW into SAP DS

[Donatas]

Hello,

We are getting an error message (A numeric's maximum number of digits is 28. You are attempting to store value or constant, whose 35 digits exceed the maximum. Error calling RFC function to get table data RFC_ABAP_EXCEPTION Exception_Key READ_ERROR) while loading numeric fields from SAP BW into EDW using SAP Data Services 4.2. This error occurs only when we are trying to extract data from SAP BW for numeric fields, other fields can be extracted and loaded successfully. We have checked the size of those SAP BW numeric fields - their data type is numeric(17,2). Therefore they should perfectly fit into the SAP DS transform and loaded into EDW.

Any ideas on this issue?

Looking forward your feedback.

Thank you,

Donatas

[sateesh_kumar1]

HI Donatas ,

Can you check by trim the key figure in DS transformation.I suspect some null value may causing issue.

[Donatas]

Hi, Sateesh,

Thank you for your feedback. We have discovered that this problem appears only with CURR type of data fields. Also we have changed NUMERIC(17,2) into DOUBLE in SAP DS Query and it seems that the problem disappeared.

But now we have another problem - all fields seems to be encoded with underscore between every character. We are using SAP BW Source DataStore and SAP Tables in it.

Best regards,

Donatas