Address number assignment

[Former Member]

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

[glauco]

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

[Former Member]

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

[glauco]

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

[Clemenss]

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

[JackGraus]

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

[Former Member]

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?

[JackGraus]

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