SAP ABAP Table /POSDW/AGGR (POS Aggregate)

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	TRANSP	Transparent table
Transparent table	/POSDW/AGGR	Table Relationship Diagram
Short Description	POS Aggregate

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	AGGR_NO	☑	/POSDW/AGGREGATE_NUMBER	/POSDW/AGGREGATE_NUMBER	INT4	10	0	POS Aggregate Number
3	RETAILSTOREID	☐	/POSDW/RETAILSTOREID	/POSDW/RETAILSTOREID	CHAR	10	0	Store
4	AGGR_LEVEL	☐	/POSDW/AGGREGATION_LEVEL	/POSDW/AGGREGATION_LEVEL	CHAR	4	0	Aggregation Level	/POSDW/AGLV
5	AGGR_TASK	☐	/POSDW/AGGREGATION_TASK	/POSDW/TASKCODE	CHAR	4	0	Task Used to Aggregate Data	/POSDW/TASKS
6	COMPRESSPERIOD	☐	/POSDW/COMPRESSPERIOD	/POSDW/COMPRESSPERIOD	CHAR	2	0	Aggregation Period: Grouping Criteria for Aggregation	/POSDW/AGPE
7	TIMESTAMP_OPEN	☐	/POSDW/AGGR_TIMESTAMP_OPEN	TZNTSTMPS	DEC	15	0	Time at Which Aggregate Was Created
8	TIMESTAMP_CHANGE	☐	/POSDW/AGGR_TIMESTAMP_CHANGED	TZNTSTMPS	DEC	15	0	Time at Which Aggregate Was Last Changed
9	TIMESTAMP_CLOSE	☐	/POSDW/AGGR_TIMESTAMP_CLOSE	TZNTSTMPS	DEC	15	0	Time at Which Aggregate Was Closed
10	USER_CREATE	☐	/POSDW/AGGREGATE_USER_CREATED	UNAME	CHAR	12	0	User Who Created POS Aggregate
11	USER_CHANGE	☐	/POSDW/AGGREGATE_USER_CHANGED	UNAME	CHAR	12	0	User Who Made Last Change
12	STATUS	☐	/POSDW/AGGREGATE_STATUS	/POSDW/AGGREGATE_STATUS	CHAR	1	0	Processing Status of POS Aggregate
13	PACK_COUNTER	☐	/POSDW/AGGR_PACK_COUNTER	/POSDW/AGGR_PACK_COUNTER	INT4	10	0	Number of Packages in Aggregate
14	RECBUSD_COUNTER	☐	/POSDW/AGGR_RECBUSD_COUNTER	/POSDW/AGGR_RECBUSD_INDEX	INT4	10	0	Index for Posting Date for Each Aggr. Record (Counter Stat.)
15	GROUP_COUNTER	☐	/POSDW/AGGR_GROUP_COUNTER	/POSDW/AGGR_GROUP_NUMBER	INT4	10	0	Number of Aggregation Group (Counter Status)	*
16	REC_ID_COUNTER	☐	/POSDW/AGGR_UNIQUE_RECID_COUNT	INT4	INT4	10	0	Counter Status of Unique Record Number in Aggregate
17	INDEX_AVAIL	☐	/POSDW/AGGR_TRANS_INDEX_AVAIL	BOOLE	CHAR	1	0	Aggregation Index for POS Transactions Exists
18	BUSINESSDAY_MIN	☐	/POSDW/AGGR_BUSINESSDAY_MIN	/POSDW/DATE	DATS	8	0	Minimum Posting Date for Data in Aggregate
19	BUSINESSDAY_MAX	☐	/POSDW/AGGR_BUSINESSDAY_MAX	/POSDW/DATE	DATS	8	0	Maximum Posting Date for Data in Aggregate
20	PACK_COUNT_PROC	☐	/POSDW/AGGR_PACK_CNT_PROC	/POSDW/AGGR_PACK_COUNTER	INT4	10	0	Number of Processed Packages in Aggregate
21	PACK_COUNT_1	☐	/POSDW/AGGR_PACK_COUNT_1		INT4	10	0	Number of Aggregate Packages with OK Status
22	PACK_COUNT_2	☐	/POSDW/AGGR_PACK_COUNT_2		INT4	10	0	Number of Aggregate Packages with Unprocessed Status
23	PACK_COUNT_3	☐	/POSDW/AGGR_PACK_COUNT_3		INT4	10	0	Number of Aggregate Packages with Status With Warning
24	PACK_COUNT_4	☐	/POSDW/AGGR_PACK_COUNT_4		INT4	10	0	Number of Aggregate Packages with Error Status
25	CROSS_STORE	☐	/POSDW/AGGR_CROSS_STORE	BOOLE	CHAR	1	0	Cross-Store Aggregation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/POSDW/AGGR	AGGR_LEVEL	/POSDW/AGLV	AGGR_LEVEL	REF	1	CN
2	/POSDW/AGGR	AGGR_TASK	/POSDW/TASKS	TASKCODE	REF
3	/POSDW/AGGR	COMPRESSPERIOD	/POSDW/AGPE	COMPRESSPERIOD	REF	1	CN

History

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