SAP ABAP Table /POSDW/LPA_VEXDT (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure /POSDW/LPA_VEXDT   Table Relationship Diagram
Short Description Generated Table for View    
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 MANDT MANDT MANDT CLNT 3   0   Client  
2 TMPL_ID /POSDW/LPA_TMPL_ID /POSDW/LPA_TMPL_ID CHAR 10   0   LPA : Exception Template ID  
3 CL_METHOD /POSDW/LPA_EXPMTH /POSDW/CHAR30ALPHA CHAR 30   0   LPA : Exception Template Implementation Method  
4 EXP_CL /POSDW/LPA_EXPCLS /POSDW/CHAR30ALPHA CHAR 30   0   LPA : Exception Template Implementation Class  
5 PRF_TYPE /POSDW/PROFILETYPE /POSDW/PROFILETYPE CHAR 4   0   Customizing Profile Type /POSDW/PROF
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 /POSDW/TRANTY
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 /POSDW/TENDTY
14 MAT_NO /POSDW/MATERIALNUMBER MATNR CHAR 18   0   Material Number  
15 BA_MAT_NO /POSDW/LPA_MATERIALNUMBER1 MATNR CHAR 18   0   LPA : Material Number 1  
16 TRAN_TYPE1 /POSDW/LPA_TRANTYPE1 /POSDW/TRANSACTIONTYPECODE CHAR 4   0   LPA : Transaction Type 1 /POSDW/TRANTY
17 TENDER_TYPE1 /POSDW/LPA_TENDER_TYPE1 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
18 TENDER_TYPE2 /POSDW/LPA_TENDER_TYPE2 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
19 TENDER_TYPE3 /POSDW/LPA_TENDER_TYPE3 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
20 TENDER_TYPE4 /POSDW/LPA_TENDER_TYPE4 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
21 TENDER_TYPE5 /POSDW/LPA_TENDER_TYPE5 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
22 TENDER_TYPE6 /POSDW/LPA_TENDER_TYPE6 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
23 TENDER_TYPE7 /POSDW/LPA_TENDER_TYPE7 /POSDW/TENDERTYPECODE CHAR 4   0   LPA : Means of Payment /POSDW/TENDTY
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 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 RINGTIME_FROM /POSDW/LPA_RNGTIME_FROM /POSDW/TRANSINDEX INT4 10   0   LPA : Total Ringtime From  
39 RINGTIME_TO /POSDW/LPA_RNGTIME_TO /POSDW/TRANSINDEX INT4 10   0   LPA : Total Ringtime 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_ATTR1 /POSDW/LPA_ITM_ATTR CHAR 10   0   LPA : Item Attribute 1  
64 ITM_ATRVAL1 /POSDW/LPA_IT_AVAL1 /POSDW/CHAR10ALPHA CHAR 10   0   LPA : Item Attribute Value 1  
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_ATTR1 /POSDW/LPA_ORD_ATTR CHAR 10   0   LPA : Order Attribute 1  
68 ORD_ATRVAL1 /POSDW/LPA_ORD_AVAL1 /POSDW/CHAR10ALPHA CHAR 10   0   LPA : Order Attribute Value 1  
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 /POSDW/REASON
73 RETAILTYPECODE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type /POSDW/RETTY
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 DISC_TYPE_GRP1 /POSDW/LPA_DISC_TYPE_GROUP1 /POSDW/DISCOUNTTYPEGROUP CHAR 4   0   LPA: Discount Type Group 1 /POSDW/DISCTG
80 DISC_TYPE_GRP2 /POSDW/LPA_DISC_TYPE_GROUP2 /POSDW/DISCOUNTTYPEGROUP CHAR 4   0   LPA: Discount Type Group 2 /POSDW/DISCTG
81 TENDER_TYPE_GRP1 /POSDW/LPA_TENDER_TYPE_GROUP1 /POSDW/TENDERTYPEGROUP CHAR 4   0   LPA: Tender Type Group 1 /POSDW/TENDTG
82 TENDER_TYPE_GRP2 /POSDW/LPA_TENDER_TYPE_GROUP2 /POSDW/TENDERTYPEGROUP CHAR 4   0   LPA: Tender Type Group 2 /POSDW/TENDTG
83 TRAN_TYPE_GRP1 /POSDW/LPA_TRAN_TYPE_GROUP1 /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   LPA: Transaction Type Group 1 /POSDW/TRANTG
84 TRAN_TYPE_GRP2 /POSDW/LPA_TRAN_TYPE_GROUP2 /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   LPA: Transaction Type Group 2 /POSDW/TRANTG
85 PTN_STATUS /POSDW/LPA_PTNSTAT /POSDW/LPA_PTNSTAT CHAR 4   0   LPA : Pattern Status  
86 TASKCODE /POSDW/TASKCODE /POSDW/TASKCODE CHAR 4   0   Task Code /POSDW/TASKS
87 CREATED_ON /POSDW/LPA_CRD_ON /POSDW/DATE DATS 8   0   LPA : Template/Pattern Created On Date  
88 CHANGED_ON /POSDW/LPA_CHD_ON /POSDW/DATE DATS 8   0   LPA : Template/Pattern Changed Date  
89 AUTHOR SYUNAME SYCHAR12 CHAR 12   0   User Name  
90 CHANGEDBY SYUNAME SYCHAR12 CHAR 12   0   User Name  
91 SRT_TIMVAL /POSDW/LPA_SRT_TIMVAL /POSDW/LPA_ITMCNT NUMC 10   0   LPA: Scan Rate Template Time value  
92 SRT_MERCHG /POSDW/LPA_SRT_MERCHG MATKL CHAR 9   0   LPA:Scan Rate Template Merchandise Group  
93 SRT_EXMERCHG /POSDW/LPA_SRT_EXMERCHG /POSDW/FLAG CHAR 1   0   LPA: Scan Rate Template Exclude Merchandise Groups  
94 SRT_MANUAL /POSDW/LPA_SRT_MANUAL /POSDW/FLAG CHAR 1   0   LPA: Scan Rate Template Manual Entries Indicator  
95 SRT_MSVAL /POSDW/LPA_SRT_MSVAL /POSDW/LPA_ITMCNT NUMC 10   0   LPA: Scan Rate Template Item count  
96 SRT_MERCHGCOLL /POSDW/LPA_MERCHGCOLL   CHAR 255   0   LPA: Merchandise Group Collection  
97 REF_WO_TENDER /POSDW/LPA_REF_TENDER /POSDW/FLAG CHAR 1   0   LPA: Indicator for Diff. Tender Types in Refund /Sales  
98 REF_WO_TENDTY /POSDW/LPA_REF_TENDTY /POSDW/FLAG CHAR 1   0   LPA: Indicator for Different Credit Cards in Refund /Sales  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/LPA_VEXDT DISC_TYPE_GRP1 /POSDW/DISCTG DISCOUNTTYPEGROU 1 CN
2 /POSDW/LPA_VEXDT DISC_TYPE_GRP2 /POSDW/DISCTG DISCOUNTTYPEGROU 1 CN
3 /POSDW/LPA_VEXDT PRF_TYPE /POSDW/PROF PROFILETYPE    
4 /POSDW/LPA_VEXDT REASONCODE /POSDW/REASON REASONCODE 1 CN
5 /POSDW/LPA_VEXDT RETAILTYPECODE /POSDW/RETTY RETAILTYPECODE 1 CN
6 /POSDW/LPA_VEXDT TASKCODE /POSDW/TASKS TASKCODE 1 CN
7 /POSDW/LPA_VEXDT TENDER_TYPE /POSDW/TENDTY TENDERTYPECODE    
8 /POSDW/LPA_VEXDT TENDER_TYPE1 /POSDW/TENDTY TENDERTYPECODE    
9 /POSDW/LPA_VEXDT TENDER_TYPE2 /POSDW/TENDTY TENDERTYPECODE    
10 /POSDW/LPA_VEXDT TENDER_TYPE3 /POSDW/TENDTY TENDERTYPECODE    
11 /POSDW/LPA_VEXDT TENDER_TYPE4 /POSDW/TENDTY TENDERTYPECODE    
12 /POSDW/LPA_VEXDT TENDER_TYPE5 /POSDW/TENDTY TENDERTYPECODE    
13 /POSDW/LPA_VEXDT TENDER_TYPE6 /POSDW/TENDTY TENDERTYPECODE    
14 /POSDW/LPA_VEXDT TENDER_TYPE7 /POSDW/TENDTY TENDERTYPECODE    
15 /POSDW/LPA_VEXDT TENDER_TYPE_GRP1 /POSDW/TENDTG TENDERTYPEGROUP 1 CN
16 /POSDW/LPA_VEXDT TENDER_TYPE_GRP2 /POSDW/TENDTG TENDERTYPEGROUP 1 CN
17 /POSDW/LPA_VEXDT TRAN_TYPE /POSDW/TRANTY TRANSTYPECODE 1 CN
18 /POSDW/LPA_VEXDT TRAN_TYPE1 /POSDW/TRANTY TRANSTYPECODE 1 CN
19 /POSDW/LPA_VEXDT TRAN_TYPE_GRP1 /POSDW/TRANTG TRANSTYPEGROUP 1 CN
20 /POSDW/LPA_VEXDT TRAN_TYPE_GRP2 /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20111123 
SAP Release Created in