BAPI_PRICES_CONDITION - DBSQL_DUPLICATE_KEY_ERROR

[Former Member]

Hi All,

We are developing a mass upload program for condition records. We are not going to use LSMW or Idoc. so we used the FM BAPI_PRICES_CONDITION. My question is, have anyone encountered a duplicate key error when executing the FM?

[VeselinaPeykova · Accepted solution]

The correct bapi name is BAPI_PRICES_CONDITIONS. Did you try searching in SAP notes with the correct bapi name as criterion?

I ask, because the first result is 2523848 - Condition Upload: Duplicate Key Error and normally when you encounter a problem with standard FM one searches for notes on the subject.

For reference - I used fuzzy threshold = 1.0 (exact match) and no date restriction in expert notes search app.

As you did not mention anything related to CRM, I would point out the recommendation by SAP in 1135984 - Conditions cannot be created with BAPI_PRICES_CONDITIONS not to use this BAPI in custom developments due to the risk of causing inconsistencies. I do not know why it was decided against the alternative methods for condition upload, but if there is any chance to influence the decision by the requester, I would try to persuade him/her to pick one of the safer options mentioned in the second note.