Customer Master Data.
I have to retrieve customer master data from table KNA1 for all the customers from the system who have not been marked for deletion. Though this can be done using select statement, I wanted to know if this was possible using any function module.
Is there any function module available for the above scenario?
Also I have to get the contact person email(field SMTP_ADDR) from table ADR6 for a customer. I am not able to find a link between KNA1 and ADR6. Could you please help me to retrieve the data?