AR Aging Dashboard
AR Aging 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
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
Version
User