End Customer detail in Equipment Master Location TAB

[Former Member]

Dear All,

I have a requirment to fetch the name and address of the end customer maintained in the Equipment and Serial number master data.

Kindly help me to fetch the relevent customer detail with respect to Equipement master.

Regards,

SaravanaaS

[former_member187991]

hi

if you have specified the customer no in the serialization tab you can get the same from EQBS ,get the customer number KUNNR and input the same in KNA1,get the address also check KNB1

regards

thyagarajan

[Former Member]

Hi Thiyagarajan,

Thanks for your reply.

My scenario is goods manufatured at my clients place will be deleivered to the delaers then the same will be sold the end customer that is consumer.

Once the goods are instaled at the customer premises, serial number, date of instalation and the consumer name will be maintained in the IQ02 - Equipment master.

Here I am required to take the list of end consumers with respective serial or Equipment number.

I hope I have clearly explained my query.

Kindly someone help me to get the list of consumers.

Thanks &

Regards,

Saravanaa.S

[former_member187991]

hi

you can check the table IHPA whil will list the partner specified in the partner tab of the equipmnet no ie sold to party,dep responsible

regards

thyagarajan

[Former Member]

Dear All,

I have solved my by following the below logic.

We have to get the value of ILOAN Number from EQUZ table, then pass the value and Execute ILOA table where in we can get the ADRNR Number.

Address Number should be passed to ADRC Table to get the address details of the consumer.

I take this oppurtunity to thank everyone who contributed this thread.

Regards,

Saravanaa.S

Edited by: Saravanan Sevugaperumal on May 15, 2009 4:30 PM