SAP ABAP Table /POSDW/LPA_EXDET (LPA : Exception Template Details (Parameters))
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
Basic Data
Table Category TRANSP    Transparent table 
Transparent table /POSDW/LPA_EXDET   Table Relationship Diagram
Short Description LPA : Exception Template Details (Parameters)    
Delivery and Maintenance
Pool/cluster      
Delivery Class E   Control table, SAP and customer have separate key areas 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 PRF_TYPE /POSDW/PROFILETYPE /POSDW/PROFILETYPE CHAR 4   0   Customizing Profile Type /POSDW/PROF
3 PTN_ID /POSDW/LPA_PTN_ID /POSDW/CHAR10ALPHA CHAR 10   0   LPA : Pattern Identifier  
4 TMPL_ID /POSDW/LPA_TMPL_ID /POSDW/LPA_TMPL_ID CHAR 10   0   LPA : Exception Template ID /POSDW/LPA_EXP
5 STORE_START_TIME /POSDW/LPA_STORE_STIM TIME TIMS 6   0   LPA : Store Start Time  
6 STORE_END_TIME /POSDW/LPA_STORE_ETIM TIME TIMS 6   0   LPA : Store End Time  
7 TRAN_TYPE /POSDW/TRANSACTIONTYPECODE /POSDW/TRANSACTIONTYPECODE CHAR 4   0   Transaction Type /POSDW/TRANTY
8 ORPH_TVAL /POSDW/LPA_ORPHTVAL /POSDW/TRANSINDEX INT4 10   0   LPA : Orphan Time (min)  
9 LATE_MEASURE_VAL /POSDW/LPA_LATE_MSVAL /POSDW/TRANSINDEX INT4 10   0   LPA : Measure Value for Exception Templates  
10 LATE_MEASURE_TYP /POSDW/LPA_LATE_MSTYP /POSDW/LPA_LATE_MSTYP CHAR 3   0   LPA : Late Template Measure Type  
11 TENDER_TYPE /POSDW/TENDERTYPECODE /POSDW/TENDERTYPECODE CHAR 4   0   Means of Payment /POSDW/TENDTY
12 MAT_NO /POSDW/MATERIALNUMBER MATNR CHAR 18   0   Material Number  
13 BA_MAT_NO /POSDW/LPA_MATERIALNUMBER1 MATNR CHAR 18   0   LPA : Material Number 1  
14 TRAN_TYPE1 /POSDW/LPA_TRANTYPE1 /POSDW/TRANSACTIONTYPECODE CHAR 4   0   LPA : Transaction Type 1 /POSDW/TRANTY
15 TENDER_TYPE1 /POSDW/LPA_TENDER_TYPE1 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
16 TENDER_TYPE2 /POSDW/LPA_TENDER_TYPE2 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
17 TENDER_TYPE3 /POSDW/LPA_TENDER_TYPE3 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
18 TENDER_TYPE4 /POSDW/LPA_TENDER_TYPE4 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
19 TENDER_TYPE5 /POSDW/LPA_TENDER_TYPE5 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
20 TENDER_TYPE6 /POSDW/LPA_TENDER_TYPE6 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
21 TENDER_TYPE7 /POSDW/LPA_TENDER_TYPE7 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
22 CUST_TYPE /POSDW/CUSTOMERINFTYPECODE /POSDW/TYPECODE CHAR 4   0   Type of Customer Information  
23 LOOKREF_TYP /POSDW/LPA_REFTXN_ID /POSDW/LPA_LKUPREF CHAR 1   0   LPA : Refund Transaction ID  
24 BA_COMPARISONREL /POSDW/LPA_BA_CMPREL /POSDW/LPA_BA_CMPREL CHAR 2   0   LPA : Relationship Between Two Transactions  
25 BA_MEASURE_VAL /POSDW/LPA_BA_MSVAL /POSDW/TRANSINDEX INT4 10   0   LPA : Before/After Template Measure Value  
26 BA_MEASURE_TYPE /POSDW/LPA_BA_MSTYP /POSDW/LPA_BA_MSTYP CHAR 4   0   LPA : Before/After Template Measure Type  
27 BA_MEASURE_BASIS /POSDW/LPA_BA_MSBASIS /POSDW/LPA_BA_MSBASIS CHAR 3   0   LPA : Before/After Template Measure With  
28 DSCT_TYP /POSDW/LPA_DISCOUNTTYPECODE /POSDW/LPA_DISCOUNTTYPECODE CHAR 10   0   LPA : Discount Type  
29 DSCT_TYPVAL /POSDW/LPA_DSCT_TYPVAL /POSDW/CURRENCY CURR 15   2   LPA : Discount Value  
30 FL_MEASURE_TYP /POSDW/LPA_FL_MSTYP /POSDW/LPA_FL_MSTYP CHAR 6   0   LPA : First/Last Hour Template Measure Type  
31 FL_MEASURE_VAL /POSDW/LPA_FL_MSVAL /POSDW/TRANSINDEX INT4 10   0   LPA : First/Last Hour Template Measure Value  
32 RANGE_FROM /POSDW/LPA_RNG_FRM /POSDW/CHAR30ALPHA CHAR 30   0   LPA : Cashier ID or Total Ringtime From  
33 RANGE_TO /POSDW/LPA_RNG_TO /POSDW/CHAR30ALPHA CHAR 30   0   LPA : Cashier ID or Total Ringtime To  
34 RINGTIME_FROM /POSDW/LPA_RNGTIME_FROM /POSDW/TRANSINDEX INT4 10   0   LPA : Total Ringtime From  
35 RINGTIME_TO /POSDW/LPA_RNGTIME_TO /POSDW/TRANSINDEX INT4 10   0   LPA : Total Ringtime To  
36 SKUID_FROM /POSDW/LPA_SKUID_FROM MATNR CHAR 18   0   LPA : SKU ID From  
37 SKUID_TO /POSDW/LPA_SKUID_TO MATNR CHAR 18   0   LPA : SKU ID To  
38 TXNAMOUNT_FROM /POSDW/LPA_TXNAMOUNT_FROM /POSDW/CURRENCY CURR 15   2   LPA : Transaction Amount From  
39 TXNAMOUNT_TO /POSDW/LPA_TXNAMOUNT_TO /POSDW/CURRENCY CURR 15   2   LPA : Transaction Amount To  
40 REF_TYPE /POSDW/LPA_REF_TYPE /POSDW/LPA_REF_TYPE CHAR 5   0   LPA : Refund Type  
41 TRANSCURRENCY /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
42 REL_OPER /POSDW/LPA_REL_OPER /POSDW/LPA_REL_OPER CHAR 3   0   LPA : Relational Operator  
43 REL_OPR1 /POSDW/LPA_RELOPRD /POSDW/LPA_RELOPRD CHAR 3   0   LPA: Relational Operator  
44 REL_OPR2 /POSDW/LPA_RELOPRD /POSDW/LPA_RELOPRD CHAR 3   0   LPA: Relational Operator  
45 REL_OPR3 /POSDW/LPA_RELOPRD /POSDW/LPA_RELOPRD CHAR 3   0   LPA: Relational Operator  
46 REL_OPR4 /POSDW/LPA_RELOPRD /POSDW/LPA_RELOPRD CHAR 3   0   LPA: Relational Operator  
47 LOGIC_OPER /POSDW/LPA_LOG_OPR /POSDW/LPA_LOG_OPR CHAR 3   0   LPA : Logical Operator  
48 LOG_OPR1 /POSDW/LPA_LOG_OPR /POSDW/LPA_LOG_OPR CHAR 3   0   LPA : Logical Operator  
49 LOG_OPR2 /POSDW/LPA_LOG_OPR /POSDW/LPA_LOG_OPR CHAR 3   0   LPA : Logical Operator  
50 LOG_OPR3 /POSDW/LPA_LOG_OPR /POSDW/LPA_LOG_OPR CHAR 3   0   LPA : Logical Operator  
51 ITM_CNT /POSDW/LPA_ITMCNT /POSDW/LPA_ITMCNT NUMC 10   0   LPA : Item Count  
52 ITM_MSTYP /POSDW/LPA_ITM_MSTYP /POSDW/LPA_ITM_MSTYP CHAR 20   0   LPA : Item Scan Rate Template Measure Type  
53 TI_MSTYP /POSDW/LPA_TI_MSTYP /POSDW/LPA_TI_MSTYP CHAR 6   0   LPA : Tender Information Template Measure Type  
54 TI_MSVAL /POSDW/LPA_TI_MSVAL /POSDW/LPA_TI_MSVAL CHAR 25   0   LPA : Tender Information Template Measure Value  
55 SMCARD_MS /POSDW/LPA_SMCRD_MS /POSDW/LPA_SMCRD_MS CHAR 4   0   LPA : Same Card Used Template Measure Type  
56 SMCARD_MSVAL /POSDW/LPA_SMCRD_MSVAL /POSDW/TRANSINDEX INT4 10   0   LPA : Same Card Used Template Measure Value  
57 SPLORD_MS /POSDW/LPA_SPLORDMS /POSDW/LPA_SPLORDMS CHAR 5   0   LPA : Transaction Header Template Measure Value  
58 TXN_INSUFFINFO /POSDW/LPA_TXN_INSUFFINFO /POSDW/LPA_WOINSUFF CHAR 6   0   LPA : Insufficient Information Template Measure Type  
59 ITM_ATTR /POSDW/LPA_ITM_ATTR /POSDW/LPA_ITM_ATTR CHAR 10   0   LPA : Item Attribute  
60 ITM_ATRVAL /POSDW/LPA_IT_AVAL /POSDW/CHAR10ALPHA CHAR 10   0   LPA : Item Attribute Value  
61 ITM_ATTR1 /POSDW/LPA_ITM_ATTR1 /POSDW/LPA_ITM_ATTR CHAR 10   0   LPA : Item Attribute 1  
62 ITM_ATRVAL1 /POSDW/LPA_IT_AVAL1 /POSDW/CHAR10ALPHA CHAR 10   0   LPA : Item Attribute Value 1  
63 ORD_ATTR /POSDW/LPA_ORD_ATTR /POSDW/LPA_ORD_ATTR CHAR 10   0   LPA : Order Attribute *
64 ORD_ATRVAL /POSDW/LPA_ORD_AVAL /POSDW/CHAR10ALPHA CHAR 10   0   LPA : Order Attribute Value  
65 ORD_ATTR1 /POSDW/LPA_ORD_ATTR1 /POSDW/LPA_ORD_ATTR CHAR 10   0   LPA : Order Attribute 1 *
66 ORD_ATRVAL1 /POSDW/LPA_ORD_AVAL1 /POSDW/CHAR10ALPHA CHAR 10   0   LPA : Order Attribute Value 1  
67 ITMATR_MSTYP /POSDW/LPA_ITATMTYP /POSDW/LPA_ITATMTYP CHAR 6   0   LPA :Transaction Line Item Template Measure Type  
68 ITMATR_MSVAL /POSDW/LPA_ITATMVAL /POSDW/CURRENCY CURR 15   2   LPA: Transaction Line Item Template Measure Value  
69 SPLSKU_MSTYP /POSDW/LPA_SKUMSTYP /POSDW/LPA_SKUMSTYP CHAR 6   0   LPA : SKU Matching Amount Template Measure Type  
70 REASONCODE /POSDW/REASONCODE /POSDW/REASONCODE CHAR 4   0   Reason /POSDW/REASON
71 RETAILTYPECODE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type /POSDW/RETTY
72 SPLSKU_MSVAL /POSDW/LPA_SKUMSVAL /POSDW/CURRENCY CURR 15   2   LPA : SKU Matching Amount Template Measure Value  
73 LOG_OPR_LTD /POSDW/LPA_LOG_OPR_LTD /POSDW/LPA_LOG_OPR_LTD CHAR 3   0   LPA: Logical Operator Limited Values  
74 SRT_TIMVAL /POSDW/LPA_SRT_TIMVAL /POSDW/LPA_ITMCNT NUMC 10   0   LPA: Scan Rate Template Time value  
75 SRT_MERCHG /POSDW/LPA_SRT_MERCHG MATKL CHAR 9   0   LPA:Scan Rate Template Merchandise Group *
76 SRT_MERCHGCOLL /POSDW/LPA_MERCHGCOLL   CHAR 255   0   LPA: Merchandise Group Collection  
77 SRT_EXMERCHG /POSDW/LPA_SRT_EXMERCHG /POSDW/FLAG CHAR 1   0   LPA: Scan Rate Template Exclude Merchandise Groups  
78 SRT_MANUAL /POSDW/LPA_SRT_MANUAL /POSDW/FLAG CHAR 1   0   LPA: Scan Rate Template Manual Entries Indicator  
79 SRT_MSVAL /POSDW/LPA_SRT_MSVAL /POSDW/LPA_ITMCNT NUMC 10   0   LPA: Scan Rate Template Item count  
80 LOG_OPR1_LTD /POSDW/LPA_LOG_OPR_LTD /POSDW/LPA_LOG_OPR_LTD CHAR 3   0   LPA: Logical Operator Limited Values  
81 PTN_STATUS /POSDW/LPA_PTNSTAT /POSDW/LPA_PTNSTAT CHAR 4   0   LPA : Pattern Status  
82 CREATED_ON /POSDW/LPA_CRD_ON /POSDW/DATE DATS 8   0   LPA : Template/Pattern Created On Date  
83 CHANGED_ON /POSDW/LPA_CHD_ON /POSDW/DATE DATS 8   0   LPA : Template/Pattern Changed Date  
84 AUTHOR SYUNAME SYCHAR12 CHAR 12   0   User Name  
85 CHANGEDBY SYUNAME SYCHAR12 CHAR 12   0   User Name  
86 REF_WO_TENDER /POSDW/LPA_REF_TENDER /POSDW/FLAG CHAR 1   0   LPA: Indicator for Diff. Tender Types in Refund /Sales  
87 REF_WO_TENDTY /POSDW/LPA_REF_TENDTY /POSDW/FLAG CHAR 1   0   LPA: Indicator for Different Credit Cards in Refund /Sales  
88 LOG_OPR2_LTD /POSDW/LPA_LOG_OPR_LTD /POSDW/LPA_LOG_OPR_LTD CHAR 3   0   LPA: Logical Operator Limited Values  
89 LOG_OPR3_LTD /POSDW/LPA_LOG_OPR_LTD /POSDW/LPA_LOG_OPR_LTD CHAR 3   0   LPA: Logical Operator Limited Values  
90 DISC_TYPE_GRP1 /POSDW/LPA_DISC_TYPE_GROUP1 /POSDW/DISCOUNTTYPEGROUP CHAR 4   0   LPA: Discount Type Group 1 /POSDW/DISCTG
91 DISC_TYPE_GRP2 /POSDW/LPA_DISC_TYPE_GROUP2 /POSDW/DISCOUNTTYPEGROUP CHAR 4   0   LPA: Discount Type Group 2 /POSDW/DISCTG
92 TENDER_TYPE_GRP1 /POSDW/LPA_TENDER_TYPE_GROUP1 /POSDW/TENDERTYPEGROUP CHAR 4   0   LPA: Tender Type Group 1 /POSDW/TENDTG
93 TENDER_TYPE_GRP2 /POSDW/LPA_TENDER_TYPE_GROUP2 /POSDW/TENDERTYPEGROUP CHAR 4   0   LPA: Tender Type Group 2 /POSDW/TENDTG
94 TRAN_TYPE_GRP1 /POSDW/LPA_TRAN_TYPE_GROUP1 /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   LPA: Transaction Type Group 1 /POSDW/TRANTG
95 TRAN_TYPE_GRP2 /POSDW/LPA_TRAN_TYPE_GROUP2 /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   LPA: Transaction Type Group 2 /POSDW/TRANTG
96 TASKCODE /POSDW/TASKCODE /POSDW/TASKCODE CHAR 4   0   Task Code /POSDW/TASKS
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/LPA_EXDET DISC_TYPE_GRP1 /POSDW/DISCTG DISCOUNTTYPEGROU 1 CN
2 /POSDW/LPA_EXDET DISC_TYPE_GRP2 /POSDW/DISCTG DISCOUNTTYPEGROU 1 CN
3 /POSDW/LPA_EXDET PRF_TYPE /POSDW/PROF PROFILETYPE    
4 /POSDW/LPA_EXDET REASONCODE /POSDW/REASON REASONCODE 1 CN
5 /POSDW/LPA_EXDET RETAILTYPECODE /POSDW/RETTY RETAILTYPECODE 1 CN
6 /POSDW/LPA_EXDET TASKCODE /POSDW/TASKS TASKCODE 1 CN
7 /POSDW/LPA_EXDET TENDER_TYPE /POSDW/TENDTY TENDERTYPECODE    
8 /POSDW/LPA_EXDET TENDER_TYPE1 /POSDW/TENDTY TENDERTYPECODE    
9 /POSDW/LPA_EXDET TENDER_TYPE2 /POSDW/TENDTY TENDERTYPECODE    
10 /POSDW/LPA_EXDET TENDER_TYPE3 /POSDW/TENDTY TENDERTYPECODE    
11 /POSDW/LPA_EXDET TENDER_TYPE4 /POSDW/TENDTY TENDERTYPECODE    
12 /POSDW/LPA_EXDET TENDER_TYPE5 /POSDW/TENDTY TENDERTYPECODE    
13 /POSDW/LPA_EXDET TENDER_TYPE6 /POSDW/TENDTY TENDERTYPECODE    
14 /POSDW/LPA_EXDET TENDER_TYPE7 /POSDW/TENDTY TENDERTYPECODE    
15 /POSDW/LPA_EXDET TENDER_TYPE_GRP1 /POSDW/TENDTG TENDERTYPEGROUP 1 CN
16 /POSDW/LPA_EXDET TENDER_TYPE_GRP2 /POSDW/TENDTG TENDERTYPEGROUP 1 CN
17 /POSDW/LPA_EXDET TMPL_ID /POSDW/LPA_EXP TMPL_ID 1 CN
18 /POSDW/LPA_EXDET TRAN_TYPE /POSDW/TRANTY TRANSTYPECODE 1 CN
19 /POSDW/LPA_EXDET TRAN_TYPE1 /POSDW/TRANTY TRANSTYPECODE 1 CN
20 /POSDW/LPA_EXDET TRAN_TYPE_GRP1 /POSDW/TRANTG TRANSTYPEGROUP 1 CN
21 /POSDW/LPA_EXDET TRAN_TYPE_GRP2 /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20111123 
SAP Release Created in 705