[Internet Sales 4.0] How to get a list of product ids (GUIDs)

[Former Member]

I am trying to get a list of product ids from the shopping cart. Is there an easy way to get a list of product guids from the shopping cart? Maybe from Shop object?

[Former Member]

Eqbal,

If you have order guid, you can do the following to get product ids and product guids

Product id - ordered_prod field in table crmd_orderadm_i has product ids. Get all crmd_orderadm_i where header = order guid

Product guid - product_guid field in table comm_product has product guid. Join crmd_orderadm_i with comm_product on fields ordered_prod and product_id respectively.

<b>Please award points if this helps.</b>

Regards

Haseeb

[Former Member]

I am referring to the ISA web application. Sorry for the confusion. I am a comlete newbie to both SAP/CRM/ISA world.

Thanks.