SD Report Custom development ALV report

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

Short answer: 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.

Estimated effort
M · 5–8 working days
System
ECC and S/4HANA
Tables
8
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

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.

Who uses it? Credit and risk managers, finance managers, sales managers and teams approving shipments.

Closest standard alternatives

  • FD32 Change Customer Credit Management. Shows the credit data and exposure of one customer; does not list all customers split into exposure components.
  • VKM1 Blocked SD Documents. Lists documents blocked for credit; does not show customers approaching their limit without a block.

Tables used

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

TableRoleJoinSystem
KNKKCustomer Master Credit Management: Control Area DataCredit account, limit, risk category and credit representative group (ECC, driving table)—ECC only
UKMBP_CMS_SGMSAP Credit Management: Master Data for Credit AccountCredit segment limit, block and limit validity date (S/4HANA, driving table)—S/4HANA only
BSIDCustomer Open ItemsOpen customer items and special G/L (cheque/bill) itemsBSID-KUNNR = KNKK-KUNNRECC + S/4
BSEDBill of Exchange Fields Document SegmentBank, drawer and status of cheques and billsBSED-BUKRS = BSID-BUKRS AND BSED-BELNR = BSID-BELNR AND BSED-GJAHR = BSID-GJAHR AND BSED-BUZEI = BSID-BUZEIECC + S/4
S066Open Orders: Credit ManagementCredit management: open order values (ECC)S066-KNKLI = KNKK-KNKLI AND S066-KKBER = KNKK-KKBERECC only
S067Open Deliveries and Billing Documents: Credit ManagementCredit management: open delivery and untransferred invoice values (ECC)S067-KNKLI = KNKK-KNKLI AND S067-KKBER = KNKK-KKBERECC only
UKM_TOTALSSAP Credit Management: Liability TotalsOpen order, delivery and invoice totals by commitment type (S/4HANA)UKM_TOTALS-PARTNER = UKMBP_CMS_SGM-PARTNER AND UKM_TOTALS-CREDIT_SGMNT = UKMBP_CMS_SGM-CREDIT_SGMNTS/4HANA only
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = KNKK-KNKLIECC + S/4

S/4HANA notes

  • KNKK → UKMBP_CMS_SGM: In S/4HANA FI-AR-CR credit management is replaced by SAP Credit Management (FIN-FSCM-CR); credit segment data is kept per business partner in UKM tables such as UKMBP_CMS_SGM.
  • 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.
  • S066: In S/4HANA classic SD credit management is replaced by SAP Credit Management (FIN-FSCM-CR); the credit exposure is no longer calculated from this info structure.
  • S067: In S/4HANA classic SD credit management is replaced by SAP Credit Management (FIN-FSCM-CR); the credit exposure is no longer calculated from this info structure.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_KKBERCredit control area (credit segment in S/4HANA)Single valueKNKK-KKBERYes1000
S_KNKLICredit account (customer)Range / multipleKNKK-KNKLINo200118
S_CTLPCRisk categoryRange / multipleKNKK-CTLPCNo002
S_SBGRPCredit representative groupRange / multipleKNKK-SBGRPNoK01
S_UMSKZSpecial G/L indicators of cheques/bills to includeRange / multipleBSID-UMSKZNoW
P_KEYDTKey dateSingle valueBSID-ZFBDTYes17.11.2026
P_BUFFDays cheques stay in exposure after maturitySingle value—No3
P_OVEROnly customers over their limitCheckbox—No—

Output columns

#ColumnSource
1Credit accountKNKK-KNKLI
2Customer nameKNA1-NAME1
3Risk categoryKNKK-CTLPC
4Credit limitKNKK-KLIMK
5Open receivablesCalculated Σ BSID-DMBTR (UMSKS blank, debit +, credit −)
6OverdueCalculated Open receivables with net due date before the key date
7Cheques/bills in exposureCalculated Σ BSID-DMBTR (UMSKZ ∈ S_UMSKZ, ZFBDT + P_BUFF ≥ key date)
8Open ordersCalculated S066-OEIKW; in S/4HANA the UKM_TOTALS order commitment
9Open deliveries/invoicesCalculated S067-OLIKW + S067-OFAKW; in S/4HANA UKM_TOTALS
10Total exposureCalculated Open receivables + cheques/bills + open orders + open deliveries/invoices
11Available limitCalculated Credit limit − total exposure
12Utilization %Calculated Total exposure / credit limit × 100

Sample output

Credit accountCustomer nameRisk categoryCredit limitOpen receivablesOverdueCheques/bills in exposureOpen ordersOpen deliveries/invoicesTotal exposureAvailable limitUtilization %
200118Örnek Tekstil A.Ş.0022,500,0001,184,300212,400640,000318,50096,2002,239,000261,00089.60
200342Anadolu Dış Ticaret A.Ş.0031,500,0001,046,800488,900410,000152,30001,609,100-109,100107.30
200455Ege Ev Tekstili Ltd. Şti.001750,000214,6000120,00084,20031,800450,600299,40060.10
200510Örnek Bayi Ltd. Şti.0021,000,000386,90074,300255,000412,80001,054,700-54,700105.50
A view built with fictional sample data; not real system data.

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.

Performance notes

Read BSID with the company code and the list of customers in the credit account, and split special G/L items in SQL. S066/S067 already hold totals, so do not read order and delivery documents one by one. In S/4HANA the released accounting item view can be used for open items.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a column opens FD32, FBL5N or VKM1 for blocked orders.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Customers over their limit can be sent to credit and sales managers every morning.

Authorization objects

  • F_KNKA_KKBCredit data display authorization by credit control area (ECC)
  • F_UKM_SGMTCredit data authorization by credit segment (S/4HANA)
  • F_BKPF_BUKAuthorization 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.

Related reports

FI Report Custom ALV report

Customer Payment Behavior and Days-to-Pay Report

A custom ALV report that uses customer invoices cleared in the selected period to calculate each customer's average days to pay, amount-weighted days …

BSAD · BKPF · BSID · KNA1

FI Report Custom ALV report

Customer Receivables Aging Report

A custom ALV report that ages customer open items by net due date and shows down payments received and other special G/L items in the same list. …

BSID · BSAD · KNA1 · KNB1

SD Report Custom ALV report

Credit-Blocked Sales Orders by Value and Age Report

A custom ALV report that groups credit-blocked sales orders per credit account and shows the blocked order value, the age of the oldest block, the …

VBUK · VBAK · VBAP · VBUP

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: Customer Credit Risk Exposure Report (Open Items, Cheques and Open Orders)