on 08-05-2009 11:24 AM
Hi!
in which table customer master general data will be stored.
How can we view structure. I want to see the structure "ADRS", when I am using the where used list to check the data base table, it is not showing any database tables.
Can any one tell the purpose of "ADRS" structure...
regs,
Ramesh
Hi,
The ADRS structure stores the address data. For example in case of customer master the complete address details are not stored in table KNA1. KNA1 table has a field ADRNR which stores the address number. The complete address is stored in table ADRC with reference to the address number ADRNR. The structure ADRS stores the address obtained from table ADRC during processing. When you are looking at structure ADRS, you are effectively looking at / trying to store data into table Table ADRC.
Rgds
Shivram.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanq
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, just consider and review this ADR tables:
ADR2 Telephone Numbers (Business Address Services)
ADR3 Fax Numbers (Business Address Services)
ADR4 Teletex Numbers (Business Address Services)
ADR5 Telex Numbers (Business Address Services)
ADR6 E-Mail Addresses (Business Address Services)
ADR7 Remote Mail Addresses (SAP - SAP - Communication; BAS)
ADR8 X.400 Numbers (Business Address Services)
ADR9 RFC Destinations (Business Address Services)
ADRC Addresses (Business Address Services)
ADRG Assignment of Addresses to Other Address Groups BAS
ADRP Persons (Business Address Services)
ADRT Communication Data Text (Business Address Services)
ADRU Table for Communication Usages
ADRV Address Where-Used List (Business Address Services)
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can use below mentioned tables for customer master.
KNA1 - Customer master
KNB1 - Customer / company
KNVV - Customer sales data
KNBK - Bank details
KNVH - Customer hierarchy
KNVP - Customer partners
KNVS- Shipment data for customer
KNVK - Contact persons
KNVI - Customer master tax indicator
Table ADRC stores the address data for customer like street no, house no, search term ect..
Dhara.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Customer General details are stored in table KNA1. In this table, the field ADRNR which needs to be passed to the table ADRC to get some more data. We need to refer to either of the tables to fetch customer details depending on what is required.
Thanks and Regards,
Anit
Edited by: Anit Mangat on Aug 5, 2009 4:07 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ramesh,
Customer master general data will be stored at KNA1
Customer master company code data will be stored at KNB1
Go to se16 and give table name KNA1 and execute whrere you can search for structure "ADRS".
Thanks,
Hari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think your problem is to know the transperant table, wherein the address of customer is maintained.
The table name is ADR6 in which the address of customer master is maintained.
Hope your problem is resolved. If you would like to know more, please let me know.
Regards
K Khatri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
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.