SAP ABAP Table /POSDW/LPA_ITEM_DETAILS (LPA : Item Details For Transaction Viewer)
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_ITEM_DETAILS   Table Relationship Diagram
Short Description LPA : Item Details For Transaction Viewer    
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 RETAILNUMBER /POSDW/RETAILSEQUENCENUMBER /POSDW/SEQUENCENUMBER CHAR 10   0   Sales Item Number  
2 ITEM_ID /POSDW/ITEMID /POSDW/ITEMID CHAR 18   0   Article Identifier  
3 PRICE /POSDW/ACTUALUNITPRICE /POSDW/CURRENCY CURR 15   2   Sales Price of Article per Unit  
4 QUANTITY /POSDW/RETAILQUANTITY /POSDW/QUANTITY QUAN 13   3   Quantity in Sales Unit  
5 AMOUNT /POSDW/SALESAMOUNT /POSDW/CURRENCY CURR 15   2   Actual Retail Value  
6 DEPARTMENT /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
7 REDUCTIONAMOUNT /POSDW/REDUCTIONAMOUNT /POSDW/CURRENCY CURR 15   2   Discount Value  
8 TRANSCURRENCY /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
9 SALESOUM /POSDW/SALESUNITOFMEASURE MEINS UNIT 3   0   Sales Unit *
10 MANUAL_ENTER_ITEM /POSDW/LPA_STATUS /POSDW/LPA_STATUS CHAR 4   0   LPA : Yes/No Status  
11 VOID_ITEM /POSDW/LPA_STATUS /POSDW/LPA_STATUS CHAR 4   0   LPA : Yes/No Status  
12 EXCHANGE_ITEM /POSDW/LPA_STATUS /POSDW/LPA_STATUS CHAR 4   0   LPA : Yes/No Status  
13 RETURN_ITEM /POSDW/LPA_STATUS /POSDW/LPA_STATUS CHAR 4   0   LPA : Yes/No Status  
14 TAXAMOUNT /POSDW/TAXAMOUNT /POSDW/CURRENCY CURR 15   2   Tax Amount  
15 TXN_DESC CHAR20 CHAR20 CHAR 20   0   Char 20  
16 SALESUOM /POSDW/SALESUNITOFMEASURE MEINS UNIT 3   0   Sales Unit *
17 COMP_DISCRIPTION RSTXTMD TEXT40 CHAR 40   0   Medium description  
18 RETAILTYPECODE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type *
19 ITEM_TYPE /POSDW/DESCRIPTION /POSDW/DESCRIPTION CHAR 50   0   Description  
20 NORMALSALESAMT /POSDW/NORMALSALESAMOUNT /POSDW/CURRENCY CURR 15   2   Normal Sales Value  
21 ORIGRETAILSTOREID /POSDW/ORIGRETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store in which transactions are to be refunded  
22 ORIGBUSINESSDAYDATE /POSDW/ORIGBUSINESSDAYDATE /POSDW/DATE DATS 8   0   Date of transaction to be Refunded  
23 ORIGWORKSTATIONID /POSDW/ORIGWORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   Cash Desk of Transaction To Be Refunded  
24 ORIGTRANSNUMBER /POSDW/ORIGTRANSNUMBER /POSDW/TRANSACTIONSEQUENCENUMB CHAR 20   0   Number of the Transaction To Be Refunded  
History
Last changed by/on SAP  20111123 
SAP Release Created in 705