/POSDW/AGGR SAP table for – POS Aggregate

Here we would like to draw your attention to /POSDW/AGGR 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/AGGR is a SAP standard transp table used for storing POS Aggregate related data in SAP. It comes under the package /POSDW/CORE.

SAP /POSDW/AGGR table

Table /POSDW/AGGR technical data

Table/POSDW/AGGR
Data storingPOS Aggregate
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/CORE
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

SAP /POSDW/AGGR 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/AGGR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • AGGR_NO : POS Aggregate Number
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RETAILSTOREID : Store
    Its data type is CHAR (Character String) with field length 10
  • AGGR_LEVEL : Aggregation Level
    Its data type is CHAR (Character String) with field length 4
  • AGGR_TASK : Task Used to Aggregate Data
    Its data type is CHAR (Character String) with field length 4
  • COMPRESSPERIOD : Aggregation Period: Grouping Criteria for Aggregation
    Its data type is CHAR (Character String) with field length 2
  • TIMESTAMP_OPEN : Time at Which Aggregate Was Created
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TIMESTAMP_CHANGE : Time at Which Aggregate Was Last Changed
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TIMESTAMP_CLOSE : Time at Which Aggregate Was Closed
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • USER_CREATE : User Who Created POS Aggregate
    Its data type is CHAR (Character String) with field length 12
  • USER_CHANGE : User Who Made Last Change
    Its data type is CHAR (Character String) with field length 12
  • STATUS : Processing Status of POS Aggregate
    Its data type is CHAR (Character String) with field length 1
  • PACK_COUNTER : Number of Packages in Aggregate
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RECBUSD_COUNTER : Index for Posting Date for Each Aggr. Record (Counter Stat.)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • GROUP_COUNTER : Number of Aggregation Group (Counter Status)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • REC_ID_COUNTER : Counter Status of Unique Record Number in Aggregate
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • INDEX_AVAIL : Aggregation Index for POS Transactions Exists
    Its data type is CHAR (Character String) with field length 1
  • BUSINESSDAY_MIN : Minimum Posting Date for Data in Aggregate
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUSINESSDAY_MAX : Maximum Posting Date for Data in Aggregate
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PACK_COUNT_PROC : Number of Processed Packages in Aggregate
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PACK_COUNT_1 : Number of Aggregate Packages with OK Status
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PACK_COUNT_2 : Number of Aggregate Packages with Unprocessed Status
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PACK_COUNT_3 : Number of Aggregate Packages with Status With Warning
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PACK_COUNT_4 : Number of Aggregate Packages with Error Status
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CROSS_STORE : Cross-Store Aggregation
    Its data type is CHAR (Character String) with field length 1