SAP ABAP Table CRMA_BILLPLAN_D (Billing Plan - Dates)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-BPL (Application Component) Billing Plan
     ⤷ CRM_BILLPLAN (Package) CRM Billing Plan

Basic Data

Table Category	INTTAB	Structure
Structure	CRMA_BILLPLAN_D	Table Relationship Diagram
Short Description	Billing Plan - Dates

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	NUMBER_INT	☑	CRMT_BILL_NUMBER_INT		NUMC	10	0	Billing Plan: Internal Sort Order
5	.INCLUDE	☑				0	0	External FIMA Field FIN_VIEW for a Billing Plan Date
6	FIN_VIEW	☑	CRMT_FINANCING_VIEW	CRMT_FINANCING_VIEW	NUMC	2	0	Financing View	*
7	SCHED_IND	☑	CRMT_SCHED_INDICATOR	CRM_SCHED_INDICATOR	CHAR	1	0	Schedule Line Indicator for Billing Plan
8	BILLPLAN_GUID	☐	CRMT_OBJECT_GUID32		CHAR	32	0	32 Character CRM Object GUID (Converted)
9	.INCLUDE	☐				0	0	Date Fields at Deadline Level: External Part
10	PERIOD_DATE	☐	CRMT_PERIOD_DATE	BCOS_TSTMP	DEC	15	0	Period Date
11	RULE_PERIOD_DATE	☐	CRMT_RULE_PERIOD_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Period Date	*
12	SETTL_FROM	☐	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
13	RULE_SETTL_FROM	☐	CRMT_RULE_SETTL_FROM	TIMERULEID	RAW	16	0	Rule for Determining Start of Settlement Period	*
14	SETTL_TO	☐	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
15	RULE_SETTL_TO	☐	CRMT_RULE_SETTL_TO	TIMERULEID	RAW	16	0	Rule for Determining End of Settlement Period	*
16	BILL_DATE	☐	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
17	RULE_BILL_DATE	☐	CRMT_RULE_BILL_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Next Billing Date	*
18	INVCR_DATE	☐	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
19	RULE_INVCR_DATE	☐	CRMT_RULE_INVCR_DATE	TIMERULEID	RAW	16	0	Rule for Determining Next Billing Document Creation Date	*
20	VALUE_DATE	☐	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
21	RULE_VALUE_DATE	☐	CRMT_RULE_VALUE_DATE	TIMERULEID	RAW	16	0	Rule for Origin of Next Fixed Value Date	*
22	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	TTZZ
23	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
24	BILL_VALUE	☐	CRMT_BILL_VALUE	CRM_COND_VALUE	CURR	19	2	Value to be Billed on Date Specified in Billing Plan
25	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
26	NO_OF_PERIODS	☐	CRMT_NO_OF_PERIODS		NUMC	5	0	Number of Periods in Billing Plan
27	CASHFLOW_TYPE	☐	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
28	.INCLUDE	☐				0	0	Billing Plan Deadline: Internal Fields
29	.INCLUDE	☐				0	0	Date Fields at Deadline Level: Internal Part
30	KIND_PERIOD_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
31	KIND_SETTL_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
32	KIND_SETTL_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
33	KIND_BILL_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
34	KIND_INVCR_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
35	KIND_VALUE_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
36	KIND_START_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
37	KIND_END_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
38	KIND_DATE_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
39	KIND_DATE_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
40	.INCLUDE	☐				0	0	External FIMA Fields for a Billing Plan Date
41	PER_PAYMENTFORM	☐	CRMT_PER_PAYMENTFORM	CRMT_PAYMENTFORM	NUMC	1	0	When Due in Period	*
42	UNIT_PERIODS	☐	CRMT_UNIT_PERIODS	TFMSINSTALLMENT	NUMC	2	0	Time Unit for Periods
43	MAN_FIRSTDUEDATE	☐	CRMT_MAN_FIRSTDUEDATE	BCOS_TSTMP	DEC	15	0	Individual Due Date
44	NOMINAL_INT_RATE	☐	CRMT_NOMINAL_INT_RATE	DECV3_7	DEC	10	7	Nominal Interest Rate
45	NOMINAL_IRAT_INT	☐	CRMT_NOMINAL_INT_RATE_INT	DECV3_7	DEC	10	7	Nominal Interest Rate (Internal Plan)
46	DEFAULT_AMOUNT	☐	CRMT_DEFAULT_AMOUNT	CRMT_COND_VALUE	CURR	19	2	Default Amount
47	DEFAULT_PERCENT	☐	CRMT_DEFAULT_PERCENTAGE	DECV3_7	DEC	10	7	Default Percentage
48	DEF_RATEPERX	☐	CRMT_DEFAULT_RATEPERK	CRMT_DECV7_10	DEC	17	10	Default Rate per x
49	FREQ_CONVERSION	☐	CRMT_FREQ_CONVERSION	TFM_PPAYMENT_INTERN	DEC	6	0	Payment Frequency Factor
50	CALCULATION_DATE	☐	CRMT_CALCULATION_DATE	BCOS_TSTMP	DEC	15	0	Calculation date
51	FLAG_ULTIMO	☐	CRMT_FLAG_ULTIMO	XFELD	CHAR	1	0	Do Not Draw Standard Values from Conditions
52	FLAG_BLOCKED	☐	CRMT_FLAG_BLOCKED	XFELD	CHAR	1	0	Calculation Locked
53	STEP_KIND	☐	CRMT_STEP_KIND	CRMT_STEP_KIND	NUMC	2	0	Payment Structure/Change to Principal Indicator
54	FIXING	☐	CRMT_STEP_FIXING	CRMT_FINPROD_FIX01	NUMC	2	0	Field Control Billplan_d Rows (Fixed/Changeable)
55	SETTL_FROM_VIRTU	☐	CRMT_SETTL_FROM_FIMA	BCOS_TSTMP	DEC	15	0	Virtual Start of Settlement of Period
56	DATEUPD_SUPPRESS	☐	CRMT_DATEUPD_SUPPRESS	CRMT_DATEUPD_SUPPRESS	CHAR	1	0	No Date Update (FIMA)
57	OFFSET_VAL	☐	CRMT_FINPROD_OFFS01	DEC5	DEC	5	0	Offset
58	OFFSET_UNIT	☐	CRMT_FINPROD_OFFSU01	TIMEUNITNA	CHAR	12	0	Offset Unit	*
59	SETTLED	☐	CRMT_FIMAN_SETTLED	CRMT_FIMAN_SETTLED	CHAR	1	0	Settled Payment Step
60	FACTOR1	☐	CRMT_FIMAN_FACTOR	DECV5_10	DEC	15	10	Factor
61	FACTOR2	☐	CRMT_FIMAN_FACTOR	DECV5_10	DEC	15	10	Factor
62	FACTOR3	☐	CRMT_FIMAN_FACTOR	DECV5_10	DEC	15	10	Factor
63	.INCLUDE	☐				0	0	External FIMA Result Fields of Date in Reference
64	RESULT_AMOUNT	☐	CRMT_RESULT_AMOUNT	CRMT_COND_VALUE	CURR	19	2	Resulting Amount
65	RESULT_AMOUNT_PR	☐	CRMT_AMOUNT_PRECISE	CRMT_COND_VALUE	CURR	19	2	Unrounded Result Amount
66	RPX_DIVISOR	☐	CRMT_RPXDIV	CRMT_COND_VALUE	CURR	19	2	Divisor for Rate per x Determination
67	RESULT_RATEPERK	☐	CRMT_RESULT_RATEPERK	CRMT_DECV7_10	DEC	17	10	Rate per x
68	RESULT_RATE_K_G	☐	CRMT_RESULT_RATEPERK_G	CRMT_DECV7_10	DEC	17	10	Gross Rate per X

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMA_BILLPLAN_D	BILLING_TIMEZONE	TTZZ	TZONE	KEY	1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	30A