SAP ABAP Table /CEM/S_H_DB (Header Database Buffer structure)

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_H_DB	Table Relationship Diagram
Short Description	Header Database Buffer structure

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	APPLICATION	☐	/CEM/APPLICATION	/CEM/APPLICATION	CHAR	4	0	Program Type	*
3	H_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
4	H_ID	☐	/CEM/ID	/CEM/ID	CHAR	10	0	Id
5	SERIAL_NO	☐	/CEM/SERIAL_NO	/CEM/SERIAL_NO	CHAR	40	0	Entitlements Serial Number
6	.INCLUDE	☐				0	0	General Header Data
7	.INCLUDE	☐				0	0	Header Attributes Data
8	.INCLUDE	☐				0	0	Header Attribute: Processing Attributes
9	TYPE	☐	/CEM/TYPE	/CEM/TYPE	CHAR	2	0	Type
10	IC_FLAG	☐	/CEM/INTER_COMPANY_FLAG	/CEM/FLAG	CHAR	1	0	Inter company flag
11	ENT_STRATEGY	☐	/CEM/ENT_STRATEGY	/CEM/ENT_STRATEGY	CHAR	2	0	Entitlement Program Scheme	*
12	DEF_FLAG	☐	/CEM/DEF_FLAG	/CEM/DEF_FLAG	CHAR	1	0	Deferred Clearing Program Scheme
13	ATTRITION_FLAG	☐	/CEM/ATTR_FLAG	/CEM/ATTR_FLAG	CHAR	1	0	Expiration Indicator
14	.INCLUDE	☐				0	0	Header Attribute: General Attributes
15	H_LOGSYS	☐	/CEM/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
16	H_LOGHANDLE	☐	/CEM/LOGHANDLE	SYSUUID_22	CHAR	22	0	Log handle
17	H_ARCHIVE_FLAG	☐	/CEM/ARCHIVE_FLAG	/CEM/FLAG	CHAR	1	0	Archive flag
18	H_CANC_FLAG	☐	/CEM/FLAG	/CEM/FLAG	CHAR	1	0	FLAG
19	.INCLUDE	☐				0	0	Header Organizational Data
20	BILL_ORG	☐	BEA_BILL_ORG	BU_PARTNER	CHAR	10	0	Billing Unit	*
21	.INCLUDE	☐				0	0	Sales Organizational Data
22	SALES_ORG	☐	/CEM/SALES_ORG	/CEM/SALES_ORG	CHAR	14	0	Sales Organization
23	DIS_CHANNEL	☐	/CEM/DISTRIBUTION_CHANNEL	/CEM/DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel
24	DIVISION	☐	/CEM/DIVISION	/CEM/DIVISION	CHAR	2	0	Division
25	.INCLUDE	☐				0	0	Header Partner Data
26	.INCLUDE	☐				0	0	Header type Partner data
27	H_PART_ID	☐	/CEM/PARTNER_ID	BU_PARTNER	CHAR	10	0	Partner ID	*
28	H_PART_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
29	H_PART_LOGSYS	☐	/CEM/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
30	.INCLUDE	☐				0	0	Issuer data
31	COPA_PART_ID	☐	/CEM/ISSUER	BU_PARTNER	CHAR	10	0	Issuer	*
32	COPA_PART_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
33	COPA_PART_LOGSYS	☐	/CEM/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
34	.INCLUDE	☐				0	0	Header Product Data
35	.INCLUDE	☐				0	0	Header type Product Data
36	H_PROD_ID	☐	/CEM/PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
37	H_PROD_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
38	H_PROD_CAT	☐	/CEM/PRODUCT_CATEGORY	COM_CATEGORY_ID	CHAR	20	0	Product Category
39	H_PROD_LOGSYS	☐	/CEM/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
40	.INCLUDE	☐				0	0	Header Date Data
41	START_DATE	☐	/CEM/START_DATE	DATUM	DATS	8	0	Start date
42	END_DATE	☐	/CEM/END_DATE	DATUM	DATS	8	0	End Date
43	.INCLUDE	☐				0	0	Header Status Data
44	H_STATUS	☐	/CEM/STATUS	/CEM/STATUS	CHAR	4	0	Status	*
45	.INCLUDE	☐				0	0	Header Quantity Related Data
46	.INCLUDE	☐				0	0	Avialable Quantity Structure
47	AVL_QTY	☐	/CEM/AVL_QTY	MENGV15_3	QUAN	15	3	Available Quantity
48	AVL_QTY_UOM	☐	/CEM/AVL_QTY_UOM	MEINS	UNIT	3	0	Available Quantity UOM	*
49	.INCLUDE	☐				0	0	Original Quantity Structure
50	ORI_QTY	☐	/CEM/ORIGINAL_QTY	/CEM/QUANTITY15_3	QUAN	15	3	Original Quantity
51	ORI_QTY_UOM	☐	/CEM/ORIGINAL_QTY_UOM	MEINS	UNIT	3	0	Original Quantity UOM	*
52	.INCLUDE	☐				0	0	Header Price Data
53	.INCLUDE	☐				0	0	Available Value Data
54	AVL_VAL	☐	/CEM/AVL_VAL	WERTV8	CURR	15	2	Available Value
55	AVL_VAL_CURR	☐	/CEM/AVL_VAL_CURR	WAERS	CUKY	5	0	Available Value Currency	*
56	.INCLUDE	☐				0	0	Rate Data
57	RATE	☐	/CEM/RATE	WERTV8	CURR	15	2	Rate
58	RATE_CURR	☐	/CEM/RATE_CURR	WAERS	CUKY	5	0	Rate Currency	*
59	RATE_PRCUNT	☐	/CEM/RATE_PRCUNT	/CEM/PRCUNT	DEC	5	0	Rate Pricing Unit
60	RATE_PRCUOM	☐	/CEM/RATE_PRCUOM	MEINS	UNIT	3	0	Rate UOM	*
61	.INCLUDE	☐				0	0	Header Administration Data
62	H_CREA_BY	☐	/CEM/CREATED_BY	USRID	CHAR	12	0	Created By
63	H_CREA_DATE	☐	/CEM/CREATED_DATE	DATUM	DATS	8	0	Creation Date
64	H_CREA_TIME	☐	/CEM/CREATED_TIME	UZEIT	TIMS	6	0	Creation Time
65	H_CHNG_BY	☐	/CEM/CHANGED_BY	USRID	CHAR	12	0	Changed By
66	H_CHNG_DATE	☐	/CEM/CHANGED_DATE	DATUM	DATS	8	0	Changed On
67	H_CHNG_TIME	☐	/CEM/CHANGED_TIME	UZEIT	TIMS	6	0	Change Time
68	.INCLUDE	☐				0	0	Entitlement Header Extn DB
69	.INCLUDE	☐				0	0	Entitlement Header Partner Data Extn DB
70	.INCLUDE	☐				0	0	Entitlement Ordered Product data
71	ORD_PROD_ID	☐	/CEM/ORD_PROD_ID	COM_PRODUCT_ID	CHAR	40	0	Ordered Product Id
72	ORD_PROD_GUID	☐	/CEM/GUID	SYSUUID	RAW	16	0	GUID
73	ORD_PROD_LOGSYS	☐	/CEM/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
74	.INCLUDE	☐				0	0	Summary Header
75	.INCLUDE	☐				0	0	Summary details
76	SUMMARY	☐	/CEM/SE_SUMMARY	/CEM/SE_SUMMARY	CHAR	12	0	Summary	*
77	SUMMARYTYPE	☐	/CEM/SE_SUMMARYTYPE	/CEM/SE_SUMMARYTYPE	CHAR	12	0	Summary Accumulation Bucket	*
78	OPEN_QTY	☐	/CEM/OPEN_QTY	/CEM/QUANTITY15_3	QUAN	15	3	Open Quantity
79	CLOSED_QTY	☐	/CEM/CLOSED_QTY	/CEM/QUANTITY15_3	QUAN	15	3	Closed Quantity
80	BALRST_QTY	☐	/CEM/BAL_RESET_QTY	/CEM/QUANTITY15_3	QUAN	15	3	Balance Reset Quantity
81	OPEN_BALANCE	☐	/CEM/OPEN_BALANCE	WERTV8	CURR	15	2	Opening balance
82	CLOSE_BALANCE	☐	/CEM/CLOSE_BALANCE	WERTV8	CURR	15	2	Closing Balance
83	BALRST_VAL	☐	/CEM/BAL_RESET_VALUE	WERTV8	CURR	15	2	Balance Reset Value
84	SETT_AMT	☐	/CEM/SET_VAL	WERTV8	CURR	15	2	Settled Value
85	.INCLUDE	☐				0	0	Settlement Status
86	SET_STATUS	☐	/CEM/SETTLEMENT_STATUS	/CEM/SETTLEMENT_STATUS	CHAR	1	0	Settlement status
87	CAN_SET_STATUS	☐	/CEM/CAN_SETTLEMENT_STATUS	/CEM/SETTLEMENT_STATUS	CHAR	1	0	Settlement Cancellation Status
88	.INCLUDE	☐				0	0
89	.INCLUDE	☐				0	0
90	.INCLUDE	☐				0	0

History

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