https://community.sap.com/t5/technology-q-a/extract-customer-master-record-from-sap-ecc/qaa-p/13792689#M4841305 <P class="lia-align-justify">You can table join KNA1 with ADR2 table from where you get the required telephone number for a given customer number</P><P>&nbsp;</P> Tue, 13 Aug 2024 08:05:05 GMT Lakshmipathi 2024-08-13T08:05:05Z https://community.sap.com/t5/technology-q-a/extract-customer-master-record-from-sap-ecc/qaq-p/13792125 <P>Hello everyone,</P><P>Is there a method to retrieve the customer ID using either the customer's telephone number or their name in ECC?</P> Mon, 12 Aug 2024 21:17:55 GMT https://community.sap.com/t5/technology-q-a/extract-customer-master-record-from-sap-ecc/qaq-p/13792125 ShuvaSamal 2024-08-12T21:17:55Z https://community.sap.com/t5/technology-q-a/extract-customer-master-record-from-sap-ecc/qaa-p/13792689#M4841305 <P class="lia-align-justify">You can table join KNA1 with ADR2 table from where you get the required telephone number for a given customer number</P><P>&nbsp;</P> Tue, 13 Aug 2024 08:05:05 GMT https://community.sap.com/t5/technology-q-a/extract-customer-master-record-from-sap-ecc/qaa-p/13792689#M4841305 Lakshmipathi 2024-08-13T08:05:05Z