SAP ABAP Table /CEM/S_I_WRK (Item Work Area Structure (Database + Dynamic))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-EM (Application Component) CRM Entitlement Management
     ⤷ /CEM/EE_COMMON (Package) Entitlements Engine - Common Objects

Basic Data

Table Category	INTTAB	Structure
Structure	/CEM/S_I_WRK	Table Relationship Diagram
Short Description	Item Work Area Structure (Database + Dynamic)

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	.INCLUDE	☐				0	0	Item Object Buffer Workspace
2	.INCLUDE	☐				0	0	Item Database Buffer structure
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	I_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
5	I_ID	☐	/CEM/ID	/CEM/ID	CHAR	10	0	Id
6	H_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
7	.INCLUDE	☐				0	0	General Item Information
8	.INCLUDE	☐				0	0	Item Attribute Data
9	.INCLUDE	☐				0	0	Item Atrributes: Processing Attributes
10	PROCESS_CODE	☐	/CEM/PROC_CODE	/CEM/PROC_CODE	CHAR	4	0	Process Code	*
11	SUB_PROC_CODE	☐	/CEM/SUB_PROC_CODE	/CEM/SUB_PROC_CODE	CHAR	4	0	Subsequent Process Code	*
12	FICO_DOC_NO	☐	/CEM/FICO_DOC_NO	/CEM/FICO_DOC_NO	CHAR	12	0	FICO Document number
13	SUMM_REL	☐	/CEM/SUMM_REL	/CEM/SUMM_REL	CHAR	1	0	Summary Relevance
14	REASON_CODE	☐	/CEM/REASON_CODE	/CEM/REASON_CODE	CHAR	2	0	Reason code	*
15	CANCEL_REASON	☐	/CEM/CAN_REASON_CODE	/CEM/REASON_CODE	CHAR	2	0	Cancellation Reason code	*
16	IC_REL	☐	/CEM/IC_REL	/CEM/IC_REL	CHAR	1	0	Determines Intercompany Relevance
17	.INCLUDE	☐				0	0	Item Attribute: General Attributes
18	I_LOGHANDLE	☐	/CEM/LOGHANDLE	SYSUUID_22	CHAR	22	0	Log handle
19	I_CANC_FLAG	☐	/CEM/FLAG	/CEM/FLAG	CHAR	1	0	FLAG
20	.INCLUDE	☐				0	0	Item Status Data
21	I_STATUS	☐	/CEM/STATUS	/CEM/STATUS	CHAR	4	0	Status	*
22	.INCLUDE	☐				0	0	Settlement Status
23	SET_STATUS	☐	/CEM/SETTLEMENT_STATUS	/CEM/SETTLEMENT_STATUS	CHAR	1	0	Settlement status
24	CAN_SET_STATUS	☐	/CEM/CAN_SETTLEMENT_STATUS	/CEM/SETTLEMENT_STATUS	CHAR	1	0	Settlement Cancellation Status
25	.INCLUDE	☐				0	0	Item partner data
26	.INCLUDE	☐				0	0	Transactional Informartion: Partner Data
27	TRAN_PART_ID	☐	/CEM/PARTNER_ID	BU_PARTNER	CHAR	10	0	Partner ID	*
28	TRAN_PART_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
29	TRAN_PART_LOGSYS	☐	/CEM/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
30	.INCLUDE	☐				0	0	Invoice Issuer data
31	INPA_PART_ID	☐	/CEM/INV_ISSUER	BU_PARTNER	CHAR	10	0	Invoice issuer	*
32	INPA_PART_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
33	INPA_PART_LOGSYS	☐	/CEM/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
34	.INCLUDE	☐				0	0	Item product data
35	.INCLUDE	☐				0	0	Transactional Product Data
36	TRAN_PROD_ID	☐	/CEM/PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
37	TRAN_PROD_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
38	TRAN_PROD_LOGSYS	☐	/CEM/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
39	TRAN_PROD_CAT	☐	/CEM/PRODUCT_CATEGORY	COM_CATEGORY_ID	CHAR	20	0	Product Category
40	.INCLUDE	☐				0	0	Item Quantity Data
41	.INCLUDE	☐				0	0	Transactional Quantity Structure
42	TRAN_QTY	☐	/CEM/TRAN_QTY	MENGV15_3	QUAN	15	3	Transaction Quantity
43	TRAN_QTY_UOM	☐	/CEM/TRAN_QTY_UOM	MEINS	UNIT	3	0	Transactional Quantity UOM	*
44	.INCLUDE	☐				0	0	Item Original Quantity Structure
45	ORII_QTY	☐	/CEM/ORIGINAL_QTY	/CEM/QUANTITY15_3	QUAN	15	3	Original Quantity
46	ORII_QTY_UOM	☐	/CEM/ORIGINAL_QTY_UOM	MEINS	UNIT	3	0	Original Quantity UOM	*
47	.INCLUDE	☐				0	0	Item Price Data
48	.INCLUDE	☐				0	0	Transactional Rate Data
49	TRAN_RATE	☐	/CEM/TRAN_RATE	WERTV8	CURR	15	2	Transaction Rate
50	TRAN_RATE_CURR	☐	/CEM/TRAN_RATE_CURR	WAERS	CUKY	5	0	Transaction Rate Currency	*
51	TRAN_RATE_PRCUNT	☐	/CEM/TRAN_RATE_PRCUNT	/CEM/PRCUNT	DEC	5	0	Transaction Rate Pricing Unit
52	TRAN_RATE_PRCUOM	☐	/CEM/TRAN_RATE_PRCUOM	MEINS	UNIT	3	0	Transaction Rate: Unit of Measure	*
53	.INCLUDE	☐				0	0	Transactional Value Data
54	TRAN_VAL	☐	/CEM/TRAN_VAL	WERTV8	CURR	15	2	Transaction Value
55	TRAN_VAL_CURR	☐	/CEM/TRAN_VAL_CURR	WAERS	CUKY	5	0	Transactional Value Currency	*
56	.INCLUDE	☐				0	0	Item Date data
57	TRAN_DATE	☐	/CEM/TRAN_DATE	DATUM	DATS	8	0	Transaction date
58	.INCLUDE	☐				0	0	Item Admin Data
59	I_CREA_BY	☐	/CEM/CREATED_BY	USRID	CHAR	12	0	Created By
60	I_CREA_DATE	☐	/CEM/CREATED_DATE	DATUM	DATS	8	0	Creation Date
61	I_CREA_TIME	☐	/CEM/CREATED_TIME	UZEIT	TIMS	6	0	Creation Time
62	I_CHNG_BY	☐	/CEM/CHANGED_BY	USRID	CHAR	12	0	Changed By
63	I_CHNG_DATE	☐	/CEM/CHANGED_DATE	DATUM	DATS	8	0	Changed On
64	I_CHNG_TIME	☐	/CEM/CHANGED_TIME	UZEIT	TIMS	6	0	Change Time
65	.INCLUDE	☐				0	0	Entitlement Item Extn DB
66	.INCLUDE	☐				0	0	Entitlement Item Attributes DB Extn
67	.INCLUDE	☐				0	0	Entitlement Processing Attribute Extension DB
68	ROLLABLE	☐	/CEM/ROLLABLE	/CEM/FLAG	CHAR	1	0	Reinstatement Indicator
69	OPEN_QTY	☐	/CEM/OPEN_QTY	/CEM/QUANTITY15_3	QUAN	15	3	Open Quantity
70	CLOSED_QTY	☐	/CEM/CLOSED_QTY	/CEM/QUANTITY15_3	QUAN	15	3	Closed Quantity
71	BALRST_QTY	☐	/CEM/BAL_RESET_QTY	/CEM/QUANTITY15_3	QUAN	15	3	Balance Reset Quantity
72	OPEN_BALANCE	☐	/CEM/OPEN_BALANCE	WERTV8	CURR	15	2	Opening balance
73	CLOSE_BALANCE	☐	/CEM/CLOSE_BALANCE	WERTV8	CURR	15	2	Closing Balance
74	SUMMARYTYPE	☐	/CEM/SE_SUMMARYTYPE	/CEM/SE_SUMMARYTYPE	CHAR	12	0	Summary Accumulation Bucket	*
75	CALC_TYPE	☐	/CEM/SUMM_RELEVANT	/CEM/SUMM_RELEVANT	CHAR	1	0	Summary Relevance Indicator
76	.INCLUDE	☐				0	0
77	.INCLUDE	☐				0	0
78	.INCLUDE	☐				0	0
79	.INCLUDE	☐				0	0	Item Dynamic Data
80	I_SEL_MARK	☐	/CEM/SEL_MARK	/CEM/SEL_MARK	CHAR	1	0	Selection Mark
81	I_REC_MODE	☐	/CEM/REC_MODE	/CEM/REC_MODE	CHAR	1	0	Record Mode
82	I_LOCK_MODE	☐	/CEM/LOCK	/CEM/LOCK	CHAR	1	0	Lock Mode

History

Last changed by/on	SAP	20110908
SAP Release Created in	401