FI Report Custom development ALV report TR · Türkiye

Inventory Book (Envanter Defteri) Report and Print

Short answer: 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 account is listed with details: open items per customer and vendor for receivables and payables, quantity and value per material for stock accounts, and cost and accumulated depreciation per asset for fixed assets, with page numbers and a balance sheet summary at the end.

Estimated effort
L · 10–15 working days
System
ECC and S/4HANA
Tables
11
Scope
TR
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

SAP provides journal and general ledger prints as statutory books, but no local output for the inventory book. Account balances come from S_ALR_87012284, customer and vendor details from S_ALR_87012172 and FBL1N, stock from MB5B and fixed assets from AR01, each run separately and combined in Excel; page numbering and consistency checks are manual.

Who uses it? General ledger teams, financial advisors, and teams preparing year-end closing and audits.

Closest standard alternatives

  • S_ALR_87012284 Financial Statements. Gives account balances in financial statement layout; no customer, stock and asset details or inventory book layout.
  • AR01 Asset Balances List. Lists fixed assets; not printed together with the other balance sheet accounts as one book.
  • MB5B Stocks for Posting Date. Gives stock quantity and value at a date; not linked to the inventory book.

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: TotalsYear-end balances of balance sheet accounts (driving table)—ECC + S/4
ACDOCAUniversal Journal Entry Line ItemsUniversal journal used for balances on S/4HANA—ECC + S/4
SKATG/L Account DescriptionsAccount namesSKAT-SAKNR = FAGLFLEXT-RACCTECC + S/4
BSIDCustomer Open ItemsOpen items per customerBSID-HKONT = FAGLFLEXT-RACCTECC + S/4
BSIKVendor Open ItemsOpen items per vendorBSIK-HKONT = FAGLFLEXT-RACCTECC + S/4
BSISG/L Account Open Items (Secondary Index)Items of other open item managed G/L accountsBSIS-HKONT = FAGLFLEXT-RACCTECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = BSID-KUNNRECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = BSIK-LIFNRECC + S/4
MBEWHMaterial Valuation: HistoryYear-end stock quantity and value per material—ECC + S/4
ANLAAsset Master RecordFixed asset master—ECC + S/4
ANLCAsset Value FieldsAcquisition cost and accumulated depreciation per assetANLC-ANLN1 = ANLA-ANLN1ECC + 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.
  • BSID → I_OperationalAcctgDocItem: In S/4HANA BSID is no longer filled as a separate index table; reads work through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
  • BSIK: In S/4HANA BSIK is no longer filled as a separate index table; reads work through a compatibility view. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
  • BSIS → ACDOCA: In S/4HANA BSIS is no longer filled as a separate index table; it is read through a compatibility view of the same name. New developments should use ACDOCA or the related CDS views.
  • 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.
  • ANLC → ACDOCA: In S/4HANA new asset accounting the actual values are kept in ACDOCA; ANLC is only read through the compatibility view FAAV_ANLC.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_BUKRSCompany codeSingle valueT001-BUKRSYes1000
P_GJAHRFiscal yearSingle valueBKPF-GJAHRYes2026
P_KEYDTKey dateSingle valueBKPF-BUDATYes31.12.2026
S_RACCTAccount rangeRange / multipleFAGLFLEXT-RACCTNo100 – 599
P_PDFPage-numbered PDF outputCheckbox—NoX

Output columns

#ColumnSource
1AccountFAGLFLEXT-RACCT
2Account nameSKAT-TXT50
3DetailCalculated Customer, vendor, material or asset number and name
4QuantityCalculated MBEWH-LBKUM for stock lines
5DebitCalculated Debit balance of the detail line
6CreditCalculated Credit balance of the detail line
7CheckCalculated Empty if detail total = account balance, otherwise the difference

Sample output

AccountAccount nameDetailQuantityDebitCreditCheck
120.01Trade Receivables - DomesticÖrnek Yapı Market A.Ş.1,245,6000
153.01MerchandiseTM-4410 Ceramic tile 60x6018,4002,116,0000
320.01Trade Payables - DomesticDemo Lojistik Ltd.0386,250
A view built with fictional sample data; not real system data.

How does the report work?

  1. Closing balances of balance sheet accounts are read from FAGLFLEXT (ACDOCA on S/4HANA) for the selected company code and year; account names come from SKAT.
  2. A mapping defines the detail source for each account: open items per customer from BSID (with names from KNA1) for receivable accounts, open items per vendor from BSIK (with names from LFA1) for payable accounts, and BSIS for other open item managed accounts.
  3. For stock accounts, year-end quantity and value per material are read from MBEWH.
  4. For fixed asset accounts, acquisition cost and accumulated depreciation per asset come from ANLA and ANLC.
  5. The detail total of each account is compared with the account balance; if they differ, a warning line is printed under the account.
  6. The output is printed to PDF in account order, with page numbers and carry-forward totals at each page break, followed by a balance sheet summary.

Performance notes

Read balances in bulk and read detail sources only for accounts defined in the mapping. Aggregate open items per customer/vendor at key date in the database. For large company codes, run the print in the background.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Export to Excel
  • Runs as a background job For large company codes the PDF print is produced in the background.

Authorization objects

  • F_BKPF_BUKAccounting data display authorization by company code
  • F_KNA1_BUKCustomer data display by company code
  • F_LFA1_BUKVendor data display by company code
  • A_A_VIEWFixed asset data display authorization

Frequently asked questions

Is the inventory book part of e-Ledger?

No. e-Ledger covers the journal and the general ledger; the inventory book is kept separately. The report produces its content from SAP data; certification and retention follow current regulation as decided by the company.

How are inflation-adjusted amounts shown?

If adjustment postings were made to the G/L accounts, balances come in adjusted. If the adjustment is kept in a separate ledger, that ledger is selected with the ledger parameter.

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: Inventory Book (Envanter Defteri) Report and Print