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
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: The provisions on commercial books of the Turkish Commercial Code No. 6102 and the inventory and valuation provisions of the Tax Procedure Law No. 213.
The layout, certification and retention rules of the inventory book are checked against current regulation 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 |
|---|---|---|---|
| FAGLFLEXTNew General Ledger: Totals | Year-end balances of balance sheet accounts (driving table) | — | ECC + S/4 |
| ACDOCAUniversal Journal Entry Line Items | Universal journal used for balances on S/4HANA | — | ECC + S/4 |
| SKATG/L Account Descriptions | Account names | SKAT-SAKNR = FAGLFLEXT-RACCT | ECC + S/4 |
| BSIDCustomer Open Items | Open items per customer | BSID-HKONT = FAGLFLEXT-RACCT | ECC + S/4 |
| BSIKVendor Open Items | Open items per vendor | BSIK-HKONT = FAGLFLEXT-RACCT | ECC + S/4 |
| BSISG/L Account Open Items (Secondary Index) | Items of other open item managed G/L accounts | BSIS-HKONT = FAGLFLEXT-RACCT | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = BSID-KUNNR | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = BSIK-LIFNR | ECC + S/4 |
| MBEWHMaterial Valuation: History | Year-end stock quantity and value per material | — | ECC + S/4 |
| ANLAAsset Master Record | Fixed asset master | — | ECC + S/4 |
| ANLCAsset Value Fields | Acquisition cost and accumulated depreciation per asset | ANLC-ANLN1 = ANLA-ANLN1 | 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.
- 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
| 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 |
| P_KEYDT | Key date | Single value | BKPF-BUDAT | Yes | 31.12.2026 |
| S_RACCT | Account range | Range / multiple | FAGLFLEXT-RACCT | No | 100 – 599 |
| P_PDF | Page-numbered PDF output | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Account | FAGLFLEXT-RACCT |
| 2 | Account name | SKAT-TXT50 |
| 3 | Detail | Calculated Customer, vendor, material or asset number and name |
| 4 | Quantity | Calculated MBEWH-LBKUM for stock lines |
| 5 | Debit | Calculated Debit balance of the detail line |
| 6 | Credit | Calculated Credit balance of the detail line |
| 7 | Check | Calculated Empty if detail total = account balance, otherwise the difference |
Sample output
| Account | Account name | Detail | Quantity | Debit | Credit | Check |
|---|---|---|---|---|---|---|
| 120.01 | Trade Receivables - Domestic | Örnek Yapı Market A.Ş. | 1,245,600 | 0 | ||
| 153.01 | Merchandise | TM-4410 Ceramic tile 60x60 | 18,400 | 2,116,000 | 0 | |
| 320.01 | Trade Payables - Domestic | Demo Lojistik Ltd. | 0 | 386,250 |
How does the report work?
- 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.
- 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.
- For stock accounts, year-end quantity and value per material are read from MBEWH.
- For fixed asset accounts, acquisition cost and accumulated depreciation per asset come from ANLA and ANLC.
- The detail total of each account is compared with the account balance; if they differ, a warning line is printed under the account.
- 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
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 …
Türkiye Inflation Accounting Adjustment Program (Inventory, Fixed Assets and Non-Monetary Items)
A custom background program that adjusts non-monetary balance sheet items (fixed assets and their accumulated depreciation, inventory, equity and …
Türkiye Legal Journal and General Ledger (Defter-i Kebir) Printout Report
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 …
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.