SAP ABAP Table CRMT_BSP_FSQ_PROD_UI (FSQ Product List)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LAM (Application Component) CRM Leasing
     ⤷ CRM_BSP_MODEL_IL_FSQ (Package) FS: Quotations in People Centric UI

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_FSQ_PROD_UI	Table Relationship Diagram
Short Description	FSQ Product List

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

Foreign Keys

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

History

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