SD Report Custom development ALV report

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

  • VKM1 Blocked SD Documents. Lists blocked documents for release; no total blocked value per customer and no age of the block.
  • FD32 Change Customer Credit Management. Shows the credit limit and utilization of one customer; does not list blocked orders.

Tables used

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

TableRoleJoinSystem
VBUKSales Document Header Status (ECC)Credit check status in the document header (driving table in ECC)—ECC only
VBAKSales Document HeaderCredit control area, credit account, creation date and currency; in S/4HANA also the credit statusVBAK-VBELN = VBUK-VBELNECC + S/4
VBAPSales Document ItemNet value of the itemsVBAP-VBELN = VBAK-VBELNECC + S/4
VBUPSales Document: Item StatusItem delivery status; fully delivered items are not counted in the blocked valueVBUP-VBELN = VBAP-VBELN AND VBUP-POSNR = VBAP-POSNRECC + S/4
KNKKCustomer Master Credit Management: Control Area DataCredit limit, receivables, sales value and risk categoryKNKK-KUNNR = VBAK-KNKLI AND KNKK-KKBER = VBAK-KKBERECC only
UKMBP_CMSSAP Credit Management: Credit Master Data for PartnerRisk class and credit profile of the business partner in S/4HANA SAP Credit ManagementPARTNER = iş ortağı (VBAK-KNKLI'den)S/4HANA only
KNA1Customer Master (General Section)Name of the credit accountKNA1-KUNNR = VBAK-KNKLIECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_KKBERCredit control areaRange / multipleVBAK-KKBERYes1000
S_VKORGSales organizationRange / multipleVBAK-VKORGNo1000
S_KNKLICredit accountRange / multipleVBAK-KNKLINo200145
S_CTLPCRisk categoryRange / multipleKNKK-CTLPCNo002
S_ERDATOrder creation dateRange / multipleVBAK-ERDATNo01.09.2026 – 17.11.2026
P_KEYDTKey date (default: today)Single valueSY-DATUMYes17.11.2026
P_MINVALMinimum blocked valueSingle valueVBAK-NETWRNo10000
R_SUMMSummary per credit accountRadio button—NoX
R_DETLOrder detailRadio button—No—

Output columns

#ColumnSource
1Credit accountVBAK-KNKLI
2Customer nameKNA1-NAME1
3Risk categoryKNKK-CTLPC
4Credit limitKNKK-KLIMK
5ReceivablesKNKK-SKFOR
6Sales valueKNKK-SAUFT
7Limit utilization %Calculated (KNKK-SKFOR + KNKK-SSOBL + KNKK-SAUFT) ÷ KNKK-KLIMK × 100
8Blocked ordersCalculated Number of orders with credit status B or C
9Blocked valueCalculated Sum of VBAP-NETWR of open items, in credit control area currency
10CurrencyCalculated Currency of the credit control area
11Oldest blocked orderVBAK-VBELN
12Created onVBAK-ERDAT
13Days blockedCalculated Key date − VBAK-ERDAT of the oldest blocked order

Sample output

Credit accountCustomer nameRisk categoryCredit limitReceivablesSales valueLimit utilization %Blocked ordersBlocked valueCurrencyOldest blocked orderCreated onDays blocked
200310Kuzey Gıda Dağıtım0031,500,0001,320,000410,000115.304286,400TRY000012337710/28/202620
200145Marmara Yapı Market0022,500,0001,980,000520,000101.202148,750TRY000012351211/09/20268
200422Anadolu Elektrik Toptan002900,000610,000245,00095162,300TRY000012354011/14/20263
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. 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.
  4. 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).
  5. 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

FI Package Custom

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 …

4 components · v1.0

SD Package Custom

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 …

5 components · v1.0

Related reports

SD Report Custom ALV report

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 …

VBAK · VBAP · VBFA · LIKP

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: Credit-Blocked Sales Orders by Value and Age Report