SAP ABAP View /POSDW/V_AGGR_GR (View for Aggregate / Store Group)
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
⤷
/POSDW/DATABASE (Package) PIPE Database
BI_CONT (Software Component) Business Intelligence Content⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine⤷
/POSDW/DATABASE (Package) PIPE Database
Basic Data
| View Type | D | Database View |
| Database View | /POSDW/V_AGGR_GR | |
| Short Description | View for Aggregate / Store Group | |
| Root table | /POSDW/AGGR | POS Aggregate |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /POSDW/AGGR |
/POSDW/AGGR | ||
| 2 | /POSDW/STOGRC |
|||
| 3 | /POSDW/STORE |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /POSDW/STOGRC |
MANDT | JL | EQ | 0 | 0 | ||||
| 2 | /POSDW/STORE |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | /POSDW/STOGRC |
STORE_CLASS | JL | EQ | 0 | 0 | ||||
| 4 | /POSDW/STORE |
STORE_CLASS | JR | EQ | AND | 0 | 0 | |||
| 5 | /POSDW/STORE |
MANDT | JL | EQ | 0 | 0 | ||||
| 6 | /POSDW/AGGR |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 7 | /POSDW/STORE |
RETAILSTOREID | JL | EQ | 0 | 0 | ||||
| 8 | /POSDW/AGGR |
RETAILSTOREID | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
/POSDW/AGGR |
MANDT | MANDT | Client | |||
| 2 | AGGR_NO |
/POSDW/AGGR |
AGGR_NO | /POSDW/AGGREGATE_NUMBER | POS Aggregate Number | |||
| 3 | RETAILSTOREID |
/POSDW/AGGR |
RETAILSTOREID | /POSDW/RETAILSTOREID | Store | |||
| 4 | STORE_GROUP |
/POSDW/STOGRC |
STORE_GROUP | /POSDW/RETAILSTORE_GROUP | Store Group | |||
| 5 | STORE_CLASS |
/POSDW/STOGRC |
STORE_CLASS | /POSDW/RETAILSTORE_CLASS | Store Class | |||
| 6 | AGGR_LEVEL |
/POSDW/AGGR |
AGGR_LEVEL | /POSDW/AGGREGATION_LEVEL | Aggregation Level | |||
| 7 | AGGR_TASK |
/POSDW/AGGR |
AGGR_TASK | /POSDW/AGGREGATION_TASK | Task Used to Aggregate Data | |||
| 8 | COMPRESSPERIOD |
/POSDW/AGGR |
COMPRESSPERIOD | /POSDW/COMPRESSPERIOD | Aggregation Period: Grouping Criteria for Aggregation | |||
| 9 | TIMESTAMP_OPEN |
/POSDW/AGGR |
TIMESTAMP_OPEN | /POSDW/AGGR_TIMESTAMP_OPEN | Time at Which Aggregate Was Created | |||
| 10 | TIMESTAMP_CHANGE |
/POSDW/AGGR |
TIMESTAMP_CHANGE | /POSDW/AGGR_TIMESTAMP_CHANGED | Time at Which Aggregate Was Last Changed | |||
| 11 | TIMESTAMP_CLOSE |
/POSDW/AGGR |
TIMESTAMP_CLOSE | /POSDW/AGGR_TIMESTAMP_CLOSE | Time at Which Aggregate Was Closed | |||
| 12 | USER_CREATE |
/POSDW/AGGR |
USER_CREATE | /POSDW/AGGREGATE_USER_CREATED | User Who Created POS Aggregate | |||
| 13 | USER_CHANGE |
/POSDW/AGGR |
USER_CHANGE | /POSDW/AGGREGATE_USER_CHANGED | User Who Made Last Change | |||
| 14 | STATUS |
/POSDW/AGGR |
STATUS | /POSDW/AGGREGATE_STATUS | Processing Status of POS Aggregate | |||
| 15 | PACK_COUNTER |
/POSDW/AGGR |
PACK_COUNTER | /POSDW/AGGR_PACK_COUNTER | Number of Packages in Aggregate | |||
| 16 | RECBUSD_COUNTER |
/POSDW/AGGR |
RECBUSD_COUNTER | /POSDW/AGGR_RECBUSD_COUNTER | Index for Posting Date for Each Aggr. Record (Counter Stat.) | |||
| 17 | GROUP_COUNTER |
/POSDW/AGGR |
GROUP_COUNTER | /POSDW/AGGR_GROUP_COUNTER | Number of Aggregation Group (Counter Status) | |||
| 18 | REC_ID_COUNTER |
/POSDW/AGGR |
REC_ID_COUNTER | /POSDW/AGGR_UNIQUE_RECID_COUNT | Counter Status of Unique Record Number in Aggregate | |||
| 19 | INDEX_AVAIL |
/POSDW/AGGR |
INDEX_AVAIL | /POSDW/AGGR_TRANS_INDEX_AVAIL | Aggregation Index for POS Transactions Exists | |||
| 20 | BUSINESSDAY_MIN |
/POSDW/AGGR |
BUSINESSDAY_MIN | /POSDW/AGGR_BUSINESSDAY_MIN | Minimum Posting Date for Data in Aggregate | |||
| 21 | BUSINESSDAY_MAX |
/POSDW/AGGR |
BUSINESSDAY_MAX | /POSDW/AGGR_BUSINESSDAY_MAX | Maximum Posting Date for Data in Aggregate | |||
| 22 | PACK_COUNT_PROC |
/POSDW/AGGR |
PACK_COUNT_PROC | /POSDW/AGGR_PACK_CNT_PROC | Number of Processed Packages in Aggregate | |||
| 23 | PACK_COUNT_1 |
/POSDW/AGGR |
PACK_COUNT_1 | /POSDW/AGGR_PACK_COUNT_1 | Number of Aggregate Packages with OK Status | |||
| 24 | PACK_COUNT_2 |
/POSDW/AGGR |
PACK_COUNT_2 | /POSDW/AGGR_PACK_COUNT_2 | Number of Aggregate Packages with Unprocessed Status | |||
| 25 | PACK_COUNT_3 |
/POSDW/AGGR |
PACK_COUNT_3 | /POSDW/AGGR_PACK_COUNT_3 | Number of Aggregate Packages with Status With Warning | |||
| 26 | PACK_COUNT_4 |
/POSDW/AGGR |
PACK_COUNT_4 | /POSDW/AGGR_PACK_COUNT_4 | Number of Aggregate Packages with Error Status | |||
| 27 | CROSS_STORE |
/POSDW/AGGR |
CROSS_STORE | /POSDW/AGGR_CROSS_STORE | Cross-Store Aggregation | |||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
| Last changed by/on | SAP | 20100326 |
| SAP Release Created in | 705 |
