FI Report Custom development ALV report

Vendor Open Items Aging Report

Short answer: 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 finance team sees how much is owed to which vendor, and for how many days it has been overdue, in one list.

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?

FBL1N lists items but does not total them into age buckets. S_ALR_87012078 does due-date analysis, but its output layout is limited and does not offer one Excel-ready list with vendor name and reconciliation account. Month-end reporting usually ends up as a custom report.

Who uses it? Accounts payable teams, finance managers and cash management.

Closest standard alternatives

  • FBL1N Vendor Line Item Display. Lists open items; does not total them into age buckets.
  • S_ALR_87012078 Due Date Analysis for Open Items (Vendors). Totals by due-date intervals; the layout is limited and it does not offer one Excel-ready list.

Tables used

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

TableRoleJoinSystem
BSIKVendor Open ItemsVendor open items, due-date data and amounts (driving table)—ECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = BSIK-LIFNRECC + S/4
LFB1Vendor Master (Company Code)Reconciliation account and payment termsLFB1-LIFNR = BSIK-LIFNR AND LFB1-BUKRS = BSIK-BUKRSECC + S/4
T001Company CodesCompany code local currencyT001-BUKRS = BSIK-BUKRSECC + S/4
I_OperationalAcctgDocItemOperational Accounting Document Item (CDS)In S/4HANA, for reading open items together with the net due dateCompanyCode = BSIK-BUKRS AND Supplier = BSIK-LIFNRS/4HANA only

S/4HANA notes

  • BSIK: In S/4HANA BSIK is no longer filled as a separate index table; reads work through a compatibility view. For new developments the I_OperationalAcctgDocItem CDS view is recommended.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleBSIK-BUKRSYes1000
S_LIFNRVendorRange / multipleBSIK-LIFNRNo100245
S_AKONTReconciliation accountRange / multipleLFB1-AKONTNo320000
P_KEYDTKey dateSingle valueSY-DATUMYes16.11.2026
P_BKT1Bucket 1 upper limit (days)Single value—No30
P_BKT2Bucket 2 upper limit (days)Single value—No60
P_BKT3Bucket 3 upper limit (days)Single value—No90
P_NOTDUEAlso show items not yet dueCheckbox—NoX

Output columns

#ColumnSource
1Company codeBSIK-BUKRS
2VendorBSIK-LIFNR
3Vendor nameLFA1-NAME1
4DocumentBSIK-BELNR
5Fiscal yearBSIK-GJAHR
6Posting dateBSIK-BUDAT
7Net due dateCalculated BSIK-ZFBDT + payment-term days (ZBD1T/ZBD2T/ZBD3T)
8Days overdueCalculated Key date − net due date
9AmountCalculated BSIK-DMBTR, shown as a positive payable when SHKZG = H
10CurrencyT001-WAERS
11Age bucketCalculated Bucket of the days overdue by the P_BKT1, P_BKT2, P_BKT3 limits

Sample output

Company codeVendorVendor nameDocumentFiscal yearPosting dateNet due dateDays overdueAmountCurrencyAge bucket
1000100245Atlas Ambalaj5100004211202608/30/202609/29/202648125,000TRY31–60
1000100245Atlas Ambalaj5100004388202610/15/202611/14/2026246,200TRY0–30
1000100387Delta Metal5100003902202606/10/202607/10/202612948,960TRY90+
1000100512Ege Kimya5100004502202611/01/202612/01/2026-1525,560TRYNot due
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 BSIK for the selection. When a past key date is chosen, items cleared after that date are added from the cleared items table as well.
  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 calculation.
  3. Days overdue = key date − net due date. Negative values are items that are not yet due.
  4. The amount is signed by the debit/credit indicator (SHKZG) and shown in local currency (T001-WAERS).
  5. The vendor name is added from LFA1 and the reconciliation account from LFB1; amounts are spread into the age buckets.

Performance notes

Read BSIK by company code and vendor range. 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
  • Double-click drill-down to the document Double-clicking the document number opens FB03.
  • Export to Excel
  • Runs as a background job Can run automatically with the month-end key date.
  • Send the result by email

Authorization objects

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

Frequently asked questions

How is the net due date calculated?

The payment-term days are added to the baseline date (BSIK-ZFBDT). For items without cash discount, the net payment days are used; the calculation follows SAP's standard due-date logic.

Can aging be run for a past date?

Yes. With a past key date, items cleared after that date are included too, so the payables picture at a month-end close can be reproduced.

Which source should be used on S/4HANA?

BSIK can still be read as a compatibility view. For new developments, the I_OperationalAcctgDocItem CDS view, which already provides the net due date, is preferred.

Packages that include this solution

MM Package Custom

Purchasing and Payables Control Pack

A ready-made two-report pack that tracks open purchase orders per vendor and overdue payables to the same vendors with one shared vendor selection. …

2 components · v1.0

Related reports

MM Report Custom ALV report

Open Purchase Orders by Vendor Report

A custom ALV report that shows, per vendor, the quantity not yet received, the open order value and the days of delay since the delivery date in a …

EKKO · EKPO · EKET · LFA1

SD Report Custom ALV report

Sales Order – Delivery – Invoice Status Report

A custom ALV report that shows every sales order item on the same line as its delivery and invoice documents. You see in one list which orders have …

VBAK · VBAP · VBFA · LIKP

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: Vendor Open Items Aging Report