1. Home
  2. Resources
  3. SAP Tables
  4. UKM_S_ACCOUNT_DATA - Credit Account Data

SAP Table UKM_S_ACCOUNT_DATA

Credit Account Data

UKM_S_ACCOUNT_DATA (Credit Account Data) 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_ACCOUNT_DATA to other SAP tables.

UKM_S_ACCOUNT_DATA table fields

Field Data element Checktable Datatype Length Decimals
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
CREDIT_SGMNT Credit Segment UKM_CREDIT_SGMNT UKMCRED_SGM0C 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
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
X_DUNN_REVOKED Date Invalid UKM_DATA_REVOKED CHAR 1 0
X Yes
NULL No
DUNN_PGUID ID of Highest Dunning Level UKM_DUNN_PGUID CHAR 32 0
DUNN_MAX_LV Highest Dunning Level of Business Partner UKM_DUNN_MAX_LV CHAR 10 0
DUNN_AMOUNT Amount UKM_AMOUNT CURR 15 2
DUNN_CURR Currency Key WAERS TCURC CUKY 5 0
DUNN_DATE Date of Dunning UKM_DUNN_DATE DATS 8 0
DUNN_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
DUNN_COUNTER Number of Dunning Notices UKM_DUNN_COUNTER INT4 10 0
OVDUE_PGUID ID of Overdue Item UKM_OVDUE_PGUID CHAR 32 0
X_OVDUE_REVOKED Date Invalid UKM_DATA_REVOKED CHAR 1 0
X Yes
NULL No
OVDUE_NET_DATE Net Due Date UKM_OVDUE_NET_DATE DATS 8 0
OVDUE_DAYS Days in Arrears UKM_OVDUE_DAYS DEC 3 0
OVDUE_AMOUNT Amount UKM_AMOUNT CURR 15 2
OVDUE_CURR Currency Key WAERS TCURC CUKY 5 0
OVDUE_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
X_PAYMNT_REVOKED Date Invalid UKM_DATA_REVOKED CHAR 1 0
X Yes
NULL No
PAYMNT_PGUID Identification of Last Payment UKM_PAYMNT_PGUID CHAR 32 0
PAYMNT_DATE Date of Last Payment UKM_PAYMNT_DATE DATS 8 0
PAYMNT_AMOUNT Amount UKM_AMOUNT CURR 15 2
PAYMNT_CURR Currency Key WAERS CUKY 5 0
PAYMNT_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
X_IDX_REVOKED Date Invalid UKM_DATA_REVOKED CHAR 1 0
X Yes
NULL No
IDX_FIGURE Key Figure in FI Summary UKM_IDX_FIGURE DEC 6 0
IDX_AMOUNT Amount UKM_AMOUNT CURR 15 2
IDX_CURR Currency Key WAERS TCURC CUKY 5 0
IDX_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
SL_ARR_WO Average arrears with payments without cash discount taken UKM_SL_ARR_WO DEC 3 0
SL_ARR_WO_AMOUNT Gross Total of Cleared Items with Cash Discount Not Taken UKM_SL_ARR_WO_AMOUNT CURR 15 2
SL_SLARR_W Average Arrears with Cash Discount Payments UKM_SL_SLARR_W DEC 3 0
SL_ARR_W_AMOUNT Gross Total of Cleared Items without Cash Discount Loss UKM_SL_ARR_W_AMOUNT CURR 15 2
SALES_VOL Sales of Last 12 Months UKM_SALES_VOL CURR 15 2
SALES_MAX Highest Monthly Sales in Last 12 Months UKM_SALES_MAX CURR 15 2
COL_SUB_PERCENT Percentage Rate of Due Items Submitted for Collection UKM_COL_SUB_PERCENT DEC 3 0
COL_SUB_AMOUNT Amount of Receivables Transferred to Collection Agency UKM_COL_SUBM_AMOUNT CURR 15 2
CURRENCY Credit Segment Currency UKM_SGM_CURRENCY CUKY 5 0
LANGU Language Key SPRAS LANG 1 0
CREDIT_SEGMENT_DESCRIPTION Name of Credit Segment UKM_CREDIT_SGMNT_TXT CHAR 50 0
BLOCKING_REASON_DESCRIPTION SAP Credit Management: Description for Blocks UKM_BLOCK_REASON_TXT CHAR 40 0
RISK_CLASS_DESCRIPTION Name of Risk Class UKM_RISK_CLASS_TXT CHAR 40 0
HORIZON_AMOUNT Credit Exposure Within Credit Horizon UKM_COMM_TOTAL_DYN CURR 15 2
HORIZON_DATE End of Credit Horizon UKM_CREDIT_HORIZON_DATE DATS 8 0
HORIZON_PERCENT Credit Limit Utilization in Percent UKM_CREDLIMIT_USED DEC 9 1
HORIZON_DAYS Credit Horizon in Days UKM_CREDIT_HORIZON NUMC 3 0
TOTALS UKM_T_COMMITMENT_TOTALS TTYP 0 0
PARTNER_UNKNOWN General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
AUTHORITY_CHECK General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set

