SRM Tables

[Former Member]

Good morning,

Could anybody send me a list of the most important tables on SRM?

I particullary interested on documents tables (offer, bid,...)

My id is capgemini.ifernandez@navantia.es

Regards,

[Former Member · Accepted solution]

Hi,

Sent an attachment having SRM tables from my ID <removed by moderator>....to your ID <removed by moderator>.....

Please reward points if found useful.

Thanks

Venkat

[Former Member · Accepted solution]

hi Venkat,

Could you please send the attachment to me too. my mail id is <removed by moderator>.....

I shall reward you with points.

Thanks,

Vatan

[Former Member · Accepted solution]

Hi vatan,

Sent you the docs from my ID <removed by moderator>.... to your email ID <removed by moderator>.....

Thanks

Venkat

[Former Member · Accepted solution]

Hi Venkat,

Thanks a lot. I recieved the same.

Regards,

Vatan

[former_member224247 · Accepted solution]

Hi Venkat,

Can you please send to me also at <removed by moderator>....?

Thank's

[Former Member]

Hi,

1)Product category

COMM_PRODUCT (Product table)

COMM_CATEGORY (Product category table)

ROST_SEL_PRODCAT: Product Categories for Registration

2) BUT000 table for all kind of partners in SRM (Bidders, Vendors, contact persons, suppliers, goods recipients, etc..)

3) Table VENMAP for Vendors replicated from R/3 backend using BBPGETVD Transaction.

ROST_LANG_QSTN -> Language Selection for Question

ROST_PCAT_QSTN -> Assign Product Category and Questionnaire to Lan

ROST_SEL_PRODCAT -> Product Categories for Regis

ROST_WS_QSTN -> Web Survey Questionnaire

ROS_BP_PC_SURVEY -> Assign Vendor, Product Category, Survey

CRMD_IC_SCRATTR Script/Survey attributes (Interactive Script Editor)

ROST_WS_QSTN Web Survey Questionnaire

ROS_BP_PC_SURVEY Assign Vendor, Product Category, Survey

TUWS_SURVEY Survey

TUWS_SURVEY_LOG Survey Log

TUWS_SURVEY_PUB Survey Publishing

TUWS_TAROBJ Survey: Recipients

TUWS_TAROBJ_ATTR Survey: Recipient Attributes

Dont Forget to Reward Full Points.

Regards,

Ashwin.

[Former Member]

Can anyone please provide information about SRM table which store information about Purchase Requisition, Purchase Order, Goods Receipt and Invoice?

I checked BBP_PD tcode and found that there are couple of structures which holds the PR, PO value at run time, but i am looking for transperent table which holds the PR/PO/GR/IR value locally in SRM system.

Regards,

SAP Guy.

[Former Member]

Hi,

The most imp tables are CRMD_ORDERADM_H(header) and CRMD_ORDERADM_I(item).

Other than that you can find GR,Invoice related info in tables BBP_PDHGP(header) and BBP_PDIGP(item).

In addition to that you have several FM's(E.G. BBP_PD_SC_GETDETAIL

to get details of a particular Shopping Cart) which directly give you all the deatils related to the diff docs in SRM.So you can use these FM's directly instead of querying the std tables!

PR is not created in SRM!The requirement in SRM is in the form of Shopping cart.

BR,

Disha.

Do reward points for useful answers.

[Former Member]

HI,

The following are the most common tables you can find the Procurement Documents related data:

Header Data:

CRMD_ORDERADM_H

BBP_PDHGP

Item Data:

CRMD_ORDERADM_I

BBP_PDIGP

BBP_PDBEI

If you are very keen in knowing the complete list of tables, please follow this

1. Activate the SQL Trace in ST05 transaction

2. Execute the function for reading the data appropiately

2.1 BBP_PD_SC_GETDETAIL - Shopping Cart

2.2 BBP_PD_PO_GETDETAIL - Purchase Order

2.3 BBP_PD_CONF_GETDETAIL - SRM Confirmations

2.4 BBP_PD_INV_GETDETAIL - Invoice and Credit Memo

3. Once the function modules have selected the data, deactivate the trace and display it.

This will give you the complete list of tables.

Hope this solves your problem.

Regards

Kathirvel

[former_member850518]

Hi Kathirvel ,

Kindly help me i new in SAP from ARIBA .

I got the details of Shopping cart by opening the function module BBP_PD_SC_GETDETAIL from SM37 , but was not able to

find the deatils from th steps you have provided .

After ST09 , i turned on the SQL Trace . How to proceed after that .

Is their is any way to run queries like .

select * from CRMD_ORDERADM_H where createdby = 'username'