SAP ABAP Table /POSDW/LPA_TXN_FRD (LPA : Structure for Fraudulent Transactions)

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_TXN_FRD	Table Relationship Diagram
Short Description	LPA : Structure for Fraudulent Transactions

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	PTN_ID	☐	/POSDW/LPA_PTN_ID	/POSDW/CHAR10ALPHA	CHAR	10	0	LPA : Pattern Identifier
2	RECORDQUALIFIER	☐	/POSDW/RECORDQUALIFIER	/POSDW/RECORDQUALIFIER	CHAR	4	0	Record Type of Transaction
3	WORKSTATIONID	☐	/POSDW/WORKSTATIONID	/POSDW/WORKSTATIONID	CHAR	10	0	POS Number
4	BUSINESSDAYDATE	☐	/POSDW/BUSINESSDAYDATE	/POSDW/DATE	DATS	8	0	Posting Date
5	BASEUOM	☐	/POSDW/BASEUNITOFMEASURE	MEINS	UNIT	3	0	Base Unit of Measure	*
6	BASEQUANTITY	☐	/POSDW/BASEQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Base Unit of Measure
7	BUSINESSTYPE	☐	/POSDW/BUSINESSTYPE	/POSDW/BUSINESSTYPE	CHAR	1	0	Business Transaction
8	BWTRANSINDEX	☐	/POSDW/BWTRANSINDEX	/POSDW/CHAR10ALPHA	CHAR	10	0	Transaction Index for BW as Character Field
9	CARDNUMBER	☐	/POSDW/CARDNUMBER	/POSDW/CARDNUMBER	CHAR	25	0	Card Number
10	CARDTYPE	☐	/POSDW/CARDTYPE	/POSDW/CHAR02ALPHA	CHAR	2	0	Eurocheque Card Type
11	DEPARTMENT	☐	/POSDW/DEPARTMENT	/POSDW/CHAR10ALPHA	CHAR	10	0	Department
12	DISCCOUNT	☐	/POSDW/DISCOUNTCOUNT	/POSDW/COUNT	INT4	10	0	Number of Discount Items
13	DISCTYPECODE	☐	/POSDW/DISCOUNTTYPECODE	/POSDW/DISCOUNTTYPECODE	CHAR	4	0	Discount Type	*
14	DISCTYPEGROUP	☐	/POSDW/DISCOUNTTYPEGROUP	/POSDW/DISCOUNTTYPEGROUP	CHAR	4	0	Discount Type Group	*
15	DISTDISC	☐	/POSDW/DISTDISC	/POSDW/CURRENCY	CURR	15	2	Distributed Header Discount
16	LINEITEMCOUNT	☐	/POSDW/LINEITEMCOUNT	/POSDW/COUNT	INT4	10	0	Number of Sales Items
17	NORMALSALESAMT	☐	/POSDW/NORMALSALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Normal Sales Value
18	OPERATORID	☐	/POSDW/OPERATORID	/POSDW/CHAR30ALPHA	CHAR	30	0	Cashier Number or Name
19	PLANT	☐	/POSDW/PLANT	CHAR4	CHAR	4	0	Plant
20	REDUCTIONAMOUNT	☐	/POSDW/REDUCTIONTOTAL	/POSDW/CURRENCY	CURR	15	2	Discount Value Total
21	RETAILDEBITFLAG	☐	/POSDW/DEBITFLAG	/POSDW/DEBITFLAG	CHAR	1	0	Debit/Credit Indicator
22	RETL_ITEM_CAT	☐	/POSDW/RETAIL_ITEM_CATEGORY	/POSDW/ITEM_CATEGORY	CHAR	1	0	Classification of Sales Item: Category	*
23	RETL_ITEM_SCAT	☐	/POSDW/RETAIL_ITEM_SUBCATEGORY	/POSDW/ITEM_SUBCATEGORY	CHAR	1	0	Classification of Sales Item: Subcategory	*
24	REVERSALFLAG	☐	/POSDW/REVERSALFLAG	/POSDW/FLAG	CHAR	1	0	Reversal Indicator
25	SALESAMOUNT	☐	/POSDW/SALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Actual Retail Value
26	TAXAMOUNT	☐	/POSDW/TAXAMOUNT	/POSDW/CURRENCY	CURR	15	2	Tax Amount
27	TENDERAMOUNT	☐	/POSDW/TENDERAMOUNT	/POSDW/CURRENCY	CURR	15	2	Tender Value
28	TENDERID	☐	/POSDW/TENDERID	/POSDW/CHAR32ALPHA	CHAR	32	0	Tender Identifier
29	TENDERTYPECODE	☐	/POSDW/TENDERTYPECODE	/POSDW/TENDERTYPECODE	CHAR	4	0	Means of Payment	*
30	TENDERTYPEGROUP	☐	/POSDW/TENDERTYPEGROUP	/POSDW/TENDERTYPEGROUP	CHAR	4	0	Payment Means Group	*
31	TRANSCNT	☐	/POSDW/TRANSACTIONCOUNT	/POSDW/COUNT	INT4	10	0	Number of Transactions
32	TRANSTYPECODE	☐	/POSDW/TRANSACTIONTYPECODE	/POSDW/TRANSACTIONTYPECODE	CHAR	4	0	Transaction Type	*
33	TURNOVER	☐	/POSDW/TRANSTURNOVER	/POSDW/CURRENCY	CURR	15	2	Sales Totals Per Transaction
34	INDEXCURRENCY	☐	/POSDW/INDEXCURRENCY	WAERS	CUKY	5	0	Currency for Sales Totals	*
35	ENDTIMESTAMP	☐	/POSDW/ENDDATETIMESTAMP	/POSDW/TIMESTAMP	CHAR	14	0	Second in Which Transaction Ends
36	TRANSCURRENCY	☐	/POSDW/TRANSACTIONCURRENCY	WAERS	CUKY	5	0	Transaction Currency	*
37	TAXINCLUDEDFLAG	☐	/POSDW/TAXINCLUDEDFLAG	/POSDW/FLAG	CHAR	1	0	Indicates Whether Taxes Are Included in Retail Value
38	VOIDFLAG	☐	/POSDW/VOIDFLAG	/POSDW/FLAG	CHAR	1	0	Indicator for Cancelled Items
39	RETAILNUMBER	☐	/POSDW/RETAILSEQUENCENUMBER	/POSDW/SEQUENCENUMBER	CHAR	10	0	Sales Item Number
40	TENDERNUMBER	☐	/POSDW/TENDERSEQUENCENUMBER	/POSDW/SEQUENCENUMBER	CHAR	10	0	Tender Item Number

History

Last changed by/on	SAP	20111123
SAP Release Created in	705