table for storing customer's partner data

[Former Member]

Hi all,

I am searchng for the table where the customer's partner's home address is stored.. plz also tell me if i can get any bapi for that.

Thnx for ur help in advance

Puneet

[former_member188076 · Accepted solution]

Hi Puneet

Pl. try the table KNVK with ref. to KUNNR.

Regards

AA

[Former Member · Accepted solution]

Thnks AA,

In table knvk, we can get the contact person name only but i need the address and telephone details also.. plz guide

Thnks

Puneet

[Former Member · Accepted solution]

Hi Puneet,

You can get the address(Home address and business address) and Telephone number from the table "KNVK" table from the fields ADRND,ADRNP and TELF1 fields.

If you want city also you can get from the field "ORT01".

Regards,

Mohan.

[Former Member · Accepted solution]

Thnks mohan,

But i am not getting anything in that field.. its blank in that table..whereas i have filled data by using the tab of HOME ADDRESS..

[former_member188076 · Accepted solution]

Hi

From KNVK take address no. (ADRNP_2) and then from table ADRC pick the details as per your requirement.

Regards

AA

[Former Member · Accepted solution]

Hi Puneet,

Pls take ADRNP2 from KNVK table and pass the same value to "ADRC" table for home address.

If you are not able to find the field "ADRNP2" in the initial screen then select the line and click on details,scroll down to identify the field.

Pls take "ADRND" from KNVK table and pass the same value to "ADRC" table for business address.

Any way telephone is coming in "KNVK" table only.

Regards,

Mohan.

[Former Member · Accepted solution]

Thnks Mohan,

But not yet get the entries of partner's address.. there is a entry of customer address only.

[Former Member · Accepted solution]

Hi Puneet,

After your query while checking I am posting here.

For me it is coming.

I maintained 2 contact details.

For the second one in home address I maintained the city as "SOlihull" and in Business address I maintained the city as "Delhi".

Save.

In KNVk table I took my "ADRNP2" field and passed that one into "ADRC" table.I checked the city1 as "SOlihull" which is nothing but the "Home address".

similarly from KNVK table I took ADRND field and passed that one into "ADRC" table.I checked the city1 as "Delhi" which is nothing but the "Business address".

Note:In CMR the customer city is "LOndon".

Which will appear in KNA1 table.

I think you didn't save after making changes to your CMR.

or You might be confused.

I request you to pls check once.because it is coming corretly for me.

Regards,

Mohan.

[Former Member · Accepted solution]

y dont u use Function Module

"CUSTOMER_CONTACTPS_GET"

just input ur cust. no. u will get all the details

Rgds

[Former Member · Accepted solution]

Thanks mohan,

yes u r right, i got my issue solved but can u plz guide me if there is any bapi for that where it automatically gives its adrnp 2 and find the address and all details..

thnks a lot