SAP ABAP Table CRMT_FIMAP_PACKAGE_FLAT (FIMA Package Flat Part)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-FIN (Application Component) Financing
     ⤷ CRM_FIMAN_ALGORITHMS (Package) Financial Mathematics Algorithms

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_FIMAP_PACKAGE_FLAT	Table Relationship Diagram
Short Description	FIMA Package Flat Part

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	Billing Plan Date: Work Area and Object Buffer Structure
2	.INCLUDE	☐				0	0	Billing Plan Date
3	.INCLUDE	☐				0	0	One Order: Key Fields
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	.INCLUDE	☐				0	0	Billing Plan Deadline: External Fields
7	BILLPLAN_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
8	.INCLUDE	☐				0	0	Date Fields at Deadline Level: External Part
9	PERIOD_DATE	☐	CRMT_PERIOD_DATE	BCOS_TSTMP	DEC	15	0	Period Date
10	RULE_PERIOD_DATE	☐	CRMT_RULE_PERIOD_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Period Date	*
11	SETTL_FROM	☐	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
12	RULE_SETTL_FROM	☐	CRMT_RULE_SETTL_FROM	TIMERULEID	RAW	16	0	Rule for Determining Start of Settlement Period	*
13	SETTL_TO	☐	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
14	RULE_SETTL_TO	☐	CRMT_RULE_SETTL_TO	TIMERULEID	RAW	16	0	Rule for Determining End of Settlement Period	*
15	BILL_DATE	☐	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
16	RULE_BILL_DATE	☐	CRMT_RULE_BILL_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Next Billing Date	*
17	INVCR_DATE	☐	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
18	RULE_INVCR_DATE	☐	CRMT_RULE_INVCR_DATE	TIMERULEID	RAW	16	0	Rule for Determining Next Billing Document Creation Date	*
19	VALUE_DATE	☐	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
20	RULE_VALUE_DATE	☐	CRMT_RULE_VALUE_DATE	TIMERULEID	RAW	16	0	Rule for Origin of Next Fixed Value Date	*
21	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	TTZZ
22	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
23	BILL_VALUE	☐	CRMT_BILL_VALUE	CRM_COND_VALUE	CURR	19	2	Value to be Billed on Date Specified in Billing Plan
24	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
25	NO_OF_PERIODS	☐	CRMT_NO_OF_PERIODS		NUMC	5	0	Number of Periods in Billing Plan
26	NUMBER_INT	☐	CRMT_BILL_NUMBER_INT		NUMC	10	0	Billing Plan: Internal Sort Order
27	CASHFLOW_TYPE	☐	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
28	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
29	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
30	NO_BILLITEMS	☐	CRMT_NO_BILLITEMS	XFELD	CHAR	1	0	Generate Flag for No Billing Request Items
31	BP_USAGE	☐	CRMT_BP_USAGE	CRMT_BP_USAGE	CHAR	1	0	Billing Plan Usage
32	BILLPLAN_LINE_ID	☐	CRMT_BILLPLAN_LINE_ID	CRMT_BILLPLAN_LINE_ID	CHAR	2	0	ID of Billing Plan Line
33	START_DATE	☐	CRMT_START_DATE	BCOS_TSTMP	DEC	15	0	Start Date of Billing Plan
34	RULE_START_DATE	☐	CRMT_RULE_START_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan Start Date	*
35	END_DATE	☐	CRMT_END_DATE	BCOS_TSTMP	DEC	15	0	End Date of Billing Plan
36	RULE_END_DATE	☐	CRMT_RULE_END_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan End Date	*
37	DATE_FROM	☐	CRMT_DATE_FROM	BCOS_TSTMP	DEC	15	0	Dates From
38	RULE_DATE_FROM	☐	CRMT_RULE_DATE_FROM	TIMERULEID	RAW	16	0	Rule for Determining Dates from	*
39	DATE_TO	☐	CRMT_DATE_TO	BCOS_TSTMP	DEC	15	0	Dates To
40	RULE_DATE_TO	☐	CRMT_RULE_DATE_TO	TIMERULEID	RAW	16	0	Rule for Determining Dates To	*
41	RULE_STA_DATE_T	☐	CRMT_RULE_START_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan Start Date
42	RULE_END_DATE_T	☐	CRMT_RULE_END_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan End Date
43	RULE_DATE_FROM_T	☐	CRMT_RULE_DATE_FROM_T	TIMENAME	CHAR	12	0	Rule for determining dates from
44	RULE_DATE_TO_T	☐	CRMT_RULE_DATE_TO_T	TIMENAME	CHAR	12	0	Rule for Determining Dates to
45	BP_SUBTYPE	☐	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype	*
46	.INCLUDE	☐				0	0	External UBB Fields for a Billing Plan Date
47	BPLAN_DATE_TYPE	☐	CRMT_BILLPLAN_DATE_TYPE	CRM_BILLPLAN_DATE_TYPE	NUMC	2	0	UBB Billing Plan Date Type
48	NO_OF_BLOCK	☐	CRMT_NO_OF_BLOCK		NUMC	3	0	UBB Pool Assignment
49	PROC_EVENT_TYPE	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type	CRMC_PE_TYPE
50	PROC_EVENT_TYPE2	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type	CRMC_PE_TYPE
51	RULE_PER_ORIG_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date
52	PERIOD_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
53	PERIOD_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
54	.INCLUDE	☐				0	0	Billing Plan Deadline: Internal Fields
55	.INCLUDE	☐				0	0	Date Fields at Deadline Level: Internal Part
56	KIND_PERIOD_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
57	KIND_SETTL_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
58	KIND_SETTL_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
59	KIND_BILL_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
60	KIND_INVCR_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
61	KIND_VALUE_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
62	KIND_START_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
63	KIND_END_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
64	KIND_DATE_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
65	KIND_DATE_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
66	.INCLUDE	☐				0	0	Milestone Billing Plan: Internal Fields
67	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
68	.INCLUDE	☐				0	0	Billing Plan Date: Internal Dynamic Fields
69	LINE_CHANGED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
70	.INCLUDE	☐				0	0	Billing Plan Deadline: Dynamic Communication Fields
71	RULE_PER_DATE_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date
72	RULE_BILL_DATE_T	☐	CRMT_RULE_BILL_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Next Billing Date
73	RULE_INV_DATE_T	☐	CRMT_RULE_INVCR_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Next Billing Document Creation Date
74	RULE_VAL_DATE_T	☐	CRMT_RULE_VALUE_DATE_T	TIMENAME	CHAR	12	0	Rule for Origin of Next Fixed Value Date
75	RULE_SET_FROM_T	☐	CRMT_RULE_SETTL_FROM_T	TIMENAME	CHAR	12	0	Rule for Determining Start of Settlement Period
76	RULE_SETTL_TO_T	☐	CRMT_RULE_SETTL_TO_T	TIMENAME	CHAR	12	0	Rule for Determining End of Settlement Period
77	SUPPRESS_EVENT	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
78	BILLPLAN_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
79	.INCLUDE	☐				0	0	Date in Billing Plan Reference for FIMA Without Key Fields
80	.INCLUDE	☐				0	0	External FIMA Fields for a Billing Plan Date
81	.INCLUDE	☐				0	0	External FIMA Field FIN_VIEW for a Billing Plan Date
82	FIN_VIEW	☐	CRMT_FINANCING_VIEW	CRMT_FINANCING_VIEW	NUMC	2	0	Financing View	*
83	SCHED_IND	☐	CRMT_SCHED_INDICATOR	CRM_SCHED_INDICATOR	CHAR	1	0	Schedule Line Indicator for Billing Plan
84	.INCLUDE	☐				0	0	External FIMA Fields for a Billing Plan Date
85	PER_PAYMENTFORM	☐	CRMT_PER_PAYMENTFORM	CRMT_PAYMENTFORM	NUMC	1	0	When Due in Period	*
86	UNIT_PERIODS	☐	CRMT_UNIT_PERIODS	TFMSINSTALLMENT	NUMC	2	0	Time Unit for Periods
87	MAN_FIRSTDUEDATE	☐	CRMT_MAN_FIRSTDUEDATE	BCOS_TSTMP	DEC	15	0	Individual Due Date
88	NOMINAL_INT_RATE	☐	CRMT_NOMINAL_INT_RATE	DECV3_7	DEC	10	7	Nominal Interest Rate
89	NOMINAL_IRAT_INT	☐	CRMT_NOMINAL_INT_RATE_INT	DECV3_7	DEC	10	7	Nominal Interest Rate (Internal Plan)
90	DEFAULT_AMOUNT	☐	CRMT_DEFAULT_AMOUNT	CRMT_COND_VALUE	CURR	19	2	Default Amount
91	DEFAULT_PERCENT	☐	CRMT_DEFAULT_PERCENTAGE	DECV3_7	DEC	10	7	Default Percentage
92	DEF_RATEPERX	☐	CRMT_DEFAULT_RATEPERK	CRMT_DECV7_10	DEC	17	10	Default Rate per x
93	FREQ_CONVERSION	☐	CRMT_FREQ_CONVERSION	TFM_PPAYMENT_INTERN	DEC	6	0	Payment Frequency Factor
94	CALCULATION_DATE	☐	CRMT_CALCULATION_DATE	BCOS_TSTMP	DEC	15	0	Calculation date
95	FLAG_ULTIMO	☐	CRMT_FLAG_ULTIMO	XFELD	CHAR	1	0	Do Not Draw Standard Values from Conditions
96	FLAG_BLOCKED	☐	CRMT_FLAG_BLOCKED	XFELD	CHAR	1	0	Calculation Locked
97	STEP_KIND	☐	CRMT_STEP_KIND	CRMT_STEP_KIND	NUMC	2	0	Payment Structure/Change to Principal Indicator
98	FIXING	☐	CRMT_STEP_FIXING	CRMT_FINPROD_FIX01	NUMC	2	0	Field Control Billplan_d Rows (Fixed/Changeable)
99	SETTL_FROM_VIRTU	☐	CRMT_SETTL_FROM_FIMA	BCOS_TSTMP	DEC	15	0	Virtual Start of Settlement of Period
100	DATEUPD_SUPPRESS	☐	CRMT_DATEUPD_SUPPRESS	CRMT_DATEUPD_SUPPRESS	CHAR	1	0	No Date Update (FIMA)
101	OFFSET_VAL	☐	CRMT_FINPROD_OFFS01	DEC5	DEC	5	0	Offset
102	OFFSET_UNIT	☐	CRMT_FINPROD_OFFSU01	TIMEUNITNA	CHAR	12	0	Offset Unit	*
103	SETTLED	☐	CRMT_FIMAN_SETTLED	CRMT_FIMAN_SETTLED	CHAR	1	0	Settled Payment Step
104	FACTOR1	☐	CRMT_FIMAN_FACTOR	DECV5_10	DEC	15	10	Factor
105	FACTOR2	☐	CRMT_FIMAN_FACTOR	DECV5_10	DEC	15	10	Factor
106	FACTOR3	☐	CRMT_FIMAN_FACTOR	DECV5_10	DEC	15	10	Factor
107	.INCLUDE	☐				0	0	External FIMA Result Fields of Date in Reference
108	RESULT_AMOUNT	☐	CRMT_RESULT_AMOUNT	CRMT_COND_VALUE	CURR	19	2	Resulting Amount
109	RESULT_AMOUNT_PR	☐	CRMT_AMOUNT_PRECISE	CRMT_COND_VALUE	CURR	19	2	Unrounded Result Amount
110	RPX_DIVISOR	☐	CRMT_RPXDIV	CRMT_COND_VALUE	CURR	19	2	Divisor for Rate per x Determination
111	RESULT_RATEPERK	☐	CRMT_RESULT_RATEPERK	CRMT_DECV7_10	DEC	17	10	Rate per x
112	RESULT_RATE_K_G	☐	CRMT_RESULT_RATEPERK_G	CRMT_DECV7_10	DEC	17	10	Gross Rate per X
113	.INCLUDE	☐				0	0	Amount Allocation for Billing Plan: External Fields
114	PARTNER1	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
115	PARTNER1_NO	☐	COMT_PARTNER_NUMBER	COM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
116	PARTNER1_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
117	PARTNER2	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
118	PARTNER2_NO	☐	COMT_PARTNER_NUMBER	COM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
119	PARTNER2_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
120	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	*
121	AC_OBJECT_TYPE	☐	CRMT_AC_OBJECT_TYPE	CRMT_OBJECT_TYPE	CHAR	2	0	Object Type for Settlement Account Assignment	*
122	AC_ASSIGNMENT	☐	CRMT_AC_ASSIGN	CRMT_AC_ASSIGN	CHAR	50	0	Settlement Account Assignment
123	AC_PERCENTAGE	☐	CRMT_AC_COST_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Costs to Be Distributed
124	SPLIT_ORIGIN	☐	CRMT_SPLIT_ORIGIN	CRMT_SPLIT_ORIGIN	CHAR	2	0	Origin Split
125	KSCHL	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
126	.INCLUDE	☐				0	0	External Grouping Fields for Amount Allocation
127	GROUP1	☐	CRMT_GROUP1	CRMT_GROUP	CHAR	32	0	Group 1
128	GROUP2	☐	CRMT_GROUP2	CRMT_GROUP	CHAR	32	0	Group 2
129	GROUP3	☐	CRMT_GROUP3	CRMT_GROUP	CHAR	32	0	Group 3
130	GROUP4	☐	CRMT_GROUP4	CRMT_GROUP	CHAR	32	0	Group 4
131	GROUP5	☐	CRMT_GROUP5	CRMT_GROUP	CHAR	32	0	Group 5
132	GROUP6	☐	CRMT_GROUP6	CRMT_GROUP	CHAR	32	0	Group 6
133	GROUP7	☐	CRMT_GROUP7	CRMT_GROUP	CHAR	32	0	Group 7
134	INTEREST_NEW	☐	TFM_PEFFZINS	DECV3_7	DEC	10	7	Effective interest
135	UPDATE_STATUS_OK	☐	CRMT_STATUS_OK	XFELD	CHAR	1	0	Document OK
136	HEADER_NO	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
137	ITEM_NO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
138	SUM_INT_ORI	☐	CRMT_BZINSEN_ORI	TFM_WRTV12	CURR	23	2	Original Interest
139	SUM_INT_NEW	☐	CRMT_BZINSEN_ACT	TFM_WRTV12	CURR	23	2	Current Interest
140	SUM_INT_DIFF	☐	CRMT_BZINSEN_DIF	TFM_WRTV12	CURR	23	2	Interest Difference

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_FIMAP_PACKAGE_FLAT	BILLING_TIMEZONE	TTZZ	TZONE
2	CRMT_FIMAP_PACKAGE_FLAT	CURRENCY	TCURC	WAERS
3	CRMT_FIMAP_PACKAGE_FLAT	PROC_EVENT_TYPE	CRMC_PE_TYPE	PROC_EVENT_TYPE	KEY	1	CN
4	CRMT_FIMAP_PACKAGE_FLAT	PROC_EVENT_TYPE2	CRMC_PE_TYPE	PROC_EVENT_TYPE	KEY	1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	510