ADRC Table

[Former Member]

HI

I have address no# that is there in ADRC. I wanted to know from which table it got updated? For Ex# in ADRC address no# is 12345, i wanted to know the address is of Sales org/co code, shipping point/Transpoint etc.

Its getting tough for me to find the relevant org data from this address no#.

Any wayforward?

Cio

Shan1242

[jiteshmehta]

Check the table in ADRC run in SE16 and give your data in Name and when you get the result check the field Address Group ADDR_GROUP this will give you idea that where it is defined.

Regards

Jitesh

[Former Member]

Hi

Thanks for your reply, unfortunately its not worked for me.

In ADDR_GET fun module its only giving me address...But not able to find from where it got updated.ADDR_GROUP giving CA01-Customising activity.

I tried in Sales org, com code,shipping with bygiving my address no 701500352 in Address field but failed to find any results.

Then how to find this address no# 701500352 of which table ?

Any clues

Cio

Shan1242

[Former Member]

Got the clue..

GOTO ADRV table it tells you the table name.. '

Thanks for all your support.

Reg

Shan1242

[Former Member]

Hi Shan,

ADRC is the address table and you will have address number in ADRNR of this table. It never directly updates from a single table. You will have ADRNRs with Oganizatin unti component tables.You can get the address from ADDR_GET function module also by giving the ADRNR as input to this function module.

Sales org components itself as field in their tables to get the ADRNR.

Check these table for the following

Sales Organization - TVKO and the field is ADRNR

Company codes - T001 and the field is ADRNR

Shipping point - TVST and the field is ADRNR

Thanks,

Vinay