1. Home
  2. Resources
  3. SAP Tables
  4. UKM_S_CMS_SGM_BW - Extract Structure of Segment Data for BW

SAP Table UKM_S_CMS_SGM_BW

Extract Structure of Segment Data for BW

UKM_S_CMS_SGM_BW (Extract Structure of Segment Data for BW) 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 UKM_S_CMS_SGM_BW to other SAP tables.

UKM_S_CMS_SGM_BW 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
X Yes
NULL No
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
X Yes
NULL No
X_LIMIT_ZERO Limit is Zero UKM_LIMIT_ZERO CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
LOG_HNDL Application Log: Log Handle BALLOGHNDL CHAR 22 0
CURRENCY Currency Key WAERS CUKY 5 0
COORD_GROUP Business Partner Number BU_PARTNER CHAR 10 0

UKM_S_CMS_SGM_BW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
UKM_S_CMS_SGM_BW BLOCK_REASON UKM_S_CMS_SGM_BW BLOCK_REASON UKM_BL_REASON SAP Credit Management: Reason for Locks in Credit Management BLOCK_REASON
UKM_S_CMS_SGM_BW BLOCK_REASON SYST MANDT UKM_BL_REASON SAP Credit Management: Reason for Locks in Credit Management CLIENT
UKM_S_CMS_SGM_BW COORDINATOR SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
UKM_S_CMS_SGM_BW COORDINATOR UKM_S_CMS_SGM_BW COORDINATOR USR02 Logon Data (Kernel-Side Use) BNAME
UKM_S_CMS_SGM_BW CREDIT_SGMNT UKM_S_CMS_SGM_BW CLIENT UKMCRED_SGM0C SAP Credit Management: Segment Data CLIENT
UKM_S_CMS_SGM_BW CREDIT_SGMNT UKM_S_CMS_SGM_BW CREDIT_SGMNT UKMCRED_SGM0C SAP Credit Management: Segment Data CREDIT_SGMNT