SAP ABAP Table CMST_LO_EXTN_I_DB_WRK (Database buffer structure for item extensions)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-CHM-POS (Application Component) Point of Sale
⤷

CMS_LO_DB (Package) Lean order database layer

Basic Data

Table Category	INTTAB	Structure
Structure	CMST_LO_EXTN_I_DB_WRK	Table Relationship Diagram
Short Description	Database buffer structure for item extensions

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Item extensions for resale order
2	CLIENT	MANDT	MANDT	CLNT	3	0	Client	*
3	REF_GUID	CMST_OBJECT_GUID	SYSUUID_C	CHAR	32	0	GUID of an Object
4	REF_KIND	CMST_OBJECT_TYPE	CMST_OBJECT_TYPE	CHAR	1	0	Indicator: Header/Item
5	REF_HANDLE	CMST_HANDLE	NUMC10	NUMC	10	0	Handle
6	REC_MODE	CMST_RECORD_MODE	CMST_RECORD_MODE	CHAR	1	0	Record mode
7	.INCLUDE				0	0	Item extension for chargebacks
8	EDI849_SENT	CMST_CB_EDI_SENT_IND	CMST_YES_NO_IND	CHAR	1	0	EDI 849 Sent Indicator
9	REP_PRINT	CMST_REP_PRNT_IND	CMST_YES_NO_IND	CHAR	1	0	Print Indicator
10	RECVD_PRD_ID_TYP	CMST_PROD_ID_TYPE	CMST_PROD_ID_TYPE	CHAR	4	0	Identifier Type for Product
11	RECVD_EC_ID_TYP	CMST_ID_TYPE	CMST_ID_TYPE	CHAR	3	0	ID Type Submitted on Chargeback Claims
12	CNT_SEL_METHOD	CMST_CNT_SEL_METHOD	NUM2	NUMC	2	0	Contract Selection Method
13	UOM_SEL_METHOD	CMST_UOM_SEL_METHOD	NUM2	NUMC	2	0	UOM Selection Method Used for Chargeback Processing
14	UOM_VAR_PCT	CMST_UOM_VAR	CMS_PERCENT	DEC	5	2	Unit of Measure Variance
15	CONTR_OVER	CMST_CONTR_OVERRIDE	CMST_YES_NO_IND	CHAR	1	0	Contract Override Indicator
16	CONTR_RATE_OVER	CMST_CONTR_RATE_OVERRIDE	CMST_YES_NO_IND	CHAR	1	0	Contract Rate Override
17	WAC_PRICE_OVER	CMST_WAC_PRICE_OVERRIDE	CMST_YES_NO_IND	CHAR	1	0	WAC Price Override
18	.INCLUDE				0	0	Item extensions for price protection
19	DYN_WH_TAB	COMT_WHERE_CONDITION_TAB		TTYP	0	0
20	.INCLUDE				0	0	Channel inventory price type attributes structure
21	.INCLUDE				0	0	Extended price type attributes structure using field catalog
22	PRC_GROUP1	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
23	PP_VARIANT	CMST_PP_VARIANT	CMS_PP_VARIANT	CHAR	2	0	Price protection variant
24	PP_REASON	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
25	.INCLUDE				0	0	Item extension for Sell-in process
26	DOC_SOURCE	CMST_SI_SOURCE_TYP	CMST_SI_SOURCE_TYP	CHAR	4	0	Record Source for Sale to Channel Partner
27	DOC_CAT	CMST_SI_DOC_CAT	CMST_SI_DOC_CAT	CHAR	2	0	Sale to Channel Partner Document Category
28	REF_DOC_CAT	CMST_SI_REF_DOC_CAT	CMST_SI_DOC_CAT	CHAR	2	0	Reference Document Category for Sale to Channel Partner
29	DOC_CAT_TXT	CMST_SI_DOC_CAT_TXT	DDTEXT	CHAR	60	0	Document Category Text
30	REF_DOC_CAT_TXT	CMST_SI_REF_DOC_CAT_TXT	DDTEXT	CHAR	60	0	Reference Document Category Text
31	ORD_DOC_CAT	CMST_SI_ORD_CAT	CMST_SI_DOC_CAT	CHAR	2	0	Order Document Category
32	ORD_DOC_TYP	CMST_SI_ORD_DOC_TYP	CMST_SI_DOC_TYP	CHAR	4	0	Order Document Type
33	ORD_ITEM_CAT	CMST_SI_ORD_ITEM_CAT	CMST_SI_DOC_ITEM_CAT	CHAR	4	0	Order Document Item Category
34	ORD_ITEM_TYP	CMST_SI_ORD_ITEM_TYP	CMST_SI_DOC_TYP	CHAR	4	0	Order Document Item Type
35	.INCLUDE				0	0	Item extension for Resale Tracking Process
36	REASON_CLUP	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
37	REASON_CLMST	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
38	.INCLUDE				0	0	CIR Item Extension Structure
39	REASON_CANC	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
40	REASON_ADJ	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
41	REASON_SYNC	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
42	.INCLUDE				0	0	IR Item extension structure
43	IR_REASON	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
44	.INCLUDE				0	0	BU :Item Extn Structure
45	BU_REASON	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
46	.INCLUDE				0	0	Item extensions for transmission object
47	XMN_LINES	CMST_TO_NO_LINES	NUM10	NUMC	10	0	Number of Lines
48	ERROR_LINES	CMST_TO_NO_LINES	NUM10	NUMC	10	0	Number of Lines
49	DELETED_LINES	CMST_TO_NO_LINES	NUM10	NUMC	10	0	Number of Lines
50	XMN_ERROR_LINES	CMST_TO_NO_LINES	NUM10	NUMC	10	0	Number of Lines
51	MANUAL_LINES	CMST_TO_NO_LINES	NUM10	NUMC	10	0	Number of Lines
52	PER_COMPLETE	CMST_TOLERANCE	NUM2	NUMC	2	0	Transmission Tolerence Percentage
53	EXPECTED_TRANS	CMST_NO_OF_TRANS	NUM2	NUMC	2	0	Number of Transmissions for Each Period
54	MSG_TYPE	CMST_RTCM_MESTYPE	EDI_MESTYP	CHAR	30	0	Message Type	*
55	.INCLUDE				0	0	Customer extensions include - Item
56	CUSTOMER_EXT_I	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
57	.INCLUDE				0	0	SI : EEW Extension
58	SI_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
59	.INCLUDE				0	0
60	.INCLUDE				0	0
61	.INCLUDE				0	0
62	.INCLUDE				0	0	IR : EEW Extension
63	IR_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
64	.INCLUDE				0	0
65	.INCLUDE				0	0	RTCM : EEW Extension
66	RTCM_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
67	.INCLUDE				0	0
68	.INCLUDE				0	0	EEW Extension
69	CIR_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
70	.INCLUDE				0	0
71	.INCLUDE				0	0	EEW Extension
72	BU_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
73	.INCLUDE				0	0
74	.INCLUDE				0	0	PP ITEM : EEW Extension
75	PP_I_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
76	.INCLUDE				0	0
77	.INCLUDE				0	0
78	.INCLUDE				0	0	Duelist extension structure
79	.INCLUDE				0	0	Duelist extension structure
80	CEM_APPLICATION	/CEM/APPLICATION	/CEM/APPLICATION	CHAR	4	0	Program Type	*
81	CEM_H_GUID	/CEM/GUID	SYSUUID	RAW	16	0	GUID
82	CEM_H_ID	/CEM/ID	/CEM/ID	CHAR	10	0	Id
83	CEM_I_GUID	/CEM/GUID	SYSUUID	RAW	16	0	GUID
84	CEM_I_ID	/CEM/ID	/CEM/ID	CHAR	10	0	Id
85	CEM_D_GUID	/CEM/GUID	SYSUUID	RAW	16	0	GUID
86	CEM_D_ID	/CEM/ID	/CEM/ID	CHAR	10	0	Id
87	CEM_IC_FLAG	/CEM/INTER_COMPANY_FLAG	/CEM/FLAG	CHAR	1	0	Inter company flag
88	CEM_ENT_PROGRAM	/CEM/ENT_STRATEGY	/CEM/ENT_STRATEGY	CHAR	2	0	Entitlement Program Scheme	*
89	CEM_DEF_FLAG	/CEM/DEF_FLAG	/CEM/DEF_FLAG	CHAR	1	0	Deferred Clearing Program Scheme
90	CEM_RO_LE	/CEM/LOGICAL_EVENT	/CEM/EC_LOGICAL_EVENT	CHAR	10	0	Logical event	*
91	CEM_EE_LE	/CEM/LOGICAL_EVENT	/CEM/EC_LOGICAL_EVENT	CHAR	10	0	Logical event	*
92	CEM_PARSET_GUID	/CEM/GUID	SYSUUID	RAW	16	0	GUID
93	CEM_PRIDOC_GUID	/CEM/GUID	SYSUUID	RAW	16	0	GUID
94	CEM_T_DOC_TYPE	/CEM/DOC_TYPE	/CEM/DOC_TYPE	CHAR	2	0	Entitlement-Specific Transaction Category	*
95	CEM_S_DOC_TYPE	/CEM/SRC_DOC_TYPE	/CEM/DOC_TYPE	CHAR	2	0	Source Document Type	*
96	CEM_T_DOC_BUSOBJ	/CEM/BUS_TRAN_CAT	OJ_NAME	CHAR	10	0	Business Transaction Category	*
97	CEM_S_DOC_BUSOBJ	/CEM/BUS_TRAN_CAT	OJ_NAME	CHAR	10	0	Business Transaction Category	*
98	CEM_PROCESS_CODE	/CEM/PROC_CODE	/CEM/PROC_CODE	CHAR	4	0	Process Code	*
99	CEM_REASON_CODE	/CEM/REASON_CODE	/CEM/REASON_CODE	CHAR	2	0	Reason code	*
100	EXEC_PROFILE	/CEM/EC_EXEC_PROFILE	/CEM/EC_EXEC_PROFILE	CHAR	10	0	Execution Profile	*
101	EE_SCENARIO	/CEM/EE_SCENARIO	/CEM/EE_SCENARIO	CHAR	10	0	Entitlements scenario	*
102	CEM_SET_TYPE	/CEM/SETTLEMENT_TYPE	/CEM/SETTLEMENT_TYPE	CHAR	1	0	Settlement Type: Billing / FICO
103	CEM_SET_DOC_TYPE	/CEM/SET_DOC_TYPE	/CEM/DOC_TYPE	CHAR	2	0	Settlment Document Type	*
104	VERSION	/CEM/VERSION	/CEM/ID	CHAR	10	0	Version
105	CEM_SERIALNO_REL	/CEM/SERIALNO_RELEVANT	/CEM/BOOLEAN	CHAR	1	0	Serial number relevancy
106	CEM_SERIALNO	/CEM/SERIAL_NO	/CEM/SERIAL_NO	CHAR	40	0	Entitlements Serial Number
107	.INCLUDE				0	0	Duelist extension structure descriptions
108	CEM_APP_DESC	/CEM/DESCRIPTION	TEXT40	CHAR	40	0	Description
109	CEM_PRG_DESC	/CEM/DESCRIPTION	TEXT40	CHAR	40	0	Description
110	CEM_T_DOC_DESC	/CEM/DOC_TYPE_SHORT_DESC	/CEM/SHORT_DESC20	CHAR	20	0	Entitlement Transaction Category Description
111	CEM_S_DOC_DESC	/CEM/DOC_TYPE_SHORT_DESC	/CEM/SHORT_DESC20	CHAR	20	0	Entitlement Transaction Category Description
112	CEM_PROC_DESC	/CEM/DESCRIPTION	TEXT40	CHAR	40	0	Description
113	CEM_REASON_DESC	/CEM/DESCRIPTION	TEXT40	CHAR	40	0	Description
114	CEM_EE_SCN_DESC	/CEM/DESCRIPTION	TEXT40	CHAR	40	0	Description
115	CEM_SET_TYPE_DESC	/CEM/DESCRIPTION	TEXT40	CHAR	40	0	Description
116	CEM_SET_DOC_DESC	/CEM/DOC_TYPE_SHORT_DESC	/CEM/SHORT_DESC20	CHAR	20	0	Entitlement Transaction Category Description
117	CEM_EE_LE_DESC	/CEM/DESCRIPTION	TEXT40	CHAR	40	0	Description