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

[Former Member]

Hi,

Table- ADDR1_DATA -

---

Field-STREET

KVNK----

---

ADRNP

Kindly check here

[Former Member]

Hi,

Pls check in the table KNVK table.

In that pls pass the value of the Customer number in KUNNR field.

Now it will open all the contact person details.

Select your required partner and get the value from the field "ADRNP".

If you know the contact person number then enter it in the field "PARNR".By using this also you can get values.

I hope it solves your problem.

Regrds,

Mohan.

[Former Member]

Hi,

Table- ADDR1_DATA -

---

Field-STREET

KVNK----

---

ADRNP

Edited by: Raj Kumar on Jan 27, 2009 12:25 PM

[Former Member]

Table : KNA1

U can use Func. Module : CUSTOMER_READ to get the detials of the customer address

Rgds

[jignesh_mehta3]

Dear Puneet,

Customer's Code, Name, region, City & Country are stored in KNA1

But if you want complete address then use take data from ADRC table.

Now in ADRC table there you will not find Customer number.

Thus follow this:

In KNA1 there is a field called ADRNR (Address Number).

In ADRC there is a field called ADDRNUMBER (Address Number).

Take the data in excel from both the tables (KNA1 & ADRC) & run VLOOKUP on Address number. You will have a complete list of Customers with complete address.

Hope this helps...

Give points if useful...

Thanks,

Jignesh Mehta

98700 10230

[Former Member]

Thanks Jignesh for ur quick reply but my question is to fetch the data of partner's home address. in xd01 in CONTACT PERSON tab we fill the details of contact person and home address also, I need to fetch the data of that home address.. plz guide me for that and if there is any bapi for that plz let me know.

Thnks

Puneet

[former_member217082]

Hi Puneet

The data of the contact person tab will be stored in KNA1 table only

Regards

Srinath

[jignesh_mehta3]

Dear Puneet,

Have you checked ARDC table once?

You will get all the details of COmplete address + Telephone, fax & other numbers.

Hope this helps...

Thanks,

Jignesh Mehta

[Former Member]

KNA1