FI Report Custom development ALV report TR · Türkiye

Türkiye Legal Journal and General Ledger (Defter-i Kebir) Printout Report

Short answer: A custom ALV report that prints the accounting entries of the selected period in legal format, either as a journal in date order with journal entry numbers or as a general ledger per main account with carried-forward and running balances. It gives PDF and Excel output for period checks of the books, review by the tax advisor and audit requests.

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

Why is the standard not enough?

FAGLL03 lists items per account but gives no journal entry number and does not show entries as balanced debit-credit articles. FAGLB03 only gives period balances; there is no ledger printout with carried-forward and running balances. The report produces both legal books from the same data, with numbering and main account totals.

Who uses it? General ledger teams, certified public accountants, internal and external auditors.

Closest standard alternatives

  • FAGLL03 G/L Account Line Items (New). Lists account line items; there is no journal number or legal article layout.
  • FAGLB03 Display Balances (New General Ledger). Shows period balances; gives no entry-level ledger printout with carried-forward and running balances.

Localization and legal basis

Tables used

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

TableRoleJoinSystem
BKPFAccounting Document HeaderDocument header: posting date, document type, reference (driving table)—ECC + S/4
BSEGAccounting Document SegmentLine items: account, debit/credit, amount and textBSEG-BUKRS = BKPF-BUKRS AND BSEG-BELNR = BKPF-BELNR AND BSEG-GJAHR = BKPF-GJAHRECC only
ACDOCAUniversal Journal Entry Line ItemsLine items and opening balances on S/4HANAACDOCA-RBUKRS = BKPF-BUKRS AND ACDOCA-BELNR = BKPF-BELNR AND ACDOCA-GJAHR = BKPF-GJAHRS/4HANA only
FAGLFLEXTNew General Ledger: TotalsAccount opening balances for the general ledgerFAGLFLEXT-RBUKRS = BKPF-BUKRS AND FAGLFLEXT-RYEAR = BKPF-GJAHRECC only
SKATG/L Account DescriptionsMain account and sub-account namesSKAT-SAKNR = BSEG-HKONTECC + S/4
T001Company CodesCompany name, chart of accounts and local currencyT001-BUKRS = BKPF-BUKRSECC + S/4

S/4HANA notes

  • FAGLFLEXT → ACDOCA: In S/4HANA totals tables are no longer updated separately; FAGLFLEXT is read as a compatibility view that aggregates ACDOCA line items.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_BUKRSCompany codeSingle valueBKPF-BUKRSYes1000
P_GJAHRFiscal yearSingle valueBKPF-GJAHRYes2026
S_BUDATPosting dateRange / multipleBKPF-BUDATYes01.10.2026 – 31.10.2026
R_JOURNJournalRadio button—NoX
R_LEDGRGeneral ledgerRadio button—No—
P_LEVELMain account digitsSingle value—No3
P_STARTStart journal numberSingle value—No18241

Output columns

#ColumnSource
1Journal no.Calculated Article number assigned in date and document order from the start number
2Posting dateBKPF-BUDAT
3Document no.BKPF-BELNR
4Main accountCalculated First P_LEVEL digits of the account number
5AccountBSEG-HKONT
6Account nameSKAT-TXT50
7DescriptionBSEG-SGTXT
8DebitCalculated BSEG-DMBTR when BSEG-SHKZG = S
9CreditCalculated BSEG-DMBTR when BSEG-SHKZG = H
10Running balanceCalculated In the general ledger, opening balance + cumulative debit − cumulative credit

Sample output

Journal no.Posting dateDocument no.Main accountAccountAccount nameDescriptionDebitCreditRunning balance
18,24110/01/20261900002217120120000150Alıcılar – Örnek Tekstil A.Ş.Fatura 90031102120,0000120,000
18,24110/01/20261900002217600600000100Yurt İçi SatışlarFatura 900311020100,000-100,000
18,24110/01/20261900002217391391000020Hesaplanan KDV %20Fatura 90031102020,000-20,000
A view built with fictional sample data; not real system data.

How does the report work?

  1. Documents are read from BKPF for the selected company code, fiscal year and posting date range, in posting date and document number order; reversals and special periods are included according to the parameters.
  2. Line items are read from BSEG (ACDOCA on S/4HANA); the account number is reduced to the main account by the number of digits in the parameters (e.g. 3 digits).
  3. Journal: each document becomes one article; article numbers are assigned in date order starting from the start number. Within an article, debit lines come first, then credit lines, with main account and sub-account totals.
  4. General ledger: for each main account the opening balance comes from FAGLFLEXT (ACDOCA on S/4HANA), period entries are added in date order and the running balance is calculated.
  5. Account names come from SKAT; page carry-forward totals and period totals are calculated.
  6. Output is taken as ALV, PDF or Excel; at the end of the report the equality of debit and credit totals for the period is checked.

Performance notes

Read period entries by company code, fiscal year and period; with very high volumes, run months as separate background jobs and merge the PDFs. Load account names into memory once.

Features

  • ALV list (sort, filter, subtotals)
  • Export to Excel
  • Runs as a background job The monthly printout is prepared as a PDF in the background and placed in the spool or on a file server.
  • Double-click drill-down to the document From a journal article you can jump to the accounting document.
  • User-specific layout variants

Authorization objects

  • F_BKPF_BUKDocument display authorization by company code
  • F_SKA1_BUKG/L account display authorization by company code

Frequently asked questions

Does this report replace the e-Ledger?

No. For companies subject to e-Ledger, the legal books are created and signed electronically. The report gives the same content in readable form for checks before the e-Ledger, review by the tax advisor and audit requests; companies not subject to e-Ledger also use it as the printed book.

Do the journal numbers change with each run?

The number is calculated from the given start number in date and document order. After the period is closed, a run with the same parameters gives the same numbers; the period must be closed to prevent postings into it.

Related reports

FI Report Custom ALV report

Parked Documents Aging Report

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 …

VBKPF · BKPF · VBSEGS · 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: Türkiye Legal Journal and General Ledger (Defter-i Kebir) Printout Report