Skip to Content
avatar image
Former Member

update organizationnal level value on a thousand roles

Hello Gurus,

I need to modify some organizationnal value for a thousand roles.

The problem consists of copy some thousand roles with a different value on organizationnal level (Plant, company code, sales organization,...).

We're setting up a new site in a new region with the same functionnality.

The question is : How can I do it rapidly ? do you have some code (abap script for example ...)about it

Another idea ? I'm thinking about CATT but i'm not used on that tool.

Thanks a lot gurus

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Feb 05, 2008 at 12:58 PM


    What version of SAP are you on?

    If you have access to CATTs (rather than eCATTS) then it might be possible if:

    1. You have a few master roles and lots of derived roles

    2. There are not multiple values in each org field

    Another alternative would be to get your ABAP team to write some code to update AGR_1252

    If it's only 1000 roles though you might be better off doing it manually. If you know the values you should be able to manually do 180+ in 1 day so less than 2 weeks in total. You may spend this (or more) creating and testing CATTs or an ABAP

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 05, 2008 at 12:59 PM

    changing org. values with either CATT or LSMW will present you with some hard to overcome problems.

    you could possibly use table AGR_1252 which stores the org. values for all roles.

    you need to remember though, that you are directly updating tables when going for the AGR_1252 approach, which has its own pros and cons.

    also, in hindsight you could conclude that using the derived role principle could maybe have saved you alot of time.

    edit: Alex was first...

    Edited by: Dimitri on Feb 5, 2008 2:00 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Alex Ayers


      > >

      > > Look for lines starting with AGR_1252 and keep in mind the file is fixed record length so if the original and new values differ in length you'll need to add spaces to the either the searchstring or the replacestring.


      > lol, I was bitten by that one a few years back. Luckily I was just messing about in a sandbox.

      Oh, I've been bitten more than once 😊

      As a protection I wrote some VBA code that reads the download into an excelsheet, splitting it per table and field. In there I mess around with the values and reconstruct the file with VBA again, restoring all record lengths to their original spec.

      The main reason playing with downloads can really bite is that the import function has too few checks in it. It was obviously not meant to tackle files that were edited between down- and upload 😊

      Seeing the response from the original poster and guesstimating the experience level let me please take back my advice to meddle with downloads.

  • avatar image
    Former Member
    Feb 05, 2008 at 01:28 PM

    Waouh, thanks a lot for your rapid reponses.

    We're on 4.6C and we are working on upgrade to ECC6.

    I try to use derived roles, but there are some roles with different functions. I mean the thousand roles represent a thousand parent roles. In this company, there are around 10 thousands roles (parent and derived roles included).

    I'm not sure if we try to develop an abap program we have enough time to copy and update all roles. The go-live is approximately in three weeks. I'm not expert on abap and developers seem to be very busy.

    If I try to develop the program myself, how many time do you think i can finish it ? I've never used abap in my life :=( , but I can understand a program if comments are clear.

    or using CATT is the best solution ? I used it 2 years ago for creating 200 users, I don't remember exactly how to do it

    Thanks again

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Alex Ayers

      Thanks Alex,

      I think your suggestion is the best method to do it. I've just consulted the SAP help and using CATT is the solution. I remember how to use it.

      I'll give it a go !!!

      thanks for your participation gurus !!

  • avatar image
    Former Member
    Feb 05, 2008 at 02:41 PM

    Very useful and pragmatic responses.

    Thanks sdn gurus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Sorry for the pessimism 😊

      I can imagine that if something is possible and Alex & Jurjen say they have done it, then you are in good company here.

      Let us know how it goes.