Türkiye Cheque and Promissory Note Portfolio, Risk and Maturity Report
Short answer: A custom ALV report that lists cheques and promissory notes received from customers with number, drawer, bank, due date and current position (in portfolio, at bank for collection, pledged, endorsed, dishonoured). For each customer, the open account balance and the not-yet-due cheques and notes are added up into a total risk; maturity buckets are ready for daily cash planning.
- Estimated effort
- M · 6–9 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- TR
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
FBL5N lists cheques and notes as special G/L items but does not show cheque number, drawer and bank together with the position, and does not add up the risk of endorsed or bank-held instruments per customer. F-36 is a posting transaction only. The report gives the portfolio in one list with position, maturity bucket and customer risk.
Who uses it? Finance and treasury teams, collections and credit control teams, accounting teams.
Closest standard alternatives
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: The negotiable instrument (cheque and promissory note) provisions of Turkish Commercial Code No. 6102 and Cheque Law No. 5941.
Portfolio positions (in portfolio, at bank for collection, pledged, endorsed, dishonoured) are mapped to the company's special G/L indicators and chart of accounts 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 |
|---|---|---|---|
| BSIDCustomer Open Items | Open cheque and note items: customer, amount, due date (driving table) | — | ECC + S/4 |
| BSADCustomer Cleared Items | Instruments open on the key date and cleared later | BSAD-BUKRS = BSID-BUKRS AND BSAD-KUNNR = BSID-KUNNR | ECC + S/4 |
| BSEDBill of Exchange Fields Document Segment | Cheque/note number, drawer, bank, place of issue and status | BSED-BUKRS = BSID-BUKRS AND BSED-BELNR = BSID-BELNR AND BSED-GJAHR = BSID-GJAHR AND BSED-BUZEI = BSID-BUZEI | ECC + S/4 |
| BKPFAccounting Document Header | Document type and posting date | BKPF-BUKRS = BSID-BUKRS AND BKPF-BELNR = BSID-BELNR AND BKPF-GJAHR = BSID-GJAHR | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = BSID-KUNNR | ECC + S/4 |
| T012House Banks | House bank of instruments given for collection or as collateral | T012-BUKRS = BSID-BUKRS | ECC + S/4 |
S/4HANA notes
- 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.
- BSAD → I_OperationalAcctgDocItem: In S/4HANA BSAD is not filled as a separate table; it is read through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BSID-BUKRS | Yes | 1000 |
| P_KEYDT | Key date | Single value | — | Yes | 17.11.2026 |
| S_KUNNR | Customer | Range / multiple | BSID-KUNNR | No | 200000 – 299999 |
| S_UMSKZ | Cheque/note special G/L indicators | Range / multiple | BSID-UMSKZ | Yes | W, D |
| S_ZFBDT | Due date | Range / multiple | BSID-ZFBDT | No | 01.11.2026 – 31.03.2027 |
| S_HBKID | House bank | Range / multiple | T012-HBKID | No | AKB01 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Customer | BSID-KUNNR |
| 2 | Customer name | KNA1-NAME1 |
| 3 | Instrument type | Calculated Cheque or promissory note according to the special G/L indicator |
| 4 | Instrument number | BSED-BOENO |
| 5 | Drawer | BSED-WNAME |
| 6 | Bank | BSED-WBANK |
| 7 | Due date | BSID-ZFBDT |
| 8 | Amount | BSID-WRBTR |
| 9 | Currency | BSID-WAERS |
| 10 | Position | Calculated In portfolio, at bank for collection, pledged, endorsed or dishonoured |
| 11 | Days to maturity | Calculated Due date − key date |
| 12 | Customer total risk | Calculated Open account balance + not-yet-due instruments in portfolio, at bank and endorsed |
Sample output
| Customer | Customer name | Instrument type | Instrument number | Drawer | Bank | Due date | Amount | Currency | Position | Days to maturity | Customer total risk |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 200150 | Örnek Tekstil A.Ş. | Cheque | 0045821 | Örnek Tekstil A.Ş. | Örnek Bank Merkez Şb. | 12/15/2026 | 250,000 | TRY | At bank for collection | 28 | 1,185,000 |
| 200150 | Örnek Tekstil A.Ş. | Cheque | 0045822 | Mavi Konfeksiyon Ltd. | Demo Katılım Bankası | 01/31/2027 | 180,000 | TRY | Endorsed | 75 | 1,185,000 |
| 200388 | Demo Retail Ltd. | Promissory note | S-2026-118 | Demo Retail Ltd. | 11/10/2026 | 95,000 | TRY | In portfolio (overdue) | -7 | 412,000 |
How does the report work?
- Open items with the cheque and note special G/L indicators are read from BSID for the selected company code and key date; BSAD is also read for items that were open on the key date and cleared later.
- Instrument data (cheque/note number, drawer, bank, place of issue, status) comes from BSED by item key; the document header comes from BKPF.
- The position is determined from the item’s special G/L indicator and the related endorsement or collection posting: in portfolio, at bank for collection, pledged, endorsed or dishonoured. For instruments given to a bank, the bank is shown from the house bank definition in T012.
- Days to maturity = due date − key date; rows are put into 0-30, 31-60, 61-90 and 90+ day buckets, and overdue instruments are flagged separately.
- Customer risk = open account balance + total of not-yet-due instruments in portfolio, at bank and endorsed. The customer name comes from KNA1.
- The result is shown in an ALV with subtotals per customer and maturity.
Performance notes
Limit BSID and BSAD by company code and special G/L indicator; read BSED in bulk by item key. Calculate the customer risk total in one pass.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document From a row you can jump to the cheque/note document and the customer items.
- Export to Excel
- Runs as a background job The daily portfolio list can be prepared in the background in the morning and e-mailed to the finance team.
Authorization objects
- F_BKPF_BUKDocument display authorization by company code
- F_KNA1_BUKCustomer data display authorization by company code
Frequently asked questions
Why does an endorsed cheque stay in the customer risk?
If an endorsed cheque is not paid at maturity, it comes back to the company and must be collected from the customer. It is therefore kept in the risk total until its due date; once the date passes without a dishonour notice, it drops out of the risk.
Are foreign currency cheques included?
Yes. Each instrument is shown in its document currency; the local currency amount is used for the risk total. If needed, an amount revalued at the key-date rate can be added as an extra column.
Does it work on S/4HANA?
Yes. BSID and BSAD can be read as compatibility views on S/4HANA and BSED keeps the same structure. If clean core is preferred, open items can be read from released accounting CDS views.
Related reports
Unmatched Bank Statement Items on Clearing Accounts Report
A custom ALV report that lists electronic or manual bank statement items that were never posted, or were posted to a bank clearing account and are …
Customer Payment Behavior and Days-to-Pay Report
A custom ALV report that uses customer invoices cleared in the selected period to calculate each customer's average days to pay, amount-weighted days …
Customer Receivables Aging Report
A custom ALV report that ages customer open items by net due date and shows down payments received and other special G/L items in the same list. …
Credit-Blocked Sales Orders by Value and Age Report
A custom ALV report that groups credit-blocked sales orders per credit account and shows the blocked order value, the age of the oldest block, the …
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.