hi guru's want to find the field in SRM

[Former Member]

I am new to SRM i have got an object.. in which

we have a shopping cart i am able to get the shopping cart to the r3 as purchase req.. Now i want to check for the purchase req number in the Shopping cart i have tried many table ... i am not able to fine the Table and field of the purchase req NO...

can any one tell me the table name and the field

i have nearly spent a day on this Issue.

Thanks & regards ,

Vijaybasker Sundaram

720-982-9026

[Former Member]

Hi,

If you want to get the SC number thru development, use <b>FM BBP_PD_SC_GETDETAIL </b> passing the GUID or OBJECT_ID as input parameter, there you will find all the relevant information related with the SC and also the relations with follow-on documents and the status of the <b>data transfer to R/3</b>.

E_STATUS (table with all the document and item lines status).

E_HEADER_REL (document header relations)

E_ITMLIM_REL (item lines relations)

Regards,

Gerardo.

[Former Member]

Hi

Based on the Shopping cart number, <b>use that in transaction BBP_PD</b> and specify the same as Object_ID to get all the relevant tables and all the required information in the SRM system.

Hope this will help.

Please reward suitable points.

Regards

- Atul

[Former Member]

Hi,

In the table CRMD_ORDERADM_H/ CRMD_ORDERADM_I,you will find the SC no/SC guid.

With this GUID query the table BBP_PDBEI ,in the field BE_OBJECT_ID you will find the PR no.

HTH.

BR,

Disha.

Pls reward points for useful answers.