Customer address details

Hello,

I have a requirement to have report of Partners E-mail id based on customer master.

In KNVP table i can get list of partner functions maintained to customer master.

I can pass the customer number in KNA1 table and address number,based on it ,i can get get E-mail id from ADR6 table.

How to get E-mail id for KNVP-PERNR.

Thanks,

MP