cdpos table

126 Views

Hi,

When i make changes in transaction crmd_order and entry is made in the cdpos table with the transaction's ID ,old value ,new value,tabname.

Now my requirement is that i have to fetch the business partner id on which this change was performed.

In activities screen on the UI there is an assignment block 'Attendees'.I have to keep track of the attendees deleted or inserted and update a Z transparent table with the following details:

1.The transaction ID.

2.The timestamp.

3.The action porformed-insertion or deletion.

4.the Business partner ID of the person deleted or inserted.

Now from the table CDPOS i can get the first 3 values but i m unable to get the 4th value.I cant query the BUT000 table with NEW_VALUE or OLD_VALUE of table CDPOS as description need not be unique for a business partner.

The objectclass value i get is CRMD_ORDER in table cdpos.

Then how can i get the business partner Id?

Please help!I have been stuck with this for a long time now:(

Thanks and Regards

Shilpi