Skip to Content
avatar image
Former Member

hi guru's want to find the field in SRM

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 17, 2007 at 05:52 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2007 at 12:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 19, 2007 at 11:59 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded