FI Report Custom development ALV report

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

  • FBL3N G/L Account Line Items. Lists credit account items; no limits or non-cash risk.
  • FBL5N Customer Line Items. Shows cheques held as collateral and letter of guarantee items; no total risk per bank.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
T012House BanksHouse banks (bank the limit belongs to)—ECC + S/4
BNKABank Master DataBank nameBNKA-BANKS = T012-BANKS AND BNKA-BANKL = T012-BANKLECC + S/4
T012KHouse Bank AccountsBank accounts and their G/L accountsT012K-BUKRS = T012-BUKRS AND T012K-HBKID = T012-HBKIDECC + S/4
ACDOCAUniversal Journal Entry Line ItemsIn S/4HANA the key-date balance of credit accountsACDOCA-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 accountsBSIS-BUKRS = T012-BUKRS AND BSIS-HKONT IN kredi hesaplarıECC + S/4
BSIDCustomer Open ItemsLetter of guarantee statistical items and customer cheques held as collateralBSID-BUKRS = T012-BUKRS AND BSID-UMSKZ IN teminat göstergeleriECC + S/4
BSIKVendor Open ItemsNon-cash items on the vendor side (letters of credit, etc.)BSIK-BUKRS = T012-BUKRS AND BSIK-UMSKZ IN gayrinakdi göstergelerECC + S/4
BSEDBill of Exchange Fields Document SegmentCollateral cheque details: cheque number, drawer, due dateBSED-BUKRS = BSID-BUKRS AND BSED-BELNR = BSID-BELNR AND BSED-GJAHR = BSID-GJAHR AND BSED-BUZEI = BSID-BUZEIECC + S/4
TCURRExchange RatesKey-date exchange ratesTCURR-KURST = P_KURSTECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleT012-BUKRSYes1000
P_KEYDTKey dateSingle value—Yes18.11.2026
S_HBKIDHouse bankRange / multipleT012-HBKIDNo—
P_KURSTRate typeSingle valueTCURR-KURSTNoM
P_DETLLimit type detailCheckbox—NoX

Output columns

#ColumnSource
1BankBNKA-BANKA
2Limit typeCalculated Cash, letter of guarantee, letter of credit or other non-cash
3Limit (TRY)Calculated Amount in the limit table at the key-date rate
4Risk used (TRY)Calculated Credit balance or total of open letters of guarantee/credit
5Remaining limit (TRY)Calculated Limit − risk used
6Usage %Calculated Risk used / limit × 100
7Collateral cheques (TRY)Calculated Total of not-yet-due customer cheques held by the bank as collateral
8Collateral ratio %Calculated Collateral cheques / cash risk × 100

Sample output

BankLimit typeLimit (TRY)Risk used (TRY)Remaining limit (TRY)Usage %Collateral cheques (TRY)Collateral ratio %
Demo Bank A.Ş.Cash50,000,00041,250,0008,750,00082.5018,400,00044.60
Demo Bank A.Ş.Letter of guarantee20,000,00012,600,0007,400,0006300
Örnek Katılım BankasıCash30,000,0009,800,00020,200,00032.706,100,00062.20
A view built with fictional sample data; not real system data.

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.

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

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.

Related report: Bank Credit Limit and Risk Report (Cash and Non-Cash)