SAP ABAP Table CRMT_BSP_LAM_OD1_LFRQ_ITEMDAT (Lean Financing Request ODC1 - Basic Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LAM-BTX-CTR (Application Component) Quotation and Contract
     ⤷ CRM_BSP_FINANCE_DFRQ (Package) Dealer Financing Request

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_LAM_OD1_LFRQ_ITEMDAT	Table Relationship Diagram
Short Description	Lean Financing Request ODC1 - Basic Data

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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	GUID_H	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	HANDLE_H	☐	CRMT_HANDLE		NUMC	10	0	Handle
4	GUID_I	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	HANDLE_I	☐	CRMT_HANDLE		NUMC	10	0	Handle
6	ALLOCATION_ID	☐	CRMT_ALLOCATION_ID_MASK	CRM_ALLOCATION_ID_MASK	CHAR	35	0	External Allocation Number (Wildcard)
7	SOLD_TO_PARTY_GUID	☐	CRMT_SOLD_TO_PARTY	SYSUUID	RAW	16	0	Sold-to Party GUID
8	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
9	NAME_TXT	☐	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
10	SHORT_WITH_STREET	☐	COMT_PARTNER_ADDRESS_W_STREET	CHAR80S	CHAR	80	0	Partner Address With Street
11	CAMPAIGN_GUID	☐	CRMT_MKTPL_CPG_TEMPL	CGPL_PROJECT_GUID	RAW	16	0	Campaign template
12	CAMPAIGN_HE_ID	☐	CAMPAIGN_HE_ID	CGPL_EXTID	CHAR	24	0	Marketing Project Identification
13	CAMPAIGN_HE_ID_T	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
14	TIME_OUT_FROM_DATS	☐	CRMT_BSP_CONTSTART_DATS	DATS	DATS	8	0	Contract Start Date
15	TIME_OUT_TO_DATS	☐	CRMT_BSP_CONTEND_DATS	DATS	DATS	8	0	Contract End Date
16	TIME_OUT_TO	☐	CRMT_BSP_CONTEND	TZTF_IO_FIELD	CHAR	26	0	Contract End Date
17	TIME_BILL_START_DATS	☐	CRMT_BSP_BILLSTART_DATS	DATS	DATS	8	0	Start of Billing
18	TIME_BILL_START	☐	CRMT_START_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Start Date of Billing Plan
19	RESULT_AMOUNT_IP	☐	CRMT_RESULT_AMOUNT_IP	CRMT_COND_VALUE	CURR	19	2	Interim Period
20	TAX_IP	☐	CRMT_BILL_TAX	CRMT_COND_VALUE	CURR	19	2	Tax Amount (Leasing)
21	RESULT_AMOUNT_MI	☐	CRMT_RESULT_AMOUNT_MI	CRMT_COND_VALUE	CURR	19	2	Monthly Installment
22	TAX_MI	☐	CRMT_BILL_TAX	CRMT_COND_VALUE	CURR	19	2	Tax Amount (Leasing)
23	RESULT_AMOUNT_LI	☐	CRMT_RESULT_AMOUNT_LI	CRMT_COND_VALUE	CURR	19	2	Last Installment
24	TAX_LI	☐	CRMT_BILL_TAX	CRMT_COND_VALUE	CURR	19	2	Tax Amount (Leasing)
25	RESULT_OTAX	☐	CRMT_FIN_LFRQ_BSP_OTAX	CRMT_COND_VALUE	CURR	19	2	One-Time Tax
26	.INCLUDE	☐				0	0	Item Data (Combined Physical Product/Financing Product)
27	.INCLUDE	☐				0	0	Management of Interface Structures
28	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
29	HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
30	HEADER_CHAR	☐			CHAR	32	0
31	SCHED_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
32	PROD_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
33	PROD_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
34	PROD_SCHED_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
35	NUMBER_INT	☐	CRMT_BSP_ITEM_NO	CRM_BSP_ITEM_NO	NUMC	10	0	Item Number in Document
36	ORDERED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
37	DESCRIPTION	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
38	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
39	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
40	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	T006
41	FROM_TIME_IO	☐	CRMT_BSP_CONTSTART	TZTF_IO_FIELD	CHAR	26	0	Contract Start Date
42	FROM_TIME	☐	EV_FR_TIME	BCOS_TSTMP	DEC	15	0	Start Time Stamp: Date
43	LATEST_TIME_CONFIRMED	☐	CRMT_SCHEDLIN_LTIME_CONFIRMED	BCOS_TSTMP	DEC	15	0	Latest Confirmation Date for an Item
44	LATEST_TIME_CONFIRMED_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
45	MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
46	ORDER_QTY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
47	CONFIRMED_QTY	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
48	NUMBER_PARENT	☐	CRMT_BSP_ITEM_NO_PARENT	CRM_BSP_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Document
49	NUMBER_ALTERN	☐	CRMT_BSP_ITEM_NO	CRM_BSP_ITEM_NO	NUMC	10	0	Item Number in Document
50	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
51	STATUS_TXT	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
52	STATUS_ICON	☐	CRMT_ATP_ICON	SYCHAR132	CHAR	132	0	ATP Traffic light
53	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
54	DLV_GROUP	☐	CRMT_DLV_GROUP	CRMT_DLV_GROUP	NUMC	3	0	Delivery Group (Items are Delivered Together)
55	DLV_GROUP_DATE	☐	CRMT_DLV_GROUP_DATE	BCOS_TSTMP	DEC	15	0	Delivery Group Date
56	DLV_GROUP_DATE_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
57	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
58	PROC_IDENT	☐	CRMT_ITM_PROC_IDENT	CRM_ITM_PROC_IDENT	CHAR	4	0	Process Identifier
59	BILLED_QTY	☐	CRMT_BILLED_QTY	CRM_MENGV15	QUAN	15	3	Billed Quantity
60	BILLED_VALUE	☐	CRMT_BILLED_VALUE	CRM_COND_VALUE	CURR	19	2	Billed Value
61	BILL_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
62	DELIVERED_QTY	☐	CRMT_DELIVERED_QTY	CRM_MENGV15	QUAN	15	3	Delivered Quantity
63	FINPROD_ICON	☐	CRMT_LEAS_FIN_ICON	SYCHAR132	CHAR	132	0	Choose Financing Product
64	GOODS_ISSUE_QTY	☐	CRMT_GOODS_ISSUE_QTY	CRM_MENGV15	QUAN	15	3	Goods Issue Quantity
65	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
66	PARENT_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
67	PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
68	FIN_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
69	FIN_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
70	FIN_SCHED_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
71	FIN_NUMBER_INT	☐	CRMT_BSP_ITEM_NO	CRM_BSP_ITEM_NO	NUMC	10	0	Item Number in Document
72	FIN_ORDERED_PROD	☐	CRMT_BSP_LAM_FIN_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
73	FIN_DESCRIPTION	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
74	FIN_ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
75	FIN_QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
76	FIN_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	T006
77	FIN_FROM_TIME_IO	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
78	FIN_FROM_TIME	☐	EV_FR_TIME	BCOS_TSTMP	DEC	15	0	Start Time Stamp: Date
79	FIN_LATEST_TIME_CONFIRMED	☐	CRMT_SCHEDLIN_LTIME_CONFIRMED	BCOS_TSTMP	DEC	15	0	Latest Confirmation Date for an Item
80	FIN_LATEST_TIME_CONFIRMED_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
81	FIN_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
82	FIN_ORDER_QTY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
83	FIN_CONFIRMED_QTY	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
84	FIN_NUMBER_PARENT	☐	CRMT_BSP_ITEM_NO_PARENT	CRM_BSP_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Document
85	FIN_NUMBER_ALTERN	☐	CRMT_ITEM_NO_ALTERNATIVE	CRM_ITEM_NO	NUMC	10	0	Item for Which This Item is an Alternative in the Document
86	FIN_PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
87	FIN_STATUS_TXT	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
88	FIN_STATUS_ICON	☐	CRMT_ATP_ICON	SYCHAR132	CHAR	132	0	ATP Traffic light
89	FIN_ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
90	FIN_DLV_GROUP	☐	CRMT_DLV_GROUP	CRMT_DLV_GROUP	NUMC	3	0	Delivery Group (Items are Delivered Together)
91	FIN_DLV_GROUP_DATE	☐	CRMT_DLV_GROUP_DATE	BCOS_TSTMP	DEC	15	0	Delivery Group Date
92	FIN_DLV_GROUP_DATE_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
93	FIN_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
94	FIN_PROC_IDENT	☐	CRMT_ITM_PROC_IDENT	CRM_ITM_PROC_IDENT	CHAR	4	0	Process Identifier
95	FIN_BILLED_QTY	☐	CRMT_BILLED_QTY	CRM_MENGV15	QUAN	15	3	Billed Quantity
96	FIN_BILLED_VALUE	☐	CRMT_BILLED_VALUE	CRM_COND_VALUE	CURR	19	2	Billed Value
97	FIN_BILL_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
98	FIN_DELIVERED_QTY	☐	CRMT_DELIVERED_QTY	CRM_MENGV15	QUAN	15	3	Delivered Quantity
99	FIN_GOODS_ISSUE_QTY	☐	CRMT_GOODS_ISSUE_QTY	CRM_MENGV15	QUAN	15	3	Goods Issue Quantity
100	FIN_PARENT_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
101	FIN_PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
102	STEP_STRUCTURE	☐	CRMT_FIMAN_STEPSTR	XFELD	CHAR	1	0	Step Payments
103	ONE_VIEW_FLAG	☐	CRMT_ONE_VIEW_FLAG	CRMT_ONE_VIEW_FLAG	CHAR	1	0	Manage Only One View
104	LESSOR_IRR	☐	CRMT_LESSOR_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Lessor Internal Rate of Return
105	ACCOUNT_IRR	☐	CRMT_ACCOUNT_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Internal Rate of Return for Accounting
106	CUSTOMER_IRR	☐	CRMT_CUSTOMER_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Lessee Internal Rate of Return
107	TAX_IRR	☐	CRMT_TAX_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Internal Rate of Return - Tax
108	CUSTOM_COMPL_IRR	☐	CRMT_CUSTOMER_COMPL_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Cust.Compl.View -Internal Rate of Return(Effective Int.Rate)
109	FEES_IRR	☐	CRMT_FEES_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Fees View - Internal Rate of Return (Effective Int. Rate)
110	SERVICE_IRR	☐	CRMT_SERVICE_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Service Internal Rate of Return (Effective Interest Rate)
111	CSTINCL_IRR	☐	CRMT_CSTINCL_IRR	CRMT_LEAS_INTEREST	DEC	11	7	Cost Inclusion -Internal Rate of Return(Effective Int. Rate)
112	RESULT_RATEPERK	☐	CRMT_RESULT_RATEPERK	CRMT_DECV7_10	DEC	17	10	Rate per x
113	RESULT_AMOUNT	☐	CRMT_RESULT_AMOUNT	CRMT_COND_VALUE	CURR	19	2	Resulting Amount
114	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
115	CHNG_PROCESS	☐	CRMT_LEAS_CHNG	CRMT_LEAS_CHNG_PROC	CHAR	4	0	Change Process	*
116	DURATION	☐	CRMT_BSP_LAM_NEW_LEASDURATION	TIMEDURA	DEC	13	0	Lease Duration
117	TIME_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
118	TIME_UNIT_TEXT	☐	UDZEITE	UDZEITE	CHAR	20	0	Time unit
119	TIME_OUT_FROM	☐	CRMT_BSP_CONTSTART	TZTF_IO_FIELD	CHAR	26	0	Contract Start Date
120	KSCHL_1	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
121	KBETR_1	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
122	WAERS_1	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
123	KPEIN_1	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
124	KMEIN_1	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
125	KSCHL_2	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
126	KBETR_2	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
127	WAERS_2	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
128	KPEIN_2	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
129	KMEIN_2	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
130	KSCHL_3	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
131	KBETR_3	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
132	WAERS_3	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
133	KPEIN_3	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
134	KMEIN_3	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
135	KSCHL_4	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
136	KBETR_4	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
137	WAERS_4	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
138	KPEIN_4	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
139	KMEIN_4	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
140	KSCHL_5	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
141	KBETR_5	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
142	WAERS_5	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
143	KPEIN_5	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
144	KMEIN_5	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
145	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
146	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
147	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
148	PRODUCT_FIN	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
149	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
150	SOLD_TO_PARTY_LIST	☐	CRMT_SOLD_TO_PART_LIST	TEXT80	CHAR	80	0	Sold-To Party
151	DATE1	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
152	DATE2	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
153	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
154	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date

Foreign Keys

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

History

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