Vendor Master Modification Report

[Former Member]

Hello,

I'm creating a report which must show the modifications done to a Vendor Master Record by a group of users. I work with two tables: CDHDR and CDPOS to extract the modified data.

One of the requirements of this report is that it show's which Vendor Code (Number) was modified. I thought that this information could be extracted from table CDHDR, from the field Object ID, but this field doesn't contain it. Objects ID values are like this: "BP 0000041906".

Is there any other way to extract a Vendor Code knowing the Object Id Value from this table or should I look for this information in another place?

Thanks for your help.

[Former Member]

Hello,

I'm creating a report which must show the modifications done to a Vendor Master Record by a group of users. I work with two tables: CDHDR and CDPOS to extract the modified data.

One of the requirements of this report is that it show's which Vendor Code (Number) was modified. I thought that this information could be extracted from table CDHDR, from the field Object ID, but this field doesn't contain it. Objects ID values are like this: "BP 0000041906".

Is there any other way to extract a Vendor Code knowing the Object Id Value from this table or should I look for this information in another place?

Thanks for your help.

[Former Member]

Could there be a link to the vendor master table (LFA1)?

Try to see if there is a link to the tables you have already used.

Blacky

[Former Member]

Hello, thanks for your answer.

I just checked tables LFA1 (Vendor Master) and CDHDR(Change Document Header) and there are no references between any field.

[Former Member]

Hi,

In your case the object id should be "KRED"..then you can extract the lifnr(vendor number) values..

Hope the info was helpful.

Regards

Vasavi kotha

[Former Member]

Hello, thanks for you answer.

You are right, when the Object Class is KRED the Object Value contains the Vendor LINFNR. When I change de email address for example for a vendor master the Object Class Changes to ADRESSE and the Object Value doesn't contain the Vendor Number, instead it contain the following value: "BP 0000041906"

[Former Member]

Hi

41906 should be your vendor in this case if I am not wrong..

[Former Member]

Hello Ankeshk, thanks for your reply.

I checked that also and the las digits of the Object Value doesn't correspond to the Vendor Number.

[Former Member]

Hi Andres,

Could you check if 41906 is the addrnumber in ADRC table?

Revert.

[Former Member]

Hello Ankesh, thanks for you help.

Actually 0000041906 is the address number (ADDRNUMBER) of the vendor whose master record was changed.

The problem then is that depending on which object is modify on the Vendor Master Record, I would have to look for Vendor Number using different tables ?

[Former Member]

Have a look at FM CHANGEDOCUMENT_READ. It's well documented.

Rob