Show TOC

 Detection Method: Growth Between 1st and 2nd Year Exceeds Threshold

 

You can use this detection method to find new vendors the growth of whose turnover between the first and second years of business is suspiciously high.

The method compares turnover in the first and second years in which vendor turnover is found for a company code. The beginning date is the first day of the month in which vendor turnover is found for the first time within a company code.

An alert is triggered if the percentage growth in turnover is bigger than the growth threshold and if the turnover amount exceeds in one of the two years the threshold for maximum allowable turnover. If the company code currency and threshold currency are different, currency conversion takes place.

Investigation and Detection Object Types

Investigation object type: FRA_NEWVEN (New Vendor)

Detection object type: FRA_NEWVEN (New Vendor Master Data)

ERP Tables Used

  • LFA1: Vendor Master (General Section)

  • LFB1: Vendor Master (Company Code)

  • BSEG: Accounting Document Segment

  • BSEC:One-Time Account Data Document Segment

  • T001: Company Codes

Procedures for Detection Methods

Procedure Category

Procedure Name

Procedure Type

Package

Selection

PR_RGB_VENDOR_TURNOVER_TWO_YEARS_SELE

SQLScript Procedure

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

Execution

PR_RGB_VENDOR_TURNOVER_TWO_YEARS_EXEC

SQLScript Procedure

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

Additional Information

PR_RGB_VENDOR_TURNOVER_TWO_YEARS_ADDINF

SQLScript Procedure

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

  • THRESHOLD_REVENUE_GROWTH: The threshold in percent for the maximum growth in turnover from the first year to the second year of business with a new vendor.

  • THRESHOLD_REVENUE_YEAR: The threshold for the minimum amount of turnover considered relevant for investigation by this detection rule. If the total turnover of the first and/or the second year DOES NOT exceed this threshold, then the detection rule skips the new vendor; the new vendor is not evaluated.

  • THRESHOLD_CURRENCY: The currency in which THRESHOLD_REVENUE_YEAR is denominated.

Alert Messages

  • Message ID FRA_INTERNAL_AUDIT, message number 003, Growth is &1 % (threshold for growth is &2 %)