Skip to Content
avatar image
Former Member

SAP IP Locking Issue

Hello,

I have a problem in undertanding the locking logic in SAP IP.

I have two planning querys working on the same aggregation level. The only difference of the two queries are the selection variables.

For query a it is 0Employee and for b 0Costcenter.

If I start a twice with different employees it works.

But when I start a with a employee and b with a costcenter (a costcenter different from the emplopyee), I get an error that the records are locked by the user which executes query a.

I would understand this issue if query b is called with the costcenter of the respective employee. The there would be a conflict in locking the same records. but in the case the employee is different from the costcenter.

Can anyone explain this issue to me?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 15, 2015 at 08:55 AM

    Hi Michael,

    if the two characteristics 0EMPLOYEE and 0COSTCENTER are lock relevant the the 2 dimensional data reqion described by the static filter of the query is locked. So overlapping data reqions will lead to a lock conflict.

    You say 0EMPLOYEE and 0COSTCENTER are somehow related. What exactly is the relation? Lock relevant characteristics are considered as independent. If 0EMPLOYEE has 0COSTCENTER as an attribute you might consider to make it a navigation attribute 0EMPLOYEE__0COSTCENTER and to make the navigation attribute lock relevant. Then it might be possible to define the filter in the query in such a way that the locked data regions are not overlapping.

    Lock relevant characteristics are defined in RSPLSE; you can make navigation attributes lock relevant in the 'expert mode'; you find all details in the sizing note 928044.

    Regards,

    Gregor

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Gregor Dieckmann

      Hi Gregor,

      thanks for your help.

      Okay, I thought the locks are record based. Then it is clear to me. I didnt found this information in any documentation.

      Do you have any idea to bypass this problem?

      Regards

      Michael

  • avatar image
    Former Member
    Oct 16, 2015 at 04:08 AM

    Hi Gregor,

    thanks for your help.

    Okay, I thought the locks are record based. Then it is clear to me. I didnt found this information in any documentation.

    Do you have any idea to bypass this problem?

    Regards

    Michael

    Add comment
    10|10000 characters needed characters exceeded