In SAP S/4HANA, the main table for credit-management business partner data is UKMBP_CMS; credit-segment-specific data is stored in UKMBP_CMS_SGM. The right table depends on which credit detail you need, and table access differs between classic SAP Credit Management and SAP Credit Management in S/4HANA.
What “credit limit table” means
There is not one universal table containing every credit limit and every related value. SAP Credit Management stores information at different levels. A general business partner credit profile can be separate from its data for a particular credit segment, while exposure and credit decisions involve additional records and processes.
UKMBP_CMS: general Credit Management data associated with the business partner, including central credit-management attributes.UKMBP_CMS_SGM: credit-management data by credit segment, where segment-specific settings such as a limit are maintained.BUT000: general business partner master data, such as the business partner number and name; it is not itself the table to use for a segment’s credit limit.
In an S/4HANA system, “customer” credit data is commonly handled through the Business Partner approach. The business partner is the master-data identity, while the credit-management profile and segment assignments supply the credit-specific information.
Which table to use for a credit limit
If the question is “What limit is assigned to this business partner in this credit segment?”, start by checking UKMBP_CMS_SGM in the relevant system and release. Identify the business partner and credit segment together; a business partner can be assigned to multiple segments, each with its own data. Do not assume there is a single customer-wide limit that applies to every segment.
Use UKMBP_CMS when you need general credit-management profile information rather than a segment’s limit. For names or other general partner details, link to the Business Partner master data as appropriate. The exact field names, available records, and relationships should be confirmed in the system’s Data Dictionary, because releases and implementations can differ.
For a reliable lookup, establish these details first:
- The business partner number, including any conversion or formatting rules used by the system.
- The relevant credit segment, not just a sales organization or company code.
- Whether you need the maintained limit, a calculated exposure, a blocked-document status, or a credit-check result. These are different questions.
- The system’s deployment and release, such as on-premise or cloud, and whether the implementation uses classic or newer credit-management functionality.
How credit-segment data fits together
A credit segment represents a defined scope for credit control. An organization can configure segments to match how it manages credit exposure, and a business partner’s credit data can be maintained separately for each applicable segment. The segment-specific record is therefore the natural place to investigate a limit tied to that scope.
A limit is not the same as the amount currently available. A simplified view is that the available amount depends on the maintained limit minus relevant credit exposure, but SAP’s actual checks can include configuration, exposure categories, open documents, risk settings, and other rules. A displayed balance or a credit-check outcome should not be inferred from the limit field alone.
Likewise, an order being blocked does not prove that the table’s limit is wrong. The check may use a different segment, exposure may have changed, or configuration and status may affect the result. To diagnose a decision, compare the business partner’s segment assignment, limit, exposure, and the application’s credit-check details.
How to verify the data in SAP
For functional users, the Business Partner and credit-management applications are generally a safer starting point than reading database tables directly. They present the data in business context and respect the system’s authorization model. Exact app names and navigation depend on the S/4HANA deployment, activated scope, and configuration.
- Open the relevant business partner in the supported Business Partner or Credit Management interface.
- Check that the credit-management role and credit profile are present.
- Open the credit segment data and confirm the segment matches the document or process being investigated.
- Review the limit, currency, validity or status information available, and exposure separately.
- If a technical extract is necessary, verify the table and field definitions in the system’s Data Dictionary, then validate the result against the application display.
In an authorized development or support environment, SAP GUI transaction SE11 can be used to inspect table definitions, and SE16N may be available for table display, subject to access controls and local policy. A table browser is not a substitute for application-level validation, especially in production or when data is exposed outside SAP.
Classic and newer Credit Management
SAP terminology can make table searches confusing. Older SAP ERP systems commonly used classic credit-management structures such as KNKK for customer credit data. That does not mean KNKK is the authoritative location for a current S/4HANA Credit Management limit. S/4HANA Credit Management uses the Business Partner model and its own credit-management data structures; compatibility, migration, and integration details depend on the system.
Do not choose a table solely because it appears in a report, old interface, or online example. A legacy system may still use classic credit management, while an S/4HANA implementation may have migrated data, compatibility views, or custom integrations. Confirm which credit-management solution is active and whether the data source is supported for the intended use.
Common lookup mistakes
- Using a customer number as if it were always the business partner number: the relationship and numbering can vary. Confirm the mapping in the system.
- Ignoring the credit segment: querying only by partner can return multiple records or lead to a wrong limit.
- Treating exposure as the limit: these values answer different questions and may be updated through different processes.
- Assuming a table field name without checking: verify the installed release’s field definition instead of relying on a copied query.
- Reading tables without authorization or context: access should follow the organization’s security and data-handling procedures; use supported interfaces where possible.
Frequently Asked Questions
What is the SAP S/4HANA table for a credit limit?
For a credit-segment-specific limit, check UKMBP_CMS_SGM. Confirm the applicable field and relationship in your system’s Data Dictionary, since implementation and release details matter.
What is the purpose of UKMBP_CMS?UKMBP_CMS holds general SAP Credit Management data associated with the business partner. Segment-specific data is represented separately, commonly in UKMBP_CMS_SGM.
Is KNKK used for credit limits in S/4HANA?KNKK is associated with classic customer credit management in older SAP systems. Do not assume it is the authoritative source for an S/4HANA Credit Management limit; check the active solution and system documentation.
Why does one business partner have more than one credit limit?
Credit limits can be maintained by credit segment. If a partner has multiple segment assignments, each can have its own limit and related settings.
Does the credit limit equal available credit?
No. Available credit depends on exposure and the configured credit-check logic as well as the maintained limit. Check the application’s exposure and decision details for the specific transaction.
Can I use SE16N to view the credit limit?
It may be available to authorized users, depending on system settings and policy. Verify the table and segment in the Data Dictionary and compare the result with the supported Business Partner or Credit Management interface.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this section
- Cash-Out Refinance at U.S. Bank: Estimate the Cash$62,000.00
- VA Cash-Out Refinance Calculator and How It Works$405.53
- Cash-Out Refinance on a Second Home: Rules and Costs$405.53
- Cash-Out Refinance With a Second Lien?$405.53
- Cash-Out Refinance on a Second Home: Costs and Options$405.53
- Cash-Out Refinance Second Home Rates Explained$1,330.60