SAP ABAP Table /POSDW/RETAILLINEITEM_FI (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_FI	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 - 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	.INCLUDE	☐				0	0	Sales Item Data - Enhanced Fields
21	MATERIALNUMBER	☐	/POSDW/MATERIALNUMBER	MATNR	CHAR	18	0	Material Number
22	MERCHANDISECAT	☐	/POSDW/MERCHANDISECATEGORY	MATKL	CHAR	9	0	Material Group	*
23	BASEQUANTITY	☐	/POSDW/BASEQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Base Unit of Measure
24	BASEUOM	☐	/POSDW/BASEUNITOFMEASURE	MEINS	UNIT	3	0	Base Unit of Measure	T006
25	RETAILTYPEGROUP	☐	/POSDW/RETAILTYPEGROUP	/POSDW/RETAILTYPEGROUP	CHAR	4	0	Sales Item Type Group	*
26	RETAILDEBITFLAG	☐	/POSDW/DEBITFLAG	/POSDW/DEBITFLAG	CHAR	1	0	Debit/Credit Indicator
27	RETAILREASONGRP	☐	/POSDW/REASONGROUP	/POSDW/REASONGROUP	CHAR	4	0	Group for Reasons	/POSDW/REASG
28	RETL_ITEM_CAT	☐	/POSDW/RETAIL_ITEM_CATEGORY	/POSDW/ITEM_CATEGORY	CHAR	1	0	Classification of Sales Item: Category	*
29	RETL_ITEM_SCAT	☐	/POSDW/RETAIL_ITEM_SUBCATEGORY	/POSDW/ITEM_SUBCATEGORY	CHAR	1	0	Classification of Sales Item: Subcategory	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/POSDW/RETAILLINEITEM_FI	BASEUOM	T006	MSEHI	KEY	1	CN
2	/POSDW/RETAILLINEITEM_FI	RETAILREASONGRP	/POSDW/REASG	REASONGROUP	KEY	1	CN
3	/POSDW/RETAILLINEITEM_FI	RETAILTYPECODE	/POSDW/RETTY	RETAILTYPECODE	KEY	1	CN
4	/POSDW/RETAILLINEITEM_FI	SALESUOM	T006	MSEHI	KEY

History

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