| 1 |
 LRO |
|
/CEM/D_H_LRO |
|
STRU |
0 |
0 |
|
|
| 2 |
CLIENT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
|
| 3 |
LRO_GUID |
|
/CEM/LRO_GUID |
/CEM/LRO_GUID |
RAW |
16 |
0 |
Lock Request Object GUID |
|
| 4 |
APPLICATION |
|
/CEM/LRO_TYPE |
/CEM/LRO_TYPE |
CHAR |
4 |
0 |
Program Type (Deposit/Returns Entitlement) |
|
| 5 |
.INCLUDE |
|
|
|
|
0 |
0 |
External transaction data for Lock Request Object |
|
| 6 |
.INCLUDE |
|
|
|
|
0 |
0 |
Header type Partner data |
|
| 7 |
H_PART_ID |
|
/CEM/PARTNER_ID |
BU_PARTNER |
CHAR |
10 |
0 |
Partner ID |
|
| 8 |
H_PART_GUID |
|
/CEM/GUID |
SYSUUID |
RAW |
16 |
0 |
GUID |
|
| 9 |
H_PART_LOGSYS |
|
/CEM/LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Logical System |
|
| 10 |
.INCLUDE |
|
|
|
|
0 |
0 |
Header type Product Data |
|
| 11 |
H_PROD_ID |
|
/CEM/PRODUCT_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Product ID |
|
| 12 |
H_PROD_GUID |
|
/CEM/GUID |
SYSUUID |
RAW |
16 |
0 |
GUID |
|
| 13 |
H_PROD_CAT |
|
/CEM/PRODUCT_CATEGORY |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Product Category |
|
| 14 |
H_PROD_LOGSYS |
|
/CEM/LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Logical System |
|
| 15 |
.INCLUDE |
|
|
|
|
0 |
0 |
Alternative Product data |
|
| 16 |
A_PROD_ID |
|
/CEM/PRODUCT_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Product ID |
|
| 17 |
A_PROD_GUID |
|
/CEM/GUID |
SYSUUID |
RAW |
16 |
0 |
GUID |
|
| 18 |
A_PROD_CAT |
|
/CEM/PRODUCT_CATEGORY |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Product Category |
|
| 19 |
A_PROD_LOGSYS |
|
/CEM/LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Logical System |
|
| 20 |
.INCLUDE |
|
|
|
|
0 |
0 |
Requested Quantity Structure |
|
| 21 |
REQ_QTY |
|
/CEM/REQ_QTY |
MENGV15_3 |
QUAN |
15 |
3 |
Requested Quantity |
|
| 22 |
REQ_QTY_UOM |
|
/CEM/REQ_QTY_UOM |
MEINS |
UNIT |
3 |
0 |
Requested Quantity UOM |
|
| 23 |
REQ_PROD_ID |
|
/CEM/REQ_PROD_ID |
COM_PRODUCT_ID |
CHAR |
40 |
0 |
Requested Product ID |
|
| 24 |
REQ_PROD_GUID |
|
/CEM/REQ_PROD_GUID |
SYSUUID |
RAW |
16 |
0 |
Requested Product GUID |
|
| 25 |
REQ_PROD_LOGSYS |
|
/CEM/REQ_PROD_LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Requested Product Logical System |
|
| 26 |
.INCLUDE |
|
|
|
|
0 |
0 |
Derived data for Lock Request Objects |
|
| 27 |
ENT_STRATEGY |
|
/CEM/ENT_STRATEGY |
/CEM/ENT_STRATEGY |
CHAR |
2 |
0 |
Entitlement Program Scheme |
|
| 28 |
REF_STRATEGY |
|
/CEM/COREBANK_DPP |
/CEM/COREBANK_DPP |
CHAR |
2 |
0 |
Deposit Credit/Direct Purchase Program indicator |
|
| 29 |
REF_STRATEGY_IND |
|
/CEM/REFUND_STRATEGY_IND |
/CEM/REFUND_STRATEGY_IND |
CHAR |
1 |
0 |
Refund Strategy Indicator |
|
| 30 |
PROD_BASEUOM |
|
/CEM/REQUESTED_QTY_BASE_UOM |
MEINS |
UNIT |
3 |
0 |
Requested quantity base UoM for Lock Request Object |
|
| 31 |
PROD_BASEUOM_QTY |
|
/CEM/REQUESTED_QUANTITY_BASE |
MENGV15_3 |
QUAN |
15 |
3 |
Requested base quantity for a Lock Request Object |
|
| 32 |
FULFILLED_QTY |
|
/CEM/FULFILLED_QUANTITY |
MENGV15_3 |
QUAN |
15 |
3 |
Fulfilled quantity for a Lock Request Object |
|
| 33 |
AVAILABLE_QTY |
|
/CEM/AVAILABLE_QUANTITY |
MENGV15_3 |
QUAN |
15 |
3 |
Available Quantity of a Lock Request Object |
|
| 34 |
CONSUMED_QTY |
|
/CEM/CONSUMED_QUANTITY |
MENGV15_3 |
QUAN |
15 |
3 |
Consumed Quantity of a Lock Request Object |
|
| 35 |
REFUND_QTY |
|
/CEM/REFUND_QUANTITY |
MENGV15_3 |
QUAN |
15 |
3 |
Refund Quantity of a Lock Request Object |
|
| 36 |
.INCLUDE |
|
|
|
|
0 |
0 |
Status information for Lock Request |
|
| 37 |
LRO_STATUS |
|
/CEM/LOCK_REQUEST_STATUS |
/CEM/LOCK_REQUEST_STATUS |
CHAR |
1 |
0 |
Status of a Lock Request Object |
|
| 38 |
TRANS_STATUS |
|
/CEM/TRANS_ITEM_STATUS |
/CEM/TRANS_ITEM_STATUS |
CHAR |
1 |
0 |
Reference Object item status |
|
| 39 |
IS_MERGED |
|
/CEM/LOCK_REQUEST_MERGED |
/CEM/BOOLEAN |
CHAR |
1 |
0 |
Indicator: Lock Request Object is merged |
|
| 40 |
MERGED_LRO_GUID |
|
/CEM/LRO_GUID |
/CEM/LRO_GUID |
RAW |
16 |
0 |
Lock Request Object GUID |
|
| 41 |
LRO_TOP_NODE |
|
/CEM/LRO_TOP_NODE |
/CEM/BOOLEAN |
CHAR |
1 |
0 |
Lock Request is top node of hierarchy |
|
| 42 |
ARCHIVE_FLAG |
|
/CEM/ARCHIVE_FLAG |
/CEM/FLAG |
CHAR |
1 |
0 |
Archive flag |
|
| 43 |
SEARCH_SCENARIO |
|
/CEM/ED_SEARCH_SCENARIO |
/CEM/ED_SEARCH_SCENARIO |
CHAR |
10 |
0 |
Search Scenario |
|
| 44 |
SEARCH_REQ |
|
/CEM/SEARCH |
/CEM/PROGRAM_ELIG_IND |
CHAR |
1 |
0 |
Search Deposit Entitlements |
|
| 45 |
RO_GUID |
|
/CEM/RO_GUID |
SYSUUID |
RAW |
16 |
0 |
Reference Object GUID |
|
| 46 |
LOGHANDLE |
|
/CEM/LOGHANDLE |
SYSUUID_22 |
CHAR |
22 |
0 |
Log handle |
|
| 47 |
DOC_CURRENCY |
|
/CEM/ENT_RATE_CURR |
WAERS |
CUKY |
5 |
0 |
Entitlement Rate Currency |
|
| 48 |
LOCAL_CURRENCY |
|
/CEM/ENT_RATE_CURR |
WAERS |
CUKY |
5 |
0 |
Entitlement Rate Currency |
|
| 49 |
DOC_DATE |
|
/CEM/DATE |
SYDATS |
DATS |
8 |
0 |
Date |
|
| 50 |
EXCHANGE_TYPE |
|
/CEM/EXCHANGE_TYPE |
KURST |
CHAR |
4 |
0 |
Exchange Rate Type |
|
| 51 |
SALES_ORG |
|
/CEM/SALES_ORG |
/CEM/SALES_ORG |
CHAR |
14 |
0 |
Sales Organization |
|
| 52 |
CHANNEL |
|
/CEM/DISTRIBUTION_CHANNEL |
/CEM/DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
|
| 53 |
DIVISION |
|
/CEM/DIVISION |
/CEM/DIVISION |
CHAR |
2 |
0 |
Division |
|
| 54 |
BILL_ORG |
|
BEA_BILL_ORG |
BU_PARTNER |
CHAR |
10 |
0 |
Billing Unit |
|
| 55 |
.INCLUDE |
|
|
|
|
0 |
0 |
Administrative Data |
|
| 56 |
CREATED_BY |
|
/CEM/CREATED_BY |
USRID |
CHAR |
12 |
0 |
Created By |
|
| 57 |
CREATED_DATE |
|
/CEM/CREATED_DATE |
DATUM |
DATS |
8 |
0 |
Creation Date |
|
| 58 |
CREATED_TIME |
|
/CEM/CREATED_TIME |
UZEIT |
TIMS |
6 |
0 |
Creation Time |
|
| 59 |
CHANGED_BY |
|
/CEM/CHANGED_BY |
USRID |
CHAR |
12 |
0 |
Changed By |
|
| 60 |
CHANGED_DATE |
|
/CEM/CHANGED_DATE |
DATUM |
DATS |
8 |
0 |
Changed On |
|
| 61 |
CHANGED_TIME |
|
/CEM/CHANGED_TIME |
UZEIT |
TIMS |
6 |
0 |
Change Time |
|
| 62 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
| 63 |
.INCLUDE |
|
|
|
|
0 |
0 |
Lock Request: Values for Consumable Rebates |
|
| 64 |
VALUE_CURRENCY |
|
/CEM/ENT_RATE_CURR |
WAERS |
CUKY |
5 |
0 |
Entitlement Rate Currency |
|
| 65 |
REQ_VALUE |
|
/CEM/ENT_RATE |
WERTV8 |
CURR |
15 |
2 |
Entitlement Rate |
|
| 66 |
FULFILLED_VALUE |
|
/CEM/ENT_RATE |
WERTV8 |
CURR |
15 |
2 |
Entitlement Rate |
|
| 67 |
CONSUMED_VALUE |
|
/CEM/ENT_RATE |
WERTV8 |
CURR |
15 |
2 |
Entitlement Rate |
|
| 68 |
AVAILABLE_VALUE |
|
/CEM/ENT_RATE |
WERTV8 |
CURR |
15 |
2 |
Entitlement Rate |
|
| 69 |
REFOBJ |
|
/CEM/D_LRO_RO |
|
STRU |
0 |
0 |
|
|
| 70 |
CLIENT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
|
| 71 |
RO_GUID |
|
/CEM/RO_GUID |
SYSUUID |
RAW |
16 |
0 |
Reference Object GUID |
|
| 72 |
.INCLUDE |
|
|
|
|
0 |
0 |
Key of a Reference Object for a Lock Request Object |
|
| 73 |
TRANS_DOC_GUID |
|
/CEM/DOC_GUID |
SYSUUID |
RAW |
16 |
0 |
Transaction GUID |
|
| 74 |
TRANS_DOC_NO |
|
/CEM/DOC_NO |
/CEM/DOC_NO |
CHAR |
20 |
0 |
Transaction ID |
|
| 75 |
TRANS_DOC_BUSOBJ |
|
/CEM/DOC_BUSOBJ |
CRM_OJ_NAME_PROCESS |
CHAR |
10 |
0 |
Business Transaction category |
|
| 76 |
TRANS_ITM_GUID |
|
/CEM/ITEM_GUID |
SYSUUID |
RAW |
16 |
0 |
Transaction Item GUID |
|
| 77 |
TRANS_ITM_NO |
|
/CEM/DOC_ITM_NUM |
/CEM/ITEM_NO |
NUMC |
10 |
0 |
Transaction Item Number |
|
| 78 |
TRANS_ITM_BUSOBJ |
|
/CEM/ITM_TRAN_CAT |
CRM_OJ_NAME_PROCESS_ITEM |
CHAR |
10 |
0 |
Item Transaction Category |
|
| 79 |
.INCLUDE |
|
|
|
|
0 |
0 |
Add. data of Reference Object for a Lock Request Object |
|
| 80 |
TRANS_DOC_LOGSYS |
|
/CEM/DOC_LOG_SYS |
/CEM/LOGSYS |
CHAR |
10 |
0 |
Logical System of Transaction |
|
| 81 |
TRANS_DOC_TYPE |
|
/CEM/DOC_PROCESSTYPE |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
|
| 82 |
TRANS_ITM_LOGSYS |
|
/CEM/ITEM_LOG_SYS |
/CEM/LOGSYS |
CHAR |
10 |
0 |
Item Logical System |
|
| 83 |
TRANS_ITM_TYPE |
|
/CEM/DOC_ITM_CAT |
CRM_ITEM_TYPE |
CHAR |
4 |
0 |
Item Category |
|
| 84 |
.INCLUDE |
|
|
|
|
0 |
0 |
Preceding Transaction of a Reference Object |
|
| 85 |
PREC_DOC_GUID |
|
/CEM/DOC_GUID |
SYSUUID |
RAW |
16 |
0 |
Transaction GUID |
|
| 86 |
PREC_DOC_LOGSYS |
|
/CEM/DOC_LOG_SYS |
/CEM/LOGSYS |
CHAR |
10 |
0 |
Logical System of Transaction |
|
| 87 |
PREC_DOC_NO |
|
/CEM/DOC_NO |
/CEM/DOC_NO |
CHAR |
20 |
0 |
Transaction ID |
|
| 88 |
PREC_DOC_BUSOBJ |
|
/CEM/DOC_BUSOBJ |
CRM_OJ_NAME_PROCESS |
CHAR |
10 |
0 |
Business Transaction category |
|
| 89 |
PREC_DOC_TYPE |
|
/CEM/DOC_PROCESSTYPE |
CRM_PROCESS_TYPE |
CHAR |
4 |
0 |
Business Transaction Type |
|
| 90 |
PREC_ITM_GUID |
|
/CEM/ITEM_GUID |
SYSUUID |
RAW |
16 |
0 |
Transaction Item GUID |
|
| 91 |
PREC_ITM_LOGSYS |
|
/CEM/ITEM_LOG_SYS |
/CEM/LOGSYS |
CHAR |
10 |
0 |
Item Logical System |
|
| 92 |
PREC_ITM_NO |
|
/CEM/DOC_ITM_NUM |
/CEM/ITEM_NO |
NUMC |
10 |
0 |
Transaction Item Number |
|
| 93 |
PREC_ITM_BUSOBJ |
|
/CEM/ITM_TRAN_CAT |
CRM_OJ_NAME_PROCESS_ITEM |
CHAR |
10 |
0 |
Item Transaction Category |
|
| 94 |
PREC_ITM_TYPE |
|
/CEM/DOC_ITM_CAT |
CRM_ITEM_TYPE |
CHAR |
4 |
0 |
Item Category |
|
| 95 |
.INCLUDE |
|
|
|
|
0 |
0 |
Administrative Data |
|
| 96 |
CREATED_BY |
|
/CEM/CREATED_BY |
USRID |
CHAR |
12 |
0 |
Created By |
|
| 97 |
CREATED_DATE |
|
/CEM/CREATED_DATE |
DATUM |
DATS |
8 |
0 |
Creation Date |
|
| 98 |
CREATED_TIME |
|
/CEM/CREATED_TIME |
UZEIT |
TIMS |
6 |
0 |
Creation Time |
|
| 99 |
CHANGED_BY |
|
/CEM/CHANGED_BY |
USRID |
CHAR |
12 |
0 |
Changed By |
|
| 100 |
CHANGED_DATE |
|
/CEM/CHANGED_DATE |
DATUM |
DATS |
8 |
0 |
Changed On |
|
| 101 |
CHANGED_TIME |
|
/CEM/CHANGED_TIME |
UZEIT |
TIMS |
6 |
0 |
Change Time |
|
| 102 |
RELATION |
|
/CEM/D_LRO_REL |
|
STRU |
0 |
0 |
|
|
| 103 |
CLIENT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
|
| 104 |
LRO_GUID_A |
|
/CEM/LRO_GUID |
/CEM/LRO_GUID |
RAW |
16 |
0 |
Lock Request Object GUID |
|
| 105 |
LRO_GUID_B |
|
/CEM/LRO_GUID |
/CEM/LRO_GUID |
RAW |
16 |
0 |
Lock Request Object GUID |
|
| 106 |
REL_TYPE |
|
/CEM/LRO_REL_TYPE |
/CEM/LRO_REL_TYPE |
CHAR |
1 |
0 |
Relationship type between two Lock Request Objects |
|
| 107 |
REL_STATUS |
|
/CEM/LRO_REL_STATUS |
/CEM/LRO_REL_STATUS |
CHAR |
1 |
0 |
Status of a Lock Request Object relationship |
|
| 108 |
REL_QTY |
|
/CEM/RELATION_QUANTITY |
MENGV15_3 |
QUAN |
15 |
3 |
Available quantity for subsequent Lock Request Objects |
|
| 109 |
REL_QTY_UOM |
|
/CEM/RELATION_QUANTITY_UOM |
MEINS |
UNIT |
3 |
0 |
Relation quantity UoM for subsequent Lock Request Objects |
|
| 110 |
.INCLUDE |
|
|
|
|
0 |
0 |
Administrative Data |
|
| 111 |
CREATED_BY |
|
/CEM/CREATED_BY |
USRID |
CHAR |
12 |
0 |
Created By |
|
| 112 |
CREATED_DATE |
|
/CEM/CREATED_DATE |
DATUM |
DATS |
8 |
0 |
Creation Date |
|
| 113 |
CREATED_TIME |
|
/CEM/CREATED_TIME |
UZEIT |
TIMS |
6 |
0 |
Creation Time |
|
| 114 |
CHANGED_BY |
|
/CEM/CHANGED_BY |
USRID |
CHAR |
12 |
0 |
Changed By |
|
| 115 |
CHANGED_DATE |
|
/CEM/CHANGED_DATE |
DATUM |
DATS |
8 |
0 |
Changed On |
|
| 116 |
CHANGED_TIME |
|
/CEM/CHANGED_TIME |
UZEIT |
TIMS |
6 |
0 |
Change Time |
|
Hierarchy 
BBPCRM (Software Component) BBPCRM
CRM-EM (Application Component) CRM Entitlement Management
/CEM/ENT_REPOSITORY (Package) Entitlements Repository
Basic Data 
Table Relationship Diagram 
Delivery and Maintenance 
Components 
History 
