fetch Customer Address by passing Order Number-AUFNR

[Former Member]

Hi Experts,

i need to get customer address from customer master data by passing Order Number-AUFNR. in which TABLE i will get customer details by passing through Order Number-AUFNR field.

With Thanks & Regards,

SambaSiva

[Former Member]

Hi,

As you said you will get customer details by passing the order number, so once you get the customer number, fetch the customer address number from KNA1-ADRNR.

After you get the address number, you can fetch the address from ADRC table.

Regards,

Danish.

[Former Member]

Hi Danish,

In which table i can get the customer number by passing Order Number-AUFNR. can u please say the table name for getting customer number with respect to order number.

With Thanks & Regards,

Samba

[Former Member]

Hi,

To get the Customer Address details according to the Order number.

Follow the below procedure:

1. Fetch the KUNNR value in VBAK according to the Order Number i.e., AUFNR

2. With this KUNNR value, fetch the ADRNR field value from the data base table KNA1.

3. Get the Address details with this ADRNR field value from the ADRC database table

Regards,

Amaresh.K

[Former Member]

Hi,

Using the Process Order Number AUFK-AUFNR, fetch the sales order number AUFK-KDAUF. Pass this sales order number to VBAK to get Customer number i.e. VBAK-KUNNR.

Fetch address number from Customer Master KNA1-ADRNR. After you get the address number, you can fetch the address from ADRC table.

Regards,

Danish.

[Former Member]

Hi,

1. Pass AUFNR in AUFK table  =>  Get OBJNR

2. Pass OBJNR  in IHPA table   =>  Get ADRNR

3. Pass ADRNR in ADRC table => Get Address