# Customer Credit Limit Upload and Cheque-Aware Credit Check

> A development that updates customer credit limits in bulk from Excel and adds post-dated cheques in the portfolio, a per-customer cheque quota and exceptions by payment terms and material type to the credit check in the sales order. Credit segment limits are updated in S/4HANA, credit control area limits in ECC.

- Type: Program, Custom development, Enhancement
- Module: SD
- Estimated effort: L (12–18 working days)
- Localization: TR
- Last updated: 2026-11-18
- URL: https://nekuhub.com/en/programs/customer-credit-limit-upload-and-cheque-aware-credit-check/


## Why is the standard not enough?

In S/4HANA the credit limit is kept on the business partner per credit segment and updated one by one; there is no tool to update the yearly limit revision of hundreds of customers from Excel. Standard credit exposure counts open items, orders and deliveries; it does not cover, with one rule set, tracking post-dated cheques common in Turkey within a separate quota or excluding documents with cash-in-advance payment terms or certain material types. The custom development solves both needs in one installation.

### Closest standard alternatives

- FD32: Changes a customer's credit limit one by one in ECC; in S/4HANA it is replaced by business partner credit management and knows no cheque quota.
- VKM1: Releases credit-blocked orders; does not explain the block in terms of the cheque quota.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| UKMBP_CMS_SGM | Limit and valid-to date per credit segment (S/4HANA, FSCM) | Read / write | - | S/4HANA only |
| UKMBP_CMS | Credit profile and risk class of the business partner (S/4HANA) | Read | UKMBP_CMS-PARTNER = UKMBP_CMS_SGM-PARTNER | S/4HANA only |
| UKM_ITEM | Open orders, deliveries and invoices in the credit exposure (S/4HANA) | Read | UKM_ITEM-PARTNER = UKMBP_CMS_SGM-PARTNER | S/4HANA only |
| KNKK | Customer limit per credit control area (ECC classic credit management) | Read / write | - | ECC only |
| BSID | Cheques in the portfolio: open items with special G/L indicator | Read | BSID-KUNNR = VBAK-KUNNR AND BSID-UMSKZ IN (cheque indicators from setup) | ECC + S/4 |
| BSED | Cheque maturity, bank and cheque number | Read | BSED-BUKRS = BSID-BUKRS AND BELNR = BSID-BELNR AND GJAHR = BSID-GJAHR AND BUZEI = BSID-BUZEI | ECC + S/4 |
| VBAK | Order type, order value and credit control area | Read | - | ECC + S/4 |
| VBKD | Payment terms of the order | Read | VBKD-VBELN = VBAK-VBELN | ECC + S/4 |
| MARA | Material type exception | Read | - | ECC + S/4 |
| T052 | Payment terms definition (cash in advance, cheque, letter of credit) | Read | T052-ZTERM = VBKD-ZTERM | ECC + S/4 |

## BAPIs and functions used

- TEXT_CONVERT_XLS_TO_SAP: Reads the limit file from Excel
- BAPI_AR_ACC_GETOPENITEMS: Optionally reads the customer's open items and cheques

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_FILE | Limit file | Single value | - | Yes |
| P_SGMNT | Credit segment | Single value | UKMBP_CMS_SGM-CREDIT_SGMNT | Yes |
| P_THRES | Increase percentage that needs approval | Single value | - | No |
| P_TEST | Test run | Checkbox | - | No |

## Input file columns

| Column | Target field | Required |
|---|---|---|
| Business partner | UKMBP_CMS_SGM-PARTNER | Yes |
| Credit segment | UKMBP_CMS_SGM-CREDIT_SGMNT | Yes |
| New credit limit | UKMBP_CMS_SGM-CREDIT_LIMIT | Yes |
| Valid to | UKMBP_CMS_SGM-LIMIT_VALID_DATE | No |
| Cheque quota | Highest post-dated cheque amount accepted for the customer | No |
| Comment | Reason for the revision | No |

## Result list columns

| Column | Source |
|---|---|
| Business partner | UKMBP_CMS_SGM-PARTNER |
| Credit segment | UKMBP_CMS_SGM-CREDIT_SGMNT |
| Old limit | Calculated: UKMBP_CMS_SGM-CREDIT_LIMIT before the update (KNKK-KLIMK in ECC) |
| New limit | Calculated: Limit from the file |
| Change % | Calculated: (new − old) / old × 100 |
| Cheques in portfolio | Calculated: Sum of not-yet-due BSID items with the cheque indicators from setup |
| Cheque quota | Calculated: Quota from the file |
| Status | Calculated: Ready, updated, approval needed or error |
| Message | Calculated: Check or update message |

## How does the program work?

1. Limit upload: the Excel file holds business partner, credit segment, new limit, valid-to date, cheque quota and a comment. In S/4HANA the business partner and segment are checked in UKMBP_CMS_SGM; the limit and valid-to date are updated through the FSCM credit management API (CL_UKM_BUPA_FACTORY and CL_UKM_ACCOUNT), so the standard change documents are created. In ECC with classic credit management the KNKK limit is changed with CREDITLIMIT_CHANGE.
2. The test run shows old and new limit, the change in percent and rows above the approval threshold set during setup; the live run writes the results to the application log.
3. Cheque risk: the customer's post-dated cheques in the portfolio are read from open items by the special G/L indicators set during setup (BSID-UMSKZ); cheque maturity and bank come from BSED. In S/4HANA BSID is read as a compatibility view on ACDOCA and BSEG.
4. Adding to exposure: in S/4HANA the cheque risk is added to the credit exposure formula with the UKM_EV_FORMULA BAdI; in ECC classic credit control the user exit in LVKMPFZ1 is used. The cheque quota is checked separately: if the order's payment terms are flagged as payment by cheque, cheques in the portfolio plus this order's value are compared with the quota.
5. Document-based exceptions: for cash-in-advance or letter-of-credit payment terms (VBKD-ZTERM), material types chosen during setup such as samples, scrap or internal use (MARA-MTART) and certain order types, the credit check is skipped or only gives a warning through the UKM_R3_ACTIVATE BAdI.
6. The result shows up in the order as the standard credit block; the block is released with VKM1, and the rule that caused the block is written to the order text and the log.

## Authorization objects

- F_UKM_SGMT: Changing limits in a credit segment (S/4HANA, FSCM)
- F_KNKK_BED: Changing customer limits in a credit control area (ECC)
- S_APPL_LOG: Displaying the application log

## Frequently asked questions

### Cheques are already open items; why are they counted separately?

Standard exposure counts the open items on the receivables account, but in many setups received cheques are tracked separately with a special G/L indicator and do not enter the exposure. The development adds not-yet-due cheques to the exposure by the rule chosen during setup and also checks a per-customer cheque quota.

### Are limit increases updated without approval?

An increase threshold is set during installation. Rows above it are flagged 'approval needed' in the test run, and only for these rows an authorized user has to run a separate approval step; the other rows are updated directly.

### What changes when moving from ECC to S/4HANA?

In ECC classic credit management works with KNKK and user exits; in S/4HANA credit management runs through FSCM on the business partner and credit segment. The rule set and the Excel format stay the same; only the place where the limit is written and the point where exposure is extended change.

---
Let us build this program for your system: https://nekuhub.com/en/request-a-quote/?report=tr-credit-limit-upload-cheque-credit-check
