Table for user attribute data

[former_member229388]

Hi Experts,

I need to download the following data from SRM system:

1) Users per department

2) Default department per user

3) Default cost center per user

4) Default delivery address per user

How can we get this data? Any tables / FMs?

Pls help.

Thanks,

Dhananjay

[Former Member · Accepted solution]

Hi,

Basic table for attributes is T77OMATTR

Following are the tables that are updated with attributes.

HRP1222 (Infotype 1222: General attribute maintenance)

HRV1222B (View of Attributes)

HRV5502A (SRM Location)

HRP1000 (Objects details_link to Code)

HRP1001 (Relationships to other objects)

HRT1222 (Table Section Infotype 1222: General Attribute Maintenance)

HRV5500A (SRM: Selection Help for SRM Function)

HRV5500OT (SRM Function (OTJID))

HRV5501A (SRM: Selection Help for Product Responsibilities)

HRV5501OT (SRM Product Responsibility (OTJID))

HRV5502A (SRM Location)

HRV5502OT (SRM Location (OTJID))

BBP_ATTR_ACCESS (Attribute Access Mode)

BBP_ATTR_DFT (Default Values of Basic Attributes)

BBP_ATTR_VALUE_T (Text for SRM Attribute Values)

You can also use FM BBP_READ_ATTRIBUTES.

Hope this helps,

Nikhil

Edited by: Nikhil RGupta on Jun 28, 2011 3:36 PM

[former_member229388 · Accepted solution]

Hi Nikhil,

Thanks for your reply. But could you tell me how I can find specific attributes I am looking for?

I need to download this data.

Thanks,

Dhananjay

[Former Member · Accepted solution]

Hi Dhananjay,

if you want to get the values for attributes, you can first look for the relation of the object in the table HRP1222, where you can find the field TABNR and then select the table HRT1222 with key TABNR. In the table HRT1222 you have a field named ATTRIB, here you can take the requested Attribute key eg. BUK, ADDR_BILLT, ADDR_SHIPT... The values are stored in fields LOW and HIGH (possible interval values, if no intervals, the LOW field is used).

But try to use also the function modules BAPI_USER_GET_DETAIL, BBP_OM_FIND_SC, RHGA_READ_TREE_UP_SET.

Just take care about the active variant of the organization and that you select the up to date data (fields BEGDA, ENDDA, PLVAR) in leading tables.

Kind regards

Juraj

[former_member229388 · Accepted solution]

Hi,

FM BBP_READ_ATTRIBUTES solved the problem. Along with the atrribute values, it also retrned default attribute value.

-Dhananjay

[Former Member · Accepted solution]

Hello Dhananjay,

I am also using the FM BBP_READ_ATTRIBUTES as suggested by Nikhil in this post and you have resolved your issue with that. So can you share how you got all attributes for a user? I am able to get only 1 at a time.

Best Regards,

John

[former_member229388 · Accepted solution]

Hi John,

In FM:BBP_READ_ATTRIBUTES

Pass the multiple 'attributes id' in IT_ATTR_LIST, once executed FM will return values for all the attribute ID listed in IT_ATTR_LIST.

[Former Member · Accepted solution]

Juraj, Sir you are awesome Thank you for sharing your knowledge! Indeed using SQVI and table join between HRT1222 and HRP1222, I was also able to extract a list of all users and a specific attribute (BUK) which was something I was looking for intensely lately.

[former_member189766 · Accepted solution]

Hi Ganea,

But i am not getting the inherited values ? is there any table to get the inherited as well....