BAPI_BOM_UPLOAD_SAVE Exception - Numerical entry is not supported for extrnal item IDs

[vas_y]

Hi,

Can you please help me on below issue.

I received an exception "Numerical entry is not supported for external item IDs" when am using BAPI_BOM_UPLOAD_SAVE through SAP BODS for adding second component on existing BOM which is already having an component in SAP. FYI, ITEM_ID is creating internally and sending any value from source but shows related to external item id.

Other observation was, when execute BODS job using same BAPI, some records loaded successfully and some of them are not loaded and showing exception "Numerical entry is not supported for external item IDs" in the same job execution, then I re-executed BODS job and the few of the records have loaded successfully(those were failed in previous job execution) and few of them have failed with exception. Again, If I re-execute job then same issue repeats like loading few of them and few of them getting exception.

My question is, why BAPI behaves differently for same set of records. I would appreciate, if you can help to resolve this issue.

[vas_y · Accepted solution]

Received below response from SAP.

The component CRM-MD-PRO sent the incident back to us indicating that the BAPI_BOM_UPLOAD_SAVE function is not designed to handle large amount of data.
You just need to keep the number of records manageable (lower than 1000 in your case) in order to avoid the errors.

[Former Member]

Have you tried this BAPI_BOM_UPLOAD_SAVE Directly in SAP ? and getting the same message ?

Thanks,

AJ.

[vas_y]

We tried entering one or two materials in SAP and don't see this issue but we didn't try with mass load. Also when we load through BODS job with 1-20 materials, we don't see any exception. This issue come up when do mass load.