SRM Tables

[former_member504447]

Hi Friends,

Can you clarify below questions...

What is the table to see

• Company code
• Pur.Org
• Pur.Grp

And table to get Object ID of

• Company code
• Pur.Org
• Pur.Grp
• Product Category

Table to see

• Purchase Org assigned to company code
• Pur.grp assigned to a Pur.Org
• Employee assigned to a Pur.grp
• Plant assigned to a Pur.grp

Table to see BP number of

• Company code
• Pur.Org
• Pur.Grp
• Product Category

Table to see BP number  of below based on Object ID

• Company code
• Pur.Org
• Pur.Grp

Table to see Product category of Product based on product id

Thanks ,

San

[Former Member · Accepted solution]

Hi,

Please use below tables:

HRP1000 - for finding the object ID of company, P org or P grp - you need to pass the "name" or may be the company code in the "obj abbr" field

HRP1001 - Pass the above object ID in this table and you will get the corresponding BP number as well as the related objects like P org, P grp etc.

Hope this helps.

Regards,

Ajay

[former_member504447 · Accepted solution]

Hi,

HRP1001 - Pass the above object ID in this table and you will get the corresponding BP number as well as the related objects like P org, P grp etc.

can you pls tell me the techincal  field names?

[Former Member · Accepted solution]

Hi,

In HRP1001, object ID field is OBJID.

In the output - SOBID is the related object's id to the OBJID which you passes on the input screen

                    -  VARYF is the BP number of this OBJID for value B (RSIGN) and 207 (RELAT)

Regards,

Ajay

[konstantin_anikeev]

Hi Sankar,

What is the table to see

• Company code
• Pur.Org
• Pur.Grp

And table to get Object ID of

• Company code
• Pur.Org
• Pur.Grp
• Product Category

Suppose you need a view HRV5500A

Table to see

• Purchase Org assigned to company code - no such assignment
• Pur.grp assigned to a Pur.Org - HRP1001 - objects direction bottom->up until purchasing organisation
• Employee assigned to a Pur.grp - HRP1001 - objects direction up->bottom, but better the function
• Plant assigned to a Pur.grp - no such assignment

Table to see BP number of

• Company code - HRP1001
• Pur.Org - HRP1001
• Pur.Grp - HRP1001
• Product Category - there is no BP for Product category

Table to see Product category of Product based on product id

http://scn.sap.com/thread/3436930

Regards

Konstantin

P.S. very bad approach to use DB tables to retrieve info in SRM. There are a lot of classes/functions (depending on release) to do that.

[former_member504447]

Hi Konstantin,

can you pls tell me..

Which field in HRP1001 refer Business Partner number?

I need to find BP number of Plant as well..

regarding:

• Plant assigned to a Pur.grp - no such assignment

We are assiging/maintaining location Under Purchasing group extended attribute tab right?can see this assignment in some table?

[konstantin_anikeev]

Hi Sankar,

for BP see the answer of Ajay.

For plant check the view HRV5502A

Regards

Konstantin

[former_member190689]

Hello Sankar,

   Try the Tcode - BBP_PD providing you object_id(SC no) or your SC guid. Under that you will find all your related SRM tables.

Thanks

Gaurav Gautam