SAP ABAP Table CRMS_WEC_ORDER_ITEM (Web Channel: Item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ WEC-APP-SLS-CRM (Application Component) WebChannel Sales using CRM Sales
     ⤷ CRM_WEC_SALESTRANSACTIONS (Package) Web Channel: Sales Transactions

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_WEC_ORDER_ITEM	Table Relationship Diagram
Short Description	Web Channel: Item

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_ITEM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
4	PRODUCT	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
5	PRODUCT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
7	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
8	REPLACED_PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
9	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
10	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
11	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
12	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
13	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
14	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
15	NETPR_UOM	☐	PRCT_COND_UOM	MEINS	UNIT	3	0	Condition Unit	*
16	NETPR_PRIC_UNIT	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
17	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
18	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
19	DLV_PRIO	☐	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	*
20	DLV_PRIO_DESC	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
21	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
22	PMNTTRMS_DESC	☐	CRMT_PMNTTRMS_DESC	TEXT50	CHAR	50	0	Explanation of Payment Terms
23	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
24	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
25	FREIGHT_VALUE	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
26	TAX_VALUE	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
27	QUANTITY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
28	REQ_DELIVERY_DATE	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
29	REQ_DLV_DATE_TZ	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
30	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
31	CREATED_AT	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
32	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
33	REJECTION_DESC	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
34	NET_WO_FREIGHT	☐	PRCT_NET_VALUE_WITHOUT_FREIGHT	WERTV8	CURR	15	2	Item Net Value Exclusive Shipment
35	TOTAL_DISCOUNT	☐	PRCT_COND_VALUE	WERTV8	CURR	15	2	Price Determination: Condition Value
36	SUBST_REASON	☐	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
37	DELETABLE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
38	CONFIGURABLE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
39	PRICING_RELEVANT	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
40	IS_GIFTCARD	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
41	GC_SEND_TYPE	☐	CRM_GC_SEND_TYPE	CRM_GC_SEND_TYPE	CHAR	1	0	Gift Card Send Type
42	LAST_DLV_DATE	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
43	LAST_DLV_DATE_TZ	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
44	DELIVERED_QTY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
45	DELIVERED_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
46	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
47	VALID_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
48	VALID_FROM_TZONE	☐	TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	*
49	VALID_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
50	VALID_TO_TZONE	☐	TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	*
51	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
52	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
53	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
54	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
55	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
56	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
57	CONFIG_ID	☐	COMT_IPC_CONFIG_ID	CHAR80	CHAR	80	0	Configuration ID

History

Last changed by/on	SAP	20131122
SAP Release Created in	701