Skip to Content

Linked PO and SC

Hi Experts,

How I can get number SC from PO?? I used BBP_PD for GUID PO and from this how I can get exactly table name of SC?

Also I tried use FM BBP_GETPO_DETAIL, and find SC number from E_Header_REL, but i need the table because I need PO in last three year and SC accordingly.

Thank you,

Yusup W

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2011 at 12:33 PM

    Hi Yusup,

    You can use table BBP_PDBEI. Provide your PO number in the field BE_OBJECT_ID and you will get your SC GUID in the field GUID.

    From this SC GUID you can fetch the SC number using FM BBP_PD_SC_GETDETAIL

    Regards,

    Nikhil

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 07:15 AM

    Hello ,

    Please follow the steps to get SC from PO.

    1. Pass the Purchase Order number to BE_OBJECT_ID field in BBP_PDBEI table.

    2.. take the GUID where BE_OBJECT_TYPE = BUS2201.

    Now we might get the Item GUID of Shopping cart

    3. pass the Item GUID of Shopping cart into CRMD_ORDERADM_I table and get header guid .

    4. pass the Header GUID of Shopping cart into CRMD_ORDERADM_H table

    to get the Shopping cart number

    Regards,

    Neelima

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.