SAP table UKM_S_ACCOUNT_DATA (Credit Account Data)

Field Description Data Type Length Decimals Checktable Data Element
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
CREDIT_SGMNT Credit Segment CHAR 10 0 UKMCRED_SGM0C UKM_CREDIT_SGMNT
OWN_RATING Score CHAR 10 0 UKM_OWN_RATING
CHECK_RULE Rule for Credit Check CHAR 10 0 UKM_CHCK_RULE UKM_CHECK_RULE
LIMIT_RULE Rule for Calculating Score and Credit Limit CHAR 10 0 UKM_LIMIT_RULES UKM_LIMIT_RULE
RATING_VAL_DATE Valid To Date DATS 8 0 UKM_RATING_VALID_DATE
RATING_CHG_DATE Change Date for Score DATS 8 0 UKM_RATING_CHG_DATE
ALTERNATE_BP Partner for Credit Account CHAR 10 0 BUT000 UKM_ALTERNATE_BP
OWN_RATING_CALC Calculated Score CHAR 10 0 UKM_OWN_RATING_CALC
RISK_CLASS Risk Class CHAR 3 0 UKM_RISK_CL UKM_RISK_CLASS
RISK_CLASS_CALC Risk Class Calculated CHAR 3 0 UKM_RISK_CL UKM_RISK_CLASS_CALC
RISK_CLASS_CHGDT Risk Class Changed On DATS 8 0 UKM_RISK_CLASS_CHG_DATE
CREDIT_GROUP Customer Credit Group NUMC 4 0 UKM_CUST_GRP UKM_CRED_GROUP
DUMMY_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
CREDIT_LIMIT Credit Limit CURR 15 2 UKM_CREDIT_LIMIT
XBLOCKED Blocked by Credit Management CHAR 1 0 UKM_XBLOCKED
LIMIT_VALID_DATE Valid To Date DATS 8 0 UKM_VALID_DATE
LIMIT_CHG_DATE Change Date for Credit Limit DATS 8 0 UKM_CHG_DATE
COORDINATOR Credit Analyst CHAR 12 0 USR02 UKM_COORDINATOR
CUST_GROUP Customer Credit Group CHAR 10 0 UKM_CUST_GROUP
FOLLOW_UP_DT Resubmission Date DATS 8 0 UKM_FOLLOW_UP_DT
CRED_LIM_CALC Calculated Credit Limit CURR 15 2 UKM_CREDIT_LIMIT_CALC
XCRITICAL Special Attention Required CHAR 1 0 UKM_CRITICAL_ACCOUNT
X_LIMIT_ZERO Limit Is Zero CHAR 1 0 UKM_LIMIT_ZERO
BLOCK_REASON Reason for Block in Credit Management CHAR 2 0 UKM_BL_REASON UKM_BLOCK_REASON
CRED_LIM_REQ Credit Limit Requested CURR 15 2 UKM_CREDIT_LIMIT_REQ
AUTOMATIC_REQ Limit Request from Automatic Calculation CHAR 1 0 UKM_AUTOMATIC_REQUEST
LIM_VAL_DATE_REQ Valid To Date (Requested) DATS 8 0 UKM_VALID_DATE_REQ
REQ_DATE Request Date DATS 8 0 UKM_REQ_DATE
ITEM_ERROR Error Occurred in Liability Update CHAR 1 0 UKM_ITEM_ERROR
LOG_HNDL Application Log: Log Handle CHAR 22 0 BALLOGHNDL
DUMMY_SGM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
X_DUNN_REVOKED Date Invalid CHAR 1 0 UKM_DATA_REVOKED
DUNN_PGUID ID of Highest Dunning Level CHAR 32 0 UKM_DUNN_PGUID
DUNN_MAX_LV Highest Dunning Level of Business Partner CHAR 10 0 UKM_DUNN_MAX_LV
DUNN_AMOUNT Amount CURR 15 2 UKM_AMOUNT
DUNN_CURR Currency Key CUKY 5 0 TCURC WAERS
DUNN_DATE Date of Dunning DATS 8 0 UKM_DUNN_DATE
DUNN_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
DUNN_COUNTER Number of Dunning Notices INT4 10 0 UKM_DUNN_COUNTER
OVDUE_PGUID ID of Overdue Item CHAR 32 0 UKM_OVDUE_PGUID
X_OVDUE_REVOKED Date Invalid CHAR 1 0 UKM_DATA_REVOKED
OVDUE_NET_DATE Net Due Date DATS 8 0 UKM_OVDUE_NET_DATE
OVDUE_DAYS Days in Arrears DEC 3 0 UKM_OVDUE_DAYS
OVDUE_AMOUNT Amount CURR 15 2 UKM_AMOUNT
OVDUE_CURR Currency Key CUKY 5 0 TCURC WAERS
OVDUE_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
X_PAYMNT_REVOKED Date Invalid CHAR 1 0 UKM_DATA_REVOKED
PAYMNT_PGUID Identification of Last Payment CHAR 32 0 UKM_PAYMNT_PGUID
PAYMNT_DATE Date of Last Payment DATS 8 0 UKM_PAYMNT_DATE
PAYMNT_AMOUNT Amount CURR 15 2 UKM_AMOUNT
PAYMNT_CURR Currency Key CUKY 5 0 * WAERS
PAYMNT_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
X_IDX_REVOKED Date Invalid CHAR 1 0 UKM_DATA_REVOKED
IDX_FIGURE Key Figure in FI Summary DEC 6 0 UKM_IDX_FIGURE
IDX_AMOUNT Amount CURR 15 2 UKM_AMOUNT
IDX_CURR Currency Key CUKY 5 0 TCURC WAERS
IDX_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
SL_ARR_WO Average Arrears for Payments Where No Cash Discount Taken DEC 3 0 UKM_SL_ARR_WO
SL_ARR_WO_AMOUNT Gross Total of Cleared Items with Cash Discount Not Taken CURR 15 2 UKM_SL_ARR_WO_AMOUNT
SL_SLARR_W Average Arrears with Cash Discount Payments DEC 3 0 UKM_SL_SLARR_W
SL_ARR_W_AMOUNT Gross Total of Cleared Items Without Cash Discount Loss CURR 15 2 UKM_SL_ARR_W_AMOUNT
SALES_VOL Sales of Last 12 Months CURR 15 2 UKM_SALES_VOL
SALES_MAX Highest Monthly Sales in Last 12 Months CURR 15 2 UKM_SALES_MAX
COL_SUB_PERCENT Percentage Rate of Due Items Submitted for Collection DEC 3 0 UKM_COL_SUB_PERCENT
COL_SUB_AMOUNT Amount of Receivables Transferred to Collection Agency CURR 15 2 UKM_COL_SUBM_AMOUNT
CURRENCY Credit Segment Currency CUKY 5 0 UKM_SGM_CURRENCY
LANGU Language Key LANG 1 0 SPRAS
CREDIT_SEGMENT_DESCRIPTION Name of Credit Segment CHAR 50 0 UKM_CREDIT_SGMNT_TXT
BLOCKING_REASON_DESCRIPTION SAP Credit Management: Description for Blocks CHAR 40 0 UKM_BLOCK_REASON_TXT
RISK_CLASS_DESCRIPTION Name of Risk Class CHAR 40 0 UKM_RISK_CLASS_TXT
HORIZON_AMOUNT Credit Exposure Within Credit Horizon CURR 15 2 UKM_COMM_TOTAL_DYN
HORIZON_DATE End of Credit Horizon DATS 8 0 UKM_CREDIT_HORIZON_DATE
HORIZON_PERCENT Credit Limit Utilization in Percent DEC 9 1 UKM_CREDLIMIT_USED
HORIZON_DAYS Credit Horizon in Days NUMC 3 0 UKM_CREDIT_HORIZON
TOTALS TTYP 0 0 UKM_T_COMMITMENT_TOTALS
PARTNER_UNKNOWN General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)
AUTHORITY_CHECK General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)

