SAP ABAP Table /POSDW/AGGR01_1_AGGR_STRUC (Internal Structure for Aggregation (Aggregation Level 01))

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/AGGR01_1_AGGR_STRUC	Table Relationship Diagram
Short Description	Internal Structure for Aggregation (Aggregation Level 01)

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	GROUP_STRING	☐	/POSDW/AGGR_GROUP_STRING		CHAR	20	0	Characteristic/String of Aggregation Group
2	.INCLUDE	☐				0	0	Aggregate Record for Material/Stock
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	.INCLUDE	☐				0	0	Primary Key of Aggregation Record (DO NOT EXTEND)
5	.INCLUDE	☐				0	0	Aggregation Group Key (DO NOT EXTEND)
6	AGGR_NO	☐	/POSDW/AGGREGATE_NUMBER	/POSDW/AGGREGATE_NUMBER	INT4	10	0	POS Aggregate Number	*
7	GROUP_NO	☐	/POSDW/AGGR_GROUP_NUMBER	/POSDW/AGGR_GROUP_NUMBER	INT4	10	0	Number of Aggregation Group	*
8	RECORD_NO	☐	/POSDW/AGGR_REC_NUMBER	/POSDW/AGGR_REC_NUMBER	INT4	10	0	Number of Aggregation Record Within Group
9	.INCLUDE	☐				0	0	Key for Aggregation Level: Material/Stock
10	MATERIALNUMBER	☐	/POSDW/MATERIALNUMBER	MATNR	CHAR	18	0	Material Number
11	SALESUOM	☐	/POSDW/SALESUNITOFMEASURE	MEINS	UNIT	3	0	Sales Unit	*
12	CURRENCY	☐	/POSDW/TRANSACTIONCURRENCY	WAERS	CUKY	5	0	Transaction Currency	*
13	GRKEY	☐	/POSDW/AGGR_GROUPING_KEY	/POSDW/AGGR_GROUPING_KEY	CHAR	2	0	Additional Grouping Key for Summarization
14	.INCLUDE	☐				0	0	Record Data for Aggregation at Material/Stock Level
15	TRAN_TS_MIN	☐	/POSDW/TIMESTAMP	/POSDW/TIMESTAMP	CHAR	14	0	Time Stamp
16	TRAN_TS_MAX	☐	/POSDW/TIMESTAMP	/POSDW/TIMESTAMP	CHAR	14	0	Time Stamp
17	BASEUOM	☐	/POSDW/BASEUNITOFMEASURE	MEINS	UNIT	3	0	Base Unit of Measure	*
18	RETAILQUANTITY	☐	/POSDW/RETAILQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Sales Unit
19	SALESAMOUNT	☐	/POSDW/SALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Actual Retail Value
20	NORMALSALESAMT	☐	/POSDW/NORMALSALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Normal Sales Value
21	BASEQUANTITY	☐	/POSDW/BASEQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Base Unit of Measure
22	REC_ID	☐	/POSDW/AGGR_UNIQUE_RECID	INT4	INT4	10	0	Record Number Assigned Uniquely at Aggregate Level
23	TAX	☐	/POSDW/TT_AGGR11_1_AGGR_STRUC		TTYP	0	0
24	DISCOUNT	☐	/POSDW/TT_AGGR12_1_AGGR_STRUC		TTYP	0	0
25	TENDER	☐	/POSDW/TT_AGGR13_1_AGGR_STRUC		TTYP	0	0
26	TRANSSOURCE	☐	/POSDW/TT_TRANSSOURCE		TTYP	0	0

History

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