on 2009 Jan 27 10:39 AM
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
Hi Puneet
Pl. try the table KNVK with ref. to KUNNR.
Regards
AA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
Hi,
Table- ADDR1_DATA -
Field-STREET
KVNK----
ADRNP
Kindly check here
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Table- ADDR1_DATA -
Field-STREET
KVNK----
ADRNP
Edited by: Raj Kumar on Jan 27, 2009 12:25 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Table : KNA1
U can use Func. Module : CUSTOMER_READ to get the detials of the customer address
Rgds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
KNA1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.