Mass deletion of users business partner and position in SRM 4.0

[Former Member]

Hi Experts,

We have a requirement of deleting 1000 + users who are locked in ECC from SRM Organization structure. For which I got the list of users who are under u201Cdeleteu201D group from table USR02. Then I found the business partner number of those users from table BUT000. Once I got the BP number I can do mass deletion of the BPs by using BUPA_DEL.

Now, my problem is I need to mass delete the position of the users as well. If I delete it one user at a time I can go to PPOMA_BBP and select the position and delete the object. Can anyone please help me on how can I do mass deletion of the positions of those users, its pretty urgent. I am waiting for your valuable suggestions.

Thanks

Div

Edited by: Tridib Das on Sep 29, 2011 4:15 PM

[Former Member]

It was quiet helpfull

[velayutham_augustheesan2]

try the report "RHRHDL00".

hope this helps.

velu

[Former Member]

Hi,

Thanks for your help in this. Can you please tell me the table name from which I can get the position id for list of users?

[Former Member]

Hi Velu,

To find the business partner or the central person id we can' go to table HRP1001 and get the central person id / business partner by inputing the parameters in the selection field as :

Object type : CP / BP

Rel. Obj.type: US

ID rel. object : Give the id of the user

this shows the object id . Anyway thanks for your help .

Cheers

Div