Credit-Blocked Sales Orders by Value and Age Report
Short answer: 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 credit limit and the limit utilization on the same line. Credit managers can prioritize the customers whose release unlocks the most revenue.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
VKM1 lists blocked documents one by one so they can be released; it does not show the total blocked value per customer, how many days the oldest block has been waiting, or rank customers by that value. FD32 shows the credit limit and utilization for one customer at a time. Before credit meetings, teams merge the two screens in Excel. The custom report brings blocked orders and credit data together in one list.
Who uses it? Credit managers, receivables teams, sales managers and financial controllers.
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 |
|---|---|---|---|
| VBUKSales Document Header Status (ECC) | Credit check status in the document header (driving table in ECC) | — | ECC only |
| VBAKSales Document Header | Credit control area, credit account, creation date and currency; in S/4HANA also the credit status | VBAK-VBELN = VBUK-VBELN | ECC + S/4 |
| VBAPSales Document Item | Net value of the items | VBAP-VBELN = VBAK-VBELN | ECC + S/4 |
| VBUPSales Document: Item Status | Item delivery status; fully delivered items are not counted in the blocked value | VBUP-VBELN = VBAP-VBELN AND VBUP-POSNR = VBAP-POSNR | ECC + S/4 |
| KNKKCustomer Master Credit Management: Control Area Data | Credit limit, receivables, sales value and risk category | KNKK-KUNNR = VBAK-KNKLI AND KNKK-KKBER = VBAK-KKBER | ECC only |
| UKMBP_CMSSAP Credit Management: Credit Master Data for Partner | Risk class and credit profile of the business partner in S/4HANA SAP Credit Management | PARTNER = iş ortağı (VBAK-KNKLI'den) | S/4HANA only |
| KNA1Customer Master (General Section) | Name of the credit account | KNA1-KUNNR = VBAK-KNKLI | ECC + S/4 |
S/4HANA notes
- VBUK → VBAK: VBUK is not used in S/4HANA. The status fields moved to the respective document header: VBAK for sales, LIKP for deliveries, VBRK for billing. It is one of the most common fixes when custom reports move from ECC.
- VBUP → VBAP: VBUP was removed in S/4HANA; the item status fields moved directly into VBAP (sales), LIPS (delivery) and VBRP (billing).
- 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.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_KKBER | Credit control area | Range / multiple | VBAK-KKBER | Yes | 1000 |
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | No | 1000 |
| S_KNKLI | Credit account | Range / multiple | VBAK-KNKLI | No | 200145 |
| S_CTLPC | Risk category | Range / multiple | KNKK-CTLPC | No | 002 |
| S_ERDAT | Order creation date | Range / multiple | VBAK-ERDAT | No | 01.09.2026 – 17.11.2026 |
| P_KEYDT | Key date (default: today) | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_MINVAL | Minimum blocked value | Single value | VBAK-NETWR | No | 10000 |
| R_SUMM | Summary per credit account | Radio button | — | No | X |
| R_DETL | Order detail | Radio button | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Credit account | VBAK-KNKLI |
| 2 | Customer name | KNA1-NAME1 |
| 3 | Risk category | KNKK-CTLPC |
| 4 | Credit limit | KNKK-KLIMK |
| 5 | Receivables | KNKK-SKFOR |
| 6 | Sales value | KNKK-SAUFT |
| 7 | Limit utilization % | Calculated (KNKK-SKFOR + KNKK-SSOBL + KNKK-SAUFT) ÷ KNKK-KLIMK × 100 |
| 8 | Blocked orders | Calculated Number of orders with credit status B or C |
| 9 | Blocked value | Calculated Sum of VBAP-NETWR of open items, in credit control area currency |
| 10 | Currency | Calculated Currency of the credit control area |
| 11 | Oldest blocked order | VBAK-VBELN |
| 12 | Created on | VBAK-ERDAT |
| 13 | Days blocked | Calculated Key date − VBAK-ERDAT of the oldest blocked order |
Sample output
| Credit account | Customer name | Risk category | Credit limit | Receivables | Sales value | Limit utilization % | Blocked orders | Blocked value | Currency | Oldest blocked order | Created on | Days blocked |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 200310 | Kuzey Gıda Dağıtım | 003 | 1,500,000 | 1,320,000 | 410,000 | 115.30 | 4 | 286,400 | TRY | 0000123377 | 10/28/2026 | 20 |
| 200145 | Marmara Yapı Market | 002 | 2,500,000 | 1,980,000 | 520,000 | 101.20 | 2 | 148,750 | TRY | 0000123512 | 11/09/2026 | 8 |
| 200422 | Anadolu Elektrik Toptan | 002 | 900,000 | 610,000 | 245,000 | 95 | 1 | 62,300 | TRY | 0000123540 | 11/14/2026 | 3 |
How does the report work?
- Sales documents with credit status B (check not OK) or C (partially released) are selected from VBUK-CMGST. In S/4HANA this status is in VBAK-CMGST.
- Credit control area (KKBER), credit account (KNKLI), creation date and currency are read from VBAK; the sales organization and date range from the selection screen are applied.
- Blocked value = sum of VBAP-NETWR of items without a reason for rejection and not fully delivered (VBUP-LFSTA ≠ C), converted to the credit control area currency if needed.
- Credit limit (KLIMK), receivables (SKFOR), special liabilities (SSOBL), sales value (SAUFT) and risk category (CTLPC) are added from KNKK. Utilization % = (SKFOR + SSOBL + SAUFT) ÷ KLIMK × 100. In S/4HANA the credit data is read from SAP Credit Management (UKMBP_CMS and the credit segment).
- Days blocked = key date − VBAK-ERDAT of the oldest blocked order. The summary view shows one line per credit account, the detail view one line per order; the list is sorted by blocked value in descending order.
Performance notes
Reading VBUK by the credit status field may need a secondary index; on large systems narrow the selection on VBAK by credit control area and date range first. Read KNKK once with the list of credit accounts.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a credit account shows its blocked orders; double-clicking an order opens VA03, and VKM1 can be called for release.
- Export to Excel
- Runs as a background job
- Send the result by email The list can be sent to the credit manager every morning.
Authorization objects
- V_VBAK_VKOSales document display authorization by sales area
- F_KNKA_KKBCredit data display authorization by credit control area (ECC)
- F_UKM_SGMTCredit management authorization by credit segment (S/4HANA)
Frequently asked questions
Which orders count as blocked?
Orders with credit check status B (check not OK) or C (partially released). Documents without a credit check or already released (D) are not listed.
Does it work on S/4HANA?
Yes, but the credit data is read from SAP Credit Management instead of KNKK, and the credit status is in VBAK-CMGST. The program is written to pick the right source for the system release.
Can orders be released from the report?
The report only reads. For the selected lines VKM1 is called, so the release is done on the standard screen with the standard authorization check.
Packages that include this solution
Customer Receivables Collection Pack
A pack that brings together four solutions a collection team needs, with one customer and company code selection: receivables aging, the customer's …
Order-to-Cash Control Pack
A five-report pack that shows every point where a sales order gets stuck, with one sales organization selection: missing data, credit blocks, picked …
Related reports
Sales Order – Delivery – Invoice Status Report
A custom ALV report that shows every sales order item on the same line as its delivery and invoice documents. You see in one list which orders have …
On-Time In-Full (OTIF) Delivery Performance Report by Customer
A custom ALV report that compares every sales order item with the customer's requested delivery date and ordered quantity, and works out whether the …
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.