cancel
Showing results for 
Search instead for 
Did you mean: 

Contact person address

Former Member
0 Kudos

HI,

In VAP3 Contact person- can you pl let me know the Table from which i can get details w.r.t Fields

Room Number Floor Building

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Please refer to the below thread.Please find the answer in the last post.

[;

Regards,

Krishna.

Answers (2)

Answers (2)

ian_kehoe
Active Participant
0 Kudos

Hi,

You can find the value on the database by doing the following:

Transaction SE16 -> KNA1 -> enter the contact person

In this table find the value for field KNA1-ADRNR.

Transaction SE16 -> ADRC -> enter the address number from KNA1 table.

Here you can get the value for:

BUILDING

FLOOR

ROOMNUMBER

I hope this helps.

Best regards,

Ian Kehoe

Former Member
0 Kudos

.HI,

1. Can you pl suggest what is the contact person field in Table KNA1.

Also i checkd with tables KNA1/ADRC/ADR6 I could only find street/building/room details for sold to party - i coudnt find for Contact person.

ian_kehoe
Active Participant
0 Kudos

Hello,

Apologies if I was not clear in my last reply.

SE16 -> KNVK -> enter in Number of contact person (the same name or number you enter in VAP3)

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

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

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

SE16 -> ADRC -> enter ADRNR

From this table we can find the values for floor, building and room number.

I hope this is clearer. If you have any doubts just let me know.

Best regards,

Ian Kehoe

Lakshmipathi
Active Contributor
0 Kudos

Those fields are stored in structures and not in table.

thanks

G. Lakshmipathi