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.
| Table | Role | Join | System |
|---|---|---|---|
| BSIKVendor Open Items | Vendor open items, due-date data and amounts (driving table) | — | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = BSIK-LIFNR | ECC + S/4 |
| LFB1Vendor Master (Company Code) | Reconciliation account and payment terms | LFB1-LIFNR = BSIK-LIFNR AND LFB1-BUKRS = BSIK-BUKRS | ECC + S/4 |
| T001Company Codes | Company code local currency | T001-BUKRS = BSIK-BUKRS | ECC + S/4 |
| I_OperationalAcctgDocItemOperational Accounting Document Item (CDS) | In S/4HANA, for reading open items together with the net due date | CompanyCode = BSIK-BUKRS AND Supplier = BSIK-LIFNR | S/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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BSIK-BUKRS | Yes | 1000 |
| S_LIFNR | Vendor | Range / multiple | BSIK-LIFNR | No | 100245 |
| S_AKONT | Reconciliation account | Range / multiple | LFB1-AKONT | No | 320000 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 16.11.2026 |
| P_BKT1 | Bucket 1 upper limit (days) | Single value | — | No | 30 |
| P_BKT2 | Bucket 2 upper limit (days) | Single value | — | No | 60 |
| P_BKT3 | Bucket 3 upper limit (days) | Single value | — | No | 90 |
| P_NOTDUE | Also show items not yet due | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | BSIK-BUKRS |
| 2 | Vendor | BSIK-LIFNR |
| 3 | Vendor name | LFA1-NAME1 |
| 4 | Document | BSIK-BELNR |
| 5 | Fiscal year | BSIK-GJAHR |
| 6 | Posting date | BSIK-BUDAT |
| 7 | Net due date | Calculated BSIK-ZFBDT + payment-term days (ZBD1T/ZBD2T/ZBD3T) |
| 8 | Days overdue | Calculated Key date − net due date |
| 9 | Amount | Calculated BSIK-DMBTR, shown as a positive payable when SHKZG = H |
| 10 | Currency | T001-WAERS |
| 11 | Age bucket | Calculated Bucket of the days overdue by the P_BKT1, P_BKT2, P_BKT3 limits |
Sample output
| Company code | Vendor | Vendor name | Document | Fiscal year | Posting date | Net due date | Days overdue | Amount | Currency | Age bucket |
|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 100245 | Atlas Ambalaj | 5100004211 | 2026 | 08/30/2026 | 09/29/2026 | 48 | 125,000 | TRY | 31–60 |
| 1000 | 100245 | Atlas Ambalaj | 5100004388 | 2026 | 10/15/2026 | 11/14/2026 | 2 | 46,200 | TRY | 0–30 |
| 1000 | 100387 | Delta Metal | 5100003902 | 2026 | 06/10/2026 | 07/10/2026 | 129 | 48,960 | TRY | 90+ |
| 1000 | 100512 | Ege Kimya | 5100004502 | 2026 | 11/01/2026 | 12/01/2026 | -15 | 25,560 | TRY | Not due |
How does the report work?
- 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.
- 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.
- Days overdue = key date − net due date. Negative values are items that are not yet due.
- The amount is signed by the debit/credit indicator (SHKZG) and shown in local currency (T001-WAERS).
- 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
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. …
Related reports
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 …
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 …
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.