SAP ABAP Table CRMT_BSP_LAM_COMB_PROD_IL (Item Data (Combined Physical Product/Financing Product))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-FIN (Application Component) Financing
     ⤷ CRM_BSP_MODEL_IL_LEASING (Package) Model Implementation: Leasing

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_LAM_COMB_PROD_IL	Table Relationship Diagram
Short Description	Item Data (Combined Physical Product/Financing Product)

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	HEADER_CHAR	☐			CHAR	32	0
5	SCHED_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	PROD_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
7	PROD_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
8	PROD_SCHED_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
9	NUMBER_INT	☐	CRMT_BSP_ITEM_NO	CRM_BSP_ITEM_NO	NUMC	10	0	Item Number in Document
10	ORDERED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
11	DESCRIPTION	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
12	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
13	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
14	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	T006
15	FROM_TIME_IO	☐	CRMT_BSP_CONTSTART	TZTF_IO_FIELD	CHAR	26	0	Contract Start Date
16	FROM_TIME	☐	EV_FR_TIME	BCOS_TSTMP	DEC	15	0	Start Time Stamp: Date
17	LATEST_TIME_CONFIRMED	☐	CRMT_SCHEDLIN_LTIME_CONFIRMED	BCOS_TSTMP	DEC	15	0	Latest Confirmation Date for an Item
18	LATEST_TIME_CONFIRMED_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
19	MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
20	ORDER_QTY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
21	CONFIRMED_QTY	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
22	NUMBER_PARENT	☐	CRMT_BSP_ITEM_NO_PARENT	CRM_BSP_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Document
23	NUMBER_ALTERN	☐	CRMT_BSP_ITEM_NO	CRM_BSP_ITEM_NO	NUMC	10	0	Item Number in Document
24	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
25	STATUS_TXT	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
26	STATUS_ICON	☐	CRMT_ATP_ICON	SYCHAR132	CHAR	132	0	ATP Traffic light
27	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
28	DLV_GROUP	☐	CRMT_DLV_GROUP	CRMT_DLV_GROUP	NUMC	3	0	Delivery Group (Items are Delivered Together)
29	DLV_GROUP_DATE	☐	CRMT_DLV_GROUP_DATE	BCOS_TSTMP	DEC	15	0	Delivery Group Date
30	DLV_GROUP_DATE_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
31	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
32	PROC_IDENT	☐	CRMT_ITM_PROC_IDENT	CRM_ITM_PROC_IDENT	CHAR	4	0	Process Identifier
33	BILLED_QTY	☐	CRMT_BILLED_QTY	CRM_MENGV15	QUAN	15	3	Billed Quantity
34	BILLED_VALUE	☐	CRMT_BILLED_VALUE	CRM_COND_VALUE	CURR	19	2	Billed Value
35	BILL_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
36	DELIVERED_QTY	☐	CRMT_DELIVERED_QTY	CRM_MENGV15	QUAN	15	3	Delivered Quantity
37	FINPROD_ICON	☐	CRMT_LEAS_FIN_ICON	SYCHAR132	CHAR	132	0	Choose Financing Product
38	GOODS_ISSUE_QTY	☐	CRMT_GOODS_ISSUE_QTY	CRM_MENGV15	QUAN	15	3	Goods Issue Quantity
39	ETAX_HAND_TYPE	☐	CRMT_ETAX_HAND_TYPE	CRM_ETAX_HAND_TYPE	CHAR	2	0	Excise Tax Handling Type (Denotes Use of Material)	CRMC_ETAX_HTYP
40	PARENT_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
41	PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
42	FIN_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
43	FIN_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
44	FIN_SCHED_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
45	FIN_NUMBER_INT	☐	CRMT_BSP_ITEM_NO	CRM_BSP_ITEM_NO	NUMC	10	0	Item Number in Document
46	FIN_ORDERED_PROD	☐	CRMT_BSP_LAM_FIN_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
47	FIN_DESCRIPTION	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
48	FIN_ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
49	FIN_QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
50	FIN_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	T006
51	FIN_FROM_TIME_IO	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
52	FIN_FROM_TIME	☐	EV_FR_TIME	BCOS_TSTMP	DEC	15	0	Start Time Stamp: Date
53	FIN_LATEST_TIME_CONFIRMED	☐	CRMT_SCHEDLIN_LTIME_CONFIRMED	BCOS_TSTMP	DEC	15	0	Latest Confirmation Date for an Item
54	FIN_LATEST_TIME_CONFIRMED_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
55	FIN_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
56	FIN_ORDER_QTY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
57	FIN_CONFIRMED_QTY	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
58	FIN_NUMBER_PARENT	☐	CRMT_BSP_ITEM_NO_PARENT	CRM_BSP_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Document
59	FIN_NUMBER_ALTERN	☐	CRMT_ITEM_NO_ALTERNATIVE	CRM_ITEM_NO	NUMC	10	0	Item for Which This Item is an Alternative in the Document
60	FIN_PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
61	FIN_STATUS_TXT	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
62	FIN_STATUS_ICON	☐	CRMT_ATP_ICON	SYCHAR132	CHAR	132	0	ATP Traffic light
63	FIN_ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
64	FIN_DLV_GROUP	☐	CRMT_DLV_GROUP	CRMT_DLV_GROUP	NUMC	3	0	Delivery Group (Items are Delivered Together)
65	FIN_DLV_GROUP_DATE	☐	CRMT_DLV_GROUP_DATE	BCOS_TSTMP	DEC	15	0	Delivery Group Date
66	FIN_DLV_GROUP_DATE_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
67	FIN_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
68	FIN_PROC_IDENT	☐	CRMT_ITM_PROC_IDENT	CRM_ITM_PROC_IDENT	CHAR	4	0	Process Identifier
69	FIN_BILLED_QTY	☐	CRMT_BILLED_QTY	CRM_MENGV15	QUAN	15	3	Billed Quantity
70	FIN_BILLED_VALUE	☐	CRMT_BILLED_VALUE	CRM_COND_VALUE	CURR	19	2	Billed Value
71	FIN_BILL_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
72	FIN_DELIVERED_QTY	☐	CRMT_DELIVERED_QTY	CRM_MENGV15	QUAN	15	3	Delivered Quantity
73	FIN_GOODS_ISSUE_QTY	☐	CRMT_GOODS_ISSUE_QTY	CRM_MENGV15	QUAN	15	3	Goods Issue Quantity
74	FIN_PARENT_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
75	FIN_PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
76	STEP_STRUCTURE	☐	CRMT_FIMAN_STEPSTR	XFELD	CHAR	1	0	Step Payments
77	ONE_VIEW_FLAG	☐	CRMT_ONE_VIEW_FLAG	CRMT_ONE_VIEW_FLAG	CHAR	1	0	Manage Only One View
78	LESSOR_IRR	☐	CRMT_LESSOR_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Lessor Internal Rate of Return
79	ACCOUNT_IRR	☐	CRMT_ACCOUNT_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Internal Rate of Return for Accounting
80	CUSTOMER_IRR	☐	CRMT_CUSTOMER_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Lessee Internal Rate of Return
81	TAX_IRR	☐	CRMT_TAX_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Internal Rate of Return - Tax
82	CUSTOM_COMPL_IRR	☐	CRMT_CUSTOMER_COMPL_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Cust.Compl.View -Internal Rate of Return(Effective Int.Rate)
83	FEES_IRR	☐	CRMT_FEES_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Fees View - Internal Rate of Return (Effective Int. Rate)
84	SERVICE_IRR	☐	CRMT_SERVICE_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Service Internal Rate of Return (Effective Interest Rate)
85	CSTINCL_IRR	☐	CRMT_CSTINCL_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Cost Inclusion -Internal Rate of Return(Effective Int. Rate)
86	RESULT_RATEPERK	☐	CRMT_RESULT_RATEPERK	CRMT_DECV7_10	DEC	17	10	Rate per x
87	RESULT_AMOUNT	☐	CRMT_RESULT_AMOUNT	CRMT_COND_VALUE	CURR	19	2	Resulting Amount
88	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
89	CHNG_PROCESS	☐	CRMT_LEAS_CHNG	CRMT_LEAS_CHNG_PROC	CHAR	4	0	Change Process	*
90	DURATION	☐	CRMT_BSP_LAM_NEW_LEASDURATION	TIMEDURA	DEC	13	0	Lease Duration
91	TIME_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
92	TIME_UNIT_TEXT	☐	UDZEITE	UDZEITE	CHAR	20	0	Time unit
93	TIME_OUT_FROM	☐	CRMT_BSP_CONTSTART	TZTF_IO_FIELD	CHAR	26	0	Contract Start Date
94	KSCHL_1	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
95	KBETR_1	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
96	WAERS_1	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
97	KPEIN_1	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
98	KMEIN_1	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
99	KSCHL_2	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
100	KBETR_2	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
101	WAERS_2	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
102	KPEIN_2	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
103	KMEIN_2	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
104	KSCHL_3	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
105	KBETR_3	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
106	WAERS_3	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
107	KPEIN_3	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
108	KMEIN_3	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
109	KSCHL_4	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
110	KBETR_4	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
111	WAERS_4	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
112	KPEIN_4	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
113	KMEIN_4	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
114	KSCHL_5	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
115	KBETR_5	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
116	WAERS_5	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
117	KPEIN_5	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
118	KMEIN_5	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
119	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
120	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
121	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
122	PRODUCT_FIN	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_LAM_COMB_PROD_IL	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
2	CRMT_BSP_LAM_COMB_PROD_IL	FIN_ITM_TYPE	CRMC_ITEM_TYPE	ITM_TYPE
3	CRMT_BSP_LAM_COMB_PROD_IL	FIN_QTY_UNIT	T006	MSEHI
4	CRMT_BSP_LAM_COMB_PROD_IL	ITM_TYPE	CRMC_ITEM_TYPE	ITM_TYPE
5	CRMT_BSP_LAM_COMB_PROD_IL	QTY_UNIT	T006	MSEHI

History

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