Delta-Specific Field for Datasource 0BBP_TD_BID_1

[Former Member]

Hi experts,

I would like to know what the delta-specific field for Datasource 0BBP_TD_BID_1 is.

We have a custom module in SRM that allows the users to re-assign a Tender (Bid Invitation) to another user (Purchasing Group). However, after a user performs this action, the Tender is not inserted into the delta queue, hence in the BW (BEX) report, the Tender still reflects the previous Purchasing Group.

In our custom module we have taken care to update the Changed At field in CRMD_ORDERADM_H, but that does not seem to do the trick. The code to update is as follows:

GET TIME STAMP FIELD lv_time.

     UPDATE CRMD_ORDERADM_H
       set changed_by = sy-uname
           changed_at = lv_time
       where guid = ls_guid-guid.

COMMIT WORK AND WAIT.

* this is to create the change document for the change of purchasing group.

MOVE ls_guid-guid TO lv_objectid.
     CALL FUNCTION 'BBP_PRODOC_WRITE_DOCUMENT'
       EXPORTING
         objectid                = lv_objectid
         tcode                   = sy-tcode
         utime                   = sy-uzeit
         udate                   = sy-datum
         username                = sy-uname
         object_change_indicator = 'U'
         n_bbp_pdbeh             = ls_bbp_pdbeh
         o_bbp_pdbeh             = ls_bbp_pdbeh
         n_bbp_pdhgp             = ls_bbp_pdhgp
         o_bbp_pdhgp             = ls_bbp_pdhgp
         n_bbp_pdhsb             = ls_bbp_pdhsb
         o_bbp_pdhsb             = ls_bbp_pdhsb
         n_bbp_pdhsc             = ls_bbp_pdhsc
         o_bbp_pdhsc             = ls_bbp_pdhsc
         n_bbp_pdhss             = ls_bbp_pdhss
         o_bbp_pdhss             = ls_bbp_pdhss
         upd_bbp_pdorg           = 'U'
         n_crmd_orderadm_h       = ls_crmd_orderadm_h
         o_crmd_orderadm_h       = ls_crmd_orderadm_h
       TABLES
         xbbp_pdorg              = li_xorgdata1
         ybbp_pdorg              = li_yorgdata1
         icdtxt_bbp_prodoc       = icdtxt_bbp_prodoc
         xbbp_pdacc              = xbbp_pdacc
         ybbp_pdacc              = ybbp_pdacc
         xbbp_pdatt              = xbbp_pdatt
         ybbp_pdatt              = ybbp_pdatt
         xbbp_pdbei              = xbbp_pdbei
         ybbp_pdbei              = ybbp_pdbei
         xbbp_pdcon              = xbbp_pdcon
         ybbp_pdcon              = ybbp_pdcon
         xbbp_pddep              = xbbp_pddep
         ybbp_pddep              = ybbp_pddep
         xbbp_pddyn              = xbbp_pddyn
         ybbp_pddyn              = ybbp_pddyn
         xbbp_pddyn_fix          = xbbp_pddyn_fix
         ybbp_pddyn_fix          = ybbp_pddyn_fix
         xbbp_pdexr              = xbbp_pdexr
         ybbp_pdexr              = ybbp_pdexr
         xbbp_pdfrt              = xbbp_pdfrt
         ybbp_pdfrt              = ybbp_pdfrt
         xbbp_pdhcf              = xbbp_pdhcf
         ybbp_pdhcf              = ybbp_pdhcf
         xbbp_pdicf              = xbbp_pdicf
         ybbp_pdicf              = ybbp_pdicf
         xbbp_pdigp              = xbbp_pdigp
         ybbp_pdigp              = ybbp_pdigp
         xbbp_pdisb              = xbbp_pdisb
         ybbp_pdisb              = ybbp_pdisb
         xbbp_pdisc              = xbbp_pdisc
         ybbp_pdisc              = ybbp_pdisc
         xbbp_pdiss              = xbbp_pdiss
         ybbp_pdiss              = ybbp_pdiss
         xbbp_pdlim              = xbbp_pdlim
         ybbp_pdlim              = ybbp_pdlim
         xbbp_pdpset             = xbbp_pdpset
         ybbp_pdpset             = ybbp_pdpset
         xbbp_pdsdln             = xbbp_pdsdln
         ybbp_pdsdln             = ybbp_pdsdln
         xbbp_pdtax              = xbbp_pdtax
         ybbp_pdtax              = ybbp_pdtax
         xbbp_pdtol              = xbbp_pdtol
         ybbp_pdtol              = ybbp_pdtol
         xbbp_pdwgt              = xbbp_pdwgt
         ybbp_pdwgt              = ybbp_pdwgt
         xcrmd_orderadm_i        = xcrmd_orderadm_i
         ycrmd_orderadm_i        = ycrmd_orderadm_i
         xcrmd_partner           = xcrmd_partner
         ycrmd_partner           = ycrmd_partner
         xcrm_jest               = xcrm_jest
         ycrm_jest               = ycrm_jest.

We are running SAP_BW release 700 and SRM_SERVER release 550.

Any advice on what we have missed would be greatly appreciated.

Thank you very much!

Best regards,

Kwonghow

[former_member197610]

Hi Kwong,

Did you check the updates in CRMD_ORDERADM_H ? is it reflectin your change?

make sure the same changes you are seeing in CRMD_ORDERADM_I table too...

The extraction includes both the tables CRMD_ORDERADM_H and CRMD_ORDERADM_I.

Usually the changed documents should be pulled up in your next delta extraction. Also can you check if you have any delta specific time settings in BWOM_Settings table....

Hope this helps...

[Former Member]

Hi Suresh,

Yes, CRMD_ORDERADM_H is reflecting the change.

Our Bid Invitations are assigned to users are the Header level. Individual items do not have assignments.

I have gone to look at my PSA data and I have observed that the following scenario works:

- Bid Invitation was Published (status I1011) on date 01.09.2013.

- Bid Invitation was manually marked as Transaction Complete (status I1023) by the user on date 31.10.2013. This is a standard SAP function.

- In such a case, standard SAP updates the Bid Invitation Header Changed At date as 31.10.2013, but leaves Item Changed At date as 01.09.2013.

This record was in fact picked up during the delta-load. Therefore I would think that the Item Changed At date would not matter.

I was unable find a table called BWOM_Settings.

Thank you for your help.

Best regards,

Kwonghow