SAP Table UKMBP_CMS
SAP Credit Management: Credit Master Data for Partner
UKMBP_CMS (SAP Credit Management: Credit Master Data for Partner) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link UKMBP_CMS to other SAP tables.
UKMBP_CMS table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | 0 | |||
OWN_RATING | Score | UKM_OWN_RATING | CHAR | 10 | 0 | |||
CHECK_RULE | Rule for Credit Check | UKM_CHECK_RULE | UKM_CHCK_RULE | CHAR | 10 | 0 | ||
LIMIT_RULE | Rule for Calculating Score and Credit Limit | UKM_LIMIT_RULE | UKM_LIMIT_RULES | CHAR | 10 | 0 | ||
RATING_VAL_DATE | Valid To Date | UKM_RATING_VALID_DATE | DATS | 8 | 0 | |||
RATING_CHG_DATE | Change Date for Score | UKM_RATING_CHG_DATE | DATS | 8 | 0 | |||
ALTERNATE_BP | Partner for Credit Account | UKM_ALTERNATE_BP | BUT000 | CHAR | 10 | 0 | ||
OWN_RATING_CALC | Rule for Calculating Score | UKM_OWN_RATING_CALC | CHAR | 10 | 0 | |||
RISK_CLASS | Risk Class | UKM_RISK_CLASS | UKM_RISK_CL | CHAR | 3 | 0 | ||
RISK_CLASS_CALC | Risk Class Calculated | UKM_RISK_CLASS_CALC | UKM_RISK_CL | CHAR | 3 | 0 | ||
RISK_CLASS_CHGDT | Risk Class Changed On | UKM_RISK_CLASS_CHG_DATE | DATS | 8 | 0 | |||
CREDIT_GROUP | Customer Credit Group | UKM_CRED_GROUP | UKM_CUST_GRP | NUMC | 4 | 0 |
UKMBP_CMS foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
UKMBP_CMS | ALTERNATE_BP | SYST | MANDT | BUT000 | BP: General data I | CLIENT |
UKMBP_CMS | ALTERNATE_BP | UKMBP_CMS | ALTERNATE_BP | BUT000 | BP: General data I | PARTNER |
UKMBP_CMS | CHECK_RULE | SYST | MANDT | UKM_CHCK_RULE | Rule for Credit Check | CLIENT |
UKMBP_CMS | CHECK_RULE | UKMBP_CMS | CHECK_RULE | UKM_CHCK_RULE | Rule for Credit Check | CHECK_RULE |
UKMBP_CMS | CLIENT | UKMBP_CMS | CLIENT | T000 | Clients | MANDT |
UKMBP_CMS | CREDIT_GROUP | UKMBP_CMS | CREDIT_GROUP | UKM_CUST_GRP | Customer Credit Groups | CRED_GROUP |
UKMBP_CMS | CREDIT_GROUP | SYST | MANDT | UKM_CUST_GRP | Customer Credit Groups | CLIENT |
UKMBP_CMS | LIMIT_RULE | SYST | MANDT | UKM_LIMIT_RULES | SAP Credit Management: Rules for Calc. Score and Credit Lim. | CLIENT |
UKMBP_CMS | LIMIT_RULE | UKMBP_CMS | LIMIT_RULE | UKM_LIMIT_RULES | SAP Credit Management: Rules for Calc. Score and Credit Lim. | LIMIT_RULE |
UKMBP_CMS | RISK_CLASS | SYST | MANDT | UKM_RISK_CL | SAP Credit Management: Risk Class | CLIENT |
UKMBP_CMS | RISK_CLASS | UKMBP_CMS | RISK_CLASS | UKM_RISK_CL | SAP Credit Management: Risk Class | RISK_CLASS |
UKMBP_CMS | RISK_CLASS_CALC | SYST | MANDT | UKM_RISK_CL | SAP Credit Management: Risk Class | CLIENT |
UKMBP_CMS | RISK_CLASS_CALC | UKMBP_CMS | RISK_CLASS_CALC | UKM_RISK_CL | SAP Credit Management: Risk Class | RISK_CLASS |