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
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: Articles 182-183 of Tax Procedure Law No. 213 (journal and general ledger) and Article 64 of Turkish Commercial Code No. 6102.
The account level (number of main account digits) and the journal numbering rule are set according to the company's chart of accounts during installation.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| BKPFAccounting Document Header | Document header: posting date, document type, reference (driving table) | — | ECC + S/4 |
| BSEGAccounting Document Segment | Line items: account, debit/credit, amount and text | BSEG-BUKRS = BKPF-BUKRS AND BSEG-BELNR = BKPF-BELNR AND BSEG-GJAHR = BKPF-GJAHR | ECC only |
| ACDOCAUniversal Journal Entry Line Items | Line items and opening balances on S/4HANA | ACDOCA-RBUKRS = BKPF-BUKRS AND ACDOCA-BELNR = BKPF-BELNR AND ACDOCA-GJAHR = BKPF-GJAHR | S/4HANA only |
| FAGLFLEXTNew General Ledger: Totals | Account opening balances for the general ledger | FAGLFLEXT-RBUKRS = BKPF-BUKRS AND FAGLFLEXT-RYEAR = BKPF-GJAHR | ECC only |
| SKATG/L Account Descriptions | Main account and sub-account names | SKAT-SAKNR = BSEG-HKONT | ECC + S/4 |
| T001Company Codes | Company name, chart of accounts and local currency | T001-BUKRS = BKPF-BUKRS | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_BUKRS | Company code | Single value | BKPF-BUKRS | Yes | 1000 |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes | 2026 |
| S_BUDAT | Posting date | Range / multiple | BKPF-BUDAT | Yes | 01.10.2026 – 31.10.2026 |
| R_JOURN | Journal | Radio button | — | No | X |
| R_LEDGR | General ledger | Radio button | — | No | — |
| P_LEVEL | Main account digits | Single value | — | No | 3 |
| P_START | Start journal number | Single value | — | No | 18241 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Journal no. | Calculated Article number assigned in date and document order from the start number |
| 2 | Posting date | BKPF-BUDAT |
| 3 | Document no. | BKPF-BELNR |
| 4 | Main account | Calculated First P_LEVEL digits of the account number |
| 5 | Account | BSEG-HKONT |
| 6 | Account name | SKAT-TXT50 |
| 7 | Description | BSEG-SGTXT |
| 8 | Debit | Calculated BSEG-DMBTR when BSEG-SHKZG = S |
| 9 | Credit | Calculated BSEG-DMBTR when BSEG-SHKZG = H |
| 10 | Running balance | Calculated In the general ledger, opening balance + cumulative debit − cumulative credit |
Sample output
| Journal no. | Posting date | Document no. | Main account | Account | Account name | Description | Debit | Credit | Running balance |
|---|---|---|---|---|---|---|---|---|---|
| 18,241 | 10/01/2026 | 1900002217 | 120 | 120000150 | Alıcılar – Örnek Tekstil A.Ş. | Fatura 90031102 | 120,000 | 0 | 120,000 |
| 18,241 | 10/01/2026 | 1900002217 | 600 | 600000100 | Yurt İçi Satışlar | Fatura 90031102 | 0 | 100,000 | -100,000 |
| 18,241 | 10/01/2026 | 1900002217 | 391 | 391000020 | Hesaplanan KDV %20 | Fatura 90031102 | 0 | 20,000 | -20,000 |
How does the report work?
- 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.
- 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).
- 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.
- 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.
- Account names come from SKAT; page carry-forward totals and period totals are calculated.
- 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
G/L Line Items with Offsetting Account and Business Partner Report
A custom ALV general ledger report that lists the line items of selected G/L accounts with debit, credit and running balance, and adds the offsetting …
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 …
Subledger vs Reconciliation Account Balance Check Report (S/4HANA Migration Check)
A custom ALV report that totals customer and vendor subledger balances by reconciliation account and compares them with the G/L account balance for …
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.