extract items from BBP_PDIGP

[Former Member]

Hi,

I have a this requirement:

Exctract all the refused items of the Shopping Cart (BBP_PDIGP-SOURCE_REL_IND = 'Y') for current day (sy-datum).

i have implemented this solution:

with an inner join between tables BBP_PDIGP and crmd_orderadm_i i can extract all the refused items but i cannot find any date corresponding to the refusing action (BBP_PDIGP-SOURCE_REL_IND = 'Y') on the items of the shopping cardt

my code is:

SELECT crmd_orderadm_i~guid

crmd_orderadm_i~parent

crmd_orderadm_i~number_int

INTO CORRESPONDING FIELDS OF TABLE t_postes_annules

FROM ( crmd_orderadm_i INNER JOIN bbp_pdigp

ON crmd_orderadm_i_{guid = bbp_pdigp}guid )

WHERE bbp_pdigp~source_rel_ind = 'Y' . "Flag indiquant les postes annulés

• AND crmd_orderadm_i~changed_at IN lt_range_timestamp.

Then if execute the code above today i will exctract all the refused items and not only for the current day (sy-datum)

Do you have any ideas how to solve this problem

Best regards.

[Former Member]

Hi,

Thanks for your reply,in fact i had developped an enhacement in the include 'LBBP_PDIGPF3B' using a specific table.

Best regards

[Former Member]

Thanks for all,

the solution proposed by Laurent will not work :

So, i advise you to use BBP_PROCDOC_GETITEMLIST with import parameters:

- I_OBJECT_TYPE = 'BUS2121',

- I_CHANGE_DATE = sy-datum,

- I_ITEM_SOURCE_REL_IND = 'Y'.

because changed date contain the creation date of shoppin cart and not the date of ferusing action on the items (I_ITEM_SOURCE_REL_IND = 'Y'.).

i am thinking to create an enhacement to fill the changed date but i dont know how and in wich program.

regards

[former_member183819]

Hi

some clue

In CDHDR table captured the entry .

object class :- bbp_prodoc

utime field

ucode :- bbpsoco01

I noticed in the change log of shopping cart.

Muthu

[laurent_burtaire]

Hello Abdellatif,

I don't know your SRM release, but in 7.0, update in done inside method /SAPSRM/IF_CLL_DOM_SOCO_GAF1~COMPLETE_ITEMS from class /SAPSRM/CL_CH_WD_DOM_SOCO_GAF1.

Inside this method, /SAPSRM/IF_PDO_AO_SOCO~COMPLETE_ITEM from class /SAPSRM/CL_PDO_AO_SOCO makes a call to BBP_PDH_DB_DIRECT_UPDAT function module.

If you work on a lower SRM release, check how is called FM seen above or Muthuraman advise.

Regards.

Laurent.

[laurent_burtaire]

Hello Abdellatif,

I had same problem as you with SQVI transaction.

So, i advise you to use BBP_PROCDOC_GETITEMLIST with import parameters:

- I_OBJECT_TYPE = 'BUS2121',

- I_CHANGE_DATE = sy-datum,

- I_ITEM_SOURCE_REL_IND = 'Y'.

Then, check table E_PDITEMLIST.

Regards.

Laurent.

[former_member183819]

one idea..

Ok. go to SOST transaction . there you will get notification to the REQUESTER by the BUYER what cart was rejected(COMPLETED). so dig that table .

created :- Muthu on on 11.05.2010 08:36:36

Item 0000000001 from your shopping cart 10000xxx has been set to "completed" by the purchasing department. The reason may be one of the following:

The purchasing department cannot procure the item

The purchasing department cannot procure the item in its entirety

Muthu