UKM_S_ACCOUNT_DATA foreign key relationships

Table Field Check Table Check Field
0 UKM_S_ACCOUNT_DATA ALTERNATE_BP BUT000 BP: General data I PARTNER
1 UKM_S_ACCOUNT_DATA BLOCK_REASON UKM_BL_REASON SAP Credit Management: Reason for Locks in Credit Management BLOCK_REASON
0 UKM_S_ACCOUNT_DATA CHECK_RULE UKM_CHCK_RULE Rule for Credit Check CHECK_RULE
1 UKM_S_ACCOUNT_DATA COORDINATOR USR02 Logon Data (Kernel-Side Use) BNAME
0 UKM_S_ACCOUNT_DATA CREDIT_SGMNT UKMCRED_SGM0C SAP Credit Management: Segment Data CLIENT
0 UKM_S_ACCOUNT_DATA CREDIT_SGMNT UKMCRED_SGM0C SAP Credit Management: Segment Data CREDIT_SGMNT
1 UKM_S_ACCOUNT_DATA DUNN_CURR TCURC Currency Codes MANDT
1 UKM_S_ACCOUNT_DATA DUNN_CURR TCURC Currency Codes WAERS
0 UKM_S_ACCOUNT_DATA IDX_CURR TCURC Currency Codes MANDT
0 UKM_S_ACCOUNT_DATA IDX_CURR TCURC Currency Codes WAERS
1 UKM_S_ACCOUNT_DATA LIMIT_RULE UKM_LIMIT_RULES SAP Credit Management: Rules for Calc. Score and Credit Lim. CLIENT
1 UKM_S_ACCOUNT_DATA LIMIT_RULE UKM_LIMIT_RULES SAP Credit Management: Rules for Calc. Score and Credit Lim. LIMIT_RULE
0 UKM_S_ACCOUNT_DATA OVDUE_CURR TCURC Currency Codes MANDT
0 UKM_S_ACCOUNT_DATA OVDUE_CURR TCURC Currency Codes WAERS