SAP ABAP Table CRMA_FINPROD_I (Structure for Change Documents: Finance Product)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-FIN (Application Component) Financing
     ⤷ CRM_FINPROD_I (Package) CRM Leasing and Loan Product Data

Basic Data

Table Category	INTTAB	Structure
Structure	CRMA_FINPROD_I	Table Relationship Diagram
Short Description	Structure for Change Documents: Finance Product

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	Object key with GUID32
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	CRMT_OBJECT_GUID32		CHAR	32	0	32 Character CRM Object GUID (Converted)
4	.INCLUDE	☐				0	0	Financing Product Item Data - Structure w/ External Fields
5	RESID_VALUE_FLAG	☐	CRMT_RESID_VALUE_F	CRMT_RESID_VALUE_F	CHAR	1	0	Residual Risk
6	RESID_VALUE_GRP	☐	CRMT_RESID_VALUE_GRP	CRMT_RESID_VALUE_GRP	CHAR	3	0	Residual Value Curve	CRMC_RESIDVLGR
7	PURCHASE_OPTION	☐	CRMT_PURCHASE_OPTION	CRMT_PURCHASE_OPTION	CHAR	1	0	End of Lease Purchase Option
8	CLASSIFICATION	☐	CRMT_CLASSIFICATION	CRMT_CLASSIFICATION	NUMC	2	0	Contract Class
9	CLASSIF_LOCAL	☐	CRMT_CLASSIF_LOCAL	CRMT_FILA_CLASS	CHAR	2	0	Local Classification Type (Tax)	CRMC_TFILA_FIN
10	CLASSIF_LOCAL_BK	☐	CRMT_CLASSIF_LOCAL_BOOK	CRMT_FILA_CLASS	CHAR	2	0	Local Classification Type (Book)	CRMC_TFILA_FIN
11	CLASSIF_GROUP	☐	CRMT_CLASSIF_GROUP	CRMT_FILA_CLASS	CHAR	2	0	Group Classification Type	CRMC_TFILA_FIN
12	CLASSIF_GROUP_BK	☐	CRMT_CLASSIF_GROUP_BOOK	CRMT_FILA_CLASS	CHAR	2	0	Group Classification Type (Book)	CRMC_TFILA_FIN
13	CLAS_CUSTOMER	☐	CRMT_CLAS_CUSTOMER	CRMT_FILA_CLASS	CHAR	2	0	Customer Classification Type (Tax)	CRMC_TFILA_FIN
14	CLAS_GROUP_FLAG	☐	CRMT_CLAS_GROUP_FLAG	XFELD	CHAR	1	0	Default Group Classification (Tax)
15	CLAS_GROUPBK_FLG	☐	CRMT_CLAS_GROUP_BOOK_FLG	XFELD	CHAR	1	0	Default Group Classification (Book)
16	CLASSIFI_FLAG	☐	CRMT_CLASSIFI_FLAG	XFELD	CHAR	1	0	Default Local Classification (Tax)
17	CLAS_LOCALBK_FLG	☐	CRMT_CLAS_LOCAL_BOOK_FLG	XFELD	CHAR	1	0	Default Local Classification (Book)
18	LEAS_CLASS	☐	CRMT_LEAS_CLASS	CRMT_LEAS_CLASS	CHAR	1	0	Tax Pricing Strategy
19	USED_FLAG	☐	CRMT_USED_FLAG	XFELD	CHAR	1	0	Leased Object Is Used
20	TAX_FINANC_FLAG	☐	CRMT_TAX_FINANC_FLAG	XFELD	CHAR	1	0	Financing of Taxes Allowed
21	CHARGE_FIN_FLAG	☐	CRMT_CHARGE_FIN_FLAG	XFELD	CHAR	1	0	Financing of Fees Allowed
22	COSTS_FIN_FLAG	☐	CRMT_COSTS_FIN_FLAG	XFELD	CHAR	1	0	Inclusion of Costs Allowed
23	SERV_FIN_FLAG	☐	CRMT_SERV_FIN_FLAG	XFELD	CHAR	1	0	Financing of Services Allowed
24	TAX_FIN_USE_FLG	☐	CRMT_TAX_FINANC_USE_FLAG	XFELD	CHAR	1	0	Financing of Taxes
25	CHRG_FIN_USE_FLG	☐	CRMT_CHARGE_FIN_USE_FLAG	XFELD	CHAR	1	0	Financing of Fees
26	COST_FIN_USE_FLG	☐	CRMT_COSTS_FIN_USE_FLAG	XFELD	CHAR	1	0	Inclusion of Costs
27	SERV_FIN_USE_FLG	☐	CRMT_SERV_FIN_USE_FLAG	XFELD	CHAR	1	0	Financing of Services
28	FMV_CURVE	☐	CRMT_FMV_CURVE	CRMT_FMV_CURVE	CHAR	2	0	Fair Market Value Curve	CRMC_FMV_CURVE
29	PRICING_FIMA	☐	CRMT_PROCESS_FIMA	CRMT_PRICING_PROCESS_FIMA	CHAR	4	0	Installment Calculation Procedure	CRMC_PROCESS_FM
30	SERVICE_FLAG	☐	CRMT_FIN_SERV_FLAG	CRMT_FIN_SERV_FLAG	CHAR	1	0	Financing of Services
31	CHARGE_FLAG	☐	CRMT_FIN_CHARGE_FLAG	CRMT_FIN_CHARGE_FLAG	CHAR	1	0	Financing of Fees
32	COSTS_FLAG	☐	CRMT_FIN_COSTS_FLAG	CRMT_FIN_COSTS_FLAG	CHAR	1	0	Inclusion of Costs
33	RATEBLEND_FLAG	☐	CRMT_FIN_RATEBLEND	CRMT_FIN_RATEBLEND	CHAR	1	0	Payment Blending in Overall View
34	PTWACC_ROE	☐	CRMT_PTWACC_ROE	CRMT_LEAS_INTEREST	DEC	11	7	Return on Equity before Taxes
35	ATWACC_ROE	☐	CRMT_ATWACC_ROE	CRMT_LEAS_INTEREST	DEC	11	7	After Tax Return on Equity
36	LESSOR_IRR	☐	CRMT_LESSOR_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Lessor Internal Rate of Return
37	ACCOUNT_IRR	☐	CRMT_ACCOUNT_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Internal Rate of Return for Accounting
38	CUSTOMER_IRR	☐	CRMT_CUSTOMER_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Lessee Internal Rate of Return
39	FIN_TRANSACTION	☐	CRMT_FIN_TRANSACTION	CRMT_FIN_TRAN	CHAR	3	0	Financing Transactions (no longer active!)	*
40	BUSINESS_PROCESS	☐	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	*
41	CHNG_PROCESS	☐	CRMT_LEAS_CHNG	CRMT_LEAS_CHNG_PROC	CHAR	4	0	Change Process	CRMC_LEAS_PROCES
42	CHNG_PROCESS1	☐	CRMT_LEAS_CHNG_SUB1	CRMT_LEAS_CHNG_PROC	CHAR	4	0	Change of Lease: Sub-Change Process	CRMC_LEAS_PROCES
43	KEEP_RATEPERX	☐	CRMT_KEEP_RATEPERX	XFELD	CHAR	1	0	Keep Rate per x - Y/N
44	LINK_TO_TC	☐	CRMT_LINK_TO_TC	CRMT_LINK_TO_TC	CHAR	10	0	Technical Name for General Terms and Conditions	CRMC_FIN_TC
45	LOOKUP_FOR_INTER	☐	CRMT_LOOKUP_FOR_INT	CRMT_LOOKUP_FOR_INT	NUMC	2	0	Interest Determination
46	STEP_PAYMENT_F	☐	CRMT_STEP_PAYMENT_F	CRMT_STEP_PAYMENT_F	CHAR	1	0	Step Payments Allowed
47	STEP_STRUCTURE	☐	CRMT_FIMAN_STEPSTR	XFELD	CHAR	1	0	Step Payments
48	DOWN_PAYMENT_F	☐	CRMT_DOWN_PAYMENT_F	CRMT_DOWN_PAYMENT_F	CHAR	1	0	Down Payment Required
49	REFERENCE_INTER	☐	CRMT_REFERENCE_INT	CRMT_REFERENCE_INT	NUMC	2	0	Reference Interest Rate
50	REFERENCE_INTE_D	☐	CRMT_REFERENCE_INT_D	ZIREFKU	CHAR	10	0	Interest Reference ID	T056R
51	FLUCTUATION_CAP	☐	CRMT_FIN_INTEREST_CLIP_LEVEL	CRMT_FIN_INTEREST_CLIP_LEVEL	DEC	10	7	Clip Level
52	AVERAGE_DAYS	☐	CRMT_FIN_INTEREST_AVERAGE_DAYS	CRMT_FIN_INTEREST_AVERAGE_DAYS	NUMC	4	0	Number of Days for Calculation of Average Interest Rate
53	INTERIM_PERIOD	☐	CRMT_INTERIM_PERIOD	CRMT_INTERIM_PERIOD	NUMC	2	0	Interim Period (No Longer Active)
54	INTERIMDAYS	☐	CRMT_INTERIMDAYS	T_GSTAGE	INT4	10	0	Number of Interim Days
55	INTDAYSUSE	☐	CRMT_FIMAN_INTDAYSUSE	XFELD	CHAR	1	0	Use Interim Days
56	ROUND_PROFILE	☐	CRMT_ROUND_PROFILE	CRMT_ROUND_PROFILE	CHAR	12	0	Rounding Profile	CRMC_ROUND_PROFR
57	CFTYPE_PROFILE	☐	CRMT_CFTYPE_PROFILE	CRMT_CFTYPE_PROFILE	CHAR	12	0	Flow Category Profile	CRMC_CFTYPE_PR_R
58	RATE_PER_K_USE	☐	CRMT_RATE_PER_K_USE	CRMT_RATE_PER_K_USE	CHAR	1	0	Apply Rate per X
59	FLAT_RATE_PERX	☐	CRMT_FIMA_FLATRATEPERX	CRMT_FIMA_DECV7_10	DEC	17	10	Flat Rate per x
60	FINOPT_EXE	☐	CRMT_FINOPT_EXE	XFELD	CHAR	1	0	Originated from Option
61	PRED_HEADER_GUID	☐	CRMT_PRED_HEADER_GUID	SYSUUID	RAW	16	0	Header GUID of Preceding CRM Document
62	PRED_ITEM_GUID	☐	CRMT_PRED_ITEM_GUID	SYSUUID	RAW	16	0	Guid from a Preceding Item
63	TAX_IRR	☐	CRMT_TAX_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Internal Rate of Return - Tax
64	FLATRATE_LESSOR	☐	CRMT_FLATRATE_LESSOR	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Lessor
65	FLATRATE_CUSTOM	☐	CRMT_FLATRATE_CUSTOM	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Customer
66	FLATRATE_CUSTALL	☐	CRMT_FLATRATE_CUSTALL	CRMT_FIMAN_FLATRATE	CURR	19	2	Flate Rate - Customer Complete
67	FLATRATE_TAX	☐	CRMT_FLATRATE_TAX	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Tax
68	FLATRATE_FEES	☐	CRMT_FLATRATE_FEES	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Fees
69	FLATRATE_CSTINCL	☐	CRMT_FLATRATE_COSTINCL	CRMT_FIMAN_FLATRATE	CURR	19	2	Flate Rate - Costs Inclusion
70	FLATRATE_SERVICE	☐	CRMT_FLATRATE_SERVICE	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Service
71	KEYDAY	☐	CRMT_FIMAN_KEYDAY	TFM_SKEYDAY	NUMC	2	0	Key Date for Date Update
72	ONE_VIEW_FLAG	☐	CRMT_ONE_VIEW_FLAG	CRMT_ONE_VIEW_FLAG	CHAR	1	0	Manage Only One View
73	VIEW_DISTR_METH	☐	CRMT_DISTR_METHOD	CRMT_DISTR_METHOD	NUMC	1	0	Distribution of Default Amounts in Financing Views
74	CUSTOM_COMPL_IRR	☐	CRMT_CUSTOMER_COMPL_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Cust.Compl.View -Internal Rate of Return(Effective Int.Rate)
75	FEES_IRR	☐	CRMT_FEES_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Fees View - Internal Rate of Return (Effective Int. Rate)
76	SERVICE_IRR	☐	CRMT_SERVICE_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Service Internal Rate of Return (Effective Interest Rate)
77	CSTINCL_IRR	☐	CRMT_CSTINCL_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Cost Inclusion -Internal Rate of Return(Effective Int. Rate)
78	TAX_UPFRONT_FLAG	☐	CRMT_TAX_UPFRONT_FLAG	XFELD	CHAR	1	0	Upfront Tax
79	TAX_NO_FLAG	☐	CRMT_TAX_NO_FLAG	XFELD	CHAR	1	0	No Tax Calculation
80	TAX_FINANC_GUID	☐	CRMT_TAX_FINANC_GUID	SYSUUID	RAW	16	0	GUID for Virtual Tax Financing Item
81	UPG_TYPE	☐	CRMT_UPG_TYPE	CRM_UPG_TYPE	CHAR	1	0	Upgrade Category
82	UPG_BASE_GUID	☐	CRMT_UPG_BASE_GUID	SYSUUID	RAW	16	0	Base GUID for Upgrades
83	.INCLUDE	☐				0	0
84	.INCLUDE	☐				0	0	Item Data of Financing Product Options - External Fields
85	OPTION_TYPE	☐	CRMT_OPTION_ART_01	CRMT_OPTION_ART_01	CHAR	4	0	Option Type	CRMC_PR_FINOP1
86	VALUATION	☐	CRMT_VALUATION_FLAG	CRMT_VALUATION_FLAG	CHAR	1	0	Valuation Only on Exercise Date
87	PRESTATED	☐	CRMT_PRESTATED_FLAG	CRMT_PRESTATED_FLAG	CHAR	1	0	Option Was Agreed to by Customer
88	BARGAIN	☐	CRMT_BARGAIN	CRMT_BARGAIN	CHAR	1	0	Bargain Option Indicator
89	PRICING_PROCESS	☐	CRMT_PRICING_PROCESS_OPT	CRMT_PRICING_PROCESS	CHAR	4	0	Pricing Process	CRMC_PROCESS_OP
90	PRICING_PROCESS1	☐	CRMT_PRICING_PROCESS_OPT_SUB1	CRMT_PRICING_PROCESS1	CHAR	4	0	Sub-Pricing Process	CRMC_PROCESS_O1
91	FINOPT_DEF	☐	CRMT_FINOPT_DEF_EXE	XFELD	CHAR	1	0	Standard at Contract End
92	OPTION_CRE_MODE	☐	CRMT_OPTION_CREATE_MODE	CHAR1	CHAR	1	0	Create Mode for Option (Manual, Copied, Generated)
93	.INCLUDE	☐				0	0	Financing Product Item Data - Structure w/ Internal Fields
94	INTCALC_METHOD	☐	CRMT_SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
95	IRR_METHOD	☐	CRMT_SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method
96	INTCALC_M_EXT	☐	CRMT_SZBMETH_EXT	SZBMETH	CHAR	1	0	Interest Calculation Method (Effective Interest)
97	IRR_M_EXT	☐	CRMT_SEFFMETH_EXT	SEFFMETH	NUMC	1	0	Effective Interest Method (External)
98	RATE_FACTOR	☐	CRMT_RATE_FACTOR	CRMT_RATE_FACTOR	INT4	10	0	Rate Factor
99	ADGSDAYS	☐	CRMT_ADGSDAYS	T_GSTAGE	INT4	10	0	Number of Days for Payment Date Adjustment
100	COMPEXPO	☐	CRMT_FIMA_COMPEXPO	XFELD	CHAR	1	0	Exponential Interest Calculation
101	INTSETTLFREQ	☐	CRMT_FIMA_INTSETTLFREQ	TFM_AMMRHYZV	NUMC	2	0	Frequency for Exponential Interest Calculation
102	INTSETTLFREQ_IRR	☐	CRMT_FIMA_INTSETTLFREQ_IRR	TFM_AMMRHYZV	NUMC	2	0	Exponential Frequency for Interest Calculation (Effect.Int.)
103	CALC_FLATRATE	☐	CRMT_FIMA_FLATRATE_CALC	CRMT_FIMA_FLATRATE_CALC	CHAR	1	0	Calculate Flat Rate
104	PAYMSCHED_CREATE	☐	CRMT_FIMAN_PAYMSCHED_CREATE	CRMT_FIMAN_PAYMSCHED_CREATE	CHAR	4	0	Payment Schedule Generation Method	CRMC_PAYMSCHED
105	PROCESS_PROFILE	☐	CRMT_FIMAN_PROCPR	CRMT_FIMAN_CALCPR	CHAR	12	0	Installment Calculation Profile
106	BACKSOLVE_METHOD	☐	CRMT_FIMAN_BACKSOLVE_METH	CRMT_FIMAN_BACKSOLVE_METH	CHAR	20	0	Solution Method	CRMC_BACKSOLV_ME
107	BACKSOLVE_MET_PR	☐	CRMT_FIMAN_BACKSOLVE_METH_PRE	CRMT_FIMAN_BACKSOLVE_METH	CHAR	20	0	External Solution Method	CRMC_BACKSOLV_ME
108	CALC_PROFILE	☐	CRMT_FIMAN_CALCPR	CRMT_FIMAN_CALCPR	CHAR	12	0	Calculation Method Profile
109	INTP_CHARGE	☐	CRMT_FIMAN_INTPCH	XFELD	CHAR	1	0	Show Interim Period as Fee
110	IRR_PROFILE	☐	CRMT_FIMAN_IRRPR	CRMT_FIMAN_IRRPR	CHAR	12	0	Effective Interest Profile
111	IRR_METHOD_BADI	☐	CRMT_FIMAN_IRRMETH	CRMT_FIMAN_IRRMETH	CHAR	4	0	Effective Interest Procedure	CRMC_IRRMETH
112	BALSETTL_METH	☐	CRMT_FIMAN_BALSETTL	CRMT_FIMAN_BALSETTL	CHAR	1	0	Balance Settlement Method
113	CFTYPE_BALSETTL	☐	CRMT_FIMAN_CFTYPE_BS	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category Balance Settlement
114	FINV_PROFILE	☐	CRMT_FIMAN_FINVPR	CRMT_FIMAN_CALCPR	CHAR	12	0	Financing View Profile
115	INTCALC_M_INTP	☐	CRMT_FIMAN_SZBMINTP	SZBMETH	CHAR	1	0	Interest Calculation Method for Interim Period
116	USE_ACTDAYS	☐	CRMT_FIMAN_ACTDAYS	XFELD	CHAR	1	0	Calendar Days in Interim Period
117	FIMA_ALGTYPE	☐	CRMT_FIMAN_TYPE	CRMT_FIMAN_TYPE	CHAR	10	0	Financial-Mathematical Algorithm Type
118	.INCLUDE	☐				0	0	Extended Financing Terms
119	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	*
120	BILPR	☐	BLIT_BILPR	BLI_BILPR	CHAR	6	0	Billing Procedure

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMA_FINPROD_I	BACKSOLVE_METHOD	CRMC_BACKSOLV_ME	BACKSOLVE_METHOD
2	CRMA_FINPROD_I	BACKSOLVE_MET_PR	CRMC_BACKSOLV_ME	BACKSOLVE_METHOD
3	CRMA_FINPROD_I	CFTYPE_PROFILE	CRMC_CFTYPE_PR_R	CFTYPE_PROFIL	KEY	1	CN
4	CRMA_FINPROD_I	CHNG_PROCESS	CRMC_LEAS_PROCES	CHNG_PROC
5	CRMA_FINPROD_I	CHNG_PROCESS1	CRMC_LEAS_PROCES	CHNG_PROC
6	CRMA_FINPROD_I	CLASSIF_GROUP	CRMC_TFILA_FIN	CLASS
7	CRMA_FINPROD_I	CLASSIF_GROUP_BK	CRMC_TFILA_FIN	CLASS
8	CRMA_FINPROD_I	CLASSIF_LOCAL	CRMC_TFILA_FIN	CLASS
9	CRMA_FINPROD_I	CLASSIF_LOCAL_BK	CRMC_TFILA_FIN	CLASS
10	CRMA_FINPROD_I	CLAS_CUSTOMER	CRMC_TFILA_FIN	CLASS	KEY	1	CN
11	CRMA_FINPROD_I	FMV_CURVE	CRMC_FMV_CURVE	FMV_CURVE
12	CRMA_FINPROD_I	IRR_METHOD_BADI	CRMC_IRRMETH	IRR_METHOD
13	CRMA_FINPROD_I	LINK_TO_TC	CRMC_FIN_TC	LINK_TO_TC	KEY	1	CN
14	CRMA_FINPROD_I	OPTION_TYPE	CRMC_PR_FINOP1	OPTION_ART
15	CRMA_FINPROD_I	PAYMSCHED_CREATE	CRMC_PAYMSCHED	PAYMSCHED_CREATE
16	CRMA_FINPROD_I	PRICING_FIMA	CRMC_PROCESS_FM	PRICING_PROCESS
17	CRMA_FINPROD_I	PRICING_PROCESS	CRMC_PROCESS_OP	PRICING_PROCESS
18	CRMA_FINPROD_I	PRICING_PROCESS1	CRMC_PROCESS_O1	PRICING_PROCESS1
19	CRMA_FINPROD_I	REFERENCE_INTE_D	T056R	REFERENZ	KEY	1	CN
20	CRMA_FINPROD_I	RESID_VALUE_GRP	CRMC_RESIDVLGR	RESID_VALUE_GRP	KEY	1	CN
21	CRMA_FINPROD_I	ROUND_PROFILE	CRMC_ROUND_PROFR	ROUND_PROFILE	KEY	1	CN

History

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