SAP ABAP Table /POSDW/V_AGGR_GR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/POSDW/V_AGGR_GR	Table Relationship Diagram
Short Description	Generated Table for View

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

History

Last changed by/on	SAP	20100326
SAP Release Created in