Getting information from SRM !

[rajesh_rajendran2]

Hi Experts,

Can anyone help me find the tables which get updated during the below mentioned processes in SRM.

1) In transaction PPOSA_BBP the details of the cost center, delivery address etc. assigned on a position level or org unit level is stored in which tables ?

2) During vendor replication, the tables HRT1001, BUT000 and VENMAP are updated. But can you explain how the process takes place.

Looking forward for reply !

Regards,

Rajesh

[Former Member]

Hi

Please try this ->

1. Using Function modules BBP_READ_ATTRIBUTES / BBP_USER_GET_ATTRIBUTES, you can find all relevant information (Cost center, Delivery address, etc).

2. Using BBPGETVD transaction, Vendor replication is performed in SRM from R/3 back-end system.

Transaction - BBPGETVD

BBPGETVD (Initial upload)- is a transcation to run inital upload for vendors and should be run only once.

Once all the vendors are downloaded intially, subsequent vendor changes and the new vendors is taken care by Vendor_SYNC (Subsequent download).

Vendor_Sync is a program which can be shcedule as a background job for changes and new vendors.

Note that only vendors assign to purchasing ORganisaiton are transsferred.

FI vendors which are not assign to the purchasing org cannot be transferred.

Also check the number ranges settings .

For more information, See related links ->



http://help.sap.com/saphelp_srm50/helpdata/en/56/54f137a5e6740ae10000009b38f8cf/frameset.htm











Specify whether:

· The SRM system is to assign numbers from the internal number range for business partners for the vendors to be copied.

· The vendor numbers are to be copied from the backend system. If the number already exists in the SRM system, the system assigns a number internally for the vendor.
In this case, configure the internal number range so that it does not overlap with the number range in the backend system.

Before the system performs the data replication, it informs you of any possible problems (such as missing purchasing organizations).

NOTE - Make sure you enter the correct vendor root node of the organizational structure

Do let me know.

Regards

- Atul

[rajesh_rajendran2]

Hi Atul,

Thanks for the information. But can you let me know what should be the input in case of the Function module BBP_READ_ATTRIBUTES.

what is to be entered for IV_OBJECT then should I enter the org unit ID and O as the Object type .

Can you let me know as to what should be the input parameters ?

My requirement is to get the number of users in a specific org unit who use a particular cost center , delivery address etc.

Also my question is where the the data which gets stored in PPOSA_BBP be viewed. is there any table where the data is stored.

Awaiting your reply.

With Regards,

Rajesh

[Former Member]

Hi,

You just need to pass the user ID to the FM and the attribute name(eg for Pur Grp,you need to pass PURCH_GRP).The values/names of the attributes to be passed can be seen in table T77OMATTR.

To get the number of users in a specific org unit ,see the foll links for solution:

<b></b><b>

</b>

BR,

Disha.

<b>Pls reward points for useful answers.</b>

[rajesh_rajendran2]

Hi Disha,

Thanks for the info- but I would like to know if there is any table where the attribute values for a user which are displayed in PPOSA_BBP are displayed.

Looking forward for your reply.

With Regards,

Rajesh

[Former Member]

hi,

Is your basic reqt solved?If so,please reward suitable points and close the thread.

I dont have access to the system currently so cant tell you the table names.But you can find that by studying the FM "BBP_READ_ATTRIBUTES" since that gives the value of the attributes for a user in the Org structure.Also use the FM instead of querying the tables.

BR,

Disha.

<b>Pls reward points for useful answers.</b>

[rajesh_rajendran2]

Hi Disha,

My basic question was where does the data which gets displayed in the PPOSA_BBP gets stored in the SRM system.

Any tables linked to the values !

Looking forward for your input !

With Regards,

Rajesh