/POSDW/AGGRTI SAP table for – Index for Aggregate Record on POS Transaction

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

SAP /POSDW/AGGRTI table

Table /POSDW/AGGRTI technical data

Table/POSDW/AGGRTI
Data storingIndex for Aggregate Record on POS Transaction
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/CORE
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

SAP /POSDW/AGGRTI 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/AGGRTI 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
  • INDEX_NO : Index for Posting Date for Each Aggregation Record
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • TRANSINDEX : Transaction Index
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • VERSION : Version of POS Transaction
    Its a key field. Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • REVERSAL : Indicator for Reversed Lines in Aggregate
    Its data type is CHAR (Character String) with field length 1