SAP ABAP Table /POSDW/AGGR01 (Aggregate Record for Material/Stock)
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
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/AGGR01 |
Table Relationship Diagram 
|
| Short Description | Aggregate Record for Material/Stock |
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 | .INCLUDE |
0 | 0 | Primary Key of Aggregation Record (DO NOT EXTEND) | |||||
| 3 | .INCLUDE |
0 | 0 | Aggregation Group Key (DO NOT EXTEND) | |||||
| 4 | AGGR_NO |
/POSDW/AGGREGATE_NUMBER | /POSDW/AGGREGATE_NUMBER | INT4 | 10 | 0 | POS Aggregate Number | * | |
| 5 | GROUP_NO |
/POSDW/AGGR_GROUP_NUMBER | /POSDW/AGGR_GROUP_NUMBER | INT4 | 10 | 0 | Number of Aggregation Group | * | |
| 6 | RECORD_NO |
/POSDW/AGGR_REC_NUMBER | /POSDW/AGGR_REC_NUMBER | INT4 | 10 | 0 | Number of Aggregation Record Within Group | ||
| 7 | .INCLUDE |
0 | 0 | Key for Aggregation Level: Material/Stock | |||||
| 8 | MATERIALNUMBER |
/POSDW/MATERIALNUMBER | MATNR | CHAR | 18 | 0 | Material Number | ||
| 9 | SALESUOM |
/POSDW/SALESUNITOFMEASURE | MEINS | UNIT | 3 | 0 | Sales Unit | * | |
| 10 | CURRENCY |
/POSDW/TRANSACTIONCURRENCY | WAERS | CUKY | 5 | 0 | Transaction Currency | * | |
| 11 | GRKEY |
/POSDW/AGGR_GROUPING_KEY | /POSDW/AGGR_GROUPING_KEY | CHAR | 2 | 0 | Additional Grouping Key for Summarization | ||
| 12 | .INCLUDE |
0 | 0 | Record Data for Aggregation at Material/Stock Level | |||||
| 13 | TRAN_TS_MIN |
/POSDW/TIMESTAMP | /POSDW/TIMESTAMP | CHAR | 14 | 0 | Time Stamp | ||
| 14 | TRAN_TS_MAX |
/POSDW/TIMESTAMP | /POSDW/TIMESTAMP | CHAR | 14 | 0 | Time Stamp | ||
| 15 | BASEUOM |
/POSDW/BASEUNITOFMEASURE | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
| 16 | RETAILQUANTITY |
/POSDW/RETAILQUANTITY | /POSDW/QUANTITY | QUAN | 13 | 3 | Quantity in Sales Unit | ||
| 17 | SALESAMOUNT |
/POSDW/SALESAMOUNT | /POSDW/CURRENCY | CURR | 15 | 2 | Actual Retail Value | ||
| 18 | NORMALSALESAMT |
/POSDW/NORMALSALESAMOUNT | /POSDW/CURRENCY | CURR | 15 | 2 | Normal Sales Value | ||
| 19 | BASEQUANTITY |
/POSDW/BASEQUANTITY | /POSDW/QUANTITY | QUAN | 13 | 3 | Quantity in Base Unit of Measure | ||
| 20 | REC_ID |
/POSDW/AGGR_UNIQUE_RECID | INT4 | INT4 | 10 | 0 | Record Number Assigned Uniquely at Aggregate Level |
History
| Last changed by/on | SAP | 20100820 |
| SAP Release Created in | 712 |
