# 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 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.

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: L (10–15 working days)
- Localization: TR
- Last updated: 2026-11-18
- URL: https://nekuhub.com/en/reports/turkey-inventory-book-envanter-defteri-report/


## Localization and legal basis: Türkiye

- 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.

## 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.

### Closest standard alternatives

- S_ALR_87012284: Gives account balances in financial statement layout; no customer, stock and asset details or inventory book layout.
- AR01: Lists fixed assets; not printed together with the other balance sheet accounts as one book.
- MB5B: Gives stock quantity and value at a date; not linked to the inventory book.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| FAGLFLEXT | Year-end balances of balance sheet accounts (driving table) | Read | - | ECC + S/4 |
| ACDOCA | Universal journal used for balances on S/4HANA | Read | - | ECC + S/4 |
| SKAT | Account names | Read | SKAT-SAKNR = FAGLFLEXT-RACCT | ECC + S/4 |
| BSID | Open items per customer | Read | BSID-HKONT = FAGLFLEXT-RACCT | ECC + S/4 |
| BSIK | Open items per vendor | Read | BSIK-HKONT = FAGLFLEXT-RACCT | ECC + S/4 |
| BSIS | Items of other open item managed G/L accounts | Read | BSIS-HKONT = FAGLFLEXT-RACCT | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = BSID-KUNNR | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = BSIK-LIFNR | ECC + S/4 |
| MBEWH | Year-end stock quantity and value per material | Read | - | ECC + S/4 |
| ANLA | Fixed asset master | Read | - | ECC + S/4 |
| ANLC | Acquisition cost and accumulated depreciation per asset | Read | ANLC-ANLN1 = ANLA-ANLN1 | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_BUKRS | Company code | Single value | T001-BUKRS | Yes |
| P_GJAHR | Fiscal year | Single value | BKPF-GJAHR | Yes |
| P_KEYDT | Key date | Single value | BKPF-BUDAT | Yes |
| S_RACCT | Account range | Range / multiple | FAGLFLEXT-RACCT | No |
| P_PDF | Page-numbered PDF output | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Account | FAGLFLEXT-RACCT |
| Account name | SKAT-TXT50 |
| Detail | Calculated: Customer, vendor, material or asset number and name |
| Quantity | Calculated: MBEWH-LBKUM for stock lines |
| Debit | Calculated: Debit balance of the detail line |
| Credit | Calculated: Credit balance of the detail line |
| Check | Calculated: Empty if detail total = account balance, otherwise the difference |

## 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.

## Authorization objects

- F_BKPF_BUK: Accounting data display authorization by company code
- F_KNA1_BUK: Customer data display by company code
- F_LFA1_BUK: Vendor data display by company code
- A_A_VIEW: Fixed 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=tr-inventory-book
