Table & filed name required

[Former Member]

Dear Gurus,

presently we are working on a report development.

we have to archive all the shopping carts for which final entry indicator is marked.

we are looking for a table and field, where we get the shopping cart status " held".

can anyone tell us, in which table we get the field .

I have already checked the Tables BBP_PDHGP and BBP_PDIGP

This is very urgent...

full points for all.....

Thanks in advance

Rgds

Shrigiri

[Former Member]

Hi,

Status table is called CRM_JEST and status "held" have name I1009 in column STAT, so you must write something like that:

(table CRM_JEST have field OBJNR. This is the GUID of the header)

select amh~object_id
          ami~number_int
          ami~description
          jest~stat
into   (wa_temp-object_id,
         wa_temp-number_int,
         wa_temp-desc,
         wa_temp-stat )
from crmd_orderadm_h as amh
 inner join crmd_orderadm_i as ami
  on ami~header = amh~guid
 inner join crm_jest as jest
  on jest~objnr = amh~guid
where jest~stat = 'I1009'.

Regards,

Marcin Gajewski

[Former Member]

Hi,

You can use the FM's BBP_PD_SC_GETDETAIL / BBP_PRODCDOC_GETSTATUS.

BR,

Disha.

Pls reward points for useful answers.

[mani_sreedharala]

Hello ,

Use the function module BBP_PROCDOC_GETLIST.

You can also get some code snippets from the program BBP_PD_F13/BBP_PD_F01.

Regards,

Mani

[Former Member]

Hi

Which sRM version are you using ? What is the detailed requirement ?

<b>Use BBP_PD Transaction to get the complete Shopping cart deatils for object type BUS2121.</b>

<u>Alternative approach -></u>

Table CRMD_ORDERADM_H contains the Shopping cart header GUID and shopping cart number.

Table CRMD_ORDERADM_I contain Shopping cart line item data. Every line item will have same SC Parent Header GUID reference.

<b>In TJ02T table, you can get the status descripition of the Shopping cart based on the SC Header GUID. (Standard staus like I1015 -> awaiting approval, I0129 -> approved, I0131-> held etc..)</b>

Hope this will help.

Regards

- Atul