Bank Credit Limit and Risk Report (Cash and Non-Cash)
Short answer: 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.
- Estimated effort
- M · 7–10 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Finance managers, treasury teams and managers who negotiate limits with banks.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| T012House Banks | House banks (bank the limit belongs to) | — | ECC + S/4 |
| BNKABank Master Data | Bank name | BNKA-BANKS = T012-BANKS AND BNKA-BANKL = T012-BANKL | ECC + S/4 |
| T012KHouse Bank Accounts | Bank accounts and their G/L accounts | T012K-BUKRS = T012-BUKRS AND T012K-HBKID = T012-HBKID | ECC + S/4 |
| ACDOCAUniversal Journal Entry Line Items | In S/4HANA the key-date balance of credit accounts | ACDOCA-RBUKRS = T012-BUKRS AND ACDOCA-RACCT IN kredi hesapları | ECC + S/4 |
| BSISG/L Account Open Items (Secondary Index) | In ECC the open items of credit accounts | BSIS-BUKRS = T012-BUKRS AND BSIS-HKONT IN kredi hesapları | ECC + S/4 |
| BSIDCustomer Open Items | Letter of guarantee statistical items and customer cheques held as collateral | BSID-BUKRS = T012-BUKRS AND BSID-UMSKZ IN teminat göstergeleri | ECC + S/4 |
| BSIKVendor Open Items | Non-cash items on the vendor side (letters of credit, etc.) | BSIK-BUKRS = T012-BUKRS AND BSIK-UMSKZ IN gayrinakdi göstergeler | ECC + S/4 |
| BSEDBill of Exchange Fields Document Segment | Collateral cheque details: cheque number, drawer, due date | BSED-BUKRS = BSID-BUKRS AND BSED-BELNR = BSID-BELNR AND BSED-GJAHR = BSID-GJAHR AND BSED-BUZEI = BSID-BUZEI | ECC + S/4 |
| TCURRExchange Rates | Key-date exchange rates | TCURR-KURST = P_KURST | ECC + S/4 |
S/4HANA notes
- T012K: In S/4HANA reads of T012K go through the compatibility view V_T012K_BAM; bank accounts are maintained in Bank Account Management (BAM).
- 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.
- 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.
BAPIs and functions used
- CONVERT_TO_LOCAL_CURRENCYTranslate Foreign Currency Amount to Local Currency. Converts foreign currency risk and limits to local currency
- REUSE_ALV_GRID_DISPLAYSimple List Output (ALV Grid). Shows the result in an ALV with subtotals
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | T012-BUKRS | Yes | 1000 |
| P_KEYDT | Key date | Single value | — | Yes | 18.11.2026 |
| S_HBKID | House bank | Range / multiple | T012-HBKID | No | — |
| P_KURST | Rate type | Single value | TCURR-KURST | No | M |
| P_DETL | Limit type detail | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Bank | BNKA-BANKA |
| 2 | Limit type | Calculated Cash, letter of guarantee, letter of credit or other non-cash |
| 3 | Limit (TRY) | Calculated Amount in the limit table at the key-date rate |
| 4 | Risk used (TRY) | Calculated Credit balance or total of open letters of guarantee/credit |
| 5 | Remaining limit (TRY) | Calculated Limit − risk used |
| 6 | Usage % | Calculated Risk used / limit × 100 |
| 7 | Collateral cheques (TRY) | Calculated Total of not-yet-due customer cheques held by the bank as collateral |
| 8 | Collateral ratio % | Calculated Collateral cheques / cash risk × 100 |
Sample output
| Bank | Limit type | Limit (TRY) | Risk used (TRY) | Remaining limit (TRY) | Usage % | Collateral cheques (TRY) | Collateral ratio % |
|---|---|---|---|---|---|---|---|
| Demo Bank A.Ş. | Cash | 50,000,000 | 41,250,000 | 8,750,000 | 82.50 | 18,400,000 | 44.60 |
| Demo Bank A.Ş. | Letter of guarantee | 20,000,000 | 12,600,000 | 7,400,000 | 63 | 0 | 0 |
| Örnek Katılım Bankası | Cash | 30,000,000 | 9,800,000 | 20,200,000 | 32.70 | 6,100,000 | 62.20 |
How does the report work?
- 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.
- 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.
- 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.
- 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.
- Foreign currency amounts are converted to local currency with the selected rate type on the key date (TCURR).
- 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.
- 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.
Performance notes
Take credit accounts and special G/L indicators from the setup table and limit reads to them. In S/4HANA read the balance from ACDOCA aggregated by account and date (SUM ... GROUP BY) instead of item by item.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document From a row you can jump to credit items, letters of guarantee or the collateral cheque list.
- Export to Excel
- Runs as a background job The weekly limit report can be prepared in the background and emailed to finance management.
Authorization objects
- F_BKPF_BUKDocument display authorization by company code
- F_BNKA_BUKAuthorization 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.
Related reports
Daily Bank Balances, Cash Movements and Net Financial Debt Report
A report that shows the daily balance of every bank account in all company codes by bank, account and currency, from both the bank statement and the …
Bank Loan Tracking, Interest Accrual and Repayment Schedule Program
A custom program that keeps bank loans (amount, currency, interest, maturity and installment plan) in one place and automatically posts the monthly …
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 …
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.