Deduct Report Dashboard
Deduct Report
Business Schema: SAPECC_Receivables
Schema: SAPECC_CM_MD, SAPECC_CO_MD, SAPECC_BL, SAPECC_GL, SAPECC_AR, SAPECC_ADR_MD, SAPECC_FI_MD, SAPECC_MM_MD, SAPECC_SD_MD, SAPECC_GEN_MD, SAPECC_CO_MD, SAPECC_CAL_MD
Table:
Go Live: April 8, 2024
Users: Erin Funk
Purpose: Generates a list of outstanding invoices?
Fields/Definitions:
Field Name
Definition
Table/Formula
Customer Number
Customer number without the leading zeros. substring(SAPECC_Receivables.Customer.KUNNR, 4, 10)
SAPECC_Receivables.Customer.KUNNR
Name
SAPECC_CM_MD.KNA1.NAME1
Document Number
Accounts receivable document number
SAPECC_AR.BSAD_BSID_MV.BELNR
Document Type
SAPECC_AR.BSAD_BSID_MV.BLART
Document Type Description
SAPECC_FI_MD.T003T.LTEXT
OverDue Amount
case(
and( date( $Asofdate ) > SAPECC_Receivables.ReceivablesLines.Net_Due_Date, isNull( SAPECC_Receivables.ReceivablesLines.AUGBL ) ), SAPECC_Receivables.ReceivablesLines.DRCR_WRBTR, 0 )
Assignment Number
SAPECC_AR.BSAD_BSID_MV.ZUONR
Reference Document
SAPECC_AR.BSAD_BSID_MV.XBLNR
Reason Code for Payments
SAPECC_AR.BSAD_BSID_MV.RSTGR
Item Text
SAPECC_AR.BSAD_BSID_MV.SGTXT
Reference 1
SAPECC_AR.BSAD_BSID_MV.XREF1
Reference 2
SAPECC_AR.BSAD_BSID_MV.XREF2
Posting Date
SAPECC_AR.BSAD_BSID_MV.BUDAT
Sold to Broker
substring(
SAPECC_Receivables.Customer.SoldToBroker, 4,10)
Sold to Broker Name
SAPECC_CM_MD.CustomerBroker.SoldToBrokerName
Reference Key for line item
SAPECC_AR.BSAD_BSID_MV.XREF3
Customer Group
SAPECC_CM_MD.CustomerBroker.CustomerGroup
Field: SAPECC_CM_MD.KNVV.KDGRP
Customer Group Name
SAPECC_CM_MD.CustomerBroker.CustomerGroupDesc
Individual Filters
Filter Fields
Table
Criteria
OverDue Amount
case( and( date( $Asofdate ) > SAPECC_Receivables.ReceivablesLines.Net_Due_Date, isNull( SAPECC_Receivables.ReceivablesLines.AUGBL ) ), SAPECC_Receivables.ReceivablesLines.DRCR_WRBTR, 0 )
Does not equal 0
Customer Number
SAPECC_CM_MD.KNA1.KUNNR
Not in 0000800000, 0000800001
Change Control
Date
Modification Made
Requested by
User
4/1/2025
Change the name from Broker Forecast Aging report to Deduct Report
Added filter Reason Code for Payments
Added column for Reason Code for Payments in the insight.
Erin Funk
Diana Weaver