Answer:
It depends on the what changes you have done in customer master. There are many tables such as:
1. Accounting: Secondary index for customers - BSAD, BSID
2. General Data in Customer Master - KNA1
3. Customer Master (Co. code) - KNB1
4. Customer Master (Dunning data) - KNB5
5. Customer Master (Partner functions) - KNVP
6. Customer Master (Sales Data) - KNVV
7. Customer Master Record Sales request form - KNVD
You can also check the below report:
S_ALR_87012182
S_ALR_87012183
S_ALR_87012195
In SAP if the customer's address is updated (XD02 0r VD02) then all Sales Orders will automatically reflect the new address.
When in Customer Master Record, the Address is changed:
Sold To, Bill To, Payer Address has Changed to New Address, even for Old Sales orders Orders Created in previous dates, orders were delivered and billed, however Ship To Address has not been changed.
By getting order history in VBAK Table, now take old order, look at VBPA Table -> get the ADRNR, do compare with ADRC and do populate.
You can see CDHDR, CDPOS table.
Sales orders are transaction data and customer address is master data.
Typically addresses in sales orders should not be taking the latest address from the master data. It should retain the address from the time sales order is entered. Also, you can change the address directly in the sales order without effecting the master customer address.
The address is pulled as KNA1-KUNNR = VBAK-KUNNR and then getting the address. Instead you should use ADRC-ADRNR = VBPA-ADRNR
VBPA-ADRDA determines whether the address is updated.
