# Türkiye Cheque and Promissory Note Portfolio, Risk and Maturity Report

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

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: M (6–9 working days)
- Localization: TR
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/turkey-cheque-promissory-note-portfolio-risk-report/


## Localization and legal basis: Türkiye

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

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

### Closest standard alternatives

- FBL5N: Lists cheques and notes as special G/L items; position, drawer and customer risk are not shown together.
- F-36: Posts the bill of exchange payment; gives no portfolio or maturity report.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| BSID | Open cheque and note items: customer, amount, due date (driving table) | Read | - | ECC + S/4 |
| BSAD | Instruments open on the key date and cleared later | Read | BSAD-BUKRS = BSID-BUKRS AND BSAD-KUNNR = BSID-KUNNR | ECC + S/4 |
| BSED | Cheque/note number, drawer, bank, place of issue and status | Read | BSED-BUKRS = BSID-BUKRS AND BSED-BELNR = BSID-BELNR AND BSED-GJAHR = BSID-GJAHR AND BSED-BUZEI = BSID-BUZEI | ECC + S/4 |
| BKPF | Document type and posting date | Read | BKPF-BUKRS = BSID-BUKRS AND BKPF-BELNR = BSID-BELNR AND BKPF-GJAHR = BSID-GJAHR | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = BSID-KUNNR | ECC + S/4 |
| T012 | House bank of instruments given for collection or as collateral | Read | T012-BUKRS = BSID-BUKRS | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BSID-BUKRS | Yes |
| P_KEYDT | Key date | Single value | - | Yes |
| S_KUNNR | Customer | Range / multiple | BSID-KUNNR | No |
| S_UMSKZ | Cheque/note special G/L indicators | Range / multiple | BSID-UMSKZ | Yes |
| S_ZFBDT | Due date | Range / multiple | BSID-ZFBDT | No |
| S_HBKID | House bank | Range / multiple | T012-HBKID | No |

## Output columns

| Column | Source |
|---|---|
| Customer | BSID-KUNNR |
| Customer name | KNA1-NAME1 |
| Instrument type | Calculated: Cheque or promissory note according to the special G/L indicator |
| Instrument number | BSED-BOENO |
| Drawer | BSED-WNAME |
| Bank | BSED-WBANK |
| Due date | BSID-ZFBDT |
| Amount | BSID-WRBTR |
| Currency | BSID-WAERS |
| Position | Calculated: In portfolio, at bank for collection, pledged, endorsed or dishonoured |
| Days to maturity | Calculated: Due date − key date |
| Customer total risk | Calculated: Open account balance + not-yet-due instruments in portfolio, at bank and endorsed |

## How does the report work?

1. 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.
2. Instrument data (cheque/note number, drawer, bank, place of issue, status) comes from BSED by item key; the document header comes from BKPF.
3. 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.
4. 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.
5. Customer risk = open account balance + total of not-yet-due instruments in portfolio, at bank and endorsed. The customer name comes from KNA1.
6. The result is shown in an ALV with subtotals per customer and maturity.

## Authorization objects

- F_BKPF_BUK: Document display authorization by company code
- F_KNA1_BUK: Customer 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.

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