/POSDW/AGGRP SAP table for – Aggregation Package

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

SAP /POSDW/AGGRP table

Table /POSDW/AGGRP technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key of Aggregation Package (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
  • PACK_NO : Number of Aggregation Package Within POS Aggregate
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PACK_GUID : Unique Key (GUID) for Aggregation Package
    Its data type is RAW (Byte string) with field length 16
  • OUTBOUND_TASK : Task for Outbound Processing
    Its data type is CHAR (Character String) with field length 4
  • RETAILSTOREID : Store
    Its data type is CHAR (Character String) with field length 10
  • RECORD_NO_FROM : Number of First Record in Package
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • RECORD_NO_TO : Number of Last Record in Package
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • LAST_OUTB_RUN : Number of Last Processing Run
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • CONFIRMED_TS : Time at Which Package Was Confirmed
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • PROCESSED_TS : Time at Which Package Is Processed
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • MSG_STATUS : Status of Aggregate Package as to Messages
    Its data type is CHAR (Character String) with field length 1
  • STATUS : Processing Status of Aggregation Package
    Its data type is CHAR (Character String) with field length 1