2009 Jan 19 1:56 PM
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.
2009 Jan 19 2:20 PM
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
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
2009 Jan 19 2:09 PM
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
2009 Jan 19 2:27 PM
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.
2009 Jan 19 2:20 PM
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
2009 Jan 19 2:32 PM
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"
2009 Jan 19 2:26 PM
Hi
41906 should be your vendor in this case if I am not wrong..
2009 Jan 19 2:34 PM
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.
2009 Jan 19 4:00 PM
Hi Andres,
Could you check if 41906 is the addrnumber in ADRC table?
Revert.
2009 Jan 19 4:07 PM
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 ?
2009 Jan 19 4:13 PM
Have a look at FM CHANGEDOCUMENT_READ. It's well documented.
Rob
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |