on 11-24-2008 4:56 PM
Hello,
When an order is entered, the delivery address defaults to that given by the Ship-To partner. In our business, we occasionally change the default delivery address by double-clicking on the Ship-To partner. This brings up the address screen to allow changes. These are then keyed in and the order is saved.
We need to extract this changed delivery address from SAP. Any idea if there's a table I can access to do this?
Thanks for your support.
Mike
Hi
you can develop a report using the following logic
1) select VBPA-ADRNR for VBELN=order number and PARVW=SH
2) select KNA1-ADRNR for KUNNR=ship to party in order
3) compare VBPA-ADRNR with KNA1-ADRNR and if they are different then address has been changed
4) select address details from ADRC by passing ADRC-ADDRNUMBER=VBPA-ADRNR
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
When you enter a different address in any partner in the sales order a number will be saved in table VBPA, field ADRNR (CHAR 10). With this number You must go to table ADRC (depends on the version....but normally this is the table) and access with the number retrieved from VBPA in field ADDRNUMBER, and there you have !!
Let me know if this helped you !
Thanks,
Alcides Fialho
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
97 | |
9 | |
8 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.