SAP ABAP Table /POSDW/RETAILLINEITEM_TLOG (Retail Transaction Item Data - Database Fields)

Hierarchy

☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     ⤷ /POSDW/DATABASE (Package) PIPE Database

Basic Data

Table Category	INTTAB	Structure
Structure	/POSDW/RETAILLINEITEM_TLOG	Table Relationship Diagram
Short Description	Retail Transaction Item Data - Database Fields

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	Sales Item Data - Database Fields
2	.INCLUDE	☐				0	0	Salres Item Data - Database Fields (Key)
3	RETAILNUMBER	☐	/POSDW/RETAILSEQUENCENUMBER	/POSDW/SEQUENCENUMBER	CHAR	10	0	Sales Item Number
4	RETAILTYPECODE	☐	/POSDW/RETAILTYPECODE	/POSDW/RETAILTYPECODE	CHAR	4	0	Sales Item Type	/POSDW/RETTY
5	RETAILREASONCODE	☐	/POSDW/RETAILREASONCODE	/POSDW/REASONCODE	CHAR	4	0	Reason for Sales Transaction	*
6	ITEMIDQUALIFIER	☐	/POSDW/ITEMIDQUALIFIER	/POSDW/ITEMIDQUALIFIER	CHAR	1	0	Qualifier for Article Identifier
7	ITEMID	☐	/POSDW/ITEMID	/POSDW/ITEMID	CHAR	18	0	Article Identifier
8	RETAILQUANTITY	☐	/POSDW/RETAILQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Sales Unit
9	SALESUOM	☐	/POSDW/SALESUNITOFMEASURE	MEINS	UNIT	3	0	Sales Unit	T006
10	SALESAMOUNT	☐	/POSDW/SALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Actual Retail Value
11	NORMALSALESAMT	☐	/POSDW/NORMALSALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Normal Sales Value
12	COST	☐	/POSDW/COST	/POSDW/CURRENCY	CURR	15	2	Costs
13	BATCHID	☐	/POSDW/BATCHID	/POSDW/CHAR10ALPHA	CHAR	10	0	Batch
14	SERIALNUMBER	☐	/POSDW/SERIALNUMBER	/POSDW/CHAR25ALPHA	CHAR	25	0	Serial Number
15	PROMOTIONID	☐	/POSDW/PROMOTIONID	/POSDW/CHAR10ALPHA	CHAR	10	0	Promotion Number
16	ENTRYMETHODCODE	☐	/POSDW/ITEMIDENTRYMETHODCODE		CHAR	4	0	Entry Method
17	ACTUALUNITPRICE	☐	/POSDW/ACTUALUNITPRICE	/POSDW/CURRENCY	CURR	15	2	Sales Price of Article per Unit
18	UNITS	☐	/POSDW/UNITS	/POSDW/QUANTITY	QUAN	13	3	Sales Quantity
19	SCANTIME	☐	/POSDW/SCANTIME	/POSDW/TIMESTAMP	CHAR	14	0	Timestamp of an retail line item scanned
20	LINEITEMVOID	☐	/POSDW/TT_LINEITEMVOID_TLOG		TTYP	0	0
21	DISCOUNT	☐	/POSDW/TT_DISCOUNT_TLOG		TTYP	0	0
22	TAX	☐	/POSDW/TT_TAX_TLOG		TTYP	0	0
23	COMMISSION	☐	/POSDW/TT_COMMISSION_TLOG		TTYP	0	0
24	EXTENSIONS	☐	/POSDW/TT_EXTENSIONS_TLOG		TTYP	0	0
25	RETAILADDITIONALS	☐	/POSDW/TT_RETAILADDITIONA_TLOG		TTYP	0	0
26	LOYALTY	☐	/POSDW/TT_LOYALTY_TLOG		TTYP	0	0
27	REFUNDDETAILS	☐	/POSDW/TT_REFUNDDETAILS_TLOG		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/POSDW/RETAILLINEITEM_TLOG	RETAILTYPECODE	/POSDW/RETTY	RETAILTYPECODE	KEY	1	CN
2	/POSDW/RETAILLINEITEM_TLOG	SALESUOM	T006	MSEHI	KEY

History

Last changed by/on	SAP	20111123
SAP Release Created in	30B