CO Report Custom development ALV report TR · Türkiye

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

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 and carryforward balance (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)Validating account ranges in the chart of accountsSKA1-SAKNR = FAGLFLEXT-RACCTECC + S/4
SKATG/L Account DescriptionsAccount names in the detail viewSKAT-SAKNR = SKA1-SAKNRECC + S/4
T001Company CodesCompany name, currency and chart of accountsT001-BUKRS = FAGLFLEXT-RBUKRSECC + S/4
MBEWHMaterial Valuation: HistoryPeriod-end stock values for controlMBEWH-LFGJA = mali yıl AND MBEWH-LFMON = dönemECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
P_BUKRSCompany codeSingle valueT001-BUKRSYes1000
P_GJAHRFiscal yearSingle valueBKPF-GJAHRYes2026
S_MONATPeriod rangeRange / multipleBKPF-MONATYes01 – 09
P_PREVShow the same period of the prior yearCheckbox—NoX
P_RLDNRLedgerSingle valueFAGLFLEXT-RLDNRNo0L

Output columns

#ColumnSource
1Line codeCalculated Statement line from the mapping table (A, B, C …)
2Line descriptionCalculated Statutory name of the statement line
3Account rangeCalculated Accounts assigned to the line
4Current periodCalculated Sum of balances in the selected periods or subtotal formula
5Prior periodCalculated Same period range of the prior year
6Change %Calculated (Current − prior) / prior × 100

Sample output

Line codeLine descriptionAccount rangeCurrent periodPrior periodChange %
ADirect Materials710–71118,450,00015,120,00022
ECost of Goods ManufacturedA+B+C±D31,280,00026,340,00018.80
GCost of Finished Goods SoldE±F29,960,00025,110,00019.30
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. 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.
  4. For control, stock lines can be compared with the period-end stock values in MBEWH.
  5. The same period of the prior year is calculated in a side column with the change amount and percentage.
  6. 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

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: Cost of Goods Manufactured and Cost of Sales Statement (Turkey)