SAP ABAP Table CRMT_XI_CREDIT_MASTER_DATA (Credit Master Data for Credit Account)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-CM (Application Component) Credit Management
     ⤷ CRM_CREDIT_MGMT (Package) Credit Management

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_XI_CREDIT_MASTER_DATA	Table Relationship Diagram
Short Description	Credit Master Data for Credit Account

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	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
2	CREDIT_SGMNT	☐	CRMT_CREDIT_SGMNT	CRM_CREDIT_SGMNT	CHAR	10	0	Credit Segment
3	CREDIT_SGMNT_TXT	☐	CRMT_CREDIT_SGMNT_TXT	TEXT50	CHAR	50	0	Text for Credit Segment
4	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
5	CREDIT_LIMIT	☐	CRMT_CREDIT_LIMIT	CRM_CREDIT_LIMIT	CURR	15	2	Credit Limit
6	CR_LIMIT_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
7	CR_LIMIT_END_DATE	☐	CRMT_CREDIT_VALID_DATE	DATS	DATS	8	0	Valid-to Date
8	CR_LIMIT_START_DATE	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
9	CR_LIMIT_START_TIME	☐	CRMT_START_TIME	UZEIT	TIMS	6	0	Start Time
10	CR_LIMIT_END_TIME	☐	CRMT_END_TIME	UZEIT	TIMS	6	0	End (Time)
11	CR_LIMIT_DURATION	☐	SDURATION		STRU	0	0
12	YEARS	☐			INT4	10	0
13	MONTHS	☐			INT4	10	0
14	DAYS	☐			INT4	10	0
15	HOURS	☐			INT4	10	0
16	MINUTES	☐			INT4	10	0
17	SECONDS	☐	SDURATION_SECONDS		DEC	14	3	Duration in Sec.
18	XBLOCKED	☐	CRMT_CREDIT_XBLOCKED	XFELD	CHAR	1	0	Blocked By Credit Management
19	BLOCK_REASON	☐	CRMT_CREDIT_BLOCK_REASON	CHAR2	CHAR	2	0	Reason for lock in credit management
20	BLOCK_REASON_TXT	☐	CRMT_CREDIT_BLOCK_REASON_TXT	TEXT40	CHAR	40	0	SAP credit management: Description for lock
21	XCRITICAL	☐	CRMT_CREDIT_CRITICAL_ACCOUNT	XFELD	CHAR	1	0	Special attention advisable
22	CR_EXPOSURE_PERCENT	☐	CRMT_CREDLIMIT_USED_PERCENT	CRM_CREDLIMIT_USED_PERCENT	DEC	9	1	Utilization of Credit Limit in Percent
23	CREDIT_EXPOSURE	☐	CRMT_CREDIT_COMM_TOTAL	WRTV7	CURR	13	2	Credit Exposure in Credit Segment Currency
24	CR_EXPOSURE_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
25	CR_EXPOSURE_HORIZON_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
26	PAYMNT_PGUID	☐	CRMT_CREDIT_PAYMNT_PGUID	CRM_GUID	CHAR	32	0	Item ID for Last Payment
27	PAYMNT_DATE	☐	CRMT_CREDIT_PAYMNT_DATE	DATS	DATS	8	0	Date of Last Payment
28	PAYMNT_AMOUNT	☐	CRMT_CREDIT_AMOUNT	WERTV8	CURR	15	2	Amount
29	PAYMNT_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
30	PAYMNT_TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
31	OVDUE_PGUID	☐	CRMT_CREDIT_OVDUE_PGUID	CRM_GUID	CHAR	32	0	Item ID of Overdue Items
32	OVDUE_NET_DATE	☐	CRMT_CREDIT_OVDUE_NET_DATE	DATS	DATS	8	0	Net Due Date (Oldest Open item)
33	OVDUE_DAYS	☐	CRMT_CREDIT_OVDUE_DAYS	DEC3	DEC	3	0	Days in Arrears (Oldest Open Item)
34	OVDUE_AMOUNT	☐	CRMT_CREDIT_AMOUNT	WERTV8	CURR	15	2	Amount
35	OVDUE_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
36	OVDUE_TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
37	OVDUE_OPEN_ITEMS_PERCENT	☐	DEC16_3	DEC16_3K	DEC	16	3	Decimal number, 16 digits, three after decimal point
38	DAYS_OF_SALES_OUTSTANDING	☐	CRMT_CREDIT_IDX_FIGURE	DEC6	DEC	6	0	Key Figure in A/R Summary
39	DUNN_PGUID	☐	CRMT_CREDIT_DUNN_PGUID	CRM_GUID	CHAR	32	0	ID for Item with Highest Dunning Level
40	DUNN_MAX_LV	☐	CRMT_CREDIT_DUNN_MAX_LV	CRM_CREDIT_DUNN_MAX_LV	CHAR	10	0	Business partner's highest dunning level
41	DUNN_AMOUNT	☐	CRMT_CREDIT_AMOUNT	WERTV8	CURR	15	2	Amount
42	DUNN_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
43	DUNN_DATE	☐	CRMT_CREDIT_DUNN_DATE	DATS	DATS	8	0	Date of dunning notice
44	DUNN_TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
45	DUNN_COUNTER	☐	CRMT_CREDIT_DUNN_COUNTER	INT4	INT4	10	0	Number of dunning notices
46	IDX_FIGURE	☐	CRMT_CREDIT_IDX_FIGURE	DEC6	DEC	6	0	Key Figure in A/R Summary
47	IDX_AMOUNT	☐	CRMT_CREDIT_AMOUNT	WERTV8	CURR	15	2	Amount
48	IDX_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
49	IDX_TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
50	SALES_VOL	☐	CRMT_CREDIT_SALES_MAX	WERTV8	CURR	15	2	Maximum Turnover in Last 12 Months
51	SALES_MAX	☐	CRMT_CREDIT_SALES_VOL	WERTV8	CURR	15	2	Turnover in Last 12 Months
52	SL_ARR_WO	☐	CRMT_CREDIT_SL_ARR_WO	CRM_CREDIT_SL_ARR_WO	DEC	3	0	Average Days in Arrears for Payments w/Cash Discount Waiver
53	SL_ARR_WO_AMOUNT	☐	CRMT_CREDIT_SL_ARR_WO_AMOUNT	WERTV8	CURR	15	2	Gross Total of Cleared Items with Cash Discount Waiver
54	SL_SLARR_W	☐	CRMT_CREDIT_SL_SLARR_W	CRM_CREDIT_DEC3	DEC	3	0	Average Days in Arrears for Cash Discount Payments
55	SL_ARR_W_AMOUNT	☐	CRMT_CREDIT_SL_ARR_W_AMOUNT	WERTV8	CURR	15	2	Gross Total of Cleared Items Without Lost Cash Discount
56	SL_CURRENCY_	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
57	COL_SUB_PERCENT	☐	CRMT_CREDIT_COL_SUB_PERCENT		DEC	3	0	Percentage Rate of Due Items Submitted for Collection
58	COL_SUB_AMOUNT	☐	CRMT_CREDIT_COL_SUBM_AMOUNT	WERTV8	CURR	15	2	Amount of Receivables Submitted to Collection Agency
59	OWN_RATING	☐	CRMT_CREDIT_OWN_RATING	CHAR10	CHAR	10	0	Internal Creditworthiness
60	RATING_END_DATE	☐	CRMT_CREDIT_RATING_VALID_DATE	DATS	DATS	8	0	Valid-to Date
61	RATING_START_DATE	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
62	RATING_DURATION	☐	SDURATION		STRU	0	0
63	YEARS	☐			INT4	10	0
64	MONTHS	☐			INT4	10	0
65	DAYS	☐			INT4	10	0
66	HOURS	☐			INT4	10	0
67	MINUTES	☐			INT4	10	0
68	SECONDS	☐	SDURATION_SECONDS		DEC	14	3	Duration in Sec.
69	RATING_START_TIME	☐	CRMT_START_TIME	UZEIT	TIMS	6	0	Start Time
70	RATING_END_TIME	☐	CRMT_END_TIME	UZEIT	TIMS	6	0	End (Time)
71	RISK_CLASS	☐	CRMT_CREDIT_RISK_CLASS	CRM_CREDIT_RISK_CLASS	CHAR	3	0	Risk Class	*
72	RISK_CLASS_TXT	☐	CRMT_CREDIT_RISK_CLASS_TXT	TEXT40	CHAR	40	0	Text for Risk Class
73	RISK_CLASS_START_DATE	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
74	RISK_CLASS_END_DATE	☐	CRMT_CREDIT_RATING_VALID_DATE	DATS	DATS	8	0	Valid-to Date
75	RISK_CLASS_START_TIME	☐	CRMT_START_TIME	UZEIT	TIMS	6	0	Start Time
76	RISK_CLASS_END_TIME	☐	CRMT_END_TIME	UZEIT	TIMS	6	0	End (Time)
77	RISK_CLASS_DURATION	☐	SDURATION		STRU	0	0
78	YEARS	☐			INT4	10	0
79	MONTHS	☐			INT4	10	0
80	DAYS	☐			INT4	10	0
81	HOURS	☐			INT4	10	0
82	MINUTES	☐			INT4	10	0
83	SECONDS	☐	SDURATION_SECONDS		DEC	14	3	Duration in Sec.
84	CREDITOR_PARTY	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
85	SELLER_PARTY	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
86	PRODUCT_CATEGORY	☐	CRMT_FINANCE_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
87	CHECK_RULE	☐	CRMT_CREDIT_CHECKRULECODE	CRM_CREDIT_CHECKRULECODE	CHAR	2	0	Credit Management: Code for Credit Standing Check Rule
88	LIMIT_RULE	☐	CRMT_CREDIT_LIMIT_RULE	CHAR10	CHAR	10	0	Rule for Calculating Score and Credit Limit
89	TOTAL	☐	CRMT_CR_COMMITMENT_TOTAL_TAB		TTYP	0	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	510