SAP ABAP Table CRMT_FINPROD_I_EXT (Financing Product Item Data - Structure w/ External Fields)

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	CRMT_FINPROD_I_EXT	Table Relationship Diagram
Short Description	Financing Product Item Data - Structure w/ External Fields

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	RESID_VALUE_FLAG	☐	CRMT_RESID_VALUE_F	CRMT_RESID_VALUE_F	CHAR	1	0	Residual Risk
2	RESID_VALUE_GRP	☐	CRMT_RESID_VALUE_GRP	CRMT_RESID_VALUE_GRP	CHAR	3	0	Residual Value Curve	CRMC_RESIDVLGR
3	PURCHASE_OPTION	☐	CRMT_PURCHASE_OPTION	CRMT_PURCHASE_OPTION	CHAR	1	0	End of Lease Purchase Option
4	CLASSIFICATION	☐	CRMT_CLASSIFICATION	CRMT_CLASSIFICATION	NUMC	2	0	Contract Class
5	CLASSIF_LOCAL	☐	CRMT_CLASSIF_LOCAL	CRMT_FILA_CLASS	CHAR	2	0	Local Classification Type (Tax)	CRMC_TFILA_FIN
6	CLASSIF_LOCAL_BK	☐	CRMT_CLASSIF_LOCAL_BOOK	CRMT_FILA_CLASS	CHAR	2	0	Local Classification Type (Book)	CRMC_TFILA_FIN
7	CLASSIF_GROUP	☐	CRMT_CLASSIF_GROUP	CRMT_FILA_CLASS	CHAR	2	0	Group Classification Type	CRMC_TFILA_FIN
8	CLASSIF_GROUP_BK	☐	CRMT_CLASSIF_GROUP_BOOK	CRMT_FILA_CLASS	CHAR	2	0	Group Classification Type (Book)	CRMC_TFILA_FIN
9	CLAS_CUSTOMER	☐	CRMT_CLAS_CUSTOMER	CRMT_FILA_CLASS	CHAR	2	0	Customer Classification Type (Tax)	CRMC_TFILA_FIN
10	CLAS_GROUP_FLAG	☐	CRMT_CLAS_GROUP_FLAG	XFELD	CHAR	1	0	Default Group Classification (Tax)
11	CLAS_GROUPBK_FLG	☐	CRMT_CLAS_GROUP_BOOK_FLG	XFELD	CHAR	1	0	Default Group Classification (Book)
12	CLASSIFI_FLAG	☐	CRMT_CLASSIFI_FLAG	XFELD	CHAR	1	0	Default Local Classification (Tax)
13	CLAS_LOCALBK_FLG	☐	CRMT_CLAS_LOCAL_BOOK_FLG	XFELD	CHAR	1	0	Default Local Classification (Book)
14	LEAS_CLASS	☐	CRMT_LEAS_CLASS	CRMT_LEAS_CLASS	CHAR	1	0	Tax Pricing Strategy
15	USED_FLAG	☐	CRMT_USED_FLAG	XFELD	CHAR	1	0	Leased Object Is Used
16	TAX_FINANC_FLAG	☐	CRMT_TAX_FINANC_FLAG	XFELD	CHAR	1	0	Financing of Taxes Allowed
17	CHARGE_FIN_FLAG	☐	CRMT_CHARGE_FIN_FLAG	XFELD	CHAR	1	0	Financing of Fees Allowed
18	COSTS_FIN_FLAG	☐	CRMT_COSTS_FIN_FLAG	XFELD	CHAR	1	0	Inclusion of Costs Allowed
19	SERV_FIN_FLAG	☐	CRMT_SERV_FIN_FLAG	XFELD	CHAR	1	0	Financing of Services Allowed
20	TAX_FIN_USE_FLG	☐	CRMT_TAX_FINANC_USE_FLAG	XFELD	CHAR	1	0	Financing of Taxes
21	CHRG_FIN_USE_FLG	☐	CRMT_CHARGE_FIN_USE_FLAG	XFELD	CHAR	1	0	Financing of Fees
22	COST_FIN_USE_FLG	☐	CRMT_COSTS_FIN_USE_FLAG	XFELD	CHAR	1	0	Inclusion of Costs
23	SERV_FIN_USE_FLG	☐	CRMT_SERV_FIN_USE_FLAG	XFELD	CHAR	1	0	Financing of Services
24	FMV_CURVE	☐	CRMT_FMV_CURVE	CRMT_FMV_CURVE	CHAR	2	0	Fair Market Value Curve	CRMC_FMV_CURVE
25	PRICING_FIMA	☐	CRMT_PROCESS_FIMA	CRMT_PRICING_PROCESS_FIMA	CHAR	4	0	Installment Calculation Procedure	CRMC_PROCESS_FM
26	SERVICE_FLAG	☐	CRMT_FIN_SERV_FLAG	CRMT_FIN_SERV_FLAG	CHAR	1	0	Financing of Services
27	CHARGE_FLAG	☐	CRMT_FIN_CHARGE_FLAG	CRMT_FIN_CHARGE_FLAG	CHAR	1	0	Financing of Fees
28	COSTS_FLAG	☐	CRMT_FIN_COSTS_FLAG	CRMT_FIN_COSTS_FLAG	CHAR	1	0	Inclusion of Costs
29	RATEBLEND_FLAG	☐	CRMT_FIN_RATEBLEND	CRMT_FIN_RATEBLEND	CHAR	1	0	Payment Blending in Overall View
30	PTWACC_ROE	☐	CRMT_PTWACC_ROE	CRMT_LEAS_INTEREST	DEC	11	7	Return on Equity before Taxes
31	ATWACC_ROE	☐	CRMT_ATWACC_ROE	CRMT_LEAS_INTEREST	DEC	11	7	After Tax Return on Equity
32	LESSOR_IRR	☐	CRMT_LESSOR_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Lessor Internal Rate of Return
33	ACCOUNT_IRR	☐	CRMT_ACCOUNT_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Internal Rate of Return for Accounting
34	CUSTOMER_IRR	☐	CRMT_CUSTOMER_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Lessee Internal Rate of Return
35	FIN_TRANSACTION	☐	CRMT_FIN_TRANSACTION	CRMT_FIN_TRAN	CHAR	3	0	Financing Transactions (no longer active!)
36	BUSINESS_PROCESS	☐	J_VORGANG	J_VORGANG	CHAR	4	0	Business Transaction	*
37	CHNG_PROCESS	☐	CRMT_LEAS_CHNG	CRMT_LEAS_CHNG_PROC	CHAR	4	0	Change Process	CRMC_LEAS_PROCES
38	CHNG_PROCESS1	☐	CRMT_LEAS_CHNG_SUB1	CRMT_LEAS_CHNG_PROC	CHAR	4	0	Change of Lease: Sub-Change Process	CRMC_LEAS_PROCES
39	KEEP_RATEPERX	☐	CRMT_KEEP_RATEPERX	XFELD	CHAR	1	0	Keep Rate per x - Y/N
40	LINK_TO_TC	☐	CRMT_LINK_TO_TC	CRMT_LINK_TO_TC	CHAR	10	0	Technical Name for General Terms and Conditions	CRMC_FIN_TC
41	LOOKUP_FOR_INTER	☐	CRMT_LOOKUP_FOR_INT	CRMT_LOOKUP_FOR_INT	NUMC	2	0	Interest Determination
42	STEP_PAYMENT_F	☐	CRMT_STEP_PAYMENT_F	CRMT_STEP_PAYMENT_F	CHAR	1	0	Step Payments Allowed
43	STEP_STRUCTURE	☐	CRMT_FIMAN_STEPSTR	XFELD	CHAR	1	0	Step Payments
44	DOWN_PAYMENT_F	☐	CRMT_DOWN_PAYMENT_F	CRMT_DOWN_PAYMENT_F	CHAR	1	0	Down Payment Required
45	REFERENCE_INTER	☐	CRMT_REFERENCE_INT	CRMT_REFERENCE_INT	NUMC	2	0	Reference Interest Rate
46	REFERENCE_INTE_D	☐	CRMT_REFERENCE_INT_D	ZIREFKU	CHAR	10	0	Interest Reference ID	T056R
47	FLUCTUATION_CAP	☐	CRMT_FIN_INTEREST_CLIP_LEVEL	CRMT_FIN_INTEREST_CLIP_LEVEL	DEC	10	7	Clip Level
48	AVERAGE_DAYS	☐	CRMT_FIN_INTEREST_AVERAGE_DAYS	CRMT_FIN_INTEREST_AVERAGE_DAYS	NUMC	4	0	Number of Days for Calculation of Average Interest Rate
49	INTERIM_PERIOD	☐	CRMT_INTERIM_PERIOD	CRMT_INTERIM_PERIOD	NUMC	2	0	Interim Period (No Longer Active)
50	INTERIMDAYS	☐	CRMT_INTERIMDAYS	T_GSTAGE	INT4	10	0	Number of Interim Days
51	INTDAYSUSE	☐	CRMT_FIMAN_INTDAYSUSE	XFELD	CHAR	1	0	Use Interim Days
52	ROUND_PROFILE	☐	CRMT_ROUND_PROFILE	CRMT_ROUND_PROFILE	CHAR	12	0	Rounding Profile	CRMC_ROUND_PROFR
53	CFTYPE_PROFILE	☐	CRMT_CFTYPE_PROFILE	CRMT_CFTYPE_PROFILE	CHAR	12	0	Flow Category Profile	CRMC_CFTYPE_PR_R
54	RATE_PER_K_USE	☐	CRMT_RATE_PER_K_USE	CRMT_RATE_PER_K_USE	CHAR	1	0	Apply Rate per X
55	FLAT_RATE_PERX	☐	CRMT_FIMA_FLATRATEPERX	CRMT_FIMA_DECV7_10	DEC	17	10	Flat Rate per x
56	FINOPT_EXE	☐	CRMT_FINOPT_EXE	XFELD	CHAR	1	0	Originated from Option
57	PRED_HEADER_GUID	☐	CRMT_PRED_HEADER_GUID	SYSUUID	RAW	16	0	Header GUID of Preceding CRM Document
58	PRED_ITEM_GUID	☐	CRMT_PRED_ITEM_GUID	SYSUUID	RAW	16	0	Guid from a Preceding Item
59	TAX_IRR	☐	CRMT_TAX_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Internal Rate of Return - Tax
60	FLATRATE_LESSOR	☐	CRMT_FLATRATE_LESSOR	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Lessor
61	FLATRATE_CUSTOM	☐	CRMT_FLATRATE_CUSTOM	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Customer
62	FLATRATE_CUSTALL	☐	CRMT_FLATRATE_CUSTALL	CRMT_FIMAN_FLATRATE	CURR	19	2	Flate Rate - Customer Complete
63	FLATRATE_TAX	☐	CRMT_FLATRATE_TAX	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Tax
64	FLATRATE_FEES	☐	CRMT_FLATRATE_FEES	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Fees
65	FLATRATE_CSTINCL	☐	CRMT_FLATRATE_COSTINCL	CRMT_FIMAN_FLATRATE	CURR	19	2	Flate Rate - Costs Inclusion
66	FLATRATE_SERVICE	☐	CRMT_FLATRATE_SERVICE	CRMT_FIMAN_FLATRATE	CURR	19	2	Flat Rate - Service
67	KEYDAY	☐	CRMT_FIMAN_KEYDAY	TFM_SKEYDAY	NUMC	2	0	Key Date for Date Update
68	ONE_VIEW_FLAG	☐	CRMT_ONE_VIEW_FLAG	CRMT_ONE_VIEW_FLAG	CHAR	1	0	Manage Only One View
69	VIEW_DISTR_METH	☐	CRMT_DISTR_METHOD	CRMT_DISTR_METHOD	NUMC	1	0	Distribution of Default Amounts in Financing Views
70	CUSTOM_COMPL_IRR	☐	CRMT_CUSTOMER_COMPL_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Cust.Compl.View -Internal Rate of Return(Effective Int.Rate)
71	FEES_IRR	☐	CRMT_FEES_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Fees View - Internal Rate of Return (Effective Int. Rate)
72	SERVICE_IRR	☐	CRMT_SERVICE_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Service Internal Rate of Return (Effective Interest Rate)
73	CSTINCL_IRR	☐	CRMT_CSTINCL_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Cost Inclusion -Internal Rate of Return(Effective Int. Rate)
74	TAX_UPFRONT_FLAG	☐	CRMT_TAX_UPFRONT_FLAG	XFELD	CHAR	1	0	Upfront Tax
75	TAX_NO_FLAG	☐	CRMT_TAX_NO_FLAG	XFELD	CHAR	1	0	No Tax Calculation
76	TAX_FINANC_GUID	☐	CRMT_TAX_FINANC_GUID	SYSUUID	RAW	16	0	GUID for Virtual Tax Financing Item
77	UPG_TYPE	☐	CRMT_UPG_TYPE	CRM_UPG_TYPE	CHAR	1	0	Upgrade Category
78	UPG_BASE_GUID	☐	CRMT_UPG_BASE_GUID	SYSUUID	RAW	16	0	Base GUID for Upgrades
79	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_FINPROD_I_EXT	CFTYPE_PROFILE	CRMC_CFTYPE_PR_R	CFTYPE_PROFIL	KEY	1	CN
2	CRMT_FINPROD_I_EXT	CHNG_PROCESS	CRMC_LEAS_PROCES	CHNG_PROC
3	CRMT_FINPROD_I_EXT	CHNG_PROCESS1	CRMC_LEAS_PROCES	CHNG_PROC
4	CRMT_FINPROD_I_EXT	CLASSIF_GROUP	CRMC_TFILA_FIN	CLASS
5	CRMT_FINPROD_I_EXT	CLASSIF_GROUP_BK	CRMC_TFILA_FIN	CLASS
6	CRMT_FINPROD_I_EXT	CLASSIF_LOCAL	CRMC_TFILA_FIN	CLASS
7	CRMT_FINPROD_I_EXT	CLASSIF_LOCAL_BK	CRMC_TFILA_FIN	CLASS
8	CRMT_FINPROD_I_EXT	CLAS_CUSTOMER	CRMC_TFILA_FIN	CLASS	KEY	1	CN
9	CRMT_FINPROD_I_EXT	FMV_CURVE	CRMC_FMV_CURVE	FMV_CURVE
10	CRMT_FINPROD_I_EXT	LINK_TO_TC	CRMC_FIN_TC	LINK_TO_TC	KEY	1	CN
11	CRMT_FINPROD_I_EXT	PRICING_FIMA	CRMC_PROCESS_FM	PRICING_PROCESS
12	CRMT_FINPROD_I_EXT	REFERENCE_INTE_D	T056R	REFERENZ	KEY	1	CN
13	CRMT_FINPROD_I_EXT	RESID_VALUE_GRP	CRMC_RESIDVLGR	RESID_VALUE_GRP	KEY	1	CN
14	CRMT_FINPROD_I_EXT	ROUND_PROFILE	CRMC_ROUND_PROFR	ROUND_PROFILE	KEY	1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	20C