SAP ABAP Table /POSDW/BW_LOYALTY (Transfer to BW for Loyalty Program for Sales Transactions)

Hierarchy

☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     ⤷ /POSDW/OUTPUT_CONVERSION (Package) PIPE Tasks and Output Conversion

Basic Data

Table Category	INTTAB	Structure
Structure	/POSDW/BW_LOYALTY	Table Relationship Diagram
Short Description	Transfer to BW for Loyalty Program for Sales 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	.INCLUDE	☐				0	0	Transaction Header for BW
2	RECORDQUALIFIER	☐	/POSDW/RECORDQUALIFIER	/POSDW/RECORDQUALIFIER	CHAR	4	0	Record Type of Transaction
3	BWTRANSINDEX	☐	/POSDW/BWTRANSINDEX	/POSDW/CHAR10ALPHA	CHAR	10	0	Transaction Index for BW as Character Field
4	.INCLUDE	☐				0	0	Transaction
5	.INCLUDE	☐				0	0	Transaction - Database Fields
6	.INCLUDE	☐				0	0	Transaction - Database Fields (Key Fields)
7	RETAILSTOREID	☐	/POSDW/RETAILSTOREID	/POSDW/RETAILSTOREID	CHAR	10	0	Store
8	BUSINESSDAYDATE	☐	/POSDW/BUSINESSDAYDATE	/POSDW/DATE	DATS	8	0	Posting Date
9	TRANSTYPECODE	☐	/POSDW/TRANSACTIONTYPECODE	/POSDW/TRANSACTIONTYPECODE	CHAR	4	0	Transaction Type	/POSDW/TRANTY
10	WORKSTATIONID	☐	/POSDW/WORKSTATIONID	/POSDW/WORKSTATIONID	CHAR	10	0	POS Number
11	TRANSNUMBER	☐	/POSDW/TRANSACTIONSEQUENCENUMB	/POSDW/TRANSACTIONSEQUENCENUMB	CHAR	20	0	Transaction Number
12	BEGINTIMESTAMP	☐	/POSDW/BEGINDATETIMESTAMP	/POSDW/TIMESTAMP	CHAR	14	0	Second in Which Transaction Starts
13	ENDTIMESTAMP	☐	/POSDW/ENDDATETIMESTAMP	/POSDW/TIMESTAMP	CHAR	14	0	Second in Which Transaction Ends
14	DEPARTMENT	☐	/POSDW/DEPARTMENT	/POSDW/CHAR10ALPHA	CHAR	10	0	Department
15	OPERATORQUAL	☐	/POSDW/OPERATORQUALIFIER	/POSDW/OPERATORQUALIFIER	CHAR	1	0	Operator Qualifier
16	OPERATORID	☐	/POSDW/OPERATORID	/POSDW/CHAR30ALPHA	CHAR	30	0	Cashier Number or Name
17	TRANSCURRENCY	☐	/POSDW/TRANSACTIONCURRENCY	WAERS	CUKY	5	0	Transaction Currency	*
18	PARTNERQUALIFIER	☐	/POSDW/PARTNERQUALIFIER	/POSDW/PARTNERQUALIFIER	CHAR	1	0	Qualifier for Partner Number
19	PARTNERID	☐	/POSDW/PARTNERID	/POSDW/CHAR13ALPHA	CHAR	13	0	Partner Number
20	.INCLUDE	☐				0	0	Transaction - Enhanced Fields
21	TRANSINDEX	☐	/POSDW/TRANSINDEX	/POSDW/TRANSINDEX	INT4	10	0	Transaction Index
22	NONCOMPFLAG	☐	/POSDW/NONCOMPFLAG	/POSDW/FLAG	CHAR	1	0	Indicator for Non-Comparable Sales
23	TRANSTYPEGROUP	☐	/POSDW/TRANSACTIONTYPEGROUP	/POSDW/TRANSACTIONTYPEGROUP	CHAR	4	0	Transaction Type Group	/POSDW/TRANTG
24	BUSINESSTYPE	☐	/POSDW/BUSINESSTYPE	/POSDW/BUSINESSTYPE	CHAR	1	0	Business Transaction
25	REVERSALFLAG	☐	/POSDW/REVERSALFLAG	/POSDW/FLAG	CHAR	1	0	Reversal Indicator
26	TRANSDEBITFLAG	☐	/POSDW/DEBITFLAG	/POSDW/DEBITFLAG	CHAR	1	0	Debit/Credit Indicator
27	PLANT	☐	/POSDW/PLANT	CHAR4	CHAR	4	0	Plant
28	STORECURRENCY	☐	/POSDW/STORECURRENCY	WAERS	CUKY	5	0	Local Currency	*
29	PLANTCUSTOMER	☐	/POSDW/PLANTCUSTOMER	/POSDW/CHAR10ALPHA	CHAR	10	0	Customer Number of Plant
30	BUSINESSLOCATION	☐	/POSDW/BUSINESSLOCATION	/POSDW/CHAR10ALPHA	CHAR	10	0	Business Location Identifier (IS-OIL/MRN)
31	TURNOVER	☐	/POSDW/TRANSTURNOVER	/POSDW/CURRENCY	CURR	15	2	Sales Totals Per Transaction
32	INDEXCURRENCY	☐	/POSDW/INDEXCURRENCY	WAERS	CUKY	5	0	Currency for Sales Totals	*
33	VERSION	☐	/POSDW/TRANSACTION_VERSION	/POSDW/TRANSACTION_VERSION	INT1	3	0	Version of POS Transaction
34	.INCLUDE	☐				0	0	Sales Item Data
35	.INCLUDE	☐				0	0	Sales Item Data - Database Fields
36	.INCLUDE	☐				0	0	Salres Item Data - Database Fields (Key)
37	RETAILNUMBER	☐	/POSDW/RETAILSEQUENCENUMBER	/POSDW/SEQUENCENUMBER	CHAR	10	0	Sales Item Number
38	RETAILTYPECODE	☐	/POSDW/RETAILTYPECODE	/POSDW/RETAILTYPECODE	CHAR	4	0	Sales Item Type	/POSDW/RETTY
39	RETAILREASONCODE	☐	/POSDW/RETAILREASONCODE	/POSDW/REASONCODE	CHAR	4	0	Reason for Sales Transaction	*
40	ITEMIDQUALIFIER	☐	/POSDW/ITEMIDQUALIFIER	/POSDW/ITEMIDQUALIFIER	CHAR	1	0	Qualifier for Article Identifier
41	ITEMID	☐	/POSDW/ITEMID	/POSDW/ITEMID	CHAR	18	0	Article Identifier
42	RETAILQUANTITY	☐	/POSDW/RETAILQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Sales Unit
43	SALESUOM	☐	/POSDW/SALESUNITOFMEASURE	MEINS	UNIT	3	0	Sales Unit	T006
44	SALESAMOUNT	☐	/POSDW/SALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Actual Retail Value
45	NORMALSALESAMT	☐	/POSDW/NORMALSALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Normal Sales Value
46	COST	☐	/POSDW/COST	/POSDW/CURRENCY	CURR	15	2	Costs
47	BATCHID	☐	/POSDW/BATCHID	/POSDW/CHAR10ALPHA	CHAR	10	0	Batch
48	SERIALNUMBER	☐	/POSDW/SERIALNUMBER	/POSDW/CHAR25ALPHA	CHAR	25	0	Serial Number
49	PROMOTIONID	☐	/POSDW/PROMOTIONID	/POSDW/CHAR10ALPHA	CHAR	10	0	Promotion Number
50	ENTRYMETHODCODE	☐	/POSDW/ITEMIDENTRYMETHODCODE		CHAR	4	0	Entry Method
51	ACTUALUNITPRICE	☐	/POSDW/ACTUALUNITPRICE	/POSDW/CURRENCY	CURR	15	2	Sales Price of Article per Unit
52	UNITS	☐	/POSDW/UNITS	/POSDW/QUANTITY	QUAN	13	3	Sales Quantity
53	SCANTIME	☐	/POSDW/SCANTIME	/POSDW/TIMESTAMP	CHAR	14	0	Timestamp of an retail line item scanned
54	.INCLUDE	☐				0	0	Sales Item Data - Enhanced Fields
55	MATERIALNUMBER	☐	/POSDW/MATERIALNUMBER	MATNR	CHAR	18	0	Material Number
56	MERCHANDISECAT	☐	/POSDW/MERCHANDISECATEGORY	MATKL	CHAR	9	0	Material Group	*
57	BASEQUANTITY	☐	/POSDW/BASEQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Base Unit of Measure
58	BASEUOM	☐	/POSDW/BASEUNITOFMEASURE	MEINS	UNIT	3	0	Base Unit of Measure	T006
59	RETAILTYPEGROUP	☐	/POSDW/RETAILTYPEGROUP	/POSDW/RETAILTYPEGROUP	CHAR	4	0	Sales Item Type Group	*
60	RETAILDEBITFLAG	☐	/POSDW/DEBITFLAG	/POSDW/DEBITFLAG	CHAR	1	0	Debit/Credit Indicator
61	RETAILREASONGRP	☐	/POSDW/REASONGROUP	/POSDW/REASONGROUP	CHAR	4	0	Group for Reasons	/POSDW/REASG
62	RETL_ITEM_CAT	☐	/POSDW/RETAIL_ITEM_CATEGORY	/POSDW/ITEM_CATEGORY	CHAR	1	0	Classification of Sales Item: Category	*
63	RETL_ITEM_SCAT	☐	/POSDW/RETAIL_ITEM_SUBCATEGORY	/POSDW/ITEM_SUBCATEGORY	CHAR	1	0	Classification of Sales Item: Subcategory	*
64	.INCLUDE	☐				0	0	Loyalty Program
65	.INCLUDE	☐				0	0	Loyalty Program Database Fields
66	.INCLUDE	☐				0	0	Loyalty Program Database Fields (Key Fields)
67	LOYNUMBER	☐	/POSDW/LOYALTY_SEQUENCENUMBER	/POSDW/SEQUENCENUMBER	CHAR	10	0	Loyalty Program Item Number
68	CUSTCARDNUMBER	☐	/POSDW/CUSTOMERCARD_NUMBER	/POSDW/CHAR25ALPHA	CHAR	25	0	Number of Customer Card
69	LOYPROGRAMID	☐	/POSDW/LOYALTY_PROGRAM_ID	/POSDW/LOYALTY_PROGRAM_ID	CHAR	8	0	Loyalty Program Identifier
70	LOYPNTSAWARDED	☐	/POSDW/LOYALTY_POINTS_AWARDED	/POSDW/LOYALTY_POINTS	INT4	10	0	Awarded Loyalty Points
71	ELIGIBLEAMOUNT	☐	/POSDW/ELIGIBLE_AMOUNT	/POSDW/CURRENCY	CURR	15	2	Eligible Sales Value
72	ELIGIBLEQUANTITY	☐	/POSDW/ELIGIBLE_QUANTITY	/POSDW/QUANTITY	QUAN	13	3	Eligible Quantity
73	ELIGIBLEQUANUOM	☐	/POSDW/ELIGIBLE_QUAN_UOM	MEINS	UNIT	3	0	Unit of Measure for Eligible Quantity	*
74	LOYPNTSREDEEMED	☐	/POSDW/LOYALTY_POINTS_REDEEMED	/POSDW/LOYALTY_POINTS	INT4	10	0	Redeemed Loyalty Points
75	LOYPNTSTOTAL	☐	/POSDW/LOYALTY_POINTS_TOTAL	/POSDW/LOYALTY_POINTS	INT4	10	0	Total Loyalty Points
76	CUSTCARDHOLDNAME	☐	/POSDW/CARDHOLDERNAME	/POSDW/CARDHOLDERNAME	CHAR	40	0	Card Holder
77	CUSTCARDTYPE	☐	/POSDW/CUSTOMERCARD_TYPE	/POSDW/TYPECODE	CHAR	4	0	Customer Card Category
78	CUSTCARDVALIDFR	☐	/POSDW/CUSTOMERCARD_VALID_FROM	/POSDW/DATE	DATS	8	0	Start of Validity Period of Customer Card
79	CUSTCARDVALIDTO	☐	/POSDW/CUSTOMERCARD_VALID_TO	/POSDW/DATE	DATS	8	0	End of Validity Period of Customer Card
80	VOIDFLAG	☐	/POSDW/VOIDFLAG	/POSDW/FLAG	CHAR	1	0	Indicator for Cancelled Items

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/POSDW/BW_LOYALTY	BASEUOM	T006	MSEHI	KEY	1	CN
2	/POSDW/BW_LOYALTY	RETAILREASONGRP	/POSDW/REASG	REASONGROUP	KEY	1	CN
3	/POSDW/BW_LOYALTY	RETAILTYPECODE	/POSDW/RETTY	RETAILTYPECODE	KEY	1	CN
4	/POSDW/BW_LOYALTY	SALESUOM	T006	MSEHI	KEY
5	/POSDW/BW_LOYALTY	TRANSTYPECODE	/POSDW/TRANTY	TRANSTYPECODE	KEY	1	CN
6	/POSDW/BW_LOYALTY	TRANSTYPEGROUP	/POSDW/TRANTG	TRANSTYPEGROUP		1	CN

History

Last changed by/on	SAP	20100820
SAP Release Created in	703