Cost of Goods Manufactured and Cost of Sales Statement (Turkey)
Short answer: A custom ALV report that prepares the cost of sales statement of the Turkish financial statement schedules directly from SAP G/L balances. It starts from direct materials, direct labour and production overhead, applies the changes in work in process and finished goods to reach the cost of goods manufactured, and from there the cost of finished goods, merchandise and services sold; current and prior period are shown side by side, ready for Excel.
- Estimated effort
- M · 5–8 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- TR
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
S_ALR_87012284 and F.01 produce the balance sheet and income statement by financial statement version, but they do not calculate the opening/closing stock lines and subtotals of the cost of sales statement. KE30 offers profitability analysis, not the statutory layout. The statement is therefore compiled by hand in Excel from the trial balance every period.
Who uses it? Finance managers, general ledger and cost accounting teams, and teams preparing for the external audit.
Closest standard alternatives
- S_ALR_87012284 Financial Statements. Produces balance sheet and income statement by financial statement version; does not calculate the stock change lines of the cost of sales statement.
- KE30 Execute Profitability Report. Offers profitability analysis reports; no statutory layout or opening/closing stock lines.
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: The cost of sales statement among the financial statement schedules set by the General Communiqués on the Accounting System.
The account ranges of the statement lines are defined for the company's chart of accounts during installation and checked against the statement layout in current regulation.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| FAGLFLEXTNew General Ledger: Totals | G/L period balances and carryforward balance (driving table) | — | ECC + S/4 |
| ACDOCAUniversal Journal Entry Line Items | Universal journal used for balances on S/4HANA | — | ECC + S/4 |
| SKA1G/L Account Master (Chart of Accounts) | Validating account ranges in the chart of accounts | SKA1-SAKNR = FAGLFLEXT-RACCT | ECC + S/4 |
| SKATG/L Account Descriptions | Account names in the detail view | SKAT-SAKNR = SKA1-SAKNR | ECC + S/4 |
| T001Company Codes | Company name, currency and chart of accounts | T001-BUKRS = FAGLFLEXT-RBUKRS | ECC + S/4 |
| MBEWHMaterial Valuation: History | Period-end stock values for control | MBEWH-LFGJA = mali yıl AND MBEWH-LFMON = dönem | 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.
- MBEWH: In S/4HANA MBEWH is read through the compatibility view MBVMBEWH; the history values are no longer persisted in a separate table. Reading code keeps working, but nothing should write to the table directly.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_BUKRS | Company code | Single value | T001-BUKRS | Yes | 1000 |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes | 2026 |
| S_MONAT | Period range | Range / multiple | BKPF-MONAT | Yes | 01 – 09 |
| P_PREV | Show the same period of the prior year | Checkbox | — | No | X |
| P_RLDNR | Ledger | Single value | FAGLFLEXT-RLDNR | No | 0L |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Line code | Calculated Statement line from the mapping table (A, B, C …) |
| 2 | Line description | Calculated Statutory name of the statement line |
| 3 | Account range | Calculated Accounts assigned to the line |
| 4 | Current period | Calculated Sum of balances in the selected periods or subtotal formula |
| 5 | Prior period | Calculated Same period range of the prior year |
| 6 | Change % | Calculated (Current − prior) / prior × 100 |
Sample output
| Line code | Line description | Account range | Current period | Prior period | Change % |
|---|---|---|---|---|---|
| A | Direct Materials | 710–711 | 18,450,000 | 15,120,000 | 22 |
| E | Cost of Goods Manufactured | A+B+C±D | 31,280,000 | 26,340,000 | 18.80 |
| G | Cost of Finished Goods Sold | E±F | 29,960,000 | 25,110,000 | 19.30 |
How does the report work?
- Statement lines are defined with account ranges in a mapping table: A. Direct materials (710–711), B. Direct labour (720–721), C. Production overhead (730–731), D. Change in work in process (151 opening and closing), E. Cost of goods manufactured, F. Change in finished goods (152), G. Cost of finished goods sold, H. Cost of merchandise sold (153 and purchases), I. Cost of services sold (622) and cost of other sales.
- Account balances are read from FAGLFLEXT (ACDOCA on S/4HANA) for the selected company code, year and period range; opening stock lines use the carryforward balance (HSLVT) plus earlier periods.
- Subtotals are calculated with defined formulas; the cost of goods manufactured and cost of goods sold are compared with the balance of accounts 620–622 and any difference is shown on a separate line.
- For control, stock lines can be compared with the period-end stock values in MBEWH.
- The same period of the prior year is calculated in a side column with the change amount and percentage.
- From a line you can drill down to the balances and line items of the accounts behind it.
Performance notes
Read balances from FAGLFLEXT or ACDOCA by account range, aggregated in the database; read line items only on drilldown. 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 From a line you can drill down to account balances and line items.
- Export to Excel The statement is exported to Excel in a layout ready for the financial statement notes.
Authorization objects
- F_BKPF_BUKAccounting data display authorization by company code
- F_FAGL_LDRDisplay authorization by ledger
Frequently asked questions
Does it work for companies using 7/B?
Yes. Under 7/B production costs are tracked by nature in group 7, so the account ranges of the lines are defined differently; the statement layout and subtotal logic stay the same.
What if the cost of finished goods sold does not match account 620?
The report compares the calculated amount with the balance of account 620 and shows the difference on a separate control line. A difference usually points to a missing cost closing entry or a direct posting to a stock account.
Related reports
Production Order Target vs Actual Cost Variance Report
A custom ALV report that compares the actual cost of production orders in a plant with the target cost from delivered quantity × standard price, and …
Month-End Closing of Turkish 7/A Cost Accounts via Reflection Accounts
A custom closing program for companies using the 7/A option of the Turkish Uniform Chart of Accounts: it reads the month-end balances of the 7-group …
Balance Sheet and Income Statement in Turkish Format
A custom ALV report that produces the balance sheet and income statement from SAP in the Turkish Uniform Chart of Accounts structure, with …
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.