topic Re: Address number assignment in Application Development and Automation Discussions

Address number assignment

Former Member — Tue, 19 Jul 2011 18:58:01 GMT

How can I know address number "123456" has been assigned to what?

Re: Address number assignment

glauco — Tue, 19 Jul 2011 19:14:11 GMT

Hi.

What do you want to do ?

If you are taking about tables like ADR6 or USR21, this is a key field to some tables which holds user's personal information.

Can you explain more details about your doubt ?

best regards.

Glauco

Re: Address number assignment

Former Member — Tue, 19 Jul 2011 20:48:32 GMT

One of my user wants me to change the address for the address number "123456", neither me nor my user know whom this address number is assigned to (For example Ship-to-Party or Plant or Shipping Point etc). I can see the address number"123456" in table ADRC, But I do not know where do I go and change the address for this address number. as I am OTC guy I would prefer to maintain this address number through Functional roles

Re: Address number assignment

glauco — Tue, 19 Jul 2011 21:04:58 GMT

Sorry.

I don't know about your specific issue. If you can explain more detailed what you want maybe I can help you with a more accurate information.

But I think it's a kind of key to users' address tables in SAP. I think it must be for internal use only.

If may help you, in transaction SU01 you can mantain users in SAP. There you put users data, adress, mail, phones, etc.

There are many tables in SAP to store user's data, line ADRC, ADR6, USR21, etc.

regards.

Glauco

Re: Address number assignment

Clemenss — Tue, 19 Jul 2011 21:21:27 GMT

Hi Rajesh,

there is no where-used-list for addresses. If you do not know where the address is used, there is no need to change it

Otherwise check The Usual Suspects: Customer, Vendor, user, ...

Regards,

Clemens

Re: Address number assignment

JackGraus — Wed, 20 Jul 2011 04:25:03 GMT

Hi Rajesh, you can use function module ADDR_REFERENCE_GET for this. Either call it from within your ABAP coding or by making a test call in transaction SE37.

Supply the address number "123456" to input parameter ADDRESS_NUMBER.

The reference table to which the address is assigned will be returned in output parameter REFERENCE_TABLE. Field APPL_TABLE holds the table to which the address is assigned.

Regards Jack

Re: Address number assignment

Former Member — Thu, 21 Jul 2011 11:37:19 GMT

Sorry Gurus for coming late on this

Thanks for replies

I have come to the core of the issue

Issue: I have a ship-to-party for whom I can see one address in delivery note is different than one in customer master, Both address have different address number let say "123456" and "987654" respectively.

Now I need to change the address that is reflected in delivery note

Where can I change this address?

Re: Address number assignment

JackGraus — Thu, 21 Jul 2011 12:17:15 GMT

During delivery create the shipto and shipto address get copied into the delivery. The address is in VBPA-ADRNR. It will have the same address as the shipto partner in KNA1-ADRNR. When you change the address in the delivery a new address will be created in VBPA-ADRNR.

Transaction to change delivery is VL02N. Then goto shipto partner and change the address.

Regards Jack