Change Master Record details by Customer or Vendor number

[Former Member]

Hi There

i am trying to write a FD for a report where i need to list all the change has been made for the specific vendor or customer and listed down what is been change   fields) and the values as well

Input : Vendor /Customer number

Output : Date when change occurred , Field  , value , User ID of the person who change .

i tried to check the table CDHDR ,CDPOS , but where i can pass the vendor/customer number , and is there any link i can get from LFA1 or KNA1 which i can use to connect this table ? if you can help me to find the connection , it will be grateful

thanks

~Sonam

[former_member184701 · Accepted solution]

for customers in CDHDR

OBJECTCLAS is DEBI

and

OBJECTID is your customer number plus leading zeroes, for example, 0000110212 (customer number 110212)

for vendors KRED and same four leading zeroes

after you catch record in CDHDR you can jump to CDPOS using a key CHANGENR