Customer Credit Limit Upload and Cheque-Aware Credit Check
Short answer: 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.
- Estimated effort
- L · 12–18 working days
- System
- ECC and S/4HANA
- Tables
- 10
- Scope
- TR
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Credit and risk management teams, finance managers, sales operations teams and SD/FSCM consultants.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| UKMBP_CMS_SGMSAP Credit Management: Master Data for Credit Account | Limit and valid-to date per credit segment (S/4HANA, FSCM) | Read / write | S/4HANA only |
| UKMBP_CMSSAP Credit Management: Credit Master Data for Partner | Credit profile and risk class of the business partner (S/4HANA) | Read | S/4HANA only |
| UKM_ITEMCredit Management: Line Items | Open orders, deliveries and invoices in the credit exposure (S/4HANA) | Read | S/4HANA only |
| KNKKCustomer Master Credit Management: Control Area Data | Customer limit per credit control area (ECC classic credit management) | Read / write | ECC only |
| BSIDCustomer Open Items | Cheques in the portfolio: open items with special G/L indicator | Read | ECC + S/4 |
| BSEDBill of Exchange Fields Document Segment | Cheque maturity, bank and cheque number | Read | ECC + S/4 |
| VBAKSales Document Header | Order type, order value and credit control area | Read | ECC + S/4 |
| VBKDSales Document: Business Data | Payment terms of the order | Read | ECC + S/4 |
| MARAGeneral Material Data | Material type exception | Read | ECC + S/4 |
| T052Terms of Payment | Payment terms definition (cash in advance, cheque, letter of credit) | Read | ECC + 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.
BAPIs and functions used
- TEXT_CONVERT_XLS_TO_SAPConvert Excel File to SAP Format. Reads the limit file from Excel
- BAPI_AR_ACC_GETOPENITEMSCustomer Account Open Items at Key Date. Optionally reads the customer's open items and cheques
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_FILE | Limit file | Single value | — | Yes | C:\kredi\limit_revizyonu_2027.xlsx |
| P_SGMNT | Credit segment | Single value | UKMBP_CMS_SGM-CREDIT_SGMNT | Yes | 1000 |
| P_THRES | Increase percentage that needs approval | Single value | — | No | 25 |
| P_TEST | Test run | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Business partner | UKMBP_CMS_SGM-PARTNER | Yes |
| 2 | Credit segment | UKMBP_CMS_SGM-CREDIT_SGMNT | Yes |
| 3 | New credit limit | UKMBP_CMS_SGM-CREDIT_LIMIT | Yes |
| 4 | Valid to | UKMBP_CMS_SGM-LIMIT_VALID_DATE | No |
| 5 | Cheque quota | By rule Highest post-dated cheque amount accepted for the customer | No |
| 6 | Comment | By rule Reason for the revision | No |
Sample upload file
| 1 | Business partner * | Credit segment * | New credit limit * | Valid to | Cheque quota | Comment |
|---|---|---|---|---|---|---|
| 2 | 1000200145 | 1000 | 2,500,000 | 12/31/2027 | 1,500,000 | Yearly revision |
| 3 | 1000300210 | 1000 | 800,000 | 06/30/2027 | 0 | Bank guarantee renewed |
| 4 | 1000300388 | 1000 | 4,000,000 | 12/31/2027 | 2,500,000 | Turnover growth |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Business partner | UKMBP_CMS_SGM-PARTNER |
| 2 | Credit segment | UKMBP_CMS_SGM-CREDIT_SGMNT |
| 3 | Old limit | Calculated UKMBP_CMS_SGM-CREDIT_LIMIT before the update (KNKK-KLIMK in ECC) |
| 4 | New limit | Calculated Limit from the file |
| 5 | Change % | Calculated (new − old) / old × 100 |
| 6 | Cheques in portfolio | Calculated Sum of not-yet-due BSID items with the cheque indicators from setup |
| 7 | Cheque quota | Calculated Quota from the file |
| 8 | Status | Calculated Ready, updated, approval needed or error |
| 9 | Message | Calculated Check or update message |
Sample result list
| Business partner | Credit segment | Old limit | New limit | Change % | Cheques in portfolio | Cheque quota | Status | Message |
|---|---|---|---|---|---|---|---|---|
| 1000200145 | 1000 | 2,000,000 | 2,500,000 | 25 | 1,320,000 | 1,500,000 | Ready | |
| 1000300210 | 1000 | 1,000,000 | 800,000 | -20 | 0 | 0 | Ready | No cheques accepted |
| 1000300388 | 1000 | 2,500,000 | 4,000,000 | 60 | 2,140,000 | 2,500,000 | Approval needed | Increase threshold exceeded |
| 1000300999 | 1000 | 0 | 500,000 | 0 | 0 | 0 | Error | Business partner has no credit profile in this segment |
How does the program work?
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Performance notes
Do not calculate cheque risk by scanning all open items on every order save; do a narrow read by customer and special G/L indicator and buffer it within the same LUW. In the mass limit upload, update business partners in packages and issue COMMIT WORK after each package.
Features
- Export to Excel
- Test mode (check without posting) Old and new limit, change and threshold check are visible before the update.
- Line-by-line result and error log Limit changes and the rule that blocked an order are written to the log.
- Download failed lines as a separate file
Authorization objects
- F_UKM_SGMTChanging limits in a credit segment (S/4HANA, FSCM)
- F_KNKK_BEDChanging customer limits in a credit control area (ECC)
- S_APPL_LOGDisplaying 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.
Related reports
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 …
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 …
Türkiye Cheque and Promissory Note Portfolio, Risk and Maturity Report
A custom ALV report that lists cheques and promissory notes received from customers with number, drawer, bank, due date and current position (in …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.