SAP ABAP Table CRMT_ISALES_BASKETITEM_UI (Shopping Basket Item WebAPI)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ISA (Application Component) Internet Sales
     ⤷ CRM_ISALES (Package) CRM Internet Sales

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_ISALES_BASKETITEM_UI	Table Relationship Diagram
Short Description	Shopping Basket Item WebAPI

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	GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
2	HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
3	PARENT_GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
4	.INCLUDE	☐				0	0	Shopping Basket Item Data
5	PRODUCT	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
6	PRODUCT_GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
7	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
8	UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
9	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
10	PCAT	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
11	PCAT_VARIANT	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
12	PCAT_AREA	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
13	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
14	CONFIGURABLE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
15	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
16	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
17	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
18	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
19	NETPR_UOM	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
20	NETPR_PRIC_UNIT	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
21	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
22	BATCH_ID	☐	CRMT_BATCH_ID	BATCH_ID	CHAR	10	0	Batch Number
23	PRICING_RELEVANT	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
24	ATP_RELEVANT	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
25	ORDER_DUE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
26	DELIVERY_DUE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
27	DLV_PRIO	☐	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	*
28	DLV_PRIO_DESC	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
29	BACKORDERED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
30	EXT_REF_OBJECT_TYPE	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	*
31	EXT_REF_OBJECT_TYPE_DESC	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
32	PAYMENT_TERMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
33	PAYMENT_TERMS_DESC	☐	CRMT_PMNTTRMS_DESC	TEXT50	CHAR	50	0	Explanation of Payment Terms
34	NET_VALUE	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
35	GROSS_VALUE	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
36	FREIGHT_VALUE	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
37	TAX_VALUE	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
38	NUMBER_INT	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
39	QUANTITY	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
40	QUANTITY_CONFIRMED	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
41	DELIVERY_DATE	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
42	REQ_DELIVERY_DATE	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
43	NUMBER_CONFIRMED	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long
44	SHIPTO_LINE_KEY	☐	CRMT_HANDLE		NUMC	10	0	Handle
45	IPC_DOCUMENTID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
46	IPC_ITEMID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
47	IPC_PRODUCT	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
48	.INCLUDE	☐				0	0	Item Data of the Contract in Shopping Basket
49	CONTRACT_GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
50	CONTRACT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
51	CONTRACT_ITEM_GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
52	CONTRACT_ITEM_ID	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
53	CONFIG_FILTER	☐	CRMT_CONFIG_FILTER	IB_INSTANCE	NUMC	18	0	Configuration Filter
54	R3_CONFIG	☐	COMT_R3_CONFIG	XFELD	CHAR	1	0	Indicator: ERP-Type Configuration
55	USE_IPC	☐	COMT_USE_IPC	XFELD	CHAR	1	0	Indicator: IPC Used for Configuration
56	ONLY_VAR_FIND	☐	COMT_ONLY_VAR_FIND	XFELD	CHAR	1	0	Indicator: Perform Variant Matching Only in Configuration
57	REMAIN_DLV_QTY	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
58	NET_PRICE	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
59	CUMUL_DLV_QTY	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
60	CUMUL_DLV_QTY_UT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
61	CREATED_AT	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
62	STATUS	☐	J_STATUS	J_STATUS	CHAR	5	0	Object status
63	DELETABLE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
64	PARENT_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
65	ORDER_QTY	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
66	.INCLUDE	☐				0	0	Request for Contract Item Data
67	TARGET_VALUE	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
68	SIMUL_PRICE_NORMAL	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
69	NORMAL_UNIT	☐	PRCT_PROD_UOM	MEINS	UNIT	3	0	Unit of Measure for Product-Specific Quantity	*
70	NORMAL_PRICING_UNIT	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
71	SIMUL_PRICE_CNT_QUOT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
72	QUOT_UNIT	☐	PRCT_PROD_UOM	MEINS	UNIT	3	0	Unit of Measure for Product-Specific Quantity	*
73	QUOT_PRICING_UNIT	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
74	SIMUL_PRICE_CNT_INQU	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
75	INQU_UNIT	☐	PRCT_PROD_UOM	MEINS	UNIT	3	0	Unit of Measure for Product-Specific Quantity	*
76	INQU_PRICING_UNIT	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
77	REJECTION_REASON	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
78	PRED_HEAD_GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
79	PRED_ITEM_GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
80	NET_WO_FREIGHT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
81	SYSTEM_PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
82	SUBST_REASON	☐	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
83	CHANGEABLE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
84	LAST_DLV_DATE	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
85	PRODUCT_KIND	☐	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
86	STATISTICAL	☐	CRMT_STATISTICAL	CRM_STATISTICAL	CHAR	1	0	Statistical values
87	.INCLUDE	☐				0	0	Communication Structure for the basket items for auctioning
88	FROM_AUCTION	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
89	SUPPRESS_CNT_DET	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
90	SUPPRESS_SC_EXPL	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
91	SC_AUTHOR	☐	CRM_SC_INST_AUTHOR	CRM_SCD_AUTHOR	CHAR	1	0	Solution Configuration: Author Information per Instance
92	SC_GROUP	☐	CRM_SC_INST_GROUP	CRM_SCD_GROUP	CHAR	20	0	Solution Configurator: Instance Group
93	SC_SCORE	☐	IST_PROCESS_SCORE	IST_PROCESS_SCORE	NUMC	10	0	Process Score
94	BUAG_USAGE	☐	CRMT_BUAG_USAGE	CRM_BUAG_USAGE	NUMC	2	0	Usage Type for Business Agreement
95	SC_ALTERNATIVE_PROD_AVAILABLE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
96	SC_DOCUMENT_GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
97	RECURRING_NET	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
98	RECURRING_TAX	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
99	RECURRING_GROSS	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
100	REC_DURATION	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
101	REC_TIME_UNIT	☐	TIMEUNITT	TIMEUNITT	CHAR	20	0	Long Text for Time Unit in Singular
102	REC_TIME_UNIT_PL	☐	TIMEUNITTP	TIMEUNITT	CHAR	20	0	Long Text for Time Unit in Plural
103	REC_TIME_UNIT_ABBREV	☐	TIMEUNITAV	TIMEUNITAV	CHAR	3	0	Abbreviation of Time Unit
104	CNT_DURATION	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
105	CNT_DUR_UNIT	☐	TIMEUNITNA	TIMEUNITNA	CHAR	12	0	Name of Time Unit	*
106	CNT_DUR_UNIT_TEXT	☐	TIMEUNITT	TIMEUNITT	CHAR	20	0	Long Text for Time Unit in Singular
107	CNT_DUR_UNIT_TEXT_PL	☐	TIMEUNITTP	TIMEUNITT	CHAR	20	0	Long Text for Time Unit in Plural
108	CNT_DUR_UNIT_ABBREV	☐	TIMEUNITAV	TIMEUNITAV	CHAR	3	0	Abbreviation of Time Unit
109	PRODUCT_ROLE	☐	CRMT_PRODUCT_ROLE	CRMT_PRODUCT_ROLE	CHAR	1	0	Product Role
110	IS_SC_SELECTED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
111	SUPPRESS_CAMP_DET	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
112	LOY_POINTS	☐	CRM_LOY_PT_POINT		DEC	10	2	Loyalty Point
113	LOY_POINT_TYPE	☐	CRMT_MKTPL_LOY_POINT_CODE	CRM_MKTPL_LOY_POINT_CODE	CHAR	10	0	ID of Point Type
114	POINTS_SPENT	☐	CRMT_LOY_POINTS_SPENT		DEC	10	2	Loyalty Points Spent
115	IS_GIFTCARD	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
116	GC_SEND_TYPE	☐	CRM_GC_SEND_TYPE	CRM_GC_SEND_TYPE	CHAR	1	0	Gift Card Send Type
117	.INCLUDE	☐				0	0	Shopping Basket Item Extended Contracts Data for UI
118	CUMUL_QUANTITY	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
119	CUMUL_QUANT_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
120	RELEASED_VALUE	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
121	RELVAL_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
122	CALLED_OFF_QTY	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
123	CALLED_OFF_VALUE	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
124	CNT_VALID_FROM	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
125	CNT_VALID_TO	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
126	TOTAL_DISCOUNT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters

History

Last changed by/on	SAP	20130604
SAP Release Created in