Changing the partner address in a sales document
The situation is that someone manually changed an address on a sales order partner, and I'm trying to find out who did the change. (everyone is saying that they did not make the change)
When I create a sales order (VA01), it pulls in the partners and partner address from the customer master. This information is stored on table VBPA.
VBPA captures the customer master number, address number and a change indicator (D - customer master). If while in the sales order (VA01/VA02) I go to the partner tab and double click on the partner, it allows me to change fields on the address. The changes are saved in the address table (ADRC) with a new address number 90000xxxxx. If I go back and look at the partners on VBPA, I see that for the partner I changed, it has the new address number and the changed indicator is now (E - manually changed).
I can see that the address has been manually changed in the sales order, my question: is there anywhere to see WHO, or WHEN the new 90000xxxx address was created? When I look in the sales order, it captures other changes that are made, but not the change to the partner address. When I look at ADRC, I don't see a created by / on fields. The customer master is not changed in this situation, so it is not updated with the change.
Is there any other table that might capture the id that made the change and when the change was made?
Kok Wai Phang replied
If you merely need to know WHO or WHEN the new address was created, then you may consider checking who and when it was changed from the CDHDR and/or CDPOS tables.
Since your suspicion is that the address was changed from Sales Order create/change, then consider the following:
a) In table CDHDR (in SE16), input TCODE = "VA01" and/or "VA02".
b) Maintain OBJECTCLAS = "ADRESSE"
c) Maintain OBJECTID = "SD0190000xxxxxx" (the number in BOLD is the corresponding ADRNR number unique to the Partner Function obtained from table VBPA with reference to the Sales Order document, where the indicator for this partner function is marked "E" (address changed manually)"
Execute this parameter.
You would be able to find out from the results the following:
1) Who have changed the address (USERNAME field)
2) When it was changed (UDATE + UTIME fields)
Hope the above helps.