on 03-01-2010 9:02 PM
Hello,
I am wondering if there is a way to export the org structure (SRM 5.0) to Excel. We have 2,000 or so users in our org structure, and I want to be able to report which user has requisitioner, delivery address, approver for value limit, etc attributes maintained, and what those values are. I would love to be able to get a dump from the org structure itself, or a table that contains that data.
Thanks in advance,
-Eric
Hello All,
Why do you guys need to write a program?
Tips:
1. Open the org Structure
2. Press the print button.
3.This opens up the follow on screen.
4. Go to System > List> Save > Local (this time options won't be greyed out, rather you will see them highlighted.
Enjoy....Saving the file....
Points pls..
Sayantan
Senior Advisory Consultant.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Fantastic Sayantan !!
or
http://wiki.sdn.sap.com/wiki/display/SRM/DownloadExtract-Graphicaloverviewof+PurchasingOrgstructureinSAPSRM
you can try the above same.
Muthu
Hi Eric,
Search for transaction RE_RHXSTR**
This will give you some results with which you can maken a dump of the org plan.
Regards,
Timo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You need to develop a program to mass update of attribute values.
http://wiki.sdn.sap.com/wiki/display/SRM/CodeSample3UpdatingExtendedAttributes%28Storage+Location%29
muthu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Muthu,
I am not looking to update these value, I want to export what is currently set. We are moving to SRM 7.0 and we have not maintained our org structure via a transport. Therefore, I want to simply understand who has what set for delivery address, etc.
Is there a table in SRM that I could view with this information?
-Eric
hi
you can write a program
BBP_GET_ATTRIBUTES_AT03 or bbp_read_attributes by using this function module
and extract what are the values are hold by each user simply try..
FM - BBP_GET_ATTRIBUTES_AT03
i/p - user name
o/p- you will get all attributes which u have inherited.
http://wiki.sdn.sap.com/wiki/display/SRM/DownloadExtract-Graphicaloverviewof+PurchasingOrgstructureinSAPSRM
muthu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.