UKMBP_CMS
SAP Credit Management: Credit Master Data for Partner
UKMBP_CMS is an SAP database table in S/4HANA. SAP Credit Management: Credit Master Data for Partner. It contains 16 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_CrdtMBusinessPartner | view | from | EXTENSION | Extension Incl for BP Profl in Crdt Mgmt |
| I_BusinessPartnerCreditProfile | view_entity | from | BASIC | Credit Profile of Business Partner |
| I_CreditManagementBP | view | from | BASIC | Credit Management Business Partner |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | partner | BU_PARTNER | Busn. Partner | |||
| own_rating | UKM_OWN_RATING | Score | ||||
| check_rule | UKM_CHECK_RULE | Check Rule | ||||
| limit_rule | UKM_LIMIT_RULE | Rules | ||||
| rating_val_date | UKM_RATING_VALID_DATE | Valid To | ||||
| rating_chg_date | UKM_RATING_CHG_DATE | Changed On | ||||
| alternate_bp | UKM_ALTERNATE_BP | Alt. Partner | ||||
| own_rating_calc | UKM_OWN_RATING_CALC | Calculated | ||||
| risk_class | UKM_RISK_CLASS | Risk Class | ||||
| risk_class_calc | UKM_RISK_CLASS_CALC | Calculated | ||||
| risk_class_chgdt | UKM_RISK_CLASS_CHG_DATE | Changed On | ||||
| credit_group | UKM_CRED_GROUP | Credit Group | ||||
| customer_since_year | UKM_BUS_REL_SINCE_YEAR | First Year of Customer Relationship | ||||
| dummy_incl_eew_ps | CFD_DUMMY | Dummy | ||||
| last_changed_at | UKM_CMS_LAST_CHANGE_TIME | Changed On |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- SAP Credit Management: Credit Master Data for Partner
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UKMBP_CMS (
CLIENT, -- Client [MANDT]
PARTNER, -- Busn. Partner [BU_PARTNER]
OWN_RATING, -- Score [UKM_OWN_RATING]
CHECK_RULE, -- Check Rule [UKM_CHECK_RULE]
LIMIT_RULE, -- Rules [UKM_LIMIT_RULE]
RATING_VAL_DATE, -- Valid To [UKM_RATING_VALID_DATE]
RATING_CHG_DATE, -- Changed On [UKM_RATING_CHG_DATE]
ALTERNATE_BP, -- Alt. Partner [UKM_ALTERNATE_BP]
OWN_RATING_CALC, -- Calculated [UKM_OWN_RATING_CALC]
RISK_CLASS, -- Risk Class [UKM_RISK_CLASS]
RISK_CLASS_CALC, -- Calculated [UKM_RISK_CLASS_CALC]
RISK_CLASS_CHGDT, -- Changed On [UKM_RISK_CLASS_CHG_DATE]
CREDIT_GROUP, -- Credit Group [UKM_CRED_GROUP]
CUSTOMER_SINCE_YEAR, -- First Year of Customer Relationship [UKM_BUS_REL_SINCE_YEAR]
DUMMY_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
LAST_CHANGED_AT, -- Changed On [UKM_CMS_LAST_CHANGE_TIME]
PRIMARY KEY (CLIENT, PARTNER)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA