Skip to Content
author's profile photo Former Member
Former Member

Lock entry created for items in comparison columns?

Hi all,

I encountered a problem today in which I assumed the system would behave differently:

We have a planning level with positions 3,4,5,6 in the level restriction (example only!). In the layout we have fixed rows. They show position 1 and 2 as comparison columns, and 3,4,5,6 open for input. Now the system will create a lock entry also for positions 1 and 2.

Unfortunately this creates locking problems for us, as 1 and 2 will at the same time be updated in another layout.

Many thanks in advance for your assistance!

Regards,

Andreas

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 07:00 AM

    Thanks for the response. The thing about the UPC_DARK2 entry sounds very promising, however I have one question about it:

    In the description to the SAP Note it says that there is a restriction "Reference data can be either in the rows or in the columns". Does this mean that the solution will not work if we have both a reference column and a few reference rows?

    We are on SP17, so I cannot test this at the moment.

    Thanks again for your great replies,

    Andreas

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Andreas,

      if you have a layout of the following type it should work:

      Leadcolumn (characteristic M1)

      1 reference, not in package

      2 reference, not in package

      3 in package, user specific

      4 in package, user specific

      .

      and in data columns

      Keyf1 Keyf1

      Area 1 (plan) Area 2 (actuals)

      the use note 555849 to make Area 2 a 'reference' area, the

      package contains both Area 1 and Area 2 (i.e. no reference colum in terms of the new note). But with note 555849 no lock will be used for

      Area 2 at all.

      At run time the selection for Area 1 will be locked with

      M1: 3, 4, ...

      Keyfigure: Keyf1

      So all users can share the reference data for charactristic values 1, 2.

      Regards,

      Gregor

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2006 at 11:23 PM

    Hello Andreas,

    Generally the locks are created based on the characteristic values being called for in the layout and not on the key figures.

    Even though you have set the columns 1 & 2 as comparison, the characteristics being called are being used for columns 3 to 6.

    Therefore if you are trying to open a different layout with the same characteristics and trying to update other key figures, the system would lock you out as there is conflict in the characteristic data being called.

    Hope this helps.

    Sunil

    PS: Assigning points is a way of saying thanks

    Add comment
    10|10000 characters needed characters exceeded