topic Customer Address in Application Development and Automation Discussions

Customer Address

Former Member — Thu, 13 Sep 2007 09:02:30 GMT

How do everyone,

I am looking at the customer master data on KNA1. There is an address field

no ADRNR.

Using this field I am trying to locate the customers address without much

success.

Does anybody know if there is database lookup table with the address stored

or a FM to bring back the address. I have tried searching for an appropiate

address FM selection again without much success.

Any suggestions much appreciated.

Andy

Re: Customer Address

Former Member — Thu, 13 Sep 2007 09:05:02 GMT

Hi Andy,

User <b>ADDR_GET</b> function module to get address for the customer address number.

Check this code.

Data: V_ADDR TYPE ADDR1_SEL.

V_ADDR-ADDRNUMBER = KNA1-ADRNR.

CALL FUNCTION 'ADDR_GET'

EXPORTING

ADDRESS_SELECTION = V_ADDR

IMPORTING

SADR = SADR

EXCEPTIONS

PARAMETER_ERROR = 1

ADDRESS_NOT_EXIST = 2

VERSION_NOT_EXIST = 3

INTERNAL_ERROR = 4

OTHERS = 5.

Check SADR for customer address...

Thanks,

Vinay

Re: Customer Address

Former Member — Thu, 13 Sep 2007 09:13:27 GMT

Hi T

he field is

VBPA-ADRDA

thanks

vivekanand

reward if helpful

Re: Customer Address

Former Member — Thu, 13 Sep 2007 09:17:23 GMT

Take the ADRNR of KNA1 and goto ADRC and check the same with ADDRNUMBER you will get the master address data

Regards

Shiva

Re: Customer Address

Former Member — Thu, 13 Sep 2007 09:31:57 GMT

Thanks Shiva,

But that table seems to be the Business address and not the customer address.

Any other tables.

Thanks also Vinay, at least I now know a FM if I can't find the table.

Ideally I would like to find the database table so that I can store them

all in an internal table.

Andy

Re: Customer Address

Former Member — Thu, 13 Sep 2007 09:37:13 GMT

Hi Andy,

ADRC is master table for addresses all the addresses of customers are stored here.

Regards

Shiva

Re: Customer Address

former_member404244 — Thu, 13 Sep 2007 09:38:58 GMT

Hi,

check the table SADR..

Regards,

Nagaraj

Re: Customer Address

Former Member — Thu, 13 Sep 2007 09:44:00 GMT

Shiva,

My mistake I was using an incorrect ADRNR.

You was right in the first instance. Good man !!!

Many thanks

Andy

Re: Customer Address

Former Member — Thu, 13 Sep 2007 09:45:06 GMT

You can use the FM ADDRESS_INTO_PRINTFORM

just pass 1 for ADDRESS_TYPE &

your ADRNR into ADDRESS_NUMBER of FM.

Reward points if useful, get back in case of query...

Cheers!!!

Re: Customer Address

Former Member — Thu, 13 Sep 2007 09:49:58 GMT

Cheers Tripat,

that is a very useful FM to know.

Many thanks

Andy