SAP ABAP Table CRM_PROD_FIN05 (Changes to Principal)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LAM-MD-FPR (Application Component) Financing Product
     ⤷ CRM_PRODUCT_FINANCE (Package) Product Master Financial

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRM_PROD_FIN05	Table Relationship Diagram
Short Description	Changes to Principal

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	Set Key
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	FRG_GUID	☑	COMT_FRG_GUID	SYSUUID	RAW	16	0	Set GUID
4	.INCLUDE	☐				0	0	Product Administration Data
5	VALID_FROM	☐	COMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Valid From (Time Stamp)
6	VALID_TO	☐	COMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Valid To (Time Stamp)
7	UPNAME	☐	COMT_UPNAME	UNAME	CHAR	12	0	Name of the User Who Last Changed the Set
8	HISTEX	☐	COMT_HISTEX	COM_BOOLEAN	CHAR	1	0	History Exists
9	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
10	.INCLUDE	☐				0	0	Financing - Schedule of Payments
11	CFLOW_TYPE_01	☐	CRMT_CFLOWTYPE01	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category	CRMC_CFTYPE
12	NO_OF_PERIODS_01	☐	CRMT_FIN_PERIODS01		NUMC	5	0	Number of Periods in Billing Plan
13	PAYMENT_FREQU_01	☐	CRMT_FIN_PAYMENTFR01	CRMT_FIN_PAYMENTFR01	NUMC	2	0	Payment Frequency
14	PAYMENT_FORM_01	☐	CRMT_FIN_PAYMENTFO01	CRMT_PAYMENTFORM	NUMC	1	0	Payment Form	CRMC_PAYMFORM
15	PERCENTAGE_01	☐	CRMT_FINPROD_PROZ01	DECV3_7	DEC	10	7	Percentage Rate
16	RATE_PER_X_01	☐	CRMT_FIN_RATEPERX01	CRMT_DECV7_10	DEC	17	10	Rate per x
17	TIMERU_FROM_01	☐	CRMT_FIN_TIMERU_FR01	TIMENAME	CHAR	12	0	Date Rule From	TIMERUNA
18	TIMERU_TO_01	☐	CRMT_FIN_TIMERU_TO01	TIMENAME	CHAR	12	0	Date Rule To	TIMERUNA
19	SETTL_TO_01	☐	CRMT_FIN_SETTL_TO_01		DATS	8	0	To Date
20	FIX_01	☐	CRMT_FINPROD_FIX01	CRMT_FINPROD_FIX01	NUMC	2	0	Fixing
21	DATE_UPD_01	☐	CRMT_FIN_DATE_UPD_01	CRMT_FIN_DATE_UPD_01	CHAR	1	0	No Date Update
22	CFLOW_TYPE_02	☐	CRMT_CFLOWTYPE02	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category	CRMC_CFTYPE
23	NO_OF_PERIODS_02	☐	CRMT_FIN_PERIODS02		NUMC	5	0	Number of Periods in Billing Plan
24	PAYMENT_FREQU_02	☐	CRMT_FIN_PAYMENTFR02	CRMT_FIN_PAYMENTFR02	NUMC	2	0	Payment Frequency
25	PAYMENT_FORM_02	☐	CRMT_FIN_PAYMENTFO02	CRMT_PAYMENTFORM	NUMC	1	0	Payment Form	CRMC_PAYMFORM
26	PERCENTAGE_02	☐	CRMT_FINPROD_PROZ02	DECV3_7	DEC	10	7	Percentage Rate
27	RATE_PER_X_02	☐	CRMT_FIN_RATEPERX02	CRMT_DECV7_10	DEC	17	10	Rate per x
28	TIMERU_FROM_02	☐	CRMT_FIN_TIMERU_FR02	TIMENAME	CHAR	12	0	Date Rule From	TIMERUNA
29	TIMERU_TO_02	☐	CRMT_FIN_TIMERU_TO02	TIMENAME	CHAR	12	0	Date Rule To	TIMERUNA
30	SETTL_TO_02	☐	CRMT_FIN_SETTL_TO_02		DATS	8	0	To Date
31	FIX_02	☐	CRMT_FINPROD_FIX02	CRMT_FINPROD_FIX02	NUMC	2	0	Fixing
32	DATE_UPD_02	☐	CRMT_FIN_DATE_UPD_02	CRMT_FIN_DATE_UPD_02	CHAR	1	0	No Date Update
33	CFLOW_TYPE_03	☐	CRMT_CFLOWTYPE03	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category	CRMC_CFTYPE
34	NO_OF_PERIODS_03	☐	CRMT_FIN_PERIODS03		NUMC	5	0	Number of Periods in Billing Plan
35	PAYMENT_FREQU_03	☐	CRMT_FIN_PAYMENTFR03	CRMT_FIN_PAYMENTFR03	NUMC	2	0	Payment Frequency
36	PAYMENT_FORM_03	☐	CRMT_FIN_PAYMENTFO03	CRMT_PAYMENTFORM	NUMC	1	0	Payment Form	CRMC_PAYMFORM
37	PERCENTAGE_03	☐	CRMT_FINPROD_PROZ03	DECV3_7	DEC	10	7	Percentage Rate
38	RATE_PER_X_03	☐	CRMT_FIN_RATEPERX03	CRMT_DECV7_10	DEC	17	10	Rate per x
39	TIMERU_FROM_03	☐	CRMT_FIN_TIMERU_FR03	TIMENAME	CHAR	12	0	Date Rule From	TIMERUNA
40	TIMERU_TO_03	☐	CRMT_FIN_TIMERU_TO03	TIMENAME	CHAR	12	0	Date Rule To	TIMERUNA
41	SETTL_TO_03	☐	CRMT_FIN_SETTL_TO_03		DATS	8	0	To Date
42	FIX_03	☐	CRMT_FINPROD_FIX03	CRMT_FINPROD_FIX03	NUMC	2	0	Fixing
43	DATE_UPD_03	☐	CRMT_FIN_DATE_UPD_03	CRMT_FIN_DATE_UPD_03	CHAR	1	0	No Date Update
44	CFLOW_TYPE_04	☐	CRMT_CFLOWTYPE04	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category	CRMC_CFTYPE
45	NO_OF_PERIODS_04	☐	CRMT_FIN_PERIODS04		NUMC	5	0	Number of Periods in Billing Plan
46	PAYMENT_FREQU_04	☐	CRMT_FIN_PAYMENTFR04	CRMT_FIN_PAYMENTFR04	NUMC	2	0	Payment Frequency
47	PAYMENT_FORM_04	☐	CRMT_FIN_PAYMENTFO04	CRMT_PAYMENTFORM	NUMC	1	0	Payment Form	CRMC_PAYMFORM
48	PERCENTAGE_04	☐	CRMT_FINPROD_PROZ04	DECV3_7	DEC	10	7	Percentage Rate
49	RATE_PER_X_04	☐	CRMT_FIN_RATEPERX04	CRMT_DECV7_10	DEC	17	10	Rate per x
50	TIMERU_FROM_04	☐	CRMT_FIN_TIMERU_FR04	TIMENAME	CHAR	12	0	Date Rule From	TIMERUNA
51	TIMERU_TO_04	☐	CRMT_FIN_TIMERU_TO04	TIMENAME	CHAR	12	0	Date Rule To	TIMERUNA
52	SETTL_TO_04	☐	CRMT_FIN_SETTL_TO_04		DATS	8	0	To Date
53	FIX_04	☐	CRMT_FINPROD_FIX04	CRMT_FINPROD_FIX04	NUMC	2	0	Fixing
54	DATE_UPD_04	☐	CRMT_FIN_DATE_UPD_04	CRMT_FIN_DATE_UPD_04	CHAR	1	0	No Date Update
55	CFLOW_TYPE_05	☐	CRMT_CFLOWTYPE05	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category	CRMC_CFTYPE
56	NO_OF_PERIODS_05	☐	CRMT_FIN_PERIODS05		NUMC	5	0	Number of Periods in Billing Plan
57	PAYMENT_FREQU_05	☐	CRMT_FIN_PAYMENTFR05	CRMT_FIN_PAYMENTFR05	NUMC	2	0	Payment Frequency
58	PAYMENT_FORM_05	☐	CRMT_FIN_PAYMENTFO05	CRMT_PAYMENTFORM	NUMC	1	0	Payment Form	CRMC_PAYMFORM
59	PERCENTAGE_05	☐	CRMT_FINPROD_PROZ05	DECV3_7	DEC	10	7	Percentage Rate
60	RATE_PER_X_05	☐	CRMT_FIN_RATEPERX05	CRMT_DECV7_10	DEC	17	10	Rate per x
61	TIMERU_FROM_05	☐	CRMT_FIN_TIMERU_FR05	TIMENAME	CHAR	12	0	Date Rule From	TIMERUNA
62	TIMERU_TO_05	☐	CRMT_FIN_TIMERU_TO05	TIMENAME	CHAR	12	0	Date Rule To	TIMERUNA
63	SETTL_TO_05	☐	CRMT_FIN_SETTL_TO_05		DATS	8	0	To Date
64	FIX_05	☐	CRMT_FINPROD_FIX05	CRMT_FINPROD_FIX05	NUMC	2	0	Fixing
65	DATE_UPD_05	☐	CRMT_FIN_DATE_UPD_05	CRMT_FIN_DATE_UPD_05	CHAR	1	0	No Date Update
66	CFLOW_TYPE_06	☐	CRMT_CFLOWTYPE06	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category	CRMC_CFTYPE
67	NO_OF_PERIODS_06	☐	CRMT_FIN_PERIODS06		NUMC	5	0	Number of Periods in Billing Plan
68	PAYMENT_FREQU_06	☐	CRMT_FIN_PAYMENTFR06	CRMT_FIN_PAYMENTFR06	NUMC	2	0	Payment Frequency
69	PAYMENT_FORM_06	☐	CRMT_FIN_PAYMENTFO06	CRMT_PAYMENTFORM	NUMC	1	0	Payment Form	CRMC_PAYMFORM
70	PERCENTAGE_06	☐	CRMT_FINPROD_PROZ06	DECV3_7	DEC	10	7	Percentage Rate
71	RATE_PER_X_06	☐	CRMT_FIN_RATEPERX06	CRMT_DECV7_10	DEC	17	10	Rate per x
72	TIMERU_FROM_06	☐	CRMT_FIN_TIMERU_FR06	TIMENAME	CHAR	12	0	Date Rule From	TIMERUNA
73	TIMERU_TO_06	☐	CRMT_FIN_TIMERU_TO06	TIMENAME	CHAR	12	0	Date Rule To	TIMERUNA
74	SETTL_TO_06	☐	CRMT_FIN_SETTL_TO_06		DATS	8	0	To Date
75	FIX_06	☐	CRMT_FINPROD_FIX06	CRMT_FINPROD_FIX06	NUMC	2	0	Fixing
76	DATE_UPD_06	☐	CRMT_FIN_DATE_UPD_06	CRMT_FIN_DATE_UPD_06	CHAR	1	0	No Date Update

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_PROD_FIN05	CFLOW_TYPE_01	CRMC_CFTYPE	CASHFLOW_TYPE_CU
2	CRM_PROD_FIN05	CFLOW_TYPE_02	CRMC_CFTYPE	CASHFLOW_TYPE_CU
3	CRM_PROD_FIN05	CFLOW_TYPE_03	CRMC_CFTYPE	CASHFLOW_TYPE_CU
4	CRM_PROD_FIN05	CFLOW_TYPE_04	CRMC_CFTYPE	CASHFLOW_TYPE_CU
5	CRM_PROD_FIN05	CFLOW_TYPE_05	CRMC_CFTYPE	CASHFLOW_TYPE_CU
6	CRM_PROD_FIN05	CFLOW_TYPE_06	CRMC_CFTYPE	CASHFLOW_TYPE_CU
7	CRM_PROD_FIN05	PAYMENT_FORM_01	CRMC_PAYMFORM	PAYMFORM	KEY	1	CN
8	CRM_PROD_FIN05	PAYMENT_FORM_02	CRMC_PAYMFORM	PAYMFORM	KEY	1	CN
9	CRM_PROD_FIN05	PAYMENT_FORM_03	CRMC_PAYMFORM	PAYMFORM	KEY	1	CN
10	CRM_PROD_FIN05	PAYMENT_FORM_04	CRMC_PAYMFORM	PAYMFORM	KEY	1	CN
11	CRM_PROD_FIN05	PAYMENT_FORM_05	CRMC_PAYMFORM	PAYMFORM	KEY	1	CN
12	CRM_PROD_FIN05	PAYMENT_FORM_06	CRMC_PAYMFORM	PAYMFORM	KEY	1	CN
13	CRM_PROD_FIN05	TIMERU_FROM_01	TIMERUNA	RULE_NAME
14	CRM_PROD_FIN05	TIMERU_FROM_02	TIMERUNA	RULE_NAME
15	CRM_PROD_FIN05	TIMERU_FROM_03	TIMERUNA	RULE_NAME
16	CRM_PROD_FIN05	TIMERU_FROM_04	TIMERUNA	RULE_NAME
17	CRM_PROD_FIN05	TIMERU_FROM_05	TIMERUNA	RULE_NAME
18	CRM_PROD_FIN05	TIMERU_FROM_06	TIMERUNA	RULE_NAME
19	CRM_PROD_FIN05	TIMERU_TO_01	TIMERUNA	RULE_NAME
20	CRM_PROD_FIN05	TIMERU_TO_02	TIMERUNA	RULE_NAME
21	CRM_PROD_FIN05	TIMERU_TO_03	TIMERUNA	RULE_NAME
22	CRM_PROD_FIN05	TIMERU_TO_04	TIMERUNA	RULE_NAME
23	CRM_PROD_FIN05	TIMERU_TO_05	TIMERUNA	RULE_NAME
24	CRM_PROD_FIN05	TIMERU_TO_06	TIMERUNA	RULE_NAME

History

Last changed by/on	SAP	20110908
SAP Release Created in	30A