Show TOC

 Detection Method: Duplicate Regular Vendor and One-Time Vendor

 

You can use this detection method to find regular vendors that exist in the ERP system as one-time vendors.

Logic

The name of the one-time vendor (field NAME1 from table BSEC) is compared against the name of the regular vendor (field NAME1 from table LFA1) to detect duplicate regular and one-time vendors.

Investigation and Detection Object Types

  • Investigation object type: FRA_ONETIM (One-Time Vendors)

  • Detection object type: FRA_ONETIM (One-Time Vendor Invoices)

ERP Tables Used

  • BSEC: One-Time Account Data Document Segment

  • BSEG: Accounting Document Segment

  • BKPF: Accounting Document Header

  • LFA1: Vendor Master (General Section)

  • T001: Company Codes

SAP HANA Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_REG_VENDOR_NAME_SELE

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.onetimeaccts.se

Execution

PR_REG_VENDOR_NAME_EXEC

SQLScript Procedure

sap.hana-app.fra.suite.pur.dt.onetimeaccts.ex

Additional Information

PR_REG_VENDOR_NAME_ADDINF

SQLScript Procedure

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

None.

Alert Messages

Message ID

Message Number

Message Text

FRA_INTERNAL_AUDIT

022

Invoice unpaid

FRA_INTERNAL_AUDIT

024

Invoice paid with payment number &1 on &2

FRA_INTERNAL_AUDIT

025

Invoice posted on one time account but vendor with same name: &1(&2) exists