SAP ABAP Table CRMT_7786_FINPROD_I_UI (CRM: Financing Terms Item)

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_7786_FINPROD_I_UI	Table Relationship Diagram
Short Description	CRM: Financing Terms Item

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	Management of Interface Structures
2	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
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	Extended Financing Terms
85	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	*
86	BILPR	☐	BLIT_BILPR	BLI_BILPR	CHAR	6	0	Billing Procedure
87	.INCLUDE	☐				0	0	Item Data of Financing Product Options - External Fields
88	OPTION_TYPE	☐	CRMT_OPTION_ART_01	CRMT_OPTION_ART_01	CHAR	4	0	Option Type	CRMC_PR_FINOP1
89	VALUATION	☐	CRMT_VALUATION_FLAG	CRMT_VALUATION_FLAG	CHAR	1	0	Valuation Only on Exercise Date
90	PRESTATED	☐	CRMT_PRESTATED_FLAG	CRMT_PRESTATED_FLAG	CHAR	1	0	Option Was Agreed to by Customer
91	BARGAIN	☐	CRMT_BARGAIN	CRMT_BARGAIN	CHAR	1	0	Bargain Option Indicator
92	PRICING_PROCESS	☐	CRMT_PRICING_PROCESS_OPT	CRMT_PRICING_PROCESS	CHAR	4	0	Pricing Process	CRMC_PROCESS_OP
93	PRICING_PROCESS1	☐	CRMT_PRICING_PROCESS_OPT_SUB1	CRMT_PRICING_PROCESS1	CHAR	4	0	Sub-Pricing Process	CRMC_PROCESS_O1
94	FINOPT_DEF	☐	CRMT_FINOPT_DEF_EXE	XFELD	CHAR	1	0	Standard at Contract End
95	OPTION_CRE_MODE	☐	CRMT_OPTION_CREATE_MODE	CHAR1	CHAR	1	0	Create Mode for Option (Manual, Copied, Generated)

Foreign Keys

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

History

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