SAP ABAP Table CRMT_FIMAN_BILLING_WRK (Billing Structure Merge with Orderadm_i)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-LAM (Application Component) CRM Leasing
⤷

CRM_LEASING_CHECKREPORTING (Package) Check Reporting for Leasing

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_FIMAN_BILLING_WRK	Table Relationship Diagram
Short Description	Billing Structure Merge with Orderadm_i

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	REFHEADER	CRMT_OBJECT_GUID_HEADER	SYSUUID	RAW	16	0	Header GUID
2	REFGUID	CRMT_OBJECT_GUID_ITEM	SYSUUID	RAW	16	0	Financing Item GUID
3	FAPGUID	CRMT_OBJECT_GUID_FAP	SYSUUID	RAW	16	0	BRI GUID
4	NUMBER_INT	CRMT_ITEM_NO_FAP	CRM_ITEM_NO	NUMC	10	0	BRI Number
5	REF_OBJECT_ID	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
6	REF_NUMBER_INT	CRMT_ITEM_NO_FAP	CRM_ITEM_NO	NUMC	10	0	BRI Number
7	REFBILLPLAN	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
8	CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
9	PARENT	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
10	ERROR	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
11	STATUS	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
12	.INCLUDE				0	0	Business Transaction - Billing Set
13	.INCLUDE				0	0	One Order: Key Fields
14	CLIENT	MANDT	MANDT	CLNT	3	0	Client	*
15	GUID	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
16	.INCLUDE				0	0	Billing Data: External Fields
17	.INCLUDE				0	0	Date Fields at Deadline Level: External Part
18	PERIOD_DATE	CRMT_PERIOD_DATE	BCOS_TSTMP	DEC	15	0	Period Date
19	RULE_PERIOD_DATE	CRMT_RULE_PERIOD_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Period Date	*
20	SETTL_FROM	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
21	RULE_SETTL_FROM	CRMT_RULE_SETTL_FROM	TIMERULEID	RAW	16	0	Rule for Determining Start of Settlement Period	*
22	SETTL_TO	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
23	RULE_SETTL_TO	CRMT_RULE_SETTL_TO	TIMERULEID	RAW	16	0	Rule for Determining End of Settlement Period	*
24	BILL_DATE	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
25	RULE_BILL_DATE	CRMT_RULE_BILL_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Next Billing Date	*
26	INVCR_DATE	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
27	RULE_INVCR_DATE	CRMT_RULE_INVCR_DATE	TIMERULEID	RAW	16	0	Rule for Determining Next Billing Document Creation Date	*
28	VALUE_DATE	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
29	RULE_VALUE_DATE	CRMT_RULE_VALUE_DATE	TIMERULEID	RAW	16	0	Rule for Origin of Next Fixed Value Date	*
30	BILLING_TIMEZONE	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	TTZZ
31	.INCLUDE				0	0	Billing Data: External Fields
32	SETTL_FIMA	CRMT_SETTL_FIMA	BCOS_TSTMP	DEC	15	0	Internal Billing Date for Financial Mathematics
33	FIMA_KONDIND	CRMT_FIMA_KONDIND		NUMC	10	0	Reference FIMA Condition Item
34	FIMA_BEWEIND	CRMT_FIMA_BEWEIND		NUMC	10	0	Reference FIMA Flow Record
35	BILLING_BLOCK	CRMT_BUS_BILL_BLOCK_REASON	CRM_BILLING_BLOCK	CHAR	2	0	Business Partner (CRM): Billing Block Reason	*
36	BUAG_GUID	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
37	BP_SUBTYPE	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype	*
38	.INCLUDE				0	0	External UBB Fields for a Billing Plan Date
39	PERIOD_TYPE	CRMT_PERIOD_TYPE	CRM_PERIOD_TYPE	CHAR	2	0	Period Type (First, Last, First and Last, etc.)	*
40	LOC_GUID	CRMT_LOC_GUID	SYSUUID_C	CHAR	32	0	Letter of Credit GUID from SAP Global Trade Services
41	LOC_REQUIRED	CRMT_LOC_REQUIRED	CRM_BOOLEAN	CHAR	1	0	Letter of Credit required
42	LOC_EXT_NUMBER	CRMT_LOC_EXTERNAL_NUMBER		CHAR	40	0	External Number Letter of Credit
43	.INCLUDE				0	0	EEW Include
44	BILLING_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
45	.INCLUDE				0	0
46	SEPA_ON	CRMT_SEPA_ON	CRM_SEPA_ON	CHAR	1	0	Indicator for SEPA-Relevant Transactions
47	MANDATE_ID	CRMT_MANDATE_ID	CRM_MANDATE_ID	CHAR	35	0	Unique Reference to Mandate per Payment Recipient
48	.INCLUDE				0	0	Billing Data: Internal Fields
49	.INCLUDE				0	0	Date Fields at Deadline Level: Internal Part
50	KIND_PERIOD_DATE	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
51	KIND_SETTL_FROM	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
52	KIND_SETTL_TO	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
53	KIND_BILL_DATE	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
54	KIND_INVCR_DATE	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
55	KIND_VALUE_DATE	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
56	KIND_START_DATE	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
57	KIND_END_DATE	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
58	KIND_DATE_FROM	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
59	KIND_DATE_TO	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
60	.INCLU-FM1				0	0	Payment Schedule from FIMA
61	CLIENTFM1	MANDT	MANDT	CLNT	3	0	Client	*
62	BILLP_GUIDFM1	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
63	FINVIEWFM1	CRMT_FIMAN_FINVIEW	CRMT_FIMAN_FINVIEW	NUMC	2	0	View	*
64	NUMBER_INTFM1	CRMT_FIMAPAYMENTS_NUMBER_INT		NUMC	6	0	FIMA Payment Schedule: Internal Number (per Financing View)
65	RURKONDINDFM1	CRMT_FIMAN_INDEX		NUMC	10	0	Reference Index for Conditions/Flows
66	RURBEWEINDFM1	CRMT_FIMAN_INDEX		NUMC	10	0	Reference Index for Conditions/Flows
67	SETTL_FR_TFM1	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
68	SETTL_TO_TFM1	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
69	SETTL_FIMAFM1	CRMT_SETTL_FIMA	BCOS_TSTMP	DEC	15	0	Internal Billing Date for Financial Mathematics
70	BILL_DATEFM1	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
71	VALUE_DATEFM1	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
72	CASHFL_TYPFM1	CRMT_FIMAN_CFTYPE	CRMT_FIMAN_CFTYPE	CHAR	4	0	Flow Category
73	BILL_VALUEFM1	TFM_BLEIST	TFM_WRTV12	CURR	23	2	Payment Amount (Principle and Interest)
74	INTERESTFM1	TFM_BZINS	TFM_WRTV12	CURR	23	2	Interest amount
75	PRINCIPLEFM1	TFM_BTILG	TFM_WRTV12	CURR	23	2	Repayment amount
76	BALANCEFM1	TFM_BSALDO	TFM_WRTV12	CURR	23	2	Remaining Capital
77	SETTLEDFM1	CRMT_FIMAN_SETTLED	CRMT_FIMAN_SETTLED	CHAR	1	0	Settled Payment Step
78	BRI_INT_NOFM1	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
79	.INCLU-FM3				0	0	Payment Schedule from FIMA
80	CLIENTFM3	MANDT	MANDT	CLNT	3	0	Client	*
81	BILLP_GUIDFM3	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
82	FINVIEWFM3	CRMT_FIMAN_FINVIEW	CRMT_FIMAN_FINVIEW	NUMC	2	0	View	*
83	NUMBER_INTFM3	CRMT_FIMAPAYMENTS_NUMBER_INT		NUMC	6	0	FIMA Payment Schedule: Internal Number (per Financing View)
84	RURKONDINDFM3	CRMT_FIMAN_INDEX		NUMC	10	0	Reference Index for Conditions/Flows
85	RURBEWEINDFM3	CRMT_FIMAN_INDEX		NUMC	10	0	Reference Index for Conditions/Flows
86	SETTL_FR_TFM3	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
87	SETTL_TO_TFM3	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
88	SETTL_FIMAFM3	CRMT_SETTL_FIMA	BCOS_TSTMP	DEC	15	0	Internal Billing Date for Financial Mathematics
89	BILL_DATEFM3	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
90	VALUE_DATEFM3	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
91	CASHFL_TYPFM3	CRMT_FIMAN_CFTYPE	CRMT_FIMAN_CFTYPE	CHAR	4	0	Flow Category
92	BILL_VALUEFM3	TFM_BLEIST	TFM_WRTV12	CURR	23	2	Payment Amount (Principle and Interest)
93	INTERESTFM3	TFM_BZINS	TFM_WRTV12	CURR	23	2	Interest amount
94	PRINCIPLEFM3	TFM_BTILG	TFM_WRTV12	CURR	23	2	Repayment amount
95	BALANCEFM3	TFM_BSALDO	TFM_WRTV12	CURR	23	2	Remaining Capital
96	SETTLEDFM3	CRMT_FIMAN_SETTLED	CRMT_FIMAN_SETTLED	CHAR	1	0	Settled Payment Step
97	BRI_INT_NOFM3	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
98	.INCLU-FM2				0	0	Payment Schedule from FIMA
99	CLIENTFM2	MANDT	MANDT	CLNT	3	0	Client	*
100	BILLP_GUIDFM2	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
101	FINVIEWFM2	CRMT_FIMAN_FINVIEW	CRMT_FIMAN_FINVIEW	NUMC	2	0	View	*
102	NUMBER_INTFM2	CRMT_FIMAPAYMENTS_NUMBER_INT		NUMC	6	0	FIMA Payment Schedule: Internal Number (per Financing View)
103	RURKONDINDFM2	CRMT_FIMAN_INDEX		NUMC	10	0	Reference Index for Conditions/Flows
104	RURBEWEINDFM2	CRMT_FIMAN_INDEX		NUMC	10	0	Reference Index for Conditions/Flows
105	SETTL_FR_TFM2	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
106	SETTL_TO_TFM2	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
107	SETTL_FIMAFM2	CRMT_SETTL_FIMA	BCOS_TSTMP	DEC	15	0	Internal Billing Date for Financial Mathematics
108	BILL_DATEFM2	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
109	VALUE_DATEFM2	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
110	CASHFL_TYPFM2	CRMT_FIMAN_CFTYPE	CRMT_FIMAN_CFTYPE	CHAR	4	0	Flow Category
111	BILL_VALUEFM2	TFM_BLEIST	TFM_WRTV12	CURR	23	2	Payment Amount (Principle and Interest)
112	INTERESTFM2	TFM_BZINS	TFM_WRTV12	CURR	23	2	Interest amount
113	PRINCIPLEFM2	TFM_BTILG	TFM_WRTV12	CURR	23	2	Repayment amount
114	BALANCEFM2	TFM_BSALDO	TFM_WRTV12	CURR	23	2	Remaining Capital
115	SETTLEDFM2	CRMT_FIMAN_SETTLED	CRMT_FIMAN_SETTLED	CHAR	1	0	Settled Payment Step
116	BRI_INT_NOFM2	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document