SAP ABAP Table CRMT_ISALES_BASKETITEM_IL (Shopping Basket Item with Additional Fields (not 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_IL	Table Relationship Diagram
Short Description	Shopping Basket Item with Additional Fields (not 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	SYSUUID	RAW	16	0	GUID of a CRM Order Object
2	HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
3	PARENT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
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	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
35	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
36	FREIGHT_VALUE	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
37	TAX_VALUE	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
38	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
39	QUANTITY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
40	QUANTITY_CONFIRMED	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
41	DELIVERY_DATE	☐	EV_TO_TIME	BCOS_TSTMP	DEC	15	0	End Time Stamp: Date
42	NUMBER_CONFIRMED	☐	CRMT_SCHEDLIN_COUNT_CONFIRMED	CRM_SCHEDLIN_COUNT	INT2	5	0	CRM Number Confirmation Schedule Line
43	SCHED_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
44	FROM_TIME_IO	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
45	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
46	CUMUL_QUANTITY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
47	CUMUL_QUANT_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
48	CREATED_AT	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
49	PARENT_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
50	ORDER_QTY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
51	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
52	REJECTION_REASON	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
53	PRPI_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
54	NET_WO_FREIGHT	☐	PRCT_NET_VALUE_WITHOUT_FREIGHT	WERTV8	CURR	15	2	Item Net Value Exclusive Shipment
55	SYSTEM_PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
56	SUBST_REASON	☐	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
57	LAST_DLV_DATE	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
58	RECURRING_NET	☐	CRMT_RECURRING_CHARGE	WERTV8	CURR	15	2	Periodically charged values
59	RECURRING_TAX	☐	CRMT_RECURRING_TAX	WERTV8	CURR	15	2	Periodically charged taxes
60	RECURRING_GROSS	☐	CRMT_RECURRING_GROSS	WERTV8	CURR	15	2	Periodically charged values including taxes
61	REC_DURATION	☐	CRMT_REC_DURATION	TIMEDURA	DEC	13	0	Duration of a recurrence period
62	REC_TIME_UNIT	☐	CRMT_REC_TIME_UNIT	TIMEUNITNA	CHAR	12	0	Time unit of a recurrence period	*
63	CNT_DURATION	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
64	CNT_DUR_UNIT	☐	TIMEUNITNA	TIMEUNITNA	CHAR	12	0	Name of Time Unit	*
65	LOY_POINTS	☐	CRM_LOY_PT_POINT		DEC	10	2	Loyalty Point
66	LOY_POINT_TYPE	☐	CRMT_MKTPL_LOY_POINT_CODE	CRM_MKTPL_LOY_POINT_CODE	CHAR	10	0	ID of Point Type
67	POINTS_SPENT	☐	CRMT_LOY_POINTS_SPENT		DEC	10	2	Loyalty Points Spent
68	.INCLUDE	☐				0	0	Shopping Basket Item Extended Contracts Data
69	RELEASED_VALUE	☐	CRMT_CUM_VALUE	CRM_COND_VALUE	CURR	19	2	Cumulative Value
70	RELVAL_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
71	CALLED_OFF_QTY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
72	CALLED_OFF_VALUE	☐	CRMT_CUM_VALUE	CRM_COND_VALUE	CURR	19	2	Cumulative Value
73	CNT_VALID_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
74	CNT_VALID_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
75	TOTAL_DISCOUNT	☐	PRCT_COND_VALUE	WERTV8	CURR	15	2	Price Determination: Condition Value
76	VENDOR_NUMBER	☐	CRMT_VENDOR_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Vendor Number

History

Last changed by/on	SAP	20140802
SAP Release Created in