cancel
Showing results for 
Search instead for 
Did you mean: 

shipto address

Former Member
0 Kudos
83

when u create a sales order, we need to give the shipto party address. I need to compare this address to the address already present in the customer master. Can u tell me the fields and the tables where the add.. is stored when creating a sales order??

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

As I mentioned in my earlier reply..You can get the address details from the table ADRC for the corresponding ADRNR.

Thanks

Naren

Answers (3)

Answers (3)

Former Member
0 Kudos

adrnr is of 10 char, where can we get the city, postal code and shipto name ?

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

You must use ADRNR to select against ADRC, there you will find the address fields including street, city, postal code, etc.

Regards,

RIch Heilman

Former Member
0 Kudos

Hi,

You can use KNA1-ADRNR to get the address details from the table ADRC

You can use VBPA-ADRNR to get the address details from the table ADRC..where the partner function PARVW = 'WE'.

Then compare those details..

Thanks

Naren

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

The dynamic address is stored in the table ADRC. You can get to this record using the address number found on the VBPA record(i think thats where it is)

Regards,

RIch Heilman