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

History

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