Skip to Content
1
Sep 08, 2023 at 04:24 PM

How to find all the customer numbers which are having some specific email ID?

136 Views

Hi Experts,

Suppose I am Passing email ID: abc@gmail.com in ADR6 - SMTP_ADDR then I am getting 1000 records. If I see the unique Address Number (ADR6 - ADDRNUMBER) then it's coming as 600.

Now if I pass these 600 records in KNA1 - ADRNR then I am seeing only 500 records so from where rest of the 100 ADDRNUMBER are coming in table ADR6?

1. My question is how to find all the customer numbers which are having specific email ID: abc@gmail.com (for example)?

2. Is there any option available by which I can delete specific email ID (e.g. abc@gmail.com) in mass from all the customers in SAP.