Show TOC

 Detection Method: Vendor Without Bank Details

 

You can use this method to find vendors that have no bank details recorded in the vendor master data.

Logic

Vendors without bank details are identified by looking for vendors that have no entry in table LFBK (Bank Details).

Investigation and Detection Object Types

  • Investigation object type: FRA_VEND (Vendor)

  • Detection object type: FRA_VEND (Vendor Master Data)

ERP Tables Used

  • LFBK: Vendor Master (Bank Details)

SAP HANA Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_VENDOR_WO_BANK_DATA_SELE

SQLScript Procedure

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

Execution

PR_VENDOR_WO_BANK_DATA_EXEC

SQLScript Procedure

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

Additional Information

PR_VENDOR_WO_BANK_DATA_ADDINF

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.vendor.masterdata.ai
Alert Messages

  • Message ID FRA_INTERNAL_AUDIT, message number 081, Vendor &1 in company code &2 has no bank details