Top N Credit Memos (Credit Management)

Use

This query displays the credit memos from all line items in the accounts receivable accounting that stand out as causing a large loss of interest for the customer (see Interest Calculation Numerator in the column key figures). This is also called the top N list.

Filters

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0COMP_CODE	Company code

Variables Used

Variable	Description
0P_COCD	For the characteristic 0COMP_CODE: Company code (single value entry, obligatory)
0S_DEBIT	For the characteristic 0DEBTOR (selection options, optional)
0F_KEYDT	Formula variable: Key day for the due date for net payment (SAP exit replaced from 0P_KEYDT)

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0DEBTOR	Debtor
0AC_DOC_NO	Document number

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Credit memo amount	Restricted key figure: 0CREDIT_LC (credit amount in local currency). Restricted to open items, that is, characteristic item status 0FI_DOCSTAT = ‘O‘
0NETDUEDATE	Due date for net payment (characteristic)
Overdue days	Calculated key figure: Formula variable 0F_KEYDT (key date for overdue date) - due date for net payment
Interest calculation numerator	Calculated key figure: Credit memo amount * overdue days / 365 / 100 Gives the loss of interest for the customer for an overdue credit memo with a 1% interest rate.

Exceptions are defined concerning the Overdue Days and Interest Calculation Numerator columns. The exception for the Interest Calculation Numerator is active.

Overdue Days Exception

The Overdue Days exception displays how overdue a document from the accounts receivable accounting (invoice or credit memo) is. This measures the amount of time between the due date for net payment for the document and a key date (key date for net payment). This key date for net payment is automatically filled from the 0P_KEYDT variable.

The following alert values are defined for the Overdue Days exception:

Alert Level	From	To
Good	-99999	0
Average	0	15
Bad	15	99999

Interest Calculation Numerator Exception

The Interest Calculation Numerator exception displays the loss of interest with a rate of 1% that is caused by an overdue document in the accounts receivable accounting (invoice or credit memo). For the exact definition of the interest calculation numerator, see the documentation of query columns.

The following alert values are defined for the Interest Calculation Numerator exception:

Alert Level	From	To
Good	-99999999999	0
Average	0	100
Bad	100	99999999999

Requirements

Conditions (Top 10) are defined concerning the Overdue Days, Interest Calculation Numerator, and Credit Memo Amount columns. The condition (Top 10) for the Interest Calculation Numerator is active.

Rows and columns are depicted in the report presentation using the Table Display function in the form of a flat list.