Show TOC

 Detection Method: Find Duplicates of Blocked Vendors

 

Use this method to find blocked vendors for which there are active “copies”. That is, an active vendor master record exists that is similar to a blocked vendor. From a business point of view, you should not be able to evade a block on transactions with a vendor by creating copies of the vendor.

Vendors are considered to be duplicates if at least one of the following vendor data matches:

  • The bank account (fields BANKS, BANKL, BANKN and BKONT in table LFBK)

  • The telephone number (fields TELF1 or TELF2 in table LFA1)

  • The vendor address (fields ORT01 and STRAS in table LFA1)

  • The vendor name (at least one of the name fields in table LFA1: NAME1, NAME2, NAME3 or NAME4)

  • The vendor VAT registration code (field STCEG in table LFA1)

Note Note

The vendor ID must be different.

End of the note.
Logic

The method returns a detection result of 100 for any active vendor that has blocked duplicates.

If the matching blocked vendor is blocked on company-code level (field SPERR in table LFB1), then the matching vendors must have the same company code in order to get a result for the matching active vendor. If the matching blocked vendor is blocked on a general level (field SPERR in table LFA1), then a result is created for the active vendor independent of the company codes of both vendors.

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)

  • LFB1: Vendor Master (Company Code)

  • LFBK: Vendor Master (Bank Details)

SAP HANA Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_VENDOR_BLOCKED_REOPENED_SELE

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.masterdata.se

Execution

PR_VENDOR_BLOCKED_REOPENED_EXEC

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.masterdata.ex

Additional Information

PR_VENDOR_BLOCKED_REOPENED_ADDINF

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.masterdata.ai
Detection Method Parameters

None

Alert Messages

Message ID

Message Number

Message Text

FRA_INTERNAL_AUDIT

122

Blocked duplicates for vendor &1 exist in the system:

FRA_INTERNAL_AUDIT

123

Vendor &1 / Company Code &2 / Name &3 / Address &4