Where to find the GR confirmation number?

[Former Member]

I would like to have access (via a FM) to the table, where the confirmation number for the GR is stored.

My aim is to check all the shopping carts from a user which haven't been GRd.

Any ideas?

Geoff

[Former Member · Accepted solution]

Hi,

You can use the FM 's BBP_PD_CONF_GETLIST to get the list of confirmations for SC's and "BBP_PD_CONF_GETDETAIL" to get details for a specific Confirmation.

Also you can directly query on table BBP_PDHGP.

BR,

Disha.

Do reward points for useful answers.

[Former Member]

Try to play with the tables:

bbp_pdacc

bbp_pdview_acc

bbp_pdview_iap

crdm_orderadm_h

Take a look ate SE16 and check the fields you want to join and get the desired results. Thanks,

Luis Miranda