SAP ABAP Table /POSDW/SALES_QUERY_DATA (Return Structure for Sales Query)

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/SALES_QUERY_DATA	Table Relationship Diagram
Short Description	Return Structure for Sales Query

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	MATERIAL_STOCK	☐	/POSDW/MATERIALSTOCK		STRU	0	0
2	MATERIALNUMBER	☐	/POSDW/MATERIALNUMBER	MATNR	CHAR	18	0	Material Number
3	SALESUOM	☐	/POSDW/SALESUNITOFMEASURE	MEINS	UNIT	3	0	Sales Unit
4	LOCATIONID	☐	/POSDW/LOCATIONID	/POSDW/CHAR04ALPHA	CHAR	4	0	Storage Location
5	BATCHID	☐	/POSDW/BATCHID	/POSDW/CHAR10ALPHA	CHAR	10	0	Batch
6	SPECIALSTOCKCODE	☐	/POSDW/SPECIALSTOCKCODE		CHAR	1	0	Special Stock Indicator
7	SUPPLIERID	☐	/POSDW/SUPPLIERID	LIFNR	CHAR	10	0	Vendor Number
8	UNPROC_TRANSACTIONS	☐	/POSDW/UNPROC_TRANSACTIONS	BOOLE	CHAR	1	0	Unprocessed POS Transactions Exist
9	SALES_PROC	☐	/POSDW/TT_SALES_ITEM_PROC		TTYP	0	0
10	SALES_UNPROC	☐	/POSDW/SALES_ITEM_DET_AGG		STRU	0	0
11	SALES_ITEMS	☐	/POSDW/TT_SALES_ITEM		TTYP	0	0
12	RETAILQUANTITY_AGG	☐	/POSDW/S_RETAILQUANTITY		STRU	0	0
13	SALESUOM	☐	/POSDW/SALESUNITOFMEASURE	MEINS	UNIT	3	0	Sales Unit
14	RETAILQUANTITY	☐	/POSDW/RETAILQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Sales Unit
15	SALESAMOUNT_AGG	☐	/POSDW/TT_SALESAMOUNT		TTYP	0	0

History

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