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