topic ADRC Table in Application Development and Automation Discussions

ADRC Table

Former Member — Wed, 28 Jun 2006 06:28:39 GMT

when i create shipping Partner information by VT02N

And there address number is vailable in ADRC table.

when I change the Partner informations manualy in Partner Screen.... one of New Address number is createed by automaticaly with 90* and Adress Group SD01,

so my qustion is , how i getting this new adress number.

against the customer

Re: ADRC Table

Former Member — Wed, 28 Jun 2006 06:37:02 GMT

Hi Nelson,

it will generate new Numner Series for ur Changes in that Address. this changes will reflect in that transaction only bcos of this new ADRNR.

Regards

Prabhu

Re: ADRC Table

Former Member — Wed, 28 Jun 2006 06:40:03 GMT

Hi Nelson,

go to KNA1 table and find an entry for ur customer number. in that u will find field called ADRNR whcih will contain the address number.

Re: ADRC Table

Former Member — Wed, 28 Jun 2006 06:47:36 GMT

table ADRC Addresses (Business Address Services)

contain every address details. u have to pass adrnr in ADRC table it gives all details of address like name city strret etc.

if u change in any addres it create new adrnr and store all rthe address related value in adrc.

but in ur case u want new address of shipment.

don't worry it take new address.

becoz all tables all link.

u find forwarding agent from VTTK and corresponding forwarding agent u get adrnr number from VBPA ( it is new) now from this adrnr (address number ) u get all the details address from ADRC and ur new value already store in ADRC.

Re: ADRC Table

Former Member — Wed, 28 Jun 2006 06:49:20 GMT

Hi,

Do u want to retrieve new address number then check table BUT020

Re: ADRC Table

Former Member — Wed, 28 Jun 2006 15:13:46 GMT

Even though the master data for the customers is maintained in KNA1 and the address is linked using the address number, you can still allow users to change the address on the fly in any sales document through config. Because of this, you will get a different address number on the SD document than that is stored in KNA1 for that partner. You have to go to VBPA for that document and then you get the new address number. Use that to go to ADRC to get the entire address.

Re: ADRC Table

Former Member — Wed, 28 Jun 2006 15:19:19 GMT

Get the Address number from Table VBPA where partner function(PARVW) is 'WE'.

then use FM: SD_ADDRESS_GET

then u'll get the latest address.