FI Report Custom development ALV report

Customer Receivables Aging Report

Short answer: A custom ALV report that ages customer open items by net due date and shows down payments received and other special G/L items in the same list. Amounts are spread into not-due, 0–30, 31–60, 61–90 and 90+ day buckets, with profit center, accounting clerk and dunning level on every row.

Estimated effort
M · 3–5 working days
System
ECC and S/4HANA
Tables
5
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

FBL5N lists open items but does not total them into age buckets; special G/L items (down payments received, bills of exchange) are selected separately, so the customer's net exposure is not visible in one list. S_ALR_87012173 produces an open item list, but it does not offer an Excel-ready aging with profit center and accounting clerk breakdown and adjustable bucket limits.

Who uses it? Accounts receivable and collections teams, credit control, finance managers and sales managers.

Closest standard alternatives

  • FBL5N Customer Line Items. Lists open items; does not total them into age buckets and selects down payments separately.
  • S_ALR_87012173 List of Customer Open Items. Gives a customer open item list; does not offer an aging with profit center breakdown and adjustable buckets.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
BSIDCustomer Open ItemsCustomer open items, due-date data, special G/L indicator and amounts (driving table)—ECC + S/4
BSADCustomer Cleared ItemsItems cleared after a past key dateBSAD-BUKRS = BSID-BUKRS AND BSAD-KUNNR = BSID-KUNNRECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = BSID-KUNNRECC + S/4
KNB1Customer Master (Company Code)Accounting clerk, reconciliation account and payment termsKNB1-KUNNR = BSID-KUNNR AND KNB1-BUKRS = BSID-BUKRSECC + S/4
T001Company CodesCompany code local currencyT001-BUKRS = BSID-BUKRSECC + S/4

S/4HANA notes

  • BSID → I_OperationalAcctgDocItem: In S/4HANA BSID is no longer filled as a separate index table; reads work through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
  • BSAD → I_OperationalAcctgDocItem: In S/4HANA BSAD is not filled as a separate table; it is read through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleBSID-BUKRSYes1000
S_KUNNRCustomerRange / multipleBSID-KUNNRNo200118
S_AKONTReconciliation accountRange / multipleKNB1-AKONTNo120000
S_PRCTRProfit centerRange / multipleBSID-PRCTRNoPC1100
S_BUSABAccounting clerkRange / multipleKNB1-BUSABNoT1
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026
P_BKTSBucket limits (days, comma-separated)Single value—No30,60,90
P_SPGLInclude special G/L items (down payments, bills)Checkbox—NoX
P_NOTDUEAlso show items not yet dueCheckbox—NoX

Output columns

#ColumnSource
1Company codeBSID-BUKRS
2CustomerBSID-KUNNR
3Customer nameKNA1-NAME1
4Accounting clerkKNB1-BUSAB
5Profit centerBSID-PRCTR
6DocumentBSID-BELNR
7Special G/L indicatorBSID-UMSKZ
8Posting dateBSID-BUDAT
9Net due dateCalculated BSID-ZFBDT + payment-term days (ZBD1T/ZBD2T/ZBD3T)
10Days overdueCalculated Key date − net due date
11AmountCalculated BSID-DMBTR, negative when SHKZG = H
12CurrencyT001-WAERS
13Age bucketCalculated Bucket of the days overdue by the P_BKTS limits; "Down payment" for down payments received
14Dunning levelBSID-MANST

Sample output

Company codeCustomerCustomer nameAccounting clerkProfit centerDocumentSpecial G/L indicatorPosting dateNet due dateDays overdueAmountCurrencyAge bucketDunning level
1000200118Bereket Tarım ÜrünleriT1PC1100180001204408/20/202609/19/202659184,500TRY31–602
1000200118Bereket Tarım ÜrünleriT1PC11001400003117A10/05/202610/05/202643-50,000TRYDown payment0
1000200245Kuzey Yapı MarketT2PC1200180001239010/28/202611/27/2026-1096,320TRYNot due0
1000200377Selin KozmetikT2PC1300180001120806/02/202607/02/202613841,780TRY90+3
A view built with fictional sample data; not real system data.

How does the report work?

  1. Open items posted up to the key date are read from BSID for the selection. With a past key date, items cleared after that date (AUGDT > key date) are added from BSAD.
  2. The net due date is derived from the baseline date (ZFBDT) and the payment-term days (ZBD1T, ZBD2T, ZBD3T) using the standard due-date logic.
  3. Days overdue = key date − net due date; negative values are items not yet due. Bucket limits are read from the P_BKTS parameter.
  4. When P_SPGL is set, special G/L items (UMSKZ filled) are included; down payments received (UMSKS = A) are shown on their own row in a “Down payment” bucket and deducted from the customer total.
  5. The amount is signed by the debit/credit indicator (SHKZG) and shown in local currency (T001-WAERS). The customer name comes from KNA1, the accounting clerk and reconciliation account from KNB1, and the dunning level from BSID-MANST.

Performance notes

Read BSID by company code and customer range; read BSAD only for a past key date and with the AUGDT condition. In S/4HANA, for high volumes, push the aggregation down to the database on I_OperationalAcctgDocItem.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants Variants with subtotals by customer or profit center can be saved.
  • Double-click drill-down to the document Double-clicking the document opens FB03; double-clicking the customer opens FBL5N.
  • Export to Excel
  • Runs as a background job Can run automatically with the month-end key date.
  • Send the result by email The result can be sent to each accounting clerk with their own customers.

Authorization objects

  • F_BKPF_BUKAccounting document authorization by company code
  • F_KNA1_BUKCustomer master authorization by company code

Frequently asked questions

How are down payments received shown in the aging?

Down payments (special G/L indicator such as A) are shown on their own row in a "Down payment" bucket with a negative amount. The customer subtotal deducts them from invoices to give the net exposure; down payments can also be excluded.

Why is the profit center empty on some items?

The profit center is carried to the customer item when document splitting is active in the new G/L. Without document splitting the field can stay empty; the report can then be extended to read the profit center from the FAGLFLEXA line item.

Does it work on S/4HANA?

Yes. BSID and BSAD can still be read as compatibility views on S/4HANA. For new developments, the I_OperationalAcctgDocItem CDS view, which already provides the net due date, is preferred.

Packages that include this solution

FI Package Custom

Customer Receivables Collection Pack

A pack that brings together four solutions a collection team needs, with one customer and company code selection: receivables aging, the customer's …

4 components · v1.0

SD Package Custom

Order-to-Cash Control Pack

A five-report pack that shows every point where a sales order gets stuck, with one sales organization selection: missing data, credit blocks, picked …

5 components · v1.0

Related reports

FI Report Custom ALV report

Customer Payment Behavior and Days-to-Pay Report

A custom ALV report that uses customer invoices cleared in the selected period to calculate each customer's average days to pay, amount-weighted days …

BSAD · BKPF · BSID · KNA1

FI Report Custom ALV report

Vendor Open Items Aging Report

A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …

BSIK · LFA1 · LFB1 · T001

Let us build this report for your system

Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.

Related report: Customer Receivables Aging Report