Customer Address

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi T

he field is

VBPA-ADRDA

thanks

vivekanand

reward if helpful

[Former Member]

Hi

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

Regards

Shiva

[Former Member]

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

[Former Member]

Hi Andy,

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

Regards

Shiva

[Former Member]

Shiva,

My mistake I was using an incorrect ADRNR.

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

Many thanks

Andy

[former_member404244]

Hi,

check the table SADR..

Regards,

Nagaraj

[Former Member]

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!!!

[Former Member]

Cheers Tripat,

that is a very useful FM to know.

Many thanks

Andy