how to get shopping cart follow-on document confirmation and invoice

[benjamin_herzig]

Hi,

we are on SRM 7.0 and use extended classic szenario.

Now i have a requirement to get the confirmation number and invoice number for a z-report. I can see this follow-on documents in our shopping carts:

How to get the confirmation and invoice number?

I know how to get purchase requisition and purchase order number, but i can´t find the confirmation and invoice number? They are not in table BBP_PDBEH or BBP_PDBEI!

Hope someone can help me out.

Best Regards,

Ben

[ricardo_cavedini · Accepted solution]

Hello,

You can try to use function module BBP_PD_SC_GETHISTORY.

You have to pass the header GUID in H_GUID, item object type (BUS2121001) in I_OBJECT_TYPE and item GUID in I_GUID.

Then you would have the cart history in table ES_HISTORY.                                 

Regards,

Ricardo

[benjamin_herzig · Accepted solution]

Hi Ricardo,

that´s exactly what i´m looking for. Thank you.

Regards,

Ben

[Former Member]

Check the next tables:

CRMD_ORDERADM_H --> SRRELROLES -->BBP_PDBINREL -->SRRELROLES -->CRMD_ORDERADM_H

[former_member208244]

Hello Benjamim,

Take a look on BBP_DOCUMENT_TAB, there you have the GUID links of the documents required.

Kind Regards,

Reward points if usefull.

SG