SAP ABAP Table /POSDW/RETAILLINEITEM (Sales Item Data)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	/POSDW/RETAILLINEITEM	Table Relationship Diagram
Short Description	Sales Item Data

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
2	.INCLUDE	☐				0	0	Sales Item Data - Database Fields
3	.INCLUDE	☐				0	0	Salres Item Data - Database Fields (Key)
4	RETAILNUMBER	☐	/POSDW/RETAILSEQUENCENUMBER	/POSDW/SEQUENCENUMBER	CHAR	10	0	Sales Item Number
5	RETAILTYPECODE	☐	/POSDW/RETAILTYPECODE	/POSDW/RETAILTYPECODE	CHAR	4	0	Sales Item Type	/POSDW/RETTY
6	RETAILREASONCODE	☐	/POSDW/RETAILREASONCODE	/POSDW/REASONCODE	CHAR	4	0	Reason for Sales Transaction	/POSDW/REASON
7	ITEMIDQUALIFIER	☐	/POSDW/ITEMIDQUALIFIER	/POSDW/ITEMIDQUALIFIER	CHAR	1	0	Qualifier for Article Identifier
8	ITEMID	☐	/POSDW/ITEMID	/POSDW/ITEMID	CHAR	18	0	Article Identifier
9	RETAILQUANTITY	☐	/POSDW/RETAILQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Sales Unit
10	SALESUOM	☐	/POSDW/SALESUNITOFMEASURE	MEINS	UNIT	3	0	Sales Unit	T006
11	SALESAMOUNT	☐	/POSDW/SALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Actual Retail Value
12	NORMALSALESAMT	☐	/POSDW/NORMALSALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Normal Sales Value
13	COST	☐	/POSDW/COST	/POSDW/CURRENCY	CURR	15	2	Costs
14	BATCHID	☐	/POSDW/BATCHID	/POSDW/CHAR10ALPHA	CHAR	10	0	Batch
15	SERIALNUMBER	☐	/POSDW/SERIALNUMBER	/POSDW/CHAR25ALPHA	CHAR	25	0	Serial Number
16	PROMOTIONID	☐	/POSDW/PROMOTIONID	/POSDW/CHAR10ALPHA	CHAR	10	0	Promotion Number
17	ENTRYMETHODCODE	☐	/POSDW/ITEMIDENTRYMETHODCODE		CHAR	4	0	Entry Method
18	ACTUALUNITPRICE	☐	/POSDW/ACTUALUNITPRICE	/POSDW/CURRENCY	CURR	15	2	Sales Price of Article per Unit
19	UNITS	☐	/POSDW/UNITS	/POSDW/QUANTITY	QUAN	13	3	Sales Quantity
20	SCANTIME	☐	/POSDW/SCANTIME	/POSDW/TIMESTAMP	CHAR	14	0	Timestamp of an retail line item scanned
21	.INCLUDE	☐				0	0	Sales Item Data - Enhanced Fields
22	MATERIALNUMBER	☐	/POSDW/MATERIALNUMBER	MATNR	CHAR	18	0	Material Number
23	MERCHANDISECAT	☐	/POSDW/MERCHANDISECATEGORY	MATKL	CHAR	9	0	Material Group	*
24	BASEQUANTITY	☐	/POSDW/BASEQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Base Unit of Measure
25	BASEUOM	☐	/POSDW/BASEUNITOFMEASURE	MEINS	UNIT	3	0	Base Unit of Measure	T006
26	RETAILTYPEGROUP	☐	/POSDW/RETAILTYPEGROUP	/POSDW/RETAILTYPEGROUP	CHAR	4	0	Sales Item Type Group	/POSDW/RETTG
27	RETAILDEBITFLAG	☐	/POSDW/DEBITFLAG	/POSDW/DEBITFLAG	CHAR	1	0	Debit/Credit Indicator
28	RETAILREASONGRP	☐	/POSDW/REASONGROUP	/POSDW/REASONGROUP	CHAR	4	0	Group for Reasons	/POSDW/REASG
29	RETL_ITEM_CAT	☐	/POSDW/RETAIL_ITEM_CATEGORY	/POSDW/ITEM_CATEGORY	CHAR	1	0	Classification of Sales Item: Category	*
30	RETL_ITEM_SCAT	☐	/POSDW/RETAIL_ITEM_SUBCATEGORY	/POSDW/ITEM_SUBCATEGORY	CHAR	1	0	Classification of Sales Item: Subcategory	*
31	.INCLUDE	☐				0	0	Sales Item Data Table Fields
32	LINEITEMVOID	☐	/POSDW/TT_LINEITEMVOID		TTYP	0	0
33	DISCOUNT	☐	/POSDW/TT_DISCOUNT		TTYP	0	0
34	TAX	☐	/POSDW/TT_TAX		TTYP	0	0
35	COMMISSION	☐	/POSDW/TT_COMMISSION		TTYP	0	0
36	EXTENSIONS	☐	/POSDW/TT_EXTENSIONS		TTYP	0	0
37	RETAILADDITIONALS	☐	/POSDW/TT_RETAILADDITIONALS		TTYP	0	0
38	LOYALTY	☐	/POSDW/TT_LOYALTY		TTYP	0	0
39	REFUNDDETAILS	☐	/POSDW/TT_REFUNDDETAILS		TTYP	0	0
40	.INCLUDE	☐				0	0	User Interface Data for Retail Transaction
41	.INCLUDE	☐				0	0	Additional Information at Segment Level
42	NAV_ITEM_QUAL	☐	/POSDW/NAV_ITEM_QUAL	INT4	INT4	10	0	Item Qualifier for Navigation in Raw Editor
43	MESSAGE	☐	/POSDW/TT_NAVI_MESSAGE		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/POSDW/RETAILLINEITEM	BASEUOM	T006	MSEHI	KEY	1	CN
2	/POSDW/RETAILLINEITEM	RETAILREASONCODE	/POSDW/REASON	REASONCODE	KEY	1	CN
3	/POSDW/RETAILLINEITEM	RETAILREASONGRP	/POSDW/REASG	REASONGROUP	KEY	1	CN
4	/POSDW/RETAILLINEITEM	RETAILTYPECODE	/POSDW/RETTY	RETAILTYPECODE	KEY	1	CN
5	/POSDW/RETAILLINEITEM	RETAILTYPEGROUP	/POSDW/RETTG	RETAILTYPEGROUP	KEY	1	CN
6	/POSDW/RETAILLINEITEM	SALESUOM	T006	MSEHI	KEY

History

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