Difficult to list display changes in Vendor Master

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Post Reply
Posts: 707
Joined: Mon Jul 28, 2003 11:38 pm

Difficult to list display changes in Vendor Master

Post by GreenGreen » Tue Apr 09, 2019 5:24 am

Dear Experts,

It is well-known that there is no standard SAP report that can list display Vendor by the changed date.
As Vendor Tables LF* contains no data change date, I need to search the change document table CDHDR to identify which change document came from Vendor Master.

However, it seems that there are many "Object class" and "Object value" relates to the change of Vendor Master fields.
For examples, Object Classes "ADRESSE", "ADRESSE3" and "KRED", I have no idea on where the Object value came from.
Is there anyone to advise me how i can join the CDHDR with LFA1 with specific "Object values"?

Thanks & regards,

Green Green

Posts: 1955
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: Difficult to list display changes in Vendor Master

Post by Gothmog » Wed Apr 10, 2019 7:18 am

You won't be able to join the tables (type mismatch), but regarding how some of the keys are contructed :
- for KRED (for vendor data), the object is LFA1-LIFNR
- for ADRESSE for the vendor adress, the object is 'BP ' + LFA1-ADRNR
- for ADRESSE for a contact business adress, the object is 'BP ' + KNVK-ADRND
- for ADRESSE for a contact home adress, the object is 'BP ' + KNVK-ADRNP
- for ADRESSE3 for contact data, the object is 'BP ' + KNVK-PRSNR + LFA1-ADRNR
- for IBAN, the object is the key of table TIBAN (with TIBAN-TABNAME = 'LFBK' and TIBAN-TABKEY = LFBK-LIFNR
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67

Post Reply