SAP ABAP View /POSDW/LPA_VEXDT (LPA : View Exception Template Details)
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷
BW-BCT-ISR-LPA (Application Component) Loss Prevention Analytics
⤷
/POSDW/LPA_DATABASE (Package) LPA Data Base Package
BI_CONT (Software Component) Business Intelligence Content⤷
BW-BCT-ISR-LPA (Application Component) Loss Prevention Analytics⤷
/POSDW/LPA_DATABASE (Package) LPA Data Base Package
Basic Data
| View Type | D | Database View |
| Database View | /POSDW/LPA_VEXDT | |
| Short Description | LPA : View Exception Template Details | |
| Root table | /POSDW/LPA_EXDET | LPA : Exception Template Details (Parameters) |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /POSDW/LPA_EXDET |
/POSDW/LPA_EXDET | ||
| 2 | /POSDW/LPA_EXP |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /POSDW/LPA_EXP |
MANDT | JL | EQ | 0 | 0 | ||||
| 2 | /POSDW/LPA_EXDET |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | /POSDW/LPA_EXP |
TMPL_ID | JL | EQ | 0 | 0 | ||||
| 4 | /POSDW/LPA_EXDET |
TMPL_ID | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
/POSDW/LPA_EXP |
MANDT | MANDT | Client | |||
| 2 | TMPL_ID |
/POSDW/LPA_EXP |
TMPL_ID | /POSDW/LPA_TMPL_ID | LPA : Exception Template ID | |||
| 3 | CL_METHOD |
/POSDW/LPA_EXP |
CL_METHOD | /POSDW/LPA_EXPMTH | LPA : Exception Template Implementation Method | |||
| 4 | EXP_CL |
/POSDW/LPA_EXP |
EXP_CL | /POSDW/LPA_EXPCLS | LPA : Exception Template Implementation Class | |||
| 5 | PRF_TYPE |
/POSDW/LPA_EXDET |
PRF_TYPE | /POSDW/PROFILETYPE | Customizing Profile Type | |||
| 6 | PTN_ID |
/POSDW/LPA_EXDET |
PTN_ID | /POSDW/LPA_PTN_ID | LPA : Pattern Identifier | |||
| 7 | STORE_START_TIME |
/POSDW/LPA_EXDET |
STORE_START_TIME | /POSDW/LPA_STORE_STIM | LPA : Store Start Time | |||
| 8 | STORE_END_TIME |
/POSDW/LPA_EXDET |
STORE_END_TIME | /POSDW/LPA_STORE_ETIM | LPA : Store End Time | |||
| 9 | TRAN_TYPE |
/POSDW/LPA_EXDET |
TRAN_TYPE | /POSDW/TRANSACTIONTYPECODE | Transaction Type | |||
| 10 | ORPH_TVAL |
/POSDW/LPA_EXDET |
ORPH_TVAL | /POSDW/LPA_ORPHTVAL | LPA : Orphan Time (min) | |||
| 11 | LATE_MEASURE_VAL |
/POSDW/LPA_EXDET |
LATE_MEASURE_VAL | /POSDW/LPA_LATE_MSVAL | LPA : Measure Value for Exception Templates | |||
| 12 | LATE_MEASURE_TYP |
/POSDW/LPA_EXDET |
LATE_MEASURE_TYP | /POSDW/LPA_LATE_MSTYP | LPA : Late Template Measure Type | |||
| 13 | TENDER_TYPE |
/POSDW/LPA_EXDET |
TENDER_TYPE | /POSDW/TENDERTYPECODE | Means of Payment | |||
| 14 | MAT_NO |
/POSDW/LPA_EXDET |
MAT_NO | /POSDW/MATERIALNUMBER | Material Number | |||
| 15 | BA_MAT_NO |
/POSDW/LPA_EXDET |
BA_MAT_NO | /POSDW/LPA_MATERIALNUMBER1 | LPA : Material Number 1 | |||
| 16 | TRAN_TYPE1 |
/POSDW/LPA_EXDET |
TRAN_TYPE1 | /POSDW/LPA_TRANTYPE1 | LPA : Transaction Type 1 | |||
| 17 | TENDER_TYPE1 |
/POSDW/LPA_EXDET |
TENDER_TYPE1 | /POSDW/LPA_TENDER_TYPE1 | LPA : Means of Payment | |||
| 18 | TENDER_TYPE2 |
/POSDW/LPA_EXDET |
TENDER_TYPE2 | /POSDW/LPA_TENDER_TYPE2 | LPA : Means of Payment | |||
| 19 | TENDER_TYPE3 |
/POSDW/LPA_EXDET |
TENDER_TYPE3 | /POSDW/LPA_TENDER_TYPE3 | LPA : Means of Payment | |||
| 20 | TENDER_TYPE4 |
/POSDW/LPA_EXDET |
TENDER_TYPE4 | /POSDW/LPA_TENDER_TYPE4 | LPA : Means of Payment | |||
| 21 | TENDER_TYPE5 |
/POSDW/LPA_EXDET |
TENDER_TYPE5 | /POSDW/LPA_TENDER_TYPE5 | LPA : Means of Payment | |||
| 22 | TENDER_TYPE6 |
/POSDW/LPA_EXDET |
TENDER_TYPE6 | /POSDW/LPA_TENDER_TYPE6 | LPA : Means of Payment | |||
| 23 | TENDER_TYPE7 |
/POSDW/LPA_EXDET |
TENDER_TYPE7 | /POSDW/LPA_TENDER_TYPE7 | LPA : Means of Payment | |||
| 24 | CUST_TYPE |
/POSDW/LPA_EXDET |
CUST_TYPE | /POSDW/CUSTOMERINFTYPECODE | Type of Customer Information | |||
| 25 | LOOKREF_TYP |
/POSDW/LPA_EXDET |
LOOKREF_TYP | /POSDW/LPA_REFTXN_ID | LPA : Refund Transaction ID | |||
| 26 | BA_COMPARISONREL |
/POSDW/LPA_EXDET |
BA_COMPARISONREL | /POSDW/LPA_BA_CMPREL | LPA : Relationship Between Two Transactions | |||
| 27 | BA_MEASURE_VAL |
/POSDW/LPA_EXDET |
BA_MEASURE_VAL | /POSDW/LPA_BA_MSVAL | LPA : Before/After Template Measure Value | |||
| 28 | BA_MEASURE_TYPE |
/POSDW/LPA_EXDET |
BA_MEASURE_TYPE | /POSDW/LPA_BA_MSTYP | LPA : Before/After Template Measure Type | |||
| 29 | BA_MEASURE_BASIS |
/POSDW/LPA_EXDET |
BA_MEASURE_BASIS | /POSDW/LPA_BA_MSBASIS | LPA : Before/After Template Measure With | |||
| 30 | DSCT_TYP |
/POSDW/LPA_EXDET |
DSCT_TYP | /POSDW/LPA_DISCOUNTTYPECODE | LPA : Discount Type | |||
| 31 | DSCT_TYPVAL |
/POSDW/LPA_EXDET |
DSCT_TYPVAL | /POSDW/LPA_DSCT_TYPVAL | LPA : Discount Value | |||
| 32 | FL_MEASURE_TYP |
/POSDW/LPA_EXDET |
FL_MEASURE_TYP | /POSDW/LPA_FL_MSTYP | LPA : First/Last Hour Template Measure Type | |||
| 33 | FL_MEASURE_VAL |
/POSDW/LPA_EXDET |
FL_MEASURE_VAL | /POSDW/LPA_FL_MSVAL | LPA : First/Last Hour Template Measure Value | |||
| 34 | RANGE_FROM |
/POSDW/LPA_EXDET |
RANGE_FROM | /POSDW/LPA_RNG_FRM | LPA : Cashier ID or Total Ringtime From | |||
| 35 | RANGE_TO |
/POSDW/LPA_EXDET |
RANGE_TO | /POSDW/LPA_RNG_TO | LPA : Cashier ID or Total Ringtime To | |||
| 36 | SKUID_FROM |
/POSDW/LPA_EXDET |
SKUID_FROM | /POSDW/LPA_SKUID_FROM | LPA : SKU ID From | |||
| 37 | SKUID_TO |
/POSDW/LPA_EXDET |
SKUID_TO | /POSDW/LPA_SKUID_TO | LPA : SKU ID To | |||
| 38 | RINGTIME_FROM |
/POSDW/LPA_EXDET |
RINGTIME_FROM | /POSDW/LPA_RNGTIME_FROM | LPA : Total Ringtime From | |||
| 39 | RINGTIME_TO |
/POSDW/LPA_EXDET |
RINGTIME_TO | /POSDW/LPA_RNGTIME_TO | LPA : Total Ringtime To | |||
| 40 | TXNAMOUNT_FROM |
/POSDW/LPA_EXDET |
TXNAMOUNT_FROM | /POSDW/LPA_TXNAMOUNT_FROM | LPA : Transaction Amount From | |||
| 41 | TXNAMOUNT_TO |
/POSDW/LPA_EXDET |
TXNAMOUNT_TO | /POSDW/LPA_TXNAMOUNT_TO | LPA : Transaction Amount To | |||
| 42 | REF_TYPE |
/POSDW/LPA_EXDET |
REF_TYPE | /POSDW/LPA_REF_TYPE | LPA : Refund Type | |||
| 43 | TRANSCURRENCY |
/POSDW/LPA_EXDET |
TRANSCURRENCY | /POSDW/TRANSACTIONCURRENCY | Transaction Currency | |||
| 44 | REL_OPER |
/POSDW/LPA_EXDET |
REL_OPER | /POSDW/LPA_REL_OPER | LPA : Relational Operator | |||
| 45 | REL_OPR1 |
/POSDW/LPA_EXDET |
REL_OPR1 | /POSDW/LPA_RELOPRD | LPA: Relational Operator | |||
| 46 | REL_OPR2 |
/POSDW/LPA_EXDET |
REL_OPR2 | /POSDW/LPA_RELOPRD | LPA: Relational Operator | |||
| 47 | REL_OPR3 |
/POSDW/LPA_EXDET |
REL_OPR3 | /POSDW/LPA_RELOPRD | LPA: Relational Operator | |||
| 48 | REL_OPR4 |
/POSDW/LPA_EXDET |
REL_OPR4 | /POSDW/LPA_RELOPRD | LPA: Relational Operator | |||
| 49 | LOGIC_OPER |
/POSDW/LPA_EXDET |
LOGIC_OPER | /POSDW/LPA_LOG_OPR | LPA : Logical Operator | |||
| 50 | LOG_OPR1 |
/POSDW/LPA_EXDET |
LOG_OPR1 | /POSDW/LPA_LOG_OPR | LPA : Logical Operator | |||
| 51 | LOG_OPR2 |
/POSDW/LPA_EXDET |
LOG_OPR2 | /POSDW/LPA_LOG_OPR | LPA : Logical Operator | |||
| 52 | LOG_OPR3 |
/POSDW/LPA_EXDET |
LOG_OPR3 | /POSDW/LPA_LOG_OPR | LPA : Logical Operator | |||
| 53 | ITM_CNT |
/POSDW/LPA_EXDET |
ITM_CNT | /POSDW/LPA_ITMCNT | LPA : Item Count | |||
| 54 | ITM_MSTYP |
/POSDW/LPA_EXDET |
ITM_MSTYP | /POSDW/LPA_ITM_MSTYP | LPA : Item Scan Rate Template Measure Type | |||
| 55 | TI_MSTYP |
/POSDW/LPA_EXDET |
TI_MSTYP | /POSDW/LPA_TI_MSTYP | LPA : Tender Information Template Measure Type | |||
| 56 | TI_MSVAL |
/POSDW/LPA_EXDET |
TI_MSVAL | /POSDW/LPA_TI_MSVAL | LPA : Tender Information Template Measure Value | |||
| 57 | SMCARD_MS |
/POSDW/LPA_EXDET |
SMCARD_MS | /POSDW/LPA_SMCRD_MS | LPA : Same Card Used Template Measure Type | |||
| 58 | SMCARD_MSVAL |
/POSDW/LPA_EXDET |
SMCARD_MSVAL | /POSDW/LPA_SMCRD_MSVAL | LPA : Same Card Used Template Measure Value | |||
| 59 | SPLORD_MS |
/POSDW/LPA_EXDET |
SPLORD_MS | /POSDW/LPA_SPLORDMS | LPA : Transaction Header Template Measure Value | |||
| 60 | TXN_INSUFFINFO |
/POSDW/LPA_EXDET |
TXN_INSUFFINFO | /POSDW/LPA_TXN_INSUFFINFO | LPA : Insufficient Information Template Measure Type | |||
| 61 | ITM_ATTR |
/POSDW/LPA_EXDET |
ITM_ATTR | /POSDW/LPA_ITM_ATTR | LPA : Item Attribute | |||
| 62 | ITM_ATRVAL |
/POSDW/LPA_EXDET |
ITM_ATRVAL | /POSDW/LPA_IT_AVAL | LPA : Item Attribute Value | |||
| 63 | ITM_ATTR1 |
/POSDW/LPA_EXDET |
ITM_ATTR1 | /POSDW/LPA_ITM_ATTR1 | LPA : Item Attribute 1 | |||
| 64 | ITM_ATRVAL1 |
/POSDW/LPA_EXDET |
ITM_ATRVAL1 | /POSDW/LPA_IT_AVAL1 | LPA : Item Attribute Value 1 | |||
| 65 | ORD_ATTR |
/POSDW/LPA_EXDET |
ORD_ATTR | /POSDW/LPA_ORD_ATTR | LPA : Order Attribute | |||
| 66 | ORD_ATRVAL |
/POSDW/LPA_EXDET |
ORD_ATRVAL | /POSDW/LPA_ORD_AVAL | LPA : Order Attribute Value | |||
| 67 | ORD_ATTR1 |
/POSDW/LPA_EXDET |
ORD_ATTR1 | /POSDW/LPA_ORD_ATTR1 | LPA : Order Attribute 1 | |||
| 68 | ORD_ATRVAL1 |
/POSDW/LPA_EXDET |
ORD_ATRVAL1 | /POSDW/LPA_ORD_AVAL1 | LPA : Order Attribute Value 1 | |||
| 69 | ITMATR_MSTYP |
/POSDW/LPA_EXDET |
ITMATR_MSTYP | /POSDW/LPA_ITATMTYP | LPA :Transaction Line Item Template Measure Type | |||
| 70 | ITMATR_MSVAL |
/POSDW/LPA_EXDET |
ITMATR_MSVAL | /POSDW/LPA_ITATMVAL | LPA: Transaction Line Item Template Measure Value | |||
| 71 | SPLSKU_MSTYP |
/POSDW/LPA_EXDET |
SPLSKU_MSTYP | /POSDW/LPA_SKUMSTYP | LPA : SKU Matching Amount Template Measure Type | |||
| 72 | REASONCODE |
/POSDW/LPA_EXDET |
REASONCODE | /POSDW/REASONCODE | Reason | |||
| 73 | RETAILTYPECODE |
/POSDW/LPA_EXDET |
RETAILTYPECODE | /POSDW/RETAILTYPECODE | Sales Item Type | |||
| 74 | SPLSKU_MSVAL |
/POSDW/LPA_EXDET |
SPLSKU_MSVAL | /POSDW/LPA_SKUMSVAL | LPA : SKU Matching Amount Template Measure Value | |||
| 75 | LOG_OPR_LTD |
/POSDW/LPA_EXDET |
LOG_OPR_LTD | /POSDW/LPA_LOG_OPR_LTD | LPA: Logical Operator Limited Values | |||
| 76 | LOG_OPR1_LTD |
/POSDW/LPA_EXDET |
LOG_OPR1_LTD | /POSDW/LPA_LOG_OPR_LTD | LPA: Logical Operator Limited Values | |||
| 77 | LOG_OPR2_LTD |
/POSDW/LPA_EXDET |
LOG_OPR2_LTD | /POSDW/LPA_LOG_OPR_LTD | LPA: Logical Operator Limited Values | |||
| 78 | LOG_OPR3_LTD |
/POSDW/LPA_EXDET |
LOG_OPR3_LTD | /POSDW/LPA_LOG_OPR_LTD | LPA: Logical Operator Limited Values | |||
| 79 | DISC_TYPE_GRP1 |
/POSDW/LPA_EXDET |
DISC_TYPE_GRP1 | /POSDW/LPA_DISC_TYPE_GROUP1 | LPA: Discount Type Group 1 | |||
| 80 | DISC_TYPE_GRP2 |
/POSDW/LPA_EXDET |
DISC_TYPE_GRP2 | /POSDW/LPA_DISC_TYPE_GROUP2 | LPA: Discount Type Group 2 | |||
| 81 | TENDER_TYPE_GRP1 |
/POSDW/LPA_EXDET |
TENDER_TYPE_GRP1 | /POSDW/LPA_TENDER_TYPE_GROUP1 | LPA: Tender Type Group 1 | |||
| 82 | TENDER_TYPE_GRP2 |
/POSDW/LPA_EXDET |
TENDER_TYPE_GRP2 | /POSDW/LPA_TENDER_TYPE_GROUP2 | LPA: Tender Type Group 2 | |||
| 83 | TRAN_TYPE_GRP1 |
/POSDW/LPA_EXDET |
TRAN_TYPE_GRP1 | /POSDW/LPA_TRAN_TYPE_GROUP1 | LPA: Transaction Type Group 1 | |||
| 84 | TRAN_TYPE_GRP2 |
/POSDW/LPA_EXDET |
TRAN_TYPE_GRP2 | /POSDW/LPA_TRAN_TYPE_GROUP2 | LPA: Transaction Type Group 2 | |||
| 85 | PTN_STATUS |
/POSDW/LPA_EXDET |
PTN_STATUS | /POSDW/LPA_PTNSTAT | LPA : Pattern Status | |||
| 86 | TASKCODE |
/POSDW/LPA_EXDET |
TASKCODE | /POSDW/TASKCODE | Task Code | |||
| 87 | CREATED_ON |
/POSDW/LPA_EXDET |
CREATED_ON | /POSDW/LPA_CRD_ON | LPA : Template/Pattern Created On Date | |||
| 88 | CHANGED_ON |
/POSDW/LPA_EXDET |
CHANGED_ON | /POSDW/LPA_CHD_ON | LPA : Template/Pattern Changed Date | |||
| 89 | AUTHOR |
/POSDW/LPA_EXDET |
AUTHOR | SYUNAME | User Name | |||
| 90 | CHANGEDBY |
/POSDW/LPA_EXDET |
CHANGEDBY | SYUNAME | User Name | |||
| 91 | SRT_TIMVAL |
/POSDW/LPA_EXDET |
SRT_TIMVAL | /POSDW/LPA_SRT_TIMVAL | LPA: Scan Rate Template Time value | |||
| 92 | SRT_MERCHG |
/POSDW/LPA_EXDET |
SRT_MERCHG | /POSDW/LPA_SRT_MERCHG | LPA:Scan Rate Template Merchandise Group | |||
| 93 | SRT_EXMERCHG |
/POSDW/LPA_EXDET |
SRT_EXMERCHG | /POSDW/LPA_SRT_EXMERCHG | LPA: Scan Rate Template Exclude Merchandise Groups | |||
| 94 | SRT_MANUAL |
/POSDW/LPA_EXDET |
SRT_MANUAL | /POSDW/LPA_SRT_MANUAL | LPA: Scan Rate Template Manual Entries Indicator | |||
| 95 | SRT_MSVAL |
/POSDW/LPA_EXDET |
SRT_MSVAL | /POSDW/LPA_SRT_MSVAL | LPA: Scan Rate Template Item count | |||
| 96 | SRT_MERCHGCOLL |
/POSDW/LPA_EXDET |
SRT_MERCHGCOLL | /POSDW/LPA_MERCHGCOLL | LPA: Merchandise Group Collection | |||
| 97 | REF_WO_TENDER |
/POSDW/LPA_EXDET |
REF_WO_TENDER | /POSDW/LPA_REF_TENDER | LPA: Indicator for Diff. Tender Types in Refund /Sales | |||
| 98 | REF_WO_TENDTY |
/POSDW/LPA_EXDET |
REF_WO_TENDTY | /POSDW/LPA_REF_TENDTY | LPA: Indicator for Different Credit Cards in Refund /Sales | |||
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 | 20111123 |
| SAP Release Created in | 705 |
