Table for contact person intial screen data & home address data email field

[Former Member]

Dear Friends,

Could you please tell the tables for contact person intial screen data & home address data email field

Thanks,

pinky

[reazuddin_md · Accepted solution]

Goto Customer Master - General Data- Contact Person tab,

click on details icon, will find the Contact person number.

now goto KNVK table- enter the Contact person number & F8. then you will find Person number / Address number(Home address).

now goto ADR6, enter the Person number / Address number & F8.

[Former Member]

hi,

KNVK - contact persons details

ADR6 - email address(copy address number in KNVK)

regards

senya

[Former Member]

Hi,

First goto "KNVK" table.

Enter the Customer number in "KUNNR(Customer)" field.

Press F8 or click on "Execute".

All the contacts list will be displayed.

Select the required contact.

Details display.

Fetch the value of "PRSNR(Person Number)" or fetch the value of "ADRNP2(Address number)".

Pass the value of "PRSNR" into "ADR6" table.

Execute.

Click on display details.

The E-mail id can be fetched from the field "SMTP ADDR".

Regards,

Krishna.

[Former Member]

Dears,

Thanks for your response.

Are you able to get the data (e.g. e mail id) maintained in the initial & home address? Not business address

please try once again with your reply.

[Former Member]

Hi,

To get the E-mail id maintained in the home address screen,first pass the customer number into "KNVK" table.

Execute.

Fetch the value of "address number(ADRNP2)" and pass the same to "ADR6" table into "Address number(ADDRNUMBER)".

Execute.

Select the line entry.Click on Display.

Get the value from "(SMTP ADDR)E-mail Address".

It gives you the E-mail address maintained in the home address screen.

Next thing is to get the E-mail address maintained in the initial screen.Her two initial screen are there.

1.The screen which appears in the "Contact Person" tab.

2.If you double click on the contact which will take you to another initial screen.

The E-mail will be defaulted in the "contact person" initial screen will be defaulted as the E-mail maintained in the "Business data" screen if you maintain the E-mail in "Business data" screen and in in the initial screen of the contact person which is the screen is obtained by double clicking on the contact.

If you don't maintain that E-mail in "Business data" screen then it will be defaulted as the E-mail maintained in the initial screen.

To get the E-mail maintained in the "Business screen",fetch the value of "address number(ADRND)" and pass the same to "ADR6" table into "Address number(ADDRNUMBER)".

Execute.

Select the line entry.Click on Display.

Get the value from "(SMTP ADDR)E-mail Address".

It gives you the E-mail address maintained in the business address screen.

To get the E-mail maintained in the "Initial screen",fetch the value of "person number(PRSNR)" and pass the same to "ADR6" table into "Person number(PERSNUMBER)".

Execute.

Select the line entry.Click on Display.

Get the value from "(SMTP ADDR)E-mail Address".

It gives you the E-mail address maintained in the initial screen.

I hope this clarifies your doubt.I tried here with three different E-mail id's and it is worked out.Could you please check there also for your satisfaction.

Regards,

Krishna.

[Former Member]

Hi Krishna,

With respect to the two screen you are referring to: 1. Contact Perons tab & 2. Contact Person details (when we double click on any contact person on Contact person tab)

I am using 'BAPI_ADDRESSCONTPART_CHANGE' to update the address of a contact person.But that change is only reflected on 2nd Screen not on the 'Contact Person' tab.

I need to see the change on the Contact Person tab as well. Can some one please suggest how this can be achieved.

Thanks,

Santhosh.

[Former Member]

Table for Contact person - KNVK