# Customer Credit Risk Exposure Report (Open Items, Cheques and Open Orders)

> A custom ALV report that compares each customer's total exposure with the credit limit. Open receivables, cheques and bills of exchange not yet due (in the portfolio or at the bank), open orders and unbilled deliveries are totalled in separate columns; available limit, limit utilization and overdue amount appear on the same line.

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: M (5–8 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/customer-credit-risk-exposure-report/


## Why is the standard not enough?

FD32 shows the credit data of one customer; there is no screen that lists all customers split into exposure components. VKM1 lists only blocked documents. When cheques and bills of exchange are kept as special G/L items, it is not visible at a glance whether they are included in the standard credit exposure and when they will drop out of it by maturity. The custom report supports the pre-shipment decision in one list.

### Closest standard alternatives

- FD32: Shows the credit data and exposure of one customer; does not list all customers split into exposure components.
- VKM1: Lists documents blocked for credit; does not show customers approaching their limit without a block.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| KNKK | Credit account, limit, risk category and credit representative group (ECC, driving table) | Read | - | ECC only |
| UKMBP_CMS_SGM | Credit segment limit, block and limit validity date (S/4HANA, driving table) | Read | - | S/4HANA only |
| BSID | Open customer items and special G/L (cheque/bill) items | Read | BSID-KUNNR = KNKK-KUNNR | ECC + S/4 |
| BSED | Bank, drawer and status of cheques and bills | Read | BSED-BUKRS = BSID-BUKRS AND BSED-BELNR = BSID-BELNR AND BSED-GJAHR = BSID-GJAHR AND BSED-BUZEI = BSID-BUZEI | ECC + S/4 |
| S066 | Credit management: open order values (ECC) | Read | S066-KNKLI = KNKK-KNKLI AND S066-KKBER = KNKK-KKBER | ECC only |
| S067 | Credit management: open delivery and untransferred invoice values (ECC) | Read | S067-KNKLI = KNKK-KNKLI AND S067-KKBER = KNKK-KKBER | ECC only |
| UKM_TOTALS | Open order, delivery and invoice totals by commitment type (S/4HANA) | Read | UKM_TOTALS-PARTNER = UKMBP_CMS_SGM-PARTNER AND UKM_TOTALS-CREDIT_SGMNT = UKMBP_CMS_SGM-CREDIT_SGMNT | S/4HANA only |
| KNA1 | Customer name | Read | KNA1-KUNNR = KNKK-KNKLI | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_KKBER | Credit control area (credit segment in S/4HANA) | Single value | KNKK-KKBER | Yes |
| S_KNKLI | Credit account (customer) | Range / multiple | KNKK-KNKLI | No |
| S_CTLPC | Risk category | Range / multiple | KNKK-CTLPC | No |
| S_SBGRP | Credit representative group | Range / multiple | KNKK-SBGRP | No |
| S_UMSKZ | Special G/L indicators of cheques/bills to include | Range / multiple | BSID-UMSKZ | No |
| P_KEYDT | Key date | Single value | BSID-ZFBDT | Yes |
| P_BUFF | Days cheques stay in exposure after maturity | Single value | - | No |
| P_OVER | Only customers over their limit | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Credit account | KNKK-KNKLI |
| Customer name | KNA1-NAME1 |
| Risk category | KNKK-CTLPC |
| Credit limit | KNKK-KLIMK |
| Open receivables | Calculated: Σ BSID-DMBTR (UMSKS blank, debit +, credit −) |
| Overdue | Calculated: Open receivables with net due date before the key date |
| Cheques/bills in exposure | Calculated: Σ BSID-DMBTR (UMSKZ ∈ S_UMSKZ, ZFBDT + P_BUFF ≥ key date) |
| Open orders | Calculated: S066-OEIKW; in S/4HANA the UKM_TOTALS order commitment |
| Open deliveries/invoices | Calculated: S067-OLIKW + S067-OFAKW; in S/4HANA UKM_TOTALS |
| Total exposure | Calculated: Open receivables + cheques/bills + open orders + open deliveries/invoices |
| Available limit | Calculated: Credit limit − total exposure |
| Utilization % | Calculated: Total exposure / credit limit × 100 |

## How does the report work?

1. The credit account and limit are read: in ECC from KNKK (KLIMK limit, KNKLI credit account, CTLPC risk category), in S/4HANA from UKMBP_CMS_SGM (credit segment limit and validity date).
2. Open items are read from BSID for all customers linked to the credit account. Normal items (UMSKS blank) are split into not yet due and overdue by net due date.
3. Cheques and bills of exchange are selected with the special G/L indicators to include in the exposure (S_UMSKZ); bank and drawer details come from BSED. Those with a due date (BSID-ZFBDT) after the key date count as exposure; optionally they stay in exposure for a few days after maturity to allow for collection.
4. Open orders and deliveries: in ECC the credit management info structures S066 (open orders) and S067 (open deliveries and invoices not yet transferred), in S/4HANA the commitment types in UKM_TOTALS.
5. Total exposure = open receivables + cheques/bills in exposure + open orders + open deliveries/invoices; available limit = limit − total exposure; utilization = total exposure / limit.
6. Exceeded limits, balances overdue by more than a given number of days and expired limits are flagged. From a row the user jumps to FD32 (business partner credit data in S/4HANA), FBL5N and, for blocked orders, VKM1.

## Authorization objects

- F_KNKA_KKB: Credit data display authorization by credit control area (ECC)
- F_UKM_SGMT: Credit data authorization by credit segment (S/4HANA)
- F_BKPF_BUK: Authorization to display customer items by company code

## Frequently asked questions

### When do cheques drop out of the exposure?

A cheque or bill drops out of the exposure once its due date is before the key date and the extra days defined for collection have passed. Cheques that are due but not yet collected by the bank therefore remain visible as exposure for a while.

### Are endorsed customer cheques included in the exposure?

Endorsed cheques are included according to the special G/L indicator or status used for them, as set during installation. Because they can bounce until maturity, most companies prefer to keep them in the exposure until the due date.

### Does it work with S/4HANA credit management?

Yes. In S/4HANA the limit and commitments are read from business partner credit management (UKMBP_CMS_SGM, UKM_TOTALS); cheque and bill items still come from customer open items. The report layout is the same in both versions.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=sd-customer-credit-risk
