SAP ABAP View /CEM/V_ENT (Entitlement Application 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_ENT  
Short Description Entitlement Application View    
Root table /CEM/D_H_ENT   Entitlement Application: Header data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 /CEM/D_H_ENT /CEM/D_H_ENT
2 /CEM/D_I_ENT  
3 /CEM/D_D_ENT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 /CEM/D_H_ENT CLIENT JL EQ 0 0
2 /CEM/D_I_ENT CLIENT JR EQ AND 0 0
3 /CEM/D_H_ENT H_GUID JL EQ 0 0
4 /CEM/D_I_ENT H_GUID JR EQ AND 0 0
5 /CEM/D_H_ENT CLIENT JL EQ 0 0
6 /CEM/D_D_ENT CLIENT JR EQ AND 0 0
7 /CEM/D_H_ENT H_GUID JL EQ 0 0
8 /CEM/D_D_ENT H_GUID JR EQ AND 0 0
9 /CEM/D_I_ENT CLIENT JL EQ 0 0
10 /CEM/D_D_ENT CLIENT JR EQ AND 0 0
11 /CEM/D_I_ENT I_GUID JL EQ 0 0
12 /CEM/D_D_ENT I_GUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT /CEM/D_H_ENT CLIENT   MANDT Client
2 H_GUID /CEM/D_H_ENT H_GUID   /CEM/GUID GUID
3 H_ID /CEM/D_H_ENT H_ID   /CEM/ID Id
4 ATTRITION_FLAG /CEM/D_H_ENT ATTRITION_FLAG   /CEM/ATTR_FLAG Expiration Indicator
5 SERIAL_NO /CEM/D_H_ENT SERIAL_NO   /CEM/SERIAL_NO Entitlements Serial Number
6 H_LOGSYS /CEM/D_H_ENT H_LOGSYS   /CEM/LOGSYS Logical System
7 H_LOGHANDLE /CEM/D_H_ENT H_LOGHANDLE   /CEM/LOGHANDLE Log handle
8 H_ARCHIVE_FLAG /CEM/D_H_ENT H_ARCHIVE_FLAG   /CEM/ARCHIVE_FLAG Archive flag
9 H_CANC_FLAG /CEM/D_H_ENT H_CANC_FLAG   /CEM/FLAG FLAG
10 TYPE /CEM/D_H_ENT TYPE   /CEM/TYPE Type
11 IC_FLAG /CEM/D_H_ENT IC_FLAG   /CEM/INTER_COMPANY_FLAG Inter company flag
12 ENT_STRATEGY /CEM/D_H_ENT ENT_STRATEGY   /CEM/ENT_STRATEGY Entitlement Program Scheme
13 DEF_FLAG /CEM/D_H_ENT DEF_FLAG   /CEM/DEF_FLAG Deferred Clearing Program Scheme
14 BILL_ORG /CEM/D_H_ENT BILL_ORG   /CEM/BILL_ORG Entitlement Engine: Billing Unit For Billing Relevance
15 H_PART_ID /CEM/D_H_ENT H_PART_ID   /CEM/PARTNER_ID Partner ID
16 H_PART_GUID /CEM/D_H_ENT H_PART_GUID   /CEM/GUID GUID
17 H_PART_LOGSYS /CEM/D_H_ENT H_PART_LOGSYS   /CEM/LOGSYS Logical System
18 COPA_PART_ID /CEM/D_H_ENT COPA_PART_ID   /CEM/ISSUER Issuer
19 COPA_PART_GUID /CEM/D_H_ENT COPA_PART_GUID   /CEM/GUID GUID
20 COPA_PART_LOGSYS /CEM/D_H_ENT COPA_PART_LOGSYS   /CEM/LOGSYS Logical System
21 H_PROD_ID /CEM/D_H_ENT H_PROD_ID   /CEM/PRODUCT_ID Product ID
22 H_PROD_GUID /CEM/D_H_ENT H_PROD_GUID   /CEM/GUID GUID
23 H_PROD_CAT /CEM/D_H_ENT H_PROD_CAT   /CEM/PRODUCT_CATEGORY Product Category
24 H_PROD_LOGSYS /CEM/D_H_ENT H_PROD_LOGSYS   /CEM/LOGSYS Logical System
25 ORD_PROD_ID /CEM/D_H_ENT ORD_PROD_ID   /CEM/ORD_PROD_ID Ordered Product Id
26 ORD_PROD_GUID /CEM/D_H_ENT ORD_PROD_GUID   /CEM/GUID GUID
27 ORD_PROD_LOGSYS /CEM/D_H_ENT ORD_PROD_LOGSYS   /CEM/LOGSYS Logical System
28 START_DATE /CEM/D_H_ENT START_DATE   /CEM/START_DATE Start date
29 END_DATE /CEM/D_H_ENT END_DATE   /CEM/END_DATE End Date
30 H_STATUS /CEM/D_H_ENT H_STATUS   /CEM/STATUS Status
31 AVL_QTY /CEM/D_H_ENT AVL_QTY   /CEM/AVL_QTY Available Quantity
32 AVL_QTY_UOM /CEM/D_H_ENT AVL_QTY_UOM   /CEM/AVL_QTY_UOM Available Quantity UOM
33 AVL_VAL /CEM/D_H_ENT AVL_VAL   /CEM/AVL_VAL Available Value
34 AVL_VAL_CURR /CEM/D_H_ENT AVL_VAL_CURR   /CEM/AVL_VAL_CURR Available Value Currency
35 RATE /CEM/D_H_ENT RATE   /CEM/RATE Rate
36 RATE_CURR /CEM/D_H_ENT RATE_CURR   /CEM/RATE_CURR Rate Currency
37 RATE_PRCUNT /CEM/D_H_ENT RATE_PRCUNT   /CEM/RATE_PRCUNT Rate Pricing Unit
38 RATE_PRCUOM /CEM/D_H_ENT RATE_PRCUOM   /CEM/RATE_PRCUOM Rate UOM
39 H_CREA_BY /CEM/D_H_ENT H_CREA_BY   /CEM/CREATED_BY Created By
40 H_CREA_DATE /CEM/D_H_ENT H_CREA_DATE   /CEM/CREATED_DATE Creation Date
41 H_CREA_TIME /CEM/D_H_ENT H_CREA_TIME   /CEM/CREATED_TIME Creation Time
42 H_CHNG_BY /CEM/D_H_ENT H_CHNG_BY   /CEM/CHANGED_BY Changed By
43 H_CHNG_DATE /CEM/D_H_ENT H_CHNG_DATE   /CEM/CHANGED_DATE Changed On
44 H_CHNG_TIME /CEM/D_H_ENT H_CHNG_TIME   /CEM/CHANGED_TIME Change Time
45 I_GUID /CEM/D_I_ENT I_GUID   /CEM/GUID GUID
46 I_ID /CEM/D_I_ENT I_ID   /CEM/ID Id
47 PROCESS_CODE /CEM/D_I_ENT PROCESS_CODE   /CEM/PROC_CODE Process Code
48 SUB_PROC_CODE /CEM/D_I_ENT SUB_PROC_CODE   /CEM/SUB_PROC_CODE Subsequent Process Code
49 ROLLABLE /CEM/D_I_ENT ROLLABLE   /CEM/ROLLABLE Reinstatement Indicator
50 REASON_CODE /CEM/D_I_ENT REASON_CODE   /CEM/REASON_CODE Reason code
51 SUMM_REL /CEM/D_I_ENT SUMM_REL   /CEM/SUMM_REL Summary Relevance
52 I_LOGHANDLE /CEM/D_I_ENT I_LOGHANDLE   /CEM/LOGHANDLE Log handle
53 I_CANC_FLAG /CEM/D_I_ENT I_CANC_FLAG   /CEM/FLAG FLAG
54 I_STATUS /CEM/D_I_ENT I_STATUS   /CEM/DEF_CLEARING_STATUS Deferred clearing status
55 TRAN_PART_ID /CEM/D_I_ENT TRAN_PART_ID   /CEM/PARTNER_ID Partner ID
56 TRAN_PART_GUID /CEM/D_I_ENT TRAN_PART_GUID   /CEM/GUID GUID
57 TRAN_PART_LOGSYS /CEM/D_I_ENT TRAN_PART_LOGSYS   /CEM/LOGSYS Logical System
58 INPA_PART_ID /CEM/D_I_ENT INPA_PART_ID   /CEM/INV_ISSUER Invoice issuer
59 INPA_PART_GUID /CEM/D_I_ENT INPA_PART_GUID   /CEM/GUID GUID
60 INPA_PART_LOGSYS /CEM/D_I_ENT INPA_PART_LOGSYS   /CEM/LOGSYS Logical System
61 TRAN_PROD_ID /CEM/D_I_ENT TRAN_PROD_ID   /CEM/PRODUCT_ID Product ID
62 TRAN_PROD_GUID /CEM/D_I_ENT TRAN_PROD_GUID   /CEM/GUID GUID
63 TRAN_PROD_LOGSYS /CEM/D_I_ENT TRAN_PROD_LOGSYS   /CEM/LOGSYS Logical System
64 TRAN_PROD_CAT /CEM/D_I_ENT TRAN_PROD_CAT   /CEM/PRODUCT_CATEGORY Product Category
65 TRAN_QTY /CEM/D_I_ENT TRAN_QTY   /CEM/TRAN_QTY Transaction Quantity
66 TRAN_QTY_UOM /CEM/D_I_ENT TRAN_QTY_UOM   /CEM/TRAN_QTY_UOM Transactional Quantity UOM
67 TRAN_RATE /CEM/D_I_ENT TRAN_RATE   /CEM/TRAN_RATE Transaction Rate
68 TRAN_RATE_CURR /CEM/D_I_ENT TRAN_RATE_CURR   /CEM/TRAN_RATE_CURR Transaction Rate Currency
69 TRAN_RATE_PRCUNT /CEM/D_I_ENT TRAN_RATE_PRCUNT   /CEM/TRAN_RATE_PRCUNT Transaction Rate Pricing Unit
70 TRAN_RATE_PRCUOM /CEM/D_I_ENT TRAN_RATE_PRCUOM   /CEM/TRAN_RATE_PRCUOM Transaction Rate: Unit of Measure
71 TRAN_VAL /CEM/D_I_ENT TRAN_VAL   /CEM/TRAN_VAL Transaction Value
72 TRAN_VAL_CURR /CEM/D_I_ENT TRAN_VAL_CURR   /CEM/TRAN_VAL_CURR Transactional Value Currency
73 TRAN_DATE /CEM/D_I_ENT TRAN_DATE   /CEM/TRAN_DATE Transaction date
74 I_CREA_BY /CEM/D_I_ENT I_CREA_BY   /CEM/CREATED_BY Created By
75 I_CREA_DATE /CEM/D_I_ENT I_CREA_DATE   /CEM/CREATED_DATE Creation Date
76 I_CREA_TIME /CEM/D_I_ENT I_CREA_TIME   /CEM/CREATED_TIME Creation Time
77 I_CHNG_BY /CEM/D_I_ENT I_CHNG_BY   /CEM/CHANGED_BY Changed By
78 I_CHNG_DATE /CEM/D_I_ENT I_CHNG_DATE   /CEM/CHANGED_DATE Changed On
79 I_CHNG_TIME /CEM/D_I_ENT I_CHNG_TIME   /CEM/CHANGED_TIME Change Time
80 D_GUID /CEM/D_D_ENT D_GUID   /CEM/GUID GUID
81 D_ID /CEM/D_D_ENT D_ID   /CEM/ID Id
82 D_CANC_FLAG /CEM/D_D_ENT D_CANC_FLAG   /CEM/FLAG FLAG
83 DOC_TYPE /CEM/D_D_ENT DOC_TYPE   /CEM/DOC_TYPE Entitlement-Specific Transaction Category
84 DOC_CANC /CEM/D_D_ENT DOC_CANC   /CEM/DOC_CANC_FLAG Transaction Cancellation Indicator
85 DOC_LOG_SYS /CEM/D_D_ENT DOC_LOG_SYS   /CEM/DOC_LOG_SYS Logical System of Transaction
86 DOC_NO /CEM/D_D_ENT DOC_NO   /CEM/DOC_NO Transaction ID
87 DOC_GUID /CEM/D_D_ENT DOC_GUID   /CEM/GUID GUID
88 DOC_ITM_NO /CEM/D_D_ENT DOC_ITM_NO   /CEM/DOC_ITM_NUM Transaction Item Number
89 DOC_ITM_GUID /CEM/D_D_ENT DOC_ITM_GUID   /CEM/GUID GUID
90 PARSET_GUID /CEM/D_D_ENT PARSET_GUID   /CEM/GUID GUID
91 PRIDOC_GUID /CEM/D_D_ENT PRIDOC_GUID   /CEM/GUID GUID
92 SRC_DOC_TYPE /CEM/D_D_ENT SRC_DOC_TYPE   /CEM/DOC_TYPE Entitlement-Specific Transaction Category
93 SRC_DOC_GUID /CEM/D_D_ENT SRC_DOC_GUID   /CEM/GUID GUID
94 SRC_DOC_NO /CEM/D_D_ENT SRC_DOC_NO   /CEM/SRC_DOC_NO Source Document Number
95 SRC_ITM_GUID /CEM/D_D_ENT SRC_ITM_GUID   /CEM/GUID GUID
96 SRC_ITM_NO /CEM/D_D_ENT SRC_ITM_NO   /CEM/SRC_DOC_ITM_NUM Document Item Number
97 EXCHANGE_DATE /CEM/D_D_ENT EXCHANGE_DATE   /CEM/EXCHANGE_DATE Exchange Date
98 QTY /CEM/D_D_ENT QTY   /CEM/QTY Quantity
99 QTY_UOM /CEM/D_D_ENT QTY_UOM   /CEM/QTY_UOM Quantity UOM
100 REQ_QTY /CEM/D_D_ENT REQ_QTY   /CEM/REQ_QTY Requested Quantity
101 REQ_QTY_UOM /CEM/D_D_ENT REQ_QTY_UOM   /CEM/REQ_QTY_UOM Requested Quantity UOM
102 QTY_SPLIT /CEM/D_D_ENT QTY_SPLIT   /CEM/BOOLEAN Logical variable
103 PRICE /CEM/D_D_ENT PRICE   /CEM/PRICE Price
104 CURR /CEM/D_D_ENT CURR   /CEM/CURR Currency
105 PRCUNT /CEM/D_D_ENT PRCUNT   /CEM/PRCUNT Pricing Unit
106 PRCUOM /CEM/D_D_ENT PRCUOM   /CEM/PRCUOM Price UOM
107 SALES_ORG /CEM/D_H_ENT SALES_ORG   /CEM/SALES_ORG Sales Organization
108 DIS_CHANNEL /CEM/D_H_ENT DIS_CHANNEL   /CEM/DISTRIBUTION_CHANNEL Distribution Channel
109 DIVISION /CEM/D_H_ENT DIVISION   /CEM/DIVISION Division
110 FICO_DOC_NO /CEM/D_I_ENT FICO_DOC_NO   /CEM/FICO_DOC_NO FICO Document number
111 CANCEL_REASON /CEM/D_I_ENT CANCEL_REASON   /CEM/CAN_REASON_CODE Cancellation Reason code
112 SET_STATUS /CEM/D_I_ENT SET_STATUS   /CEM/SETTLEMENT_STATUS Settlement status
113 CAN_SET_STATUS /CEM/D_I_ENT CAN_SET_STATUS   /CEM/CAN_SETTLEMENT_STATUS Settlement Cancellation Status
114 ORII_QTY /CEM/D_I_ENT ORII_QTY   /CEM/ORIGINAL_QTY Original Quantity
115 ORII_QTY_UOM /CEM/D_I_ENT ORII_QTY_UOM   /CEM/ORIGINAL_QTY_UOM Original Quantity UOM
116 DOC_REL_TYPE /CEM/D_D_ENT DOC_REL_TYPE   /CEM/RELATIONSHIPTYPE Document relationship type
117 INB_REC_GUID /CEM/D_D_ENT INB_REC_GUID   /CEM/GUID GUID
                 
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