SAP ABAP Table UKM_S_ACCOUNT_DATA (Credit Account Data)

Hierarchy

☛ FINBASIS (Software Component) Fin. Basis
   ⤷ FIN-FSCM-CR-CR (Application Component) Basic Functions
     ⤷ UKM_BUSINESS_PARTNER (Package) SAP Credit Management - Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	UKM_S_ACCOUNT_DATA	Table Relationship Diagram
Short Description	Credit Account Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	SAP Credit Management: Credit Account Key
2	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	CREDIT_SGMNT	☐	UKM_CREDIT_SGMNT	UKM_CREDIT_SGMNT	CHAR	10	0	Credit Segment	*
4	.INCLUDE	☐				0	0	SAP Credit Management: Business Partner Data
5	OWN_RATING	☐	UKM_OWN_RATING	CHAR10	CHAR	10	0	Score
6	CHECK_RULE	☐	UKM_CHECK_RULE	CHAR10	CHAR	10	0	Rule for Credit Check	UKM_CHCK_RULE
7	LIMIT_RULE	☐	UKM_LIMIT_RULE	CHAR10	CHAR	10	0	Rule for Calculating Score and Credit Limit	UKM_LIMIT_RULES
8	RATING_VAL_DATE	☐	UKM_RATING_VALID_DATE	DATS	DATS	8	0	Valid To Date
9	RATING_CHG_DATE	☐	UKM_RATING_CHG_DATE	DATS	DATS	8	0	Change Date for Score
10	ALTERNATE_BP	☐	UKM_ALTERNATE_BP	BU_PARTNER	CHAR	10	0	Partner for Credit Account	BUT000
11	OWN_RATING_CALC	☐	UKM_OWN_RATING_CALC	CHAR10	CHAR	10	0	Rule for Calculating Score
12	RISK_CLASS	☐	UKM_RISK_CLASS	UKM_RISK_CLASS	CHAR	3	0	Risk Class	UKM_RISK_CL
13	RISK_CLASS_CALC	☐	UKM_RISK_CLASS_CALC	UKM_RISK_CLASS	CHAR	3	0	Risk Class Calculated	UKM_RISK_CL
14	RISK_CLASS_CHGDT	☐	UKM_RISK_CLASS_CHG_DATE	DATS	DATS	8	0	Risk Class Changed On
15	CREDIT_GROUP	☐	UKM_CRED_GROUP	UKM_CRED_GROUP	NUMC	4	0	Customer Credit Group	UKM_CUST_GRP
16	.INCLUDE	☐				0	0	SAP Credit Management: Master Data for Credit Account
17	CREDIT_LIMIT	☐	UKM_CREDIT_LIMIT	UKM_CREDIT_LIMIT	CURR	15	2	Credit Limit
18	XBLOCKED	☐	UKM_XBLOCKED	XFELD	CHAR	1	0	Blocked by Credit Management
19	LIMIT_VALID_DATE	☐	UKM_VALID_DATE	DATS	DATS	8	0	Valid To Date
20	LIMIT_CHG_DATE	☐	UKM_CHG_DATE	DATS	DATS	8	0	Change Date for Credit Limit
21	COORDINATOR	☐	UKM_COORDINATOR	XUBNAME	CHAR	12	0	Credit Analyst	USR02
22	CUST_GROUP	☐	UKM_CUST_GROUP	CHAR10	CHAR	10	0	Customer Credit Group
23	FOLLOW_UP_DT	☐	UKM_FOLLOW_UP_DT	DATS	DATS	8	0	Resubmission Date
24	CRED_LIM_CALC	☐	UKM_CREDIT_LIMIT_CALC	UKM_CREDIT_LIMIT	CURR	15	2	Calculated Credit Limit
25	XCRITICAL	☐	UKM_CRITICAL_ACCOUNT	XFELD	CHAR	1	0	Special Attention Required
26	X_LIMIT_ZERO	☐	UKM_LIMIT_ZERO	XFELD	CHAR	1	0	Limit is Zero
27	BLOCK_REASON	☐	UKM_BLOCK_REASON	UKM_BLOCK_REASON	CHAR	2	0	Reason for Block in Credit Management	UKM_BL_REASON
28	CRED_LIM_REQ	☐	UKM_CREDIT_LIMIT_REQ	UKM_CREDIT_LIMIT	CURR	15	2	Credit Limit Requested
29	AUTOMATIC_REQ	☐	UKM_AUTOMATIC_REQUEST	XFELD	CHAR	1	0	Limit Request from Automatic Calculation
30	LIM_VAL_DATE_REQ	☐	UKM_VALID_DATE_REQ	DATS	DATS	8	0	Valid To Date (Requested)
31	REQ_DATE	☐	UKM_REQ_DATE	DATS	DATS	8	0	Request Date
32	ITEM_ERROR	☐	UKM_ITEM_ERROR	XFELD	CHAR	1	0	Error Occurred in Liability Update
33	LOG_HNDL	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
34	.INCLUDE	☐				0	0	SAP Credit Management: FI Summary Data
35	.INCLUDE	☐				0	0	SAP Credit Management: FI Summary Data
36	X_DUNN_REVOKED	☐	UKM_DATA_REVOKED	XFELD	CHAR	1	0	Date Invalid
37	DUNN_PGUID	☐	UKM_DUNN_PGUID	SCPR_GUID	CHAR	32	0	ID of Highest Dunning Level
38	DUNN_MAX_LV	☐	UKM_DUNN_MAX_LV	UKM_DUNN_MAX_LV	CHAR	10	0	Highest Dunning Level of Business Partner
39	DUNN_AMOUNT	☐	UKM_AMOUNT	WERTV8	CURR	15	2	Amount
40	DUNN_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
41	DUNN_DATE	☐	UKM_DUNN_DATE	DATS	DATS	8	0	Date of Dunning
42	DUNN_TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
43	DUNN_COUNTER	☐	UKM_DUNN_COUNTER	INT4	INT4	10	0	Number of Dunning Notices
44	.INCLUDE	☐				0	0	SAP Credit Management: FI Summary Data
45	OVDUE_PGUID	☐	UKM_OVDUE_PGUID	SCPR_GUID	CHAR	32	0	ID of Overdue Item
46	X_OVDUE_REVOKED	☐	UKM_DATA_REVOKED	XFELD	CHAR	1	0	Date Invalid
47	OVDUE_NET_DATE	☐	UKM_OVDUE_NET_DATE	DATS	DATS	8	0	Net Due Date
48	OVDUE_DAYS	☐	UKM_OVDUE_DAYS	DEC3	DEC	3	0	Days in Arrears
49	OVDUE_AMOUNT	☐	UKM_AMOUNT	WERTV8	CURR	15	2	Amount
50	OVDUE_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
51	OVDUE_TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
52	.INCLUDE	☐				0	0	SAP Credit Management: FI Summary Data
53	X_PAYMNT_REVOKED	☐	UKM_DATA_REVOKED	XFELD	CHAR	1	0	Date Invalid
54	PAYMNT_PGUID	☐	UKM_PAYMNT_PGUID	SCPR_GUID	CHAR	32	0	Identification of Last Payment
55	PAYMNT_DATE	☐	UKM_PAYMNT_DATE	DATS	DATS	8	0	Date of Last Payment
56	PAYMNT_AMOUNT	☐	UKM_AMOUNT	WERTV8	CURR	15	2	Amount
57	PAYMNT_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
58	PAYMNT_TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
59	.INCLUDE	☐				0	0	SAP Credit Management: FI Summary Data
60	X_IDX_REVOKED	☐	UKM_DATA_REVOKED	XFELD	CHAR	1	0	Date Invalid
61	IDX_FIGURE	☐	UKM_IDX_FIGURE	DEC6	DEC	6	0	Key Figure in FI Summary
62	IDX_AMOUNT	☐	UKM_AMOUNT	WERTV8	CURR	15	2	Amount
63	IDX_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
64	IDX_TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
65	SL_ARR_WO	☐	UKM_SL_ARR_WO	UKM_DEC3	DEC	3	0	Average arrears with payments without cash discount taken
66	SL_ARR_WO_AMOUNT	☐	UKM_SL_ARR_WO_AMOUNT	WERTV8	CURR	15	2	Gross Total of Cleared Items with Cash Discount Not Taken
67	SL_SLARR_W	☐	UKM_SL_SLARR_W	UKM_DEC3	DEC	3	0	Average Arrears with Cash Discount Payments
68	SL_ARR_W_AMOUNT	☐	UKM_SL_ARR_W_AMOUNT	WERTV8	CURR	15	2	Gross Total of Cleared Items without Cash Discount Loss
69	SALES_VOL	☐	UKM_SALES_VOL	WERTV8	CURR	15	2	Sales of Last 12 Months
70	SALES_MAX	☐	UKM_SALES_MAX	WERTV8	CURR	15	2	Highest Monthly Sales in Last 12 Months
71	CURRENCY	☐	UKM_SGM_CURRENCY	WAERS	CUKY	5	0	Credit Segment Currency	*
72	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
73	CREDIT_SEGMENT_DESCRIPTION	☐	UKM_CREDIT_SGMNT_TXT	TEXT50	CHAR	50	0	Name of Credit Segment
74	BLOCKING_REASON_DESCRIPTION	☐	UKM_BLOCK_REASON_TXT	TEXT40	CHAR	40	0	SAP Credit Management: Description for Blocks
75	RISK_CLASS_DESCRIPTION	☐	UKM_RISK_CLASS_TXT	TEXT40	CHAR	40	0	Name of Risk Class
76	HORIZON_AMOUNT	☐	UKM_COMM_TOTAL_DYN	UKM_EXP_SALES_VOLUME	CURR	15	2	Credit Exposure Within Credit Horizon
77	HORIZON_DATE	☐	UKM_CREDIT_HORIZON_DATE	DATS	DATS	8	0	End of Credit Horizon
78	HORIZON_PERCENT	☐	UKM_CREDLIMIT_USED	UKM_PROZENT	DEC	9	1	Credit Limit Utilization in Percent
79	HORIZON_DAYS	☐	UKM_CREDIT_HORIZON	NUMC3	NUMC	3	0	Credit Horizon in Days
80	TOTALS	☐	UKM_T_COMMITMENT_TOTALS		TTYP	0	0
81	PARTNER_UNKNOWN	☐	FLAG	FLAG	CHAR	1	0	General Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UKM_S_ACCOUNT_DATA	ALTERNATE_BP	BUT000	PARTNER	KEY
2	UKM_S_ACCOUNT_DATA	BLOCK_REASON	UKM_BL_REASON	BLOCK_REASON		C	C
3	UKM_S_ACCOUNT_DATA	CHECK_RULE	UKM_CHCK_RULE	CHECK_RULE
4	UKM_S_ACCOUNT_DATA	COORDINATOR	USR02	BNAME
5	UKM_S_ACCOUNT_DATA	CREDIT_GROUP	UKM_CUST_GRP	CRED_GROUP
6	UKM_S_ACCOUNT_DATA	DUNN_CURR	TCURC	WAERS
7	UKM_S_ACCOUNT_DATA	IDX_CURR	TCURC	WAERS
8	UKM_S_ACCOUNT_DATA	LIMIT_RULE	UKM_LIMIT_RULES	LIMIT_RULE	KEY
9	UKM_S_ACCOUNT_DATA	OVDUE_CURR	TCURC	WAERS
10	UKM_S_ACCOUNT_DATA	RISK_CLASS	UKM_RISK_CL	RISK_CLASS	KEY
11	UKM_S_ACCOUNT_DATA	RISK_CLASS_CALC	UKM_RISK_CL	RISK_CLASS	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in