SAP ABAP View /CEM/V_LRO_RO_HR (To combine LRO and RO based on LRO_GUID)
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_LRO_RO_HR  
Short Description To combine LRO and RO based on LRO_GUID    
Root table /CEM/D_H_LRO   Entitlement Manager: Lock Request Objects 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 /CEM/D_H_LRO /CEM/D_H_LRO
2 /CEM/D_LRO_RO  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 /CEM/D_H_LRO CLIENT JL EQ 0 0
2 /CEM/D_LRO_RO CLIENT JR EQ AND 0 0
3 /CEM/D_H_LRO LRO_GUID JL EQ 0 0
4 /CEM/D_LRO_RO RO_GUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT /CEM/D_H_LRO CLIENT   MANDT Client
2 LRO_GUID /CEM/D_H_LRO LRO_GUID   /CEM/LRO_GUID Lock Request Object GUID
3 RO_GUID /CEM/D_LRO_RO RO_GUID   /CEM/RO_GUID Reference Object GUID
4 TRANS_DOC_GUID /CEM/D_LRO_RO TRANS_DOC_GUID   /CEM/DOC_GUID Transaction GUID
5 TRANS_DOC_NO /CEM/D_LRO_RO TRANS_DOC_NO   /CEM/DOC_NO Transaction ID
6 TRANS_DOC_BUSOBJ /CEM/D_LRO_RO TRANS_DOC_BUSOBJ   /CEM/DOC_BUSOBJ Business Transaction category
7 TRANS_ITM_GUID /CEM/D_LRO_RO TRANS_ITM_GUID   /CEM/ITEM_GUID Transaction Item GUID
8 TRANS_ITM_NO /CEM/D_LRO_RO TRANS_ITM_NO   /CEM/DOC_ITM_NUM Transaction Item Number
9 TRANS_ITM_BUSOBJ /CEM/D_LRO_RO TRANS_ITM_BUSOBJ   /CEM/ITM_TRAN_CAT Item Transaction Category
10 TRANS_DOC_LOGSYS /CEM/D_LRO_RO TRANS_DOC_LOGSYS   /CEM/DOC_LOG_SYS Logical System of Transaction
11 TRANS_DOC_TYPE /CEM/D_LRO_RO TRANS_DOC_TYPE   /CEM/DOC_PROCESSTYPE Business Transaction Type
12 TRANS_ITM_LOGSYS /CEM/D_LRO_RO TRANS_ITM_LOGSYS   /CEM/ITEM_LOG_SYS Item Logical System
13 TRANS_ITM_TYPE /CEM/D_LRO_RO TRANS_ITM_TYPE   /CEM/DOC_ITM_CAT Item Category
14 APPLICATION /CEM/D_H_LRO APPLICATION   /CEM/LRO_TYPE Program Type (Deposit/Returns Entitlement)
                 
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 500