topic Re: customer address in Application Development and Automation Discussions

customer address

Former Member — Thu, 21 Feb 2008 19:29:08 GMT

hi all,

i have created a customer with all the address details.

i want to know the list of all TABLES, where the address details of customer are stored.

plz help me out, i want to know the list of ALL tables.

thanx, shivaa.

Re: customer address

Former Member — Thu, 21 Feb 2008 19:44:02 GMT

Hi,

You can get the address number of the customer from the customer master KNA1 table field ADRNR

Then using the address number , query ADRC table to get the address details.

Cheers,

Aditya

Re: customer address

Former Member — Thu, 21 Feb 2008 20:54:26 GMT

hi adi,

thanx for ur quick reply.

but, the actual problem i got is as follows:-

i created a sales order.the address is appearing fine, but at some places in the sales order, i am getting different address.

so, i started debugging.

i wanted to know the field thru which the wrong address is displayed.

but, my investigation is just going ooooooooooooooooooooooooooooooooooooooooooooooooooon........

it isnt getting stopped at all.

i found the field thru which the wrong address is displayed.

but this field is getting value from field1, field1 from field2,............the list just goes on.

hence, i asked for the table(ADRC).

Re: customer address

Former Member — Fri, 22 Feb 2008 05:05:53 GMT

Hi Shiva,

A sales order has a lot of partners e.g. Bill To Party, Ship To Party etc. who can be customers but different customers. That is you send the bill for the goods to one customer and ship the goods to another customer.

Hence go to the partner (VBPA table) of your sales order and retrive all the partner numbers. Check the addresses for these partners and see whether it fits to complete your jigsaw puzzle.

Cheers,

Aditya

Re: customer address

Former Member — Fri, 22 Feb 2008 05:14:06 GMT

In ADRC table you can find address of all the customers

*--Compnay code address

SELECT SINGLE NAME1

CITY1

PO_BOX

STREET

COUNTRY

INTO CORRESPONDING FIELDS OF COMP_ADDR

FROM ADRC AS A

INNER JOIN T001 AS B

ON A_{ADDRNUMBER = B}ADRNR

INNER JOIN VBRK AS C

ON B_{BUKRS = C}BUKRS

WHERE VBELN = P_VBELN.

Re: customer address

Former Member — Fri, 22 Feb 2008 10:24:33 GMT

A sales order has got a lot of partners (customers) like Bill-to Party (person to which the invoice is sent), ship-to party (person to whcih the goods are sent for delivery), sold-to party (person who orders the goods) etc.

You can get the partner numbers of a sales order from VBPA table. You can have partners assigned who remains the same for all items in the sales order. For each partner the address for communication can be obtained as follows:

1. Get the ADRNR (address number) from VBPA table.

2. Go to ADRC table using ADRNR obtained from VBPA table to get the address.

Hope this helps.

Thanks,

Balaji