FI Report Custom development ALV report

Parked Documents Aging Report

Short answer: A custom ALV report that lists parked accounting documents that are not yet posted by user, document type and waiting time. Before the period close it shows old, forgotten or approval-pending documents together with their amounts on one screen.

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

Why is the standard not enough?

FBV3 displays one parked document at a time and FBV0 posts one at a time. There is no standard list that shows how many documents have been waiting with which user and for how many days, with their total amount and the completed / not completed split; pending documents are usually searched by hand at the close.

Who uses it? Chief accountants, financial controllers, teams that run the period close and internal audit.

Closest standard alternatives

  • FBV3 Display Parked Document. Displays one parked document at a time; gives no waiting time or totals.
  • FBV0 Post Parked Document. Posts a parked document; does not list pending documents.

Tables used

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

TableRoleJoinSystem
VBKPFDocument Header for Document ParkingParked document header: type, dates, user, completed indicator (driving table)—ECC + S/4
BKPFAccounting Document HeaderParked status (BSTAT = V) and entry dateBKPF-BUKRS = VBKPF-BUKRS AND BKPF-BELNR = VBKPF-BELNR AND BKPF-GJAHR = VBKPF-GJAHRECC + S/4
VBSEGSParked Document Segment for G/L AccountsG/L lines and amounts of the parked documentVBSEGS-AUSBK = VBKPF-AUSBK AND VBSEGS-BELNR = VBKPF-BELNR AND VBSEGS-GJAHR = VBKPF-GJAHRECC + S/4
T001Company CodesCompany code local currencyT001-BUKRS = VBKPF-BUKRSECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleVBKPF-BUKRSYes1000
S_BLARTDocument typeRange / multipleVBKPF-BLARTNoKR
S_USNAMParked by userRange / multipleVBKPF-USNAMNoMUHASEBE01
S_BUDATPosting dateRange / multipleVBKPF-BUDATNo01.01.2026–31.10.2026
P_MINDAYMinimum waiting time (days)Single value—No7
P_ONLYCOnly completed (approval-pending) documentsCheckbox—No—

Output columns

#ColumnSource
1Company codeVBKPF-BUKRS
2DocumentVBKPF-BELNR
3Fiscal yearVBKPF-GJAHR
4Document typeVBKPF-BLART
5Parked byVBKPF-USNAM
6Entry dateBKPF-CPUDT
7Posting dateVBKPF-BUDAT
8ReferenceVBKPF-XBLNR
9Header textVBKPF-BKTXT
10AmountCalculated Sum of VBSEGS-DMBTR for lines with SHKZG = S
11CurrencyVBKPF-WAERS
12Days waitingCalculated Report date − BKPF-CPUDT
13Age bucketCalculated Bucket of the days waiting by the 30/60/90 limits
14CompletedVBKPF-XPRFG

Sample output

Company codeDocumentFiscal yearDocument typeParked byEntry datePosting dateReferenceHeader textAmountCurrencyDays waitingAge bucketCompleted
100019000004122026KRMUHASEBE0109/12/202609/12/2026FTR2026-1182September freight invoice48,600TRY6661–90
100019000004552026SAMUHASEBE0210/30/202610/31/2026October rent accrual120,000TRY180–30X
100019000004602026KRSATINALMA0511/03/202611/03/2026A-55120Maintenance service9,850TRY140–30
200019000000982026KRMUHASEBE0107/18/202607/18/2026INV-77812Consulting invoice4,200EUR12290+
A view built with fictional sample data; not real system data.

How does the report work?

  1. Parked document headers are read from VBKPF for the selection (company code, document type, user, posting date).
  2. The entry date (CPUDT) is taken from the BKPF header with the same key whose document status is parked (BSTAT = V).
  3. The document amount is the local-currency total of the debit side (SHKZG = S) of the G/L lines in VBSEGS; vendor, customer and tax lines are not part of this total.
  4. Waiting time = report date − entry date; documents waiting less than P_MINDAY are skipped and the time is spread into 0–30, 31–60, 61–90, 90+ buckets.
  5. The completed indicator (XPRFG) separates documents waiting for approval from incomplete ones; subtotals are built by user and document type.

Performance notes

VBKPF is a small table; BKPF is read with the full key. Read VBSEGS once with FOR ALL ENTRIES on the document list.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants Comes with a variant that subtotals by user and age bucket.
  • Double-click drill-down to the document Double-clicking the document number opens FBV3.
  • Export to Excel
  • Runs as a background job Can run automatically a few days before the close.
  • Send the result by email Each user can receive their own pending documents by email.

Authorization objects

  • F_BKPF_BUKAccounting document authorization by company code
  • F_BKPF_BLADisplay authorization by document type

Frequently asked questions

Can the gross amount of vendor invoices be shown?

The standard version shows the net amount of the G/L lines. The gross invoice amount and the vendor name can be added by also reading the parking tables that hold vendor and customer lines; this extension adds about one day to the effort range.

Can documents whose posting date falls in a closed period be flagged?

Yes. Documents whose posting date now falls in a closed posting period can be flagged in an extra column, so documents that need a new date before posting are visible.

Can it be used on S/4HANA?

Yes. Classic parking keeps working with VBKPF and its related tables on S/4HANA. If the new parking solution is activated, the source tables are checked during installation.

Packages that include this solution

FI Package Custom

Month-End Close Control Pack

A pack that lists the five topics to clean up before the close with one company code and period selection: parked documents, unmatched bank items, …

5 components · v1.0

Related reports

FI Program Custom Mass upload

Mass G/L Journal Entry Upload from Excel

A custom program that posts multi-line G/L documents (accruals, reclassifications, allocation entries) in bulk from Excel or CSV rows. It checks every …

BKPF · BSEG · SKB1 · CSKS

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: Parked Documents Aging Report