UKM_S_ACCOUNT_DATA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
UKM_S_ACCOUNT_DATA ALTERNATE_BP SYST MANDT BUT000 BP: General data I CLIENT
UKM_S_ACCOUNT_DATA ALTERNATE_BP UKM_S_ACCOUNT_DATA ALTERNATE_BP BUT000 BP: General data I PARTNER
UKM_S_ACCOUNT_DATA BLOCK_REASON SYST MANDT UKM_BL_REASON SAP Credit Management: Reason for Locks in Credit Management CLIENT
UKM_S_ACCOUNT_DATA BLOCK_REASON UKM_S_ACCOUNT_DATA BLOCK_REASON UKM_BL_REASON SAP Credit Management: Reason for Locks in Credit Management BLOCK_REASON
UKM_S_ACCOUNT_DATA CHECK_RULE SYST MANDT UKM_CHCK_RULE Rule for Credit Check CLIENT
UKM_S_ACCOUNT_DATA CHECK_RULE UKM_S_ACCOUNT_DATA CHECK_RULE UKM_CHCK_RULE Rule for Credit Check CHECK_RULE
UKM_S_ACCOUNT_DATA COORDINATOR SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
UKM_S_ACCOUNT_DATA COORDINATOR UKM_S_ACCOUNT_DATA COORDINATOR USR02 Logon Data (Kernel-Side Use) BNAME
UKM_S_ACCOUNT_DATA CREDIT_GROUP UKM_S_ACCOUNT_DATA CREDIT_GROUP UKM_CUST_GRP Customer Credit Groups CRED_GROUP
UKM_S_ACCOUNT_DATA CREDIT_GROUP SYST MANDT UKM_CUST_GRP Customer Credit Groups CLIENT
UKM_S_ACCOUNT_DATA CREDIT_SGMNT SYST MANDT UKMCRED_SGM0C SAP Credit Management: Segment Data CLIENT
UKM_S_ACCOUNT_DATA CREDIT_SGMNT UKM_S_ACCOUNT_DATA CREDIT_SGMNT UKMCRED_SGM0C SAP Credit Management: Segment Data CREDIT_SGMNT
UKM_S_ACCOUNT_DATA DUNN_CURR SYST MANDT TCURC Currency Codes MANDT
UKM_S_ACCOUNT_DATA DUNN_CURR UKM_S_ACCOUNT_DATA DUNN_CURR TCURC Currency Codes WAERS
UKM_S_ACCOUNT_DATA IDX_CURR SYST MANDT TCURC Currency Codes MANDT
UKM_S_ACCOUNT_DATA IDX_CURR UKM_S_ACCOUNT_DATA IDX_CURR TCURC Currency Codes WAERS
UKM_S_ACCOUNT_DATA LIMIT_RULE SYST MANDT UKM_LIMIT_RULES SAP Credit Management: Rules for Calc. Score and Credit Lim. CLIENT
UKM_S_ACCOUNT_DATA LIMIT_RULE UKM_S_ACCOUNT_DATA LIMIT_RULE UKM_LIMIT_RULES SAP Credit Management: Rules for Calc. Score and Credit Lim. LIMIT_RULE
UKM_S_ACCOUNT_DATA OVDUE_CURR SYST MANDT TCURC Currency Codes MANDT
UKM_S_ACCOUNT_DATA OVDUE_CURR UKM_S_ACCOUNT_DATA OVDUE_CURR TCURC Currency Codes WAERS
UKM_S_ACCOUNT_DATA RISK_CLASS SYST MANDT UKM_RISK_CL SAP Credit Management: Risk Class CLIENT
UKM_S_ACCOUNT_DATA RISK_CLASS UKM_S_ACCOUNT_DATA RISK_CLASS UKM_RISK_CL SAP Credit Management: Risk Class RISK_CLASS
UKM_S_ACCOUNT_DATA RISK_CLASS_CALC SYST MANDT UKM_RISK_CL SAP Credit Management: Risk Class CLIENT
UKM_S_ACCOUNT_DATA RISK_CLASS_CALC UKM_S_ACCOUNT_DATA RISK_CLASS_CALC UKM_RISK_CL SAP Credit Management: Risk Class RISK_CLASS