# Bank Credit Limit and Risk Report (Cash and Non-Cash)

> An ALV report that shows for each bank the cash and non-cash credit limits, the cash credit used, non-cash risk such as letters of guarantee and letters of credit, customer cheques given to the bank as collateral and the remaining limit, in one list as of a key date. Risk and collateral are converted to local currency; banks with high limit usage are flagged.

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: M (7–10 working days)
- Last updated: 2026-11-18
- URL: https://nekuhub.com/en/reports/bank-credit-limit-and-risk-report-cash-and-non-cash/


## Why is the standard not enough?

Credit balances sit on credit accounts in FI, letters of guarantee on statistical items with a special G/L indicator, and cheques given as collateral on customer cheque items. Limit management in Treasury is not implemented in most companies and does not show the cash/non-cash limit and collateral cheque split used in Turkish banking in this form. Total risk and remaining limit per bank are therefore combined in Excel every week.

### Closest standard alternatives

- FBL3N: Lists credit account items; no limits or non-cash risk.
- FBL5N: Shows cheques held as collateral and letter of guarantee items; no total risk per bank.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| T012 | House banks (bank the limit belongs to) | Read | - | ECC + S/4 |
| BNKA | Bank name | Read | BNKA-BANKS = T012-BANKS AND BNKA-BANKL = T012-BANKL | ECC + S/4 |
| T012K | Bank accounts and their G/L accounts | Read | T012K-BUKRS = T012-BUKRS AND T012K-HBKID = T012-HBKID | ECC + S/4 |
| ACDOCA | In S/4HANA the key-date balance of credit accounts | Read | ACDOCA-RBUKRS = T012-BUKRS AND ACDOCA-RACCT IN kredi hesapları | ECC + S/4 |
| BSIS | In ECC the open items of credit accounts | Read | BSIS-BUKRS = T012-BUKRS AND BSIS-HKONT IN kredi hesapları | ECC + S/4 |
| BSID | Letter of guarantee statistical items and customer cheques held as collateral | Read | BSID-BUKRS = T012-BUKRS AND BSID-UMSKZ IN teminat göstergeleri | ECC + S/4 |
| BSIK | Non-cash items on the vendor side (letters of credit, etc.) | Read | BSIK-BUKRS = T012-BUKRS AND BSIK-UMSKZ IN gayrinakdi göstergeler | ECC + S/4 |
| BSED | Collateral cheque details: cheque number, drawer, due date | Read | BSED-BUKRS = BSID-BUKRS AND BSED-BELNR = BSID-BELNR AND BSED-GJAHR = BSID-GJAHR AND BSED-BUZEI = BSID-BUZEI | ECC + S/4 |
| TCURR | Key-date exchange rates | Read | TCURR-KURST = P_KURST | ECC + S/4 |

## BAPIs and functions used

- CONVERT_TO_LOCAL_CURRENCY: Converts foreign currency risk and limits to local currency
- REUSE_ALV_GRID_DISPLAY: Shows the result in an ALV with subtotals

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | T012-BUKRS | Yes |
| P_KEYDT | Key date | Single value | - | Yes |
| S_HBKID | House bank | Range / multiple | T012-HBKID | No |
| P_KURST | Rate type | Single value | TCURR-KURST | No |
| P_DETL | Limit type detail | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Bank | BNKA-BANKA |
| Limit type | Calculated: Cash, letter of guarantee, letter of credit or other non-cash |
| Limit (TRY) | Calculated: Amount in the limit table at the key-date rate |
| Risk used (TRY) | Calculated: Credit balance or total of open letters of guarantee/credit |
| Remaining limit (TRY) | Calculated: Limit − risk used |
| Usage % | Calculated: Risk used / limit × 100 |
| Collateral cheques (TRY) | Calculated: Total of not-yet-due customer cheques held by the bank as collateral |
| Collateral ratio % | Calculated: Collateral cheques / cash risk × 100 |

## How does the report work?

1. Limits are read from the limit table defined during installation: bank (house bank T012), limit type (cash, non-cash letter of guarantee, letter of credit, credit card, etc.), limit amount, currency and validity date. The bank name comes from BNKA.
2. Cash risk: the open balance on the credit accounts as of the key date, with the credit number in the assignment field, is read (ACDOCA in S/4HANA, BSIS in ECC); the account-to-bank mapping comes from T012K and the account assignment.
3. Non-cash risk: open statistical items with the special G/L indicators for letters of guarantee and letters of credit (BSID/BSIK, BSEG-HBKID = bank) are read.
4. Collateral cheques: customer cheques given to the bank as collateral are read from BSID with the related special G/L indicator, and cheque details (cheque number, drawer, due date) from BSED; overdue and collected cheques drop out of the collateral.
5. Foreign currency amounts are converted to local currency with the selected rate type on the key date (TCURR).
6. Remaining limit = limit − risk used; usage ratio = risk / limit. Banks above the thresholds set during installation are highlighted. The collateral cheque total is compared with the cash risk and shown as a collateral ratio.
7. The ALV has subtotals per bank and limit type; from a row you can jump to the credit items, letters of guarantee or the cheque list.

## Authorization objects

- F_BKPF_BUK: Document display authorization by company code
- F_BNKA_BUK: Authorization to display bank data

## Frequently asked questions

### Where are the limits kept?

Limits per bank and limit type are kept in a small maintenance table created during installation, with a validity date. When the bank sends a new limit letter, a new row is entered; past limits are selected by key date in the report.

### Can the report be used if Treasury is implemented?

Yes. If credit and guarantee data come from Treasury transactions, the data source is set up for those transactions during installation; the report still gives the same cash/non-cash view and the collateral cheque comparison.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=fi-bank-limit-risk
