How to get address #?

[former_member194142]

Hello

I am trying to pull the Address # based on the Person #.

I have contact person record in KNVK table, but it doesn't have the address #.

I want to get the Fax # of this contact person, but this fax data is available in ADRC table, which table requires Address #.

So, i found a connection between Person # and Address # in ADR6 table, but, when i wrote a SQL on ADR6 for pulling the Address # by passing the Person #, am getting a ERROR in Extended Prog. Check/Code Inspector, which is not OK in our company, hence, pls. let me know

How to get Address # being having Person # in hand?

Thank you

[Azeemquadri]

Please check for address number adrnr in KNA1.

[gouravkumar64]

Hi,

try this

SE16 -> KNVK -> enter in Number of contact person

From this table you can get the value for the field KUNNR (Customer Number ).

SE16 -> KNA1 -> enter Customer Number  (KUNNR)

From this table u can find the value for the field ADRNR (Address)

SE16 -> ADRC -> enter ADRNR

From this table u can find the values for address.

Thanks

Gourav.

[Former Member]

Hi

If you know employee no ( pernr ) , then you can use pa0006 ( address infotype ) there are some field

like ort01 , land1 , spras yo u can select field as per your requirement.

Thanks

anshul