SAP Table UKMBP_CMS_SGM
SAP Credit Management: Master Data for Credit Account
UKMBP_CMS_SGM (SAP Credit Management: Master Data for Credit Account) 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_SGM to other SAP tables.
UKMBP_CMS_SGM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | 0 | |||||||
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | 0 | |||||||
| CREDIT_SGMNT | Credit Segment | UKM_CREDIT_SGMNT | UKMCRED_SGM0C | CHAR | 10 | 0 | ||||||
| CREDIT_LIMIT | Credit Limit | UKM_CREDIT_LIMIT | CURR | 15 | 2 | |||||||
| XBLOCKED | Blocked by Credit Management | UKM_XBLOCKED | CHAR | 1 | 0 |
Possible values
|
||||||
| LIMIT_VALID_DATE | Valid To Date | UKM_VALID_DATE | DATS | 8 | 0 | |||||||
| LIMIT_CHG_DATE | Change Date for Credit Limit | UKM_CHG_DATE | DATS | 8 | 0 | |||||||
| COORDINATOR | Credit Analyst | UKM_COORDINATOR | USR02 | CHAR | 12 | 0 | ||||||
| CUST_GROUP | Customer Credit Group | UKM_CUST_GROUP | CHAR | 10 | 0 | |||||||
| FOLLOW_UP_DT | Resubmission Date | UKM_FOLLOW_UP_DT | DATS | 8 | 0 | |||||||
| CRED_LIM_CALC | Calculated Credit Limit | UKM_CREDIT_LIMIT_CALC | CURR | 15 | 2 | |||||||
| XCRITICAL | Special Attention Required | UKM_CRITICAL_ACCOUNT | CHAR | 1 | 0 |
Possible values
|
||||||
| X_LIMIT_ZERO | Limit is Zero | UKM_LIMIT_ZERO | CHAR | 1 | 0 |
Possible values
|
||||||
| BLOCK_REASON | Reason for Block in Credit Management | UKM_BLOCK_REASON | UKM_BL_REASON | CHAR | 2 | 0 | ||||||
| CRED_LIM_REQ | Credit Limit Requested | UKM_CREDIT_LIMIT_REQ | CURR | 15 | 2 | |||||||
| AUTOMATIC_REQ | Limit Request from Automatic Calculation | UKM_AUTOMATIC_REQUEST | CHAR | 1 | 0 |
Possible values
|
||||||
| LIM_VAL_DATE_REQ | Valid To Date (Requested) | UKM_VALID_DATE_REQ | DATS | 8 | 0 | |||||||
| REQ_DATE | Request Date | UKM_REQ_DATE | DATS | 8 | 0 | |||||||
| ITEM_ERROR | Error Occurred in Liability Update | UKM_ITEM_ERROR | CHAR | 1 | 0 |
Possible values
|
||||||
| LOG_HNDL | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | 0 | |||||||
UKMBP_CMS_SGM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| UKMBP_CMS_SGM | BLOCK_REASON | SYST | MANDT | UKM_BL_REASON | SAP Credit Management: Reason for Locks in Credit Management | CLIENT |
| UKMBP_CMS_SGM | BLOCK_REASON | UKMBP_CMS_SGM | BLOCK_REASON | UKM_BL_REASON | SAP Credit Management: Reason for Locks in Credit Management | BLOCK_REASON |
| UKMBP_CMS_SGM | COORDINATOR | SYST | MANDT | USR02 | Logon Data (Kernel-Side Use) | MANDT |
| UKMBP_CMS_SGM | COORDINATOR | UKMBP_CMS_SGM | COORDINATOR | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| UKMBP_CMS_SGM | CREDIT_SGMNT | UKMBP_CMS_SGM | CLIENT | UKMCRED_SGM0C | SAP Credit Management: Segment Data | CLIENT |
| UKMBP_CMS_SGM | CREDIT_SGMNT | UKMBP_CMS_SGM | CREDIT_SGMNT | UKMCRED_SGM0C | SAP Credit Management: Segment Data | CREDIT_SGMNT |
