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