topic cdpos table in Application Development and Automation Discussions

cdpos table

Former Member — Sat, 13 Dec 2008 04:52:15 GMT

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.

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

Re: cdpos table

Former Member — Sat, 13 Dec 2008 06:06:54 GMT

hi shilpi,

As per my knowledge there is no any this kind of table which will store the information of the business partner against the user ( who is deleting the records or creating ).

If you want business parrtner id only, then talk to your functional about this.

Ask him if he really has that kind of requirement then you will have to create a master table for the user and his business partner id and corresponding maintainace view.

hope this will help u out.

Re: cdpos table

Former Member — Sat, 13 Dec 2008 06:16:47 GMT

Hi Manisha ,

Thanks for the quick response.

The business partner ID of the user deleted or inserted is required because this information has 2 be sent to a legacy system.

If such a table does not exist then how can i achieve this requirement?

Thanks and Regards

Shilpi

Re: cdpos table

Former Member — Sat, 13 Dec 2008 07:59:15 GMT

hi shilpi,

This user is employee of your company or a vendor or customer ?

Make sure about the above information.

from user master can you get the address number for the user?

address number is in adrc.

if you are able to get the this address no then there is table which gives the relationship of business partner with address no . check this table BUT020 .

I have never worked on business partner senario but i can tell you that business partner gets created depending upon different types as vendor employee or customer.

so in your senario just identify what kind of user is that.

depending on type there is a table BUT000 (General Data)

depending on Roll BUT100 (BP: Roles)

hope from this you can atleast get a lil bit light...