Query reg: purchasing org,purchasing group,source of supply,employee org

[Former Member]

Hi,

Can anyone please tell me if

1) There are any tables related to vendor product relationship in SAP -SRM where i can get the details of the sources of supply.

2) If there are any tables in SAP-SRM for purchasing organization and purchasing group.

3) If there are any tables related to the employee organization relationship as to which organization the employee belongs to.

It would be really nice if I could get some information on this.

Thanks

Pratyusha

[Former Member]

See answers below

1) There are any tables related to vendor product relationship in SAP -SRM where i can get the details of the sources of supply.

See table BUT000, has vendor details,

2) If there are any tables in SAP-SRM for purchasing organization and purchasing group.

BBP_PDORG - details about Purch grp and Purch Org can be found here

3) If there are any tables related to the employee organization relationship as to which organization the employee belongs to.

HRP1001

Hope this helps

Prashanth

[Former Member]

Hi ,

from Purchasing Group drives Purchasing Org.

In PPOSA_BBP you can get the relation between PURCHASING Group and Purchasing Org.

You can find the same in HRP1001.

[Former Member]

Hi,

When it comes to vendor product relationship, you can refer to the interlinkage (where you can see the price of the material against the material). It is maintained in the product details.

else, you can refer to the supplier list where you can get to see the suppliers for a particular product or product category.

Thanks and regards,

Ranjan

[Former Member]

Hi,

For third you can use FM BBP_OM_STRUC_GET_USER_FROM_ORG.

Regards,

Nikhil

[Former Member]

Hi

For Second and Third Table is HRP1001

Regards

Trinath