FI Report Custom development ALV report

Payment Proposal Exceptions and Blocked Items Report

Short answer: A custom report that collects, in one ALV list, the items in an automatic payment program (F110) proposal that will not be paid and the vendor items that are due but did not make it into the proposal. For every row the type of obstacle (item block, vendor payment block, central block, proposal exception) is shown in its own column.

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

Why is the standard not enough?

The F110 exception list is a text log; it cannot be filtered by vendor name, amount or block reason. FBZ0 lets you edit the proposal but does not show items that are due and never entered it. FBL1N lists blocked items without linking them to a specific payment run. Before approving payments, the question "what is not paid in this run, and why" needs one list.

Who uses it? Accounts payable teams, treasury and finance managers who approve payments.

Closest standard alternatives

  • F110 Automatic Payment Program. Gives the exception list as a text log; offers no filterable list.
  • FBZ0 Display/Edit Payment Proposal. Lets you edit the proposal; does not show due items that were left out of it.

Tables used

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

TableRoleJoinSystem
REGUHPayment Program Settlement DataProposal header: payee, payment document, total amount—ECC + S/4
REGUPPayment Program Processed ItemsItems in the proposal, item block and payment method (driving table)REGUP-LAUFD = REGUH-LAUFD AND REGUP-LAUFI = REGUH-LAUFI AND REGUP-XVORL = REGUH-XVORL AND REGUP-ZBUKR = REGUH-ZBUKR AND REGUP-LIFNR = REGUH-LIFNR AND REGUP-VBLNR = REGUH-VBLNRECC + S/4
BSIKVendor Open ItemsOpen items that are due but not in the proposalBSIK-BUKRS = REGUP-BUKRS AND BSIK-BELNR = REGUP-BELNR AND BSIK-GJAHR = REGUP-GJAHR AND BSIK-BUZEI = REGUP-BUZEIECC + S/4
LFA1Vendor Master (General Section)Vendor name and central blockLFA1-LIFNR = REGUP-LIFNRECC + S/4
LFB1Vendor Master (Company Code)Company code payment blockLFB1-LIFNR = REGUP-LIFNR AND LFB1-BUKRS = REGUP-BUKRSECC + S/4
I_PaymentProposalItemPayment Proposal ItemPayment proposal items on S/4HANAPaymentRunDate = REGUP-LAUFD AND PaymentRunID = REGUP-LAUFIS/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
P_LAUFDRun dateSingle valueREGUH-LAUFDYes17.11.2026
P_LAUFIRun identificationSingle valueREGUH-LAUFIYesHAFT1
S_ZBUKRPaying company codeRange / multipleREGUH-ZBUKRNo1000
S_LIFNRVendorRange / multipleREGUP-LIFNRNo100245
S_ZLSPRPayment block keyRange / multipleBSIK-ZLSPRNoA
P_NEXTDNext payment dateSingle valueSY-DATUMNo24.11.2026
P_DUEAlso show due items not in the proposalCheckbox—NoX

Output columns

#ColumnSource
1Company codeREGUP-BUKRS
2VendorREGUP-LIFNR
3Vendor nameLFA1-NAME1
4DocumentREGUP-BELNR
5Fiscal yearREGUP-GJAHR
6ReferenceREGUP-XBLNR
7Baseline dateREGUP-ZFBDT
8AmountREGUP-WRBTR
9CurrencyREGUP-WAERS
10Payment methodREGUP-ZLSCH
11Item blockREGUP-ZLSPR
12Vendor payment blockLFB1-ZAHLS
13StatusCalculated Exception when REGUH-VBLNR is blank; not in proposal when missing from REGUP
14ReasonCalculated Item block, vendor block, central block (LFA1-SPERR) or missing payment method/bank details

Sample output

Company codeVendorVendor nameDocumentFiscal yearReferenceBaseline dateAmountCurrencyPayment methodItem blockVendor payment blockStatusReason
1000100245Atlas Ambalaj51000042112026FT-2026-091209/29/2026125,000TRYTAExceptionItem block (A)
1000100387Delta Metal51000039022026DM-5510210/10/202648,960TRYTBExceptionVendor payment block
1000100512Ege Kimya51000045022026EK-2041210/18/202625,560TRYNot in proposalPayment method missing
1000100640Marmara Lojistik51000046302026ML-778111/02/202618,400EURURExceptionItem block (R)
A view built with fictional sample data; not real system data.

How does the report work?

  1. Proposal records are read for the selected run date and identification: REGUH and REGUP with XVORL = X.
  2. Items that will not get a payment document (REGUH-VBLNR blank) are taken as exceptions; the reason is determined by checking, in this order, the item block (REGUP-ZLSPR), the vendor’s company code payment block (LFB1-ZAHLS), the central block (LFA1-SPERR) and missing payment method or bank details.
  3. When P_DUE is set, open items due by the next payment date are read from BSIK and those not found in REGUP are added as “not in proposal”.
  4. The vendor name is added from LFA1 and the payment block from LFB1; amounts are shown in document currency.
  5. The list is shown with subtotals by vendor and reason.

Performance notes

Read REGUH/REGUP by the run key (LAUFD, LAUFI). For the BSIK comparison use the company code and a due-date range; take the vendor list from the proposal scope. On S/4HANA I_PaymentProposalItem provides the proposal items.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the document opens FB03; double-clicking the vendor opens FBL1N.
  • Export to Excel
  • Send the result by email After the proposal has run, the list can be sent to the payment approver.

Authorization objects

  • F_REGU_BUKPayment program authorization by company code
  • F_BKPF_BUKAccounting document display authorization by company code
  • F_LFA1_BUKVendor master authorization by company code

Frequently asked questions

Does the report change the proposal?

No. The report only reads. Removing a block or editing the proposal is done in FBZ0 or by changing the document; navigation from the report to those steps can be added.

Does it work after the proposal has been deleted?

It works as long as the proposal data is still in REGUH/REGUP. After the payment run has been executed, the unpaid items of that run can still be listed.

How are missing bank details detected?

When the payment method requires a bank transfer and the payee bank account in the proposal record is empty, the row is flagged as "bank details missing".

Related reports

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

FI Program Custom Form

Vendor Payment Advice Email Program

A custom program that, after an automatic payment run, emails every vendor a PDF payment advice listing the invoices that were paid. A preview comes …

REGUH · REGUP · LFB1 · LFA1

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: Payment Proposal Exceptions and Blocked Items Report