ERPClimb logoERPClimb
SAP transaction codeObjectFBL5NModuleFI_FICO

FBL5N — Customer Line Item Display

FBL5N displays open, cleared, or all line items for one or more customer accounts, read from the customer sub-ledger (or the universal journal on S/4HANA). It is a display-only transaction. The most common source of confusion is the special G/L indicator: down payments and bills of exchange are posted as special G/L transactions and will not appear in the list unless that indicator is explicitly included in the selection.

This page covers FBL5N, the standard customer line item display transaction in FI. It focuses on why reported balances appear to disagree with what a user expects, walking through the special G/L indicator, open/cleared status, and key date traps that account for most support tickets raised against this report.

Reviewed by an ERPClimb SAP consultant on 15 Sept 2026· 1,241 words

Esta página aún no está disponible en español.

What it does

FBL5N is a report, not a posting transaction: it reads accounting documents already sitting in the customer sub-ledger and presents them as open, cleared, or all items for a given customer or range of customers within a company code. It does not touch customer master data or credit management settings, only line items already posted to the account. The single structural fact that explains most confusion with this transaction is the special G/L indicator. Down payments, bills of exchange, and guarantees are posted with a special G/L transaction type and are excluded from the default customer item view unless that indicator is deliberately included in the selection screen. A customer balance that looks wrong is frequently just a balance that is incomplete for the selection made, not a posting error.

When it is used

FBL5N is reached for whenever the question is about a specific customer's account history rather than a general ledger account: dispute resolution before a collections call, reconciling an AR aging report against the sub-ledger, checking whether a payment actually cleared an invoice, or confirming what open items exist before running dunning or a credit check. It sits downstream of sales order billing and payment application; nothing is posted from here. Consultants use FBL5N instead of FBL3N when the object of investigation is the customer, and reach for FAGLL03 instead when the investigation needs to cross into the general ledger view of the reconciliation account. On S/4HANA a Fiori line item app exists with similar filtering, but the classic transaction remains fully functional and is still the faster tool for ad hoc, keyboard-driven investigation.

How to use it

  • Enter the customer account number or a range/group of customers
  • Enter the company code (or leave it blank only if authorized for cross-company display)
  • Choose the item status: open items, cleared items, or all items
  • Set the key date if selecting open items, since this determines which items count as open as of that date
  • Tick or set the special G/L indicator field to include down payments, bills of exchange, or other special G/L transactions if they are relevant to the question being investigated
  • Execute, then adjust the display layout to add fields such as clearing document, baseline date, or payment terms as needed for the specific issue

Key fields

  • BSID - open customer items, read directly when open items are selected on ECC and earlier releases
  • BSAD - cleared customer items, read when cleared or all items are selected
  • BSEG - the underlying line item segment for every accounting document, joined for document detail
  • BKPF - document header, supplies posting date, document type, and fiscal year
  • KNB1 - customer master company code segment, supplies reconciliation account and other account-level attributes used to filter and display
  • ACDOCA - on S/4HANA, the universal journal table that now sources the report through compatibility views instead of BSID/BSAD directly

How to prove it in the data

To confirm a discrepancy, query BSID for open items or BSAD for cleared items filtered on the company code and customer number, and join BKPF on document number, company code, and fiscal year to bring in posting date and document type. Check the UMSKZ field on the line item to see whether a special G/L transaction exists that the user's selection excluded. On S/4HANA, run the same filter directly against ACDOCA using company code, customer, and the relevant posting date range, since BSID and BSAD are compatibility views over that table.

ECC vs S/4HANA

FBL5N still works on S/4HANA and behaves the same functionally. Underneath, it reads from the universal journal table through compatibility views rather than the separate BSID and BSAD tables, which keeps figures consistent with FI and CO since both now share one line item source. A Fiori app for customer line items offers additional filtering and a modern layout, but it does not replace the tcode; both are used depending on the consultant's habit and the client's rollout of Fiori. The special G/L indicator logic and the open/cleared/key date behavior are unchanged.

Common pitfalls

  • Special G/L items excluded: the most frequent complaint is that the customer total in FBL5N does not match a total quoted elsewhere. Check first whether the special G/L indicator field on the selection screen was left blank or restricted; down payments and bills of exchange are posted under a special G/L transaction and are invisible in the default view until that indicator is set to include them, often with a wildcard.
  • Open versus cleared confusion: an item that appears to be missing has usually been cleared, and the user selected open items only. Re-run with all items or with cleared items and a key date after the clearing date to confirm.
  • Key date cutoff: for open item selection, the key date determines what counts as still open as of that date. An item posted after the key date, or cleared before it, will not appear even though it exists; check the posting date and clearing date against the key date used.
  • Layout hides fields, not data: a field that appears blank is often just not included in the active display variant. Change layout and add the field before concluding it is not populated in the document.
  • Authorization gaps look like empty results: a blank list can mean no items exist or that the user lacks authorization for that company code or customer group. Distinguish the two by checking the authorization trace before assuming a data problem.
  • Reconciliation account changes mid-history: if the customer's reconciliation account was changed at some point, older and newer postings may sit under different GL reconciliation accounts, making a cross-check against FBL3N on a single account appear incomplete. Confirm the reconciliation account history before comparing totals.
  • Large selections timing out: pulling all items for a customer across many years, especially without a posting date restriction, can be slow or time out; narrow the date range or restrict by document type before widening the selection.

Whose problem this is

This is a functional FI/AR issue in almost every case: the fix is nearly always a selection screen adjustment, not a code or basis change. Escalate to basis only for an authorization trace or a genuine performance timeout on very large selections. A good handover states the customer, company code, date range, and exact selection options used, plus whether special G/L items were included, so the receiving consultant does not have to rediscover the selection that produced the confusing result.

Related SAP objects

Reviewed pages this object connects to in the ERPClimb knowledge graph.

Source: ERPClimb — https://erpclimb.com/sap-tcodes/fbl5nERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.