Detection Method: Vendor Telephone Number Suspicious

You can use this method to find vendors that have suspicious telephone numbers, such as when:

The vendor country code differs from the country codes of the contact phone numbers 1 and 2 and the fax number
The vendor data does not have any contact telephone number

For every contact number, the detection method checks whether the number contains a + or begins with 00; after these two indicators the country code is located. If the country code of the contact number does not equal the country code of the vendor, then the vendor is suspicious.

Logic

The method returns all vendors without any contact number (fields TELEFON_1_NUMBER, TELEFON_2_NUMBER and FAX_NUMBER are empty) with a detection result value of 100.

The method also returns vendors for whom the country area code of at least one contact number does not match the area code of the country in the vendor’s address. The detection result is set to 100 for these vendors. For the comparison of the area codes, the method uses table T005K (area codes for each country code).

Investigation and Detection Object Types

Investigation object type: FRA_VEND (Vendor)
Detection object type: FRA_VEND (Vendor Master Data)

ERP Tables Used

LFA1: Vendor Master (General Section)
T005K: Communication: country dialling code

SAP HANA Procedures for Detection Methods

Procedure Category	Procedure Name	Procedure Type	Package
Selection	PR_VENDOR_CTRY_EQ_AREA_CODE_SELE	SQLScript Procedure	sap.hana-app.fra.suite.pur.dt.vendor.masterdata.se
Execution	PR_VENDOR_CTRY_EQ_AREA_CODE_EXEC	SQLScript Procedure	sap.hana-app.fra.suite.pur.dt.vendor.masterdata.ex
Additional Information	PR_VENDOR_CTRY_EQ_AREA_CODE_ADDINF	SQLScript Procedure	sap.hana-app.fra.suite.pur.dt.vendor.masterdata.ai

Alert Messages

Message ID	Message Number	Message Text
FRA_INTERNAL_AUDIT	093	There is no entry for a phone or fax number for the vendor
FRA_INTERNAL_AUDIT	094	The phone number &1 is located in a different country as the vendor (&2)
FRA_INTERNAL_AUDIT	095	The fax number &1 is located in a different country as the vendor (&2)