Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.