Skip to Content
avatar image
Former Member

BAPI_PRICES_CONDITION - DBSQL_DUPLICATE_KEY_ERROR

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 29, 2017 at 01:42 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded