SAP ABAP View /CEM/V_LRO_UI (Lock Request header and document info, for UI result list)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-EM (Application Component) CRM Entitlement Management
⤷
/CEM/ENT_REPOSITORY (Package) Entitlements Repository
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_UI | |
| Short Description | Lock Request header and document info, for UI result list | |
| 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_LRO_RO |
CLIENT | JL | EQ | 0 | 0 | ||||
| 2 | /CEM/D_H_LRO |
CLIENT | JR | EQ | AND | 0 | 0 | |||
| 3 | /CEM/D_LRO_RO |
RO_GUID | JL | EQ | 0 | 0 | ||||
| 4 | /CEM/D_H_LRO |
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 | APPLICATION |
/CEM/D_H_LRO |
APPLICATION | /CEM/LRO_TYPE | Program Type (Deposit/Returns Entitlement) | |||
| 4 | H_PART_ID |
/CEM/D_H_LRO |
H_PART_ID | /CEM/PARTNER_ID | Partner ID | |||
| 5 | H_PART_GUID |
/CEM/D_H_LRO |
H_PART_GUID | /CEM/GUID | GUID | |||
| 6 | H_PART_LOGSYS |
/CEM/D_H_LRO |
H_PART_LOGSYS | /CEM/LOGSYS | Logical System | |||
| 7 | H_PROD_ID |
/CEM/D_H_LRO |
H_PROD_ID | /CEM/PRODUCT_ID | Product ID | |||
| 8 | H_PROD_GUID |
/CEM/D_H_LRO |
H_PROD_GUID | /CEM/GUID | GUID | |||
| 9 | H_PROD_CAT |
/CEM/D_H_LRO |
H_PROD_CAT | /CEM/PRODUCT_CATEGORY | Product Category | |||
| 10 | H_PROD_LOGSYS |
/CEM/D_H_LRO |
H_PROD_LOGSYS | /CEM/LOGSYS | Logical System | |||
| 11 | A_PROD_ID |
/CEM/D_H_LRO |
A_PROD_ID | /CEM/PRODUCT_ID | Product ID | |||
| 12 | A_PROD_GUID |
/CEM/D_H_LRO |
A_PROD_GUID | /CEM/GUID | GUID | |||
| 13 | A_PROD_CAT |
/CEM/D_H_LRO |
A_PROD_CAT | /CEM/PRODUCT_CATEGORY | Product Category | |||
| 14 | A_PROD_LOGSYS |
/CEM/D_H_LRO |
A_PROD_LOGSYS | /CEM/LOGSYS | Logical System | |||
| 15 | REQ_QTY |
/CEM/D_H_LRO |
REQ_QTY | /CEM/REQ_QTY | Requested Quantity | |||
| 16 | REQ_QTY_UOM |
/CEM/D_H_LRO |
REQ_QTY_UOM | /CEM/REQ_QTY_UOM | Requested Quantity UOM | |||
| 17 | REQ_PROD_ID |
/CEM/D_H_LRO |
REQ_PROD_ID | /CEM/REQ_PROD_ID | Requested Product ID | |||
| 18 | REQ_PROD_GUID |
/CEM/D_H_LRO |
REQ_PROD_GUID | /CEM/REQ_PROD_GUID | Requested Product GUID | |||
| 19 | REQ_PROD_LOGSYS |
/CEM/D_H_LRO |
REQ_PROD_LOGSYS | /CEM/REQ_PROD_LOGSYS | Requested Product Logical System | |||
| 20 | ENT_STRATEGY |
/CEM/D_H_LRO |
ENT_STRATEGY | /CEM/ENT_STRATEGY | Entitlement Program Scheme | |||
| 21 | REF_STRATEGY |
/CEM/D_H_LRO |
REF_STRATEGY | /CEM/COREBANK_DPP | Deposit Credit/Direct Purchase Program indicator | |||
| 22 | REF_STRATEGY_IND |
/CEM/D_H_LRO |
REF_STRATEGY_IND | /CEM/REFUND_STRATEGY_IND | Refund Strategy Indicator | |||
| 23 | PROD_BASEUOM |
/CEM/D_H_LRO |
PROD_BASEUOM | /CEM/REQUESTED_QTY_BASE_UOM | Requested quantity base UoM for Lock Request Object | |||
| 24 | PROD_BASEUOM_QTY |
/CEM/D_H_LRO |
PROD_BASEUOM_QTY | /CEM/REQUESTED_QUANTITY_BASE | Requested base quantity for a Lock Request Object | |||
| 25 | FULFILLED_QTY |
/CEM/D_H_LRO |
FULFILLED_QTY | /CEM/FULFILLED_QUANTITY | Fulfilled quantity for a Lock Request Object | |||
| 26 | AVAILABLE_QTY |
/CEM/D_H_LRO |
AVAILABLE_QTY | /CEM/AVAILABLE_QUANTITY | Available Quantity of a Lock Request Object | |||
| 27 | CONSUMED_QTY |
/CEM/D_H_LRO |
CONSUMED_QTY | /CEM/CONSUMED_QUANTITY | Consumed Quantity of a Lock Request Object | |||
| 28 | REFUND_QTY |
/CEM/D_H_LRO |
REFUND_QTY | /CEM/REFUND_QUANTITY | Refund Quantity of a Lock Request Object | |||
| 29 | LRO_STATUS |
/CEM/D_H_LRO |
LRO_STATUS | /CEM/LOCK_REQUEST_STATUS | Status of a Lock Request Object | |||
| 30 | TRANS_STATUS |
/CEM/D_H_LRO |
TRANS_STATUS | /CEM/TRANS_ITEM_STATUS | Reference Object item status | |||
| 31 | IS_MERGED |
/CEM/D_H_LRO |
IS_MERGED | /CEM/LOCK_REQUEST_MERGED | Indicator: Lock Request Object is merged | |||
| 32 | MERGED_LRO_GUID |
/CEM/D_H_LRO |
MERGED_LRO_GUID | /CEM/LRO_GUID | Lock Request Object GUID | |||
| 33 | LRO_TOP_NODE |
/CEM/D_H_LRO |
LRO_TOP_NODE | /CEM/LRO_TOP_NODE | Lock Request is top node of hierarchy | |||
| 34 | ARCHIVE_FLAG |
/CEM/D_H_LRO |
ARCHIVE_FLAG | /CEM/ARCHIVE_FLAG | Archive flag | |||
| 35 | SEARCH_SCENARIO |
/CEM/D_H_LRO |
SEARCH_SCENARIO | /CEM/ED_SEARCH_SCENARIO | Search Scenario | |||
| 36 | SEARCH_REQ |
/CEM/D_H_LRO |
SEARCH_REQ | /CEM/SEARCH | Search Deposit Entitlements | |||
| 37 | RO_GUID |
/CEM/D_H_LRO |
RO_GUID | /CEM/RO_GUID | Reference Object GUID | |||
| 38 | LOGHANDLE |
/CEM/D_H_LRO |
LOGHANDLE | /CEM/LOGHANDLE | Log handle | |||
| 39 | DOC_CURRENCY |
/CEM/D_H_LRO |
DOC_CURRENCY | /CEM/ENT_RATE_CURR | Entitlement Rate Currency | |||
| 40 | LOCAL_CURRENCY |
/CEM/D_H_LRO |
LOCAL_CURRENCY | /CEM/ENT_RATE_CURR | Entitlement Rate Currency | |||
| 41 | DOC_DATE |
/CEM/D_H_LRO |
DOC_DATE | /CEM/DATE | Date | |||
| 42 | EXCHANGE_TYPE |
/CEM/D_H_LRO |
EXCHANGE_TYPE | /CEM/EXCHANGE_TYPE | Exchange Rate Type | |||
| 43 | SALES_ORG |
/CEM/D_H_LRO |
SALES_ORG | /CEM/SALES_ORG | Sales Organization | |||
| 44 | CHANNEL |
/CEM/D_H_LRO |
CHANNEL | /CEM/DISTRIBUTION_CHANNEL | Distribution Channel | |||
| 45 | DIVISION |
/CEM/D_H_LRO |
DIVISION | /CEM/DIVISION | Division | |||
| 46 | BILL_ORG |
/CEM/D_H_LRO |
BILL_ORG | BEA_BILL_ORG | Billing Unit | |||
| 47 | CREATED_BY |
/CEM/D_H_LRO |
CREATED_BY | /CEM/CREATED_BY | Created By | |||
| 48 | CREATED_DATE |
/CEM/D_H_LRO |
CREATED_DATE | /CEM/CREATED_DATE | Creation Date | |||
| 49 | CREATED_TIME |
/CEM/D_H_LRO |
CREATED_TIME | /CEM/CREATED_TIME | Creation Time | |||
| 50 | CHANGED_BY |
/CEM/D_H_LRO |
CHANGED_BY | /CEM/CHANGED_BY | Changed By | |||
| 51 | CHANGED_DATE |
/CEM/D_H_LRO |
CHANGED_DATE | /CEM/CHANGED_DATE | Changed On | |||
| 52 | CHANGED_TIME |
/CEM/D_H_LRO |
CHANGED_TIME | /CEM/CHANGED_TIME | Change Time | |||
| 53 | TRANS_DOC_GUID |
/CEM/D_LRO_RO |
TRANS_DOC_GUID | /CEM/DOC_GUID | Transaction GUID | |||
| 54 | TRANS_DOC_NO |
/CEM/D_LRO_RO |
TRANS_DOC_NO | /CEM/DOC_NO | Transaction ID | |||
| 55 | TRANS_DOC_BUSOBJ |
/CEM/D_LRO_RO |
TRANS_DOC_BUSOBJ | /CEM/DOC_BUSOBJ | Business Transaction category | |||
| 56 | TRANS_ITM_GUID |
/CEM/D_LRO_RO |
TRANS_ITM_GUID | /CEM/ITEM_GUID | Transaction Item GUID | |||
| 57 | TRANS_ITM_NO |
/CEM/D_LRO_RO |
TRANS_ITM_NO | /CEM/DOC_ITM_NUM | Transaction Item Number | |||
| 58 | TRANS_ITM_BUSOBJ |
/CEM/D_LRO_RO |
TRANS_ITM_BUSOBJ | /CEM/ITM_TRAN_CAT | Item Transaction Category | |||
| 59 | TRANS_DOC_LOGSYS |
/CEM/D_LRO_RO |
TRANS_DOC_LOGSYS | /CEM/DOC_LOG_SYS | Logical System of Transaction | |||
| 60 | TRANS_DOC_TYPE |
/CEM/D_LRO_RO |
TRANS_DOC_TYPE | /CEM/DOC_PROCESSTYPE | Business Transaction Type | |||
| 61 | TRANS_ITM_LOGSYS |
/CEM/D_LRO_RO |
TRANS_ITM_LOGSYS | /CEM/ITEM_LOG_SYS | Item Logical System | |||
| 62 | TRANS_ITM_TYPE |
/CEM/D_LRO_RO |
TRANS_ITM_TYPE | /CEM/DOC_ITM_CAT | Item Category | |||
| 63 | PREC_DOC_GUID |
/CEM/D_LRO_RO |
PREC_DOC_GUID | /CEM/DOC_GUID | Transaction GUID | |||
| 64 | PREC_DOC_LOGSYS |
/CEM/D_LRO_RO |
PREC_DOC_LOGSYS | /CEM/DOC_LOG_SYS | Logical System of Transaction | |||
| 65 | PREC_DOC_NO |
/CEM/D_LRO_RO |
PREC_DOC_NO | /CEM/DOC_NO | Transaction ID | |||
| 66 | PREC_DOC_BUSOBJ |
/CEM/D_LRO_RO |
PREC_DOC_BUSOBJ | /CEM/DOC_BUSOBJ | Business Transaction category | |||
| 67 | PREC_DOC_TYPE |
/CEM/D_LRO_RO |
PREC_DOC_TYPE | /CEM/DOC_PROCESSTYPE | Business Transaction Type | |||
| 68 | PREC_ITM_GUID |
/CEM/D_LRO_RO |
PREC_ITM_GUID | /CEM/ITEM_GUID | Transaction Item GUID | |||
| 69 | PREC_ITM_LOGSYS |
/CEM/D_LRO_RO |
PREC_ITM_LOGSYS | /CEM/ITEM_LOG_SYS | Item Logical System | |||
| 70 | PREC_ITM_NO |
/CEM/D_LRO_RO |
PREC_ITM_NO | /CEM/DOC_ITM_NUM | Transaction Item Number | |||
| 71 | PREC_ITM_BUSOBJ |
/CEM/D_LRO_RO |
PREC_ITM_BUSOBJ | /CEM/ITM_TRAN_CAT | Item Transaction Category | |||
| 72 | PREC_ITM_TYPE |
/CEM/D_LRO_RO |
PREC_ITM_TYPE | /CEM/DOC_ITM_CAT | Item Category | |||
| 73 | VALUE_CURRENCY |
/CEM/D_H_LRO |
VALUE_CURRENCY | /CEM/ENT_RATE_CURR | Entitlement Rate Currency | |||
| 74 | REQ_VALUE |
/CEM/D_H_LRO |
REQ_VALUE | /CEM/ENT_RATE | Entitlement Rate | |||
| 75 | FULFILLED_VALUE |
/CEM/D_H_LRO |
FULFILLED_VALUE | /CEM/ENT_RATE | Entitlement Rate | |||
| 76 | CONSUMED_VALUE |
/CEM/D_H_LRO |
CONSUMED_VALUE | /CEM/ENT_RATE | Entitlement Rate | |||
| 77 | AVAILABLE_VALUE |
/CEM/D_H_LRO |
AVAILABLE_VALUE | /CEM/ENT_RATE | Entitlement Rate | |||
Maintenance Status
| 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 |
