Export SRM Org Structure?

[Former Member]

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

[Former Member]

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.

[former_member183819]

Fantastic Sayantan !!

or

http://wiki.sdn.sap.com/wiki/display/SRM/DownloadExtract-Graphicaloverviewof+PurchasingOrgstructureinSAPSRM

you can try the above same.

Muthu

[laurent_burtaire]

Hello Sayantan,

Need was to get object O and P, but also attributes for those organizational objects.

Using your method, you don't get attributes.

Regards.

Laurent.

[Former Member]

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

[former_member183819]

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

[Former Member]

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

[former_member183819]

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

[laurent_burtaire]

Hello Eric,

I don't know standard report or function module which can answer to your request.

For a quick overview, have a look at table view HRV1222A. But data you will get are for objects O and S, not for users...

You will have to create a report as suggested by Muthuraman.

Regards.

Laurent.