SAP ABAP Table CRMT_REPORT_FINPROD_I (Reporting Structure for CRMT_REPORT_STRUCT_I)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_REPORT_FINPROD_I	Table Relationship Diagram
Short Description	Reporting Structure for CRMT_REPORT_STRUCT_I

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

History

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