/POSDW/AGGR01 SAP table for – Aggregate Record for Material/Stock

Here we would like to draw your attention to /POSDW/AGGR01 table in SAP. As we know it is being mainly used with the SAP BW-BCT (Business Content and Extractors in BW) component which is coming under BW module (Business Warehouse). /POSDW/AGGR01 is a SAP standard transp table used for storing Aggregate Record for Material/Stock related data in SAP. It comes under the package /POSDW/CORE.

SAP /POSDW/AGGR01 table

Table /POSDW/AGGR01 technical data

Table/POSDW/AGGR01
Data storingAggregate Record for Material/Stock
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/CORE
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

SAP /POSDW/AGGR01 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in /POSDW/AGGR01 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary Key of Aggregation Record (DO NOT EXTEND)
    Its a key field.
  • .INCLUDE : Aggregation Group Key (DO NOT EXTEND)
    Its a key field.
  • AGGR_NO : POS Aggregate Number
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • GROUP_NO : Number of Aggregation Group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RECORD_NO : Number of Aggregation Record Within Group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Key for Aggregation Level: Material/Stock
  • MATERIALNUMBER : Material Number
    Its data type is CHAR (Character String) with field length 18
  • SALESUOM : Sales Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CURRENCY : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • GRKEY : Additional Grouping Key for Summarization
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Record Data for Aggregation at Material/Stock Level
  • TRAN_TS_MIN : Time Stamp
    Its data type is CHAR (Character String) with field length 14
  • TRAN_TS_MAX : Time Stamp
    Its data type is CHAR (Character String) with field length 14
  • BASEUOM : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • RETAILQUANTITY : Quantity in Sales Unit
    Its data type is QUAN (Quantity field) with field length 13
  • SALESAMOUNT : Actual Retail Value
    Its data type is CURR (Currency Field) with field length 15
  • NORMALSALESAMT : Normal Sales Value
    Its data type is CURR (Currency Field) with field length 15
  • BASEQUANTITY : Quantity in Base Unit of Measure
    Its data type is QUAN (Quantity field) with field length 13
  • REC_ID : Record Number Assigned Uniquely at Aggregate Level
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10