FI Report Custom development ALV report TR · Türkiye

Balance Sheet and Income Statement in Turkish Format

Short answer: A custom ALV report that produces the balance sheet and income statement from SAP in the Turkish Uniform Chart of Accounts structure, with Roman-numeral main groups and lettered sub-groups, comparing current and prior periods. Company code and business area breakdowns can be selected; accounts with reverse balances are moved to the correct side, and the statement is exported to Excel in its statutory layout.

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

Why is the standard not enough?

S_ALR_87012284 and F.01 produce the balance sheet with a financial statement version, but the reverse balance rules of the local presentation (for example moving a credit-balance receivable account to liabilities), lettered line numbering and a clean Excel export need many nodes in the version and the output is still edited by hand. A comparative statement by business area needs separate runs.

Who uses it? Finance managers, general ledger teams, and management reporting and audit preparation teams.

Closest standard alternatives

  • S_ALR_87012284 Financial Statements. Produces balance sheet and income statement with a financial statement version; local reverse balance rules and the statutory Excel layout need extra editing.
  • F.01 Financial Statements. Gives the classic list output by financial statement version; business area comparison and local line numbering are limited.

Localization and legal basis

Tables used

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

TableRoleJoinSystem
FAGLFLEXTNew General Ledger: TotalsG/L period balances with business area (driving table)—ECC + S/4
ACDOCAUniversal Journal Entry Line ItemsUniversal journal used for balances on S/4HANA—ECC + S/4
SKA1G/L Account Master (Chart of Accounts)Balance sheet vs P&L account indicator (XBILK)SKA1-SAKNR = FAGLFLEXT-RACCTECC + S/4
SKATG/L Account DescriptionsAccount namesSKAT-SAKNR = SKA1-SAKNR AND SKAT-KTOPL = SKA1-KTOPLECC + S/4
T001Company CodesCompany name, currency and chart of accountsT001-BUKRS = FAGLFLEXT-RBUKRSECC + 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 valueT001-BUKRSYes1000
P_GJAHRFiscal yearSingle valueBKPF-GJAHRYes2026
P_MONATTo periodSingle valueBKPF-MONATYes09
S_GSBERBusiness areaRange / multipleBSEG-GSBERNo0001
R_BALBalance sheetRadio button—NoX
R_PLIncome statementRadio button—No—
P_PREVCompare with prior yearCheckbox—NoX

Output columns

#ColumnSource
1Line codeCalculated Line from the mapping table (I, A, 1 …)
2Line nameCalculated Statutory line name, indented by level
3Business areaFAGLFLEXT-RBUSA
4Current periodCalculated Balance total of the line's accounts or subtotal
5Prior periodCalculated Balance at the same period end of the prior year
6DifferenceCalculated Current − prior
7Difference %Calculated (Current − prior) / prior × 100

Sample output

Line codeLine nameBusiness areaCurrent periodPrior periodDifferenceDifference %
ICURRENT ASSETS48,620,00041,270,0007,350,00017.80
I.ALiquid Assets6,840,0005,915,000925,00015.60
I.CTrade Receivables21,430,00018,260,0003,170,00017.40
A view built with fictional sample data; not real system data.

How does the report work?

  1. The line structure is kept in a mapping table: I. Current Assets, A. Liquid Assets, B. Marketable Securities … and in the income statement A. Gross Sales, B. Sales Deductions … Each line has an account range and the line it moves to on a reverse balance.
  2. Balances for the selected company code, year and period are read from FAGLFLEXT (ACDOCA on S/4HANA) by account and optionally by business area.
  3. The balance direction of each account is checked; an account with a reverse balance moves to the counter line in the mapping (for example a credit-balance sub-account of 120 moves to 340 Advances Received).
  4. Subtotals and the net profit for the period are calculated; equality of total assets and total liabilities is checked.
  5. The same date of the prior year comes in a side column with the difference amount and percentage.
  6. You can drill down from a line to accounts and from an account to items; the Excel output follows the statutory layout with indented line names.

Performance notes

Read balances from FAGLFLEXT or ACDOCA aggregated by account and business area in the database; the reverse balance check runs per account in memory. The report runs within seconds for one company code.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Drill down from a line to accounts and from an account to items.
  • Export to Excel The statement is exported to Excel in its statutory layout with indented line names.

Authorization objects

  • F_BKPF_BUKAccounting data display authorization by company code
  • F_BKPF_GSBDisplay authorization by business area

Frequently asked questions

Why a separate mapping table instead of the financial statement version?

In the local presentation the reverse balance rules differ by account and the lettered line structure needs many nodes in a financial statement version. The mapping table is one list the accounting team can maintain easily. An initial mapping can be generated from the existing financial statement version.

Does it produce consolidated statements?

No. The report works per company code; when several company codes are selected their total can be shown, but intercompany eliminations are not made.

Related reports

FI Report Custom ALV report TR

Inventory Book (Envanter Defteri) Report and Print

A custom ALV report and print output that prepares the year-end inventory book from SAP account by account. The closing balance of every balance sheet …

FAGLFLEXT · ACDOCA · SKAT · BSID

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: Balance Sheet and Income Statement in Turkish Format