topic Re: Vendor Master Modification Report in Application Development and Automation Discussions

Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 13:56:07 GMT

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.

Re: Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 14:09:23 GMT

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

Re: Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 14:20:12 GMT

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

Re: Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 14:26:33 GMT

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

Re: Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 14:27:39 GMT

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.

Re: Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 14:32:22 GMT

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"

Re: Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 14:34:23 GMT

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.

Re: Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 16:00:09 GMT

Hi Andres,

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

Revert.

Re: Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 16:07:59 GMT

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 ?

Re: Vendor Master Modification Report

Former Member — Mon, 19 Jan 2009 16:13:52 GMT

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

Rob