SAP ABAP Table /CEM/V_LRO_UI (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure /CEM/V_LRO_UI   Table Relationship Diagram
Short Description Generated Table for View    
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 LRO_GUID /CEM/LRO_GUID /CEM/LRO_GUID RAW 16   0   Lock Request Object GUID  
3 APPLICATION /CEM/LRO_TYPE /CEM/LRO_TYPE CHAR 4   0   Program Type (Deposit/Returns Entitlement)  
4 H_PART_ID /CEM/PARTNER_ID BU_PARTNER CHAR 10   0   Partner ID  
5 H_PART_GUID /CEM/GUID SYSUUID RAW 16   0   GUID  
6 H_PART_LOGSYS /CEM/LOGSYS LOGSYS CHAR 10   0   Logical System  
7 H_PROD_ID /CEM/PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
8 H_PROD_GUID /CEM/GUID SYSUUID RAW 16   0   GUID  
9 H_PROD_CAT /CEM/PRODUCT_CATEGORY COM_CATEGORY_ID CHAR 20   0   Product Category  
10 H_PROD_LOGSYS /CEM/LOGSYS LOGSYS CHAR 10   0   Logical System  
11 A_PROD_ID /CEM/PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
12 A_PROD_GUID /CEM/GUID SYSUUID RAW 16   0   GUID  
13 A_PROD_CAT /CEM/PRODUCT_CATEGORY COM_CATEGORY_ID CHAR 20   0   Product Category  
14 A_PROD_LOGSYS /CEM/LOGSYS LOGSYS CHAR 10   0   Logical System  
15 REQ_QTY /CEM/REQ_QTY MENGV15_3 QUAN 15   3   Requested Quantity  
16 REQ_QTY_UOM /CEM/REQ_QTY_UOM MEINS UNIT 3   0   Requested Quantity UOM  
17 REQ_PROD_ID /CEM/REQ_PROD_ID COM_PRODUCT_ID CHAR 40   0   Requested Product ID  
18 REQ_PROD_GUID /CEM/REQ_PROD_GUID SYSUUID RAW 16   0   Requested Product GUID  
19 REQ_PROD_LOGSYS /CEM/REQ_PROD_LOGSYS LOGSYS CHAR 10   0   Requested Product Logical System  
20 ENT_STRATEGY /CEM/ENT_STRATEGY /CEM/ENT_STRATEGY CHAR 2   0   Entitlement Program Scheme  
21 REF_STRATEGY /CEM/COREBANK_DPP /CEM/COREBANK_DPP CHAR 2   0   Deposit Credit/Direct Purchase Program indicator  
22 REF_STRATEGY_IND /CEM/REFUND_STRATEGY_IND /CEM/REFUND_STRATEGY_IND CHAR 1   0   Refund Strategy Indicator  
23 PROD_BASEUOM /CEM/REQUESTED_QTY_BASE_UOM MEINS UNIT 3   0   Requested quantity base UoM for Lock Request Object  
24 PROD_BASEUOM_QTY /CEM/REQUESTED_QUANTITY_BASE MENGV15_3 QUAN 15   3   Requested base quantity for a Lock Request Object  
25 FULFILLED_QTY /CEM/FULFILLED_QUANTITY MENGV15_3 QUAN 15   3   Fulfilled quantity for a Lock Request Object  
26 AVAILABLE_QTY /CEM/AVAILABLE_QUANTITY MENGV15_3 QUAN 15   3   Available Quantity of a Lock Request Object  
27 CONSUMED_QTY /CEM/CONSUMED_QUANTITY MENGV15_3 QUAN 15   3   Consumed Quantity of a Lock Request Object  
28 REFUND_QTY /CEM/REFUND_QUANTITY MENGV15_3 QUAN 15   3   Refund Quantity of a Lock Request Object  
29 LRO_STATUS /CEM/LOCK_REQUEST_STATUS /CEM/LOCK_REQUEST_STATUS CHAR 1   0   Status of a Lock Request Object  
30 TRANS_STATUS /CEM/TRANS_ITEM_STATUS /CEM/TRANS_ITEM_STATUS CHAR 1   0   Reference Object item status  
31 IS_MERGED /CEM/LOCK_REQUEST_MERGED /CEM/BOOLEAN CHAR 1   0   Indicator: Lock Request Object is merged  
32 MERGED_LRO_GUID /CEM/LRO_GUID /CEM/LRO_GUID RAW 16   0   Lock Request Object GUID  
33 LRO_TOP_NODE /CEM/LRO_TOP_NODE /CEM/BOOLEAN CHAR 1   0   Lock Request is top node of hierarchy  
34 ARCHIVE_FLAG /CEM/ARCHIVE_FLAG /CEM/FLAG CHAR 1   0   Archive flag  
35 SEARCH_SCENARIO /CEM/ED_SEARCH_SCENARIO /CEM/ED_SEARCH_SCENARIO CHAR 10   0   Search Scenario  
36 SEARCH_REQ /CEM/SEARCH /CEM/PROGRAM_ELIG_IND CHAR 1   0   Search Deposit Entitlements  
37 RO_GUID /CEM/RO_GUID SYSUUID RAW 16   0   Reference Object GUID /CEM/D_LRO_RO
38 LOGHANDLE /CEM/LOGHANDLE SYSUUID_22 CHAR 22   0   Log handle  
39 DOC_CURRENCY /CEM/ENT_RATE_CURR WAERS CUKY 5   0   Entitlement Rate Currency  
40 LOCAL_CURRENCY /CEM/ENT_RATE_CURR WAERS CUKY 5   0   Entitlement Rate Currency  
41 DOC_DATE /CEM/DATE SYDATS DATS 8   0   Date  
42 EXCHANGE_TYPE /CEM/EXCHANGE_TYPE KURST CHAR 4   0   Exchange Rate Type  
43 SALES_ORG /CEM/SALES_ORG /CEM/SALES_ORG CHAR 14   0   Sales Organization  
44 CHANNEL /CEM/DISTRIBUTION_CHANNEL /CEM/DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel  
45 DIVISION /CEM/DIVISION /CEM/DIVISION CHAR 2   0   Division  
46 BILL_ORG BEA_BILL_ORG BU_PARTNER CHAR 10   0   Billing Unit  
47 CREATED_BY /CEM/CREATED_BY USRID CHAR 12   0   Created By  
48 CREATED_DATE /CEM/CREATED_DATE DATUM DATS 8   0   Creation Date  
49 CREATED_TIME /CEM/CREATED_TIME UZEIT TIMS 6   0   Creation Time  
50 CHANGED_BY /CEM/CHANGED_BY USRID CHAR 12   0   Changed By  
51 CHANGED_DATE /CEM/CHANGED_DATE DATUM DATS 8   0   Changed On  
52 CHANGED_TIME /CEM/CHANGED_TIME UZEIT TIMS 6   0   Change Time  
53 TRANS_DOC_GUID /CEM/DOC_GUID SYSUUID RAW 16   0   Transaction GUID  
54 TRANS_DOC_NO /CEM/DOC_NO /CEM/DOC_NO CHAR 20   0   Transaction ID  
55 TRANS_DOC_BUSOBJ /CEM/DOC_BUSOBJ CRM_OJ_NAME_PROCESS CHAR 10   0   Business Transaction category  
56 TRANS_ITM_GUID /CEM/ITEM_GUID SYSUUID RAW 16   0   Transaction Item GUID  
57 TRANS_ITM_NO /CEM/DOC_ITM_NUM /CEM/ITEM_NO NUMC 10   0   Transaction Item Number  
58 TRANS_ITM_BUSOBJ /CEM/ITM_TRAN_CAT CRM_OJ_NAME_PROCESS_ITEM CHAR 10   0   Item Transaction Category  
59 TRANS_DOC_LOGSYS /CEM/DOC_LOG_SYS /CEM/LOGSYS CHAR 10   0   Logical System of Transaction  
60 TRANS_DOC_TYPE /CEM/DOC_PROCESSTYPE CRM_PROCESS_TYPE CHAR 4   0   Business Transaction Type  
61 TRANS_ITM_LOGSYS /CEM/ITEM_LOG_SYS /CEM/LOGSYS CHAR 10   0   Item Logical System  
62 TRANS_ITM_TYPE /CEM/DOC_ITM_CAT CRM_ITEM_TYPE CHAR 4   0   Item Category  
63 PREC_DOC_GUID /CEM/DOC_GUID SYSUUID RAW 16   0   Transaction GUID  
64 PREC_DOC_LOGSYS /CEM/DOC_LOG_SYS /CEM/LOGSYS CHAR 10   0   Logical System of Transaction  
65 PREC_DOC_NO /CEM/DOC_NO /CEM/DOC_NO CHAR 20   0   Transaction ID  
66 PREC_DOC_BUSOBJ /CEM/DOC_BUSOBJ CRM_OJ_NAME_PROCESS CHAR 10   0   Business Transaction category  
67 PREC_DOC_TYPE /CEM/DOC_PROCESSTYPE CRM_PROCESS_TYPE CHAR 4   0   Business Transaction Type  
68 PREC_ITM_GUID /CEM/ITEM_GUID SYSUUID RAW 16   0   Transaction Item GUID  
69 PREC_ITM_LOGSYS /CEM/ITEM_LOG_SYS /CEM/LOGSYS CHAR 10   0   Item Logical System  
70 PREC_ITM_NO /CEM/DOC_ITM_NUM /CEM/ITEM_NO NUMC 10   0   Transaction Item Number  
71 PREC_ITM_BUSOBJ /CEM/ITM_TRAN_CAT CRM_OJ_NAME_PROCESS_ITEM CHAR 10   0   Item Transaction Category  
72 PREC_ITM_TYPE /CEM/DOC_ITM_CAT CRM_ITEM_TYPE CHAR 4   0   Item Category  
73 VALUE_CURRENCY /CEM/ENT_RATE_CURR WAERS CUKY 5   0   Entitlement Rate Currency  
74 REQ_VALUE /CEM/ENT_RATE WERTV8 CURR 15   2   Entitlement Rate  
75 FULFILLED_VALUE /CEM/ENT_RATE WERTV8 CURR 15   2   Entitlement Rate  
76 CONSUMED_VALUE /CEM/ENT_RATE WERTV8 CURR 15   2   Entitlement Rate  
77 AVAILABLE_VALUE /CEM/ENT_RATE WERTV8 CURR 15   2   Entitlement Rate  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /CEM/V_LRO_UI RO_GUID /CEM/D_LRO_RO RO_GUID KEY 1 1
History
Last changed by/on SAP  20110908 
SAP Release Created in