In EBP table that links the Backend Confirmation number and the PO

[Former Member]

Hi,

We need the table or functional module that links the Purchase Order number and the Goods Receipt has been done in the Backend R/3.

How to get this link?

Many thanks in Advance.

Regards

Charan

[Former Member · Accepted solution]

Hi,

If you go to t.code BBP_PD, Then give the SC no in object id field. After that you will able to see one line. Click on that it will show many things, Click on the line item. It will take you to another page. There you will find out PO numbar, if follow-on-document has already created.

Taking that PO No.: You can find GR no in R/3 side.

If it will work don't forget to give points

Thanks.

[Former Member]

Hi,

You can query the tables BBP_PDHGP and BBP_PDIGP to get the refernce doc no for PO and then use FM BBP_PD_CONF_GETDETAIL to get the details fo a particular confirmation.ALso you can search confirmations by "Reference Document", use BBP_PD_CONF_GETLIST, with parameter I_REF_DOC_NO, and then use BBP_PD_CONF_GETDETAIL for the found confirmations.

HTH.

BR,

Disha.

Pls reward points for helpful answers.

[Former Member]

Hi,

We are not using the reference doc number. The case is:

I know the PO number ( i can get H Guid and Item Guids). Now i want to get the backend GR number (ie GR done directly in R/3 and no Numbers generated in EBP).

How to get this?

[shanmuga_raj]

Hi,

Even if we are passing the confirmation number to the FM conf getlist and conf getdetail, its giving the detail of local confirmation (that is done in EBP) and not the R/3 goods receipt.

How to get the r/3 GR details in EBP system.

[Former Member]

Hi,

If your PO is in SRM (and replicated into R/3), and the GR is created directly in R/3, then there is no reference of this R/3 GR in SRM. The only way to get it it to read the backend PO history.

To do this, you can try to call the BBP_PD_PO_GETDETAIL is SRM, with I_READ_BE_DATA = 'X'.

You will get your R/3 reference (R/3 material doc number) in export tables E_HEADER_REL and E_ITMLIM_REL, and actual item values in E_ACTVAL.

Rgds

Christophe

PS: please reward points for helpful answers