SAP ABAP View /CEM/V_SUMM (Entitlement Summary: View)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-EM (Application Component) CRM Entitlement Management
     ⤷ /CEM/ENT_REPOSITORY (Package) Entitlements Repository

Basic Data

View Type	D	Database View
Database View	/CEM/V_SUMM
Short Description	Entitlement Summary: View
Root table	/CEM/D_H_SUMM	Entitlement summary : Header data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	/CEM/D_H_SUMM	/CEM/D_H_SUMM
2	/CEM/D_I_SUMM
3	/CEM/D_D_SUMM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	/CEM/D_H_SUMM	CLIENT	JL	EQ				0	0
2	/CEM/D_D_SUMM	CLIENT	JR	EQ			AND	0	0
3	/CEM/D_H_SUMM	H_GUID	JL	EQ				0	0
4	/CEM/D_D_SUMM	H_GUID	JR	EQ			AND	0	0
5	/CEM/D_I_SUMM	CLIENT	JL	EQ				0	0
6	/CEM/D_D_SUMM	CLIENT	JR	EQ			AND	0	0
7	/CEM/D_I_SUMM	I_GUID	JL	EQ				0	0
8	/CEM/D_D_SUMM	I_GUID	JR	EQ			AND	0	0
9	/CEM/D_H_SUMM	CLIENT	JL	EQ				0	0
10	/CEM/D_I_SUMM	CLIENT	JR	EQ			AND	0	0
11	/CEM/D_H_SUMM	H_GUID	JL	EQ				0	0
12	/CEM/D_I_SUMM	H_GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	/CEM/D_H_SUMM	CLIENT		☐	MANDT	☐	Client
2	H_GUID	/CEM/D_H_SUMM	H_GUID		☐	/CEM/GUID	☐	GUID
3	H_ID	/CEM/D_H_SUMM	H_ID		☐	/CEM/ID	☐	Id
4	H_LOGSYS	/CEM/D_H_SUMM	H_LOGSYS		☐	/CEM/LOGSYS	☐	Logical System
5	H_LOGHANDLE	/CEM/D_H_SUMM	H_LOGHANDLE		☐	/CEM/LOGHANDLE	☐	Log handle
6	H_ARCHIVE_FLAG	/CEM/D_H_SUMM	H_ARCHIVE_FLAG		☐	/CEM/ARCHIVE_FLAG	☐	Archive flag
7	H_CANC_FLAG	/CEM/D_H_SUMM	H_CANC_FLAG		☐	/CEM/FLAG	☐	FLAG
8	TYPE	/CEM/D_H_SUMM	TYPE		☐	/CEM/TYPE	☐	Type
9	IC_FLAG	/CEM/D_H_SUMM	IC_FLAG		☐	/CEM/INTER_COMPANY_FLAG	☐	Inter company flag
10	ENT_STRATEGY	/CEM/D_H_SUMM	ENT_STRATEGY		☐	/CEM/ENT_STRATEGY	☐	Entitlement Program Scheme
11	DEF_FLAG	/CEM/D_H_SUMM	DEF_FLAG		☐	/CEM/DEF_FLAG	☐	Deferred Clearing Program Scheme
12	SUMMARY	/CEM/D_H_SUMM	SUMMARY		☐	/CEM/SE_SUMMARY	☐	Summary
13	SUMMARYTYPE	/CEM/D_H_SUMM	SUMMARYTYPE		☐	/CEM/SE_SUMMARYTYPE	☐	Summary Accumulation Bucket
14	BILL_ORG	/CEM/D_H_SUMM	BILL_ORG		☐	/CEM/BILL_ORG	☐	Entitlement Engine: Billing Unit For Billing Relevance
15	SALES_ORG	/CEM/D_H_SUMM	SALES_ORG		☐	/CEM/SALES_ORG	☐	Sales Organization
16	DIS_CHANNEL	/CEM/D_H_SUMM	DIS_CHANNEL		☐	/CEM/DISTRIBUTION_CHANNEL	☐	Distribution Channel
17	DIVISION	/CEM/D_H_SUMM	DIVISION		☐	/CEM/DIVISION	☐	Division
18	H_PART_ID	/CEM/D_H_SUMM	H_PART_ID		☐	/CEM/PARTNER_ID	☐	Partner ID
19	H_PART_GUID	/CEM/D_H_SUMM	H_PART_GUID		☐	/CEM/GUID	☐	GUID
20	H_PART_LOGSYS	/CEM/D_H_SUMM	H_PART_LOGSYS		☐	/CEM/LOGSYS	☐	Logical System
21	COPA_PART_ID	/CEM/D_H_SUMM	COPA_PART_ID		☐	/CEM/ISSUER	☐	Issuer
22	COPA_PART_GUID	/CEM/D_H_SUMM	COPA_PART_GUID		☐	/CEM/GUID	☐	GUID
23	COPA_PART_LOGSYS	/CEM/D_H_SUMM	COPA_PART_LOGSYS		☐	/CEM/LOGSYS	☐	Logical System
24	H_PROD_ID	/CEM/D_H_SUMM	H_PROD_ID		☐	/CEM/PRODUCT_ID	☐	Product ID
25	H_PROD_GUID	/CEM/D_H_SUMM	H_PROD_GUID		☐	/CEM/GUID	☐	GUID
26	H_PROD_CAT	/CEM/D_H_SUMM	H_PROD_CAT		☐	/CEM/PRODUCT_CATEGORY	☐	Product Category
27	H_PROD_LOGSYS	/CEM/D_H_SUMM	H_PROD_LOGSYS		☐	/CEM/LOGSYS	☐	Logical System
28	START_DATE	/CEM/D_H_SUMM	START_DATE		☐	/CEM/START_DATE	☐	Start date
29	END_DATE	/CEM/D_H_SUMM	END_DATE		☐	/CEM/END_DATE	☐	End Date
30	AVL_VAL	/CEM/D_H_SUMM	AVL_VAL		☐	/CEM/AVL_VAL	☐	Available Value
31	AVL_VAL_CURR	/CEM/D_H_SUMM	AVL_VAL_CURR		☐	/CEM/AVL_VAL_CURR	☐	Available Value Currency
32	H_CREA_BY	/CEM/D_H_SUMM	H_CREA_BY		☐	/CEM/CREATED_BY	☐	Created By
33	H_CREA_DATE	/CEM/D_H_SUMM	H_CREA_DATE		☐	/CEM/CREATED_DATE	☐	Creation Date
34	H_CREA_TIME	/CEM/D_H_SUMM	H_CREA_TIME		☐	/CEM/CREATED_TIME	☐	Creation Time
35	H_CHNG_BY	/CEM/D_H_SUMM	H_CHNG_BY		☐	/CEM/CHANGED_BY	☐	Changed By
36	H_CHNG_DATE	/CEM/D_H_SUMM	H_CHNG_DATE		☐	/CEM/CHANGED_DATE	☐	Changed On
37	H_CHNG_TIME	/CEM/D_H_SUMM	H_CHNG_TIME		☐	/CEM/CHANGED_TIME	☐	Change Time
38	H_STATUS	/CEM/D_H_SUMM	H_STATUS		☐	/CEM/STATUS	☐	Status
39	I_GUID	/CEM/D_I_SUMM	I_GUID		☐	/CEM/GUID	☐	GUID
40	I_ID	/CEM/D_I_SUMM	I_ID		☐	/CEM/ID	☐	Id
41	PROCESS_CODE	/CEM/D_I_SUMM	PROCESS_CODE		☐	/CEM/PROC_CODE	☐	Process Code
42	SUB_PROC_CODE	/CEM/D_I_SUMM	SUB_PROC_CODE		☐	/CEM/SUB_PROC_CODE	☐	Subsequent Process Code
43	I_LOGHANDLE	/CEM/D_I_SUMM	I_LOGHANDLE		☐	/CEM/LOGHANDLE	☐	Log handle
44	I_CANC_FLAG	/CEM/D_I_SUMM	I_CANC_FLAG		☐	/CEM/FLAG	☐	FLAG
45	I_STATUS	/CEM/D_I_SUMM	I_STATUS		☐	/CEM/STATUS	☐	Status
46	TRAN_QTY	/CEM/D_I_SUMM	TRAN_QTY		☐	/CEM/TRAN_QTY	☐	Transaction Quantity
47	TRAN_QTY_UOM	/CEM/D_I_SUMM	TRAN_QTY_UOM		☐	/CEM/TRAN_QTY_UOM	☐	Transactional Quantity UOM
48	TRAN_RATE	/CEM/D_I_SUMM	TRAN_RATE		☐	/CEM/TRAN_RATE	☐	Transaction Rate
49	TRAN_RATE_CURR	/CEM/D_I_SUMM	TRAN_RATE_CURR		☐	/CEM/TRAN_RATE_CURR	☐	Transaction Rate Currency
50	TRAN_RATE_PRCUNT	/CEM/D_I_SUMM	TRAN_RATE_PRCUNT		☐	/CEM/TRAN_RATE_PRCUNT	☐	Transaction Rate Pricing Unit
51	TRAN_RATE_PRCUOM	/CEM/D_I_SUMM	TRAN_RATE_PRCUOM		☐	/CEM/TRAN_RATE_PRCUOM	☐	Transaction Rate: Unit of Measure
52	TRAN_VAL	/CEM/D_I_SUMM	TRAN_VAL		☐	/CEM/TRAN_VAL	☐	Transaction Value
53	TRAN_VAL_CURR	/CEM/D_I_SUMM	TRAN_VAL_CURR		☐	/CEM/TRAN_VAL_CURR	☐	Transactional Value Currency
54	TRAN_DATE	/CEM/D_I_SUMM	TRAN_DATE		☐	/CEM/TRAN_DATE	☐	Transaction date
55	I_CREA_BY	/CEM/D_I_SUMM	I_CREA_BY		☐	/CEM/CREATED_BY	☐	Created By
56	I_CREA_DATE	/CEM/D_I_SUMM	I_CREA_DATE		☐	/CEM/CREATED_DATE	☐	Creation Date
57	I_CREA_TIME	/CEM/D_I_SUMM	I_CREA_TIME		☐	/CEM/CREATED_TIME	☐	Creation Time
58	I_CHNG_BY	/CEM/D_I_SUMM	I_CHNG_BY		☐	/CEM/CHANGED_BY	☐	Changed By
59	I_CHNG_DATE	/CEM/D_I_SUMM	I_CHNG_DATE		☐	/CEM/CHANGED_DATE	☐	Changed On
60	I_CHNG_TIME	/CEM/D_I_SUMM	I_CHNG_TIME		☐	/CEM/CHANGED_TIME	☐	Change Time
61	D_GUID	/CEM/D_D_SUMM	D_GUID		☐	/CEM/GUID	☐	GUID
62	D_ID	/CEM/D_D_SUMM	D_ID		☐	/CEM/ID	☐	Id
63	D_CANC_FLAG	/CEM/D_D_SUMM	D_CANC_FLAG		☐	/CEM/FLAG	☐	FLAG
64	DOC_TYPE	/CEM/D_D_SUMM	DOC_TYPE		☐	/CEM/DOC_TYPE	☐	Entitlement-Specific Transaction Category
65	DOC_CANC	/CEM/D_D_SUMM	DOC_CANC		☐	/CEM/DOC_CANC_FLAG	☐	Transaction Cancellation Indicator
66	DOC_LOG_SYS	/CEM/D_D_SUMM	DOC_LOG_SYS		☐	/CEM/DOC_LOG_SYS	☐	Logical System of Transaction
67	DOC_NO	/CEM/D_D_SUMM	DOC_NO		☐	/CEM/DOC_NO	☐	Transaction ID
68	DOC_GUID	/CEM/D_D_SUMM	DOC_GUID		☐	/CEM/GUID	☐	GUID
69	DOC_ITM_NO	/CEM/D_D_SUMM	DOC_ITM_NO		☐	/CEM/DOC_ITM_NUM	☐	Transaction Item Number
70	DOC_ITM_GUID	/CEM/D_D_SUMM	DOC_ITM_GUID		☐	/CEM/GUID	☐	GUID
71	PARSET_GUID	/CEM/D_D_SUMM	PARSET_GUID		☐	/CEM/GUID	☐	GUID
72	PRIDOC_GUID	/CEM/D_D_SUMM	PRIDOC_GUID		☐	/CEM/GUID	☐	GUID
73	QTY	/CEM/D_D_SUMM	QTY		☐	/CEM/QTY	☐	Quantity
74	QTY_UOM	/CEM/D_D_SUMM	QTY_UOM		☐	/CEM/QTY_UOM	☐	Quantity UOM
75	REQ_QTY	/CEM/D_D_SUMM	REQ_QTY		☐	/CEM/REQ_QTY	☐	Requested Quantity
76	REQ_QTY_UOM	/CEM/D_D_SUMM	REQ_QTY_UOM		☐	/CEM/REQ_QTY_UOM	☐	Requested Quantity UOM
77	PRICE	/CEM/D_D_SUMM	PRICE		☐	/CEM/PRICE	☐	Price
78	CURR	/CEM/D_D_SUMM	CURR		☐	/CEM/CURR	☐	Currency
79	PRCUNT	/CEM/D_D_SUMM	PRCUNT		☐	/CEM/PRCUNT	☐	Pricing Unit
80	PRCUOM	/CEM/D_D_SUMM	PRCUOM		☐	/CEM/PRCUOM	☐	Price UOM

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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