TWISPA_AVERAGERT SAP table for – Merchandise and Assortment Planning: Average Retail

Here we would like to draw your attention to TWISPA_AVERAGERT table in SAP. As we know it is being mainly used with the SAP LO-MAP (Merchandise and Assortment Planning in LO) component which is coming under LO module (Logistics). TWISPA_AVERAGERT is a SAP standard transparent table used for storing Merchandise and Assortment Planning: Average Retail related data in SAP. It comes under the package WIS_PLANB.

SAP TWISPA_AVERAGERT table

Table TWISPA_AVERAGERT technical data

TableTWISPA_AVERAGERT
Data storingMerchandise and Assortment Planning: Average Retail
ModuleLO
ComponentLO-MAP
SAP PackageWIS_PLANB
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP TWISPA_AVERAGERT Table Fields

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PLGTP
    Its data type is C (Character String) with field length 2
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • BASME
    Its data type is C (Character String) with field length 3
  • PSWAE
    Its data type is C (Character String) with field length 5
  • AVGDATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AVGRET1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • AVGRET2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • AVGRET3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • WGRU2
    Its a key field. Its data type is C (Character String) with field length 18
  • WGRU1
    Its a key field. Its data type is C (Character String) with field length 18
  • MATKL : Material Group
    Its a key field. Its data type is C (Character String) with field length 9
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • ASORT
    Its a key field. Its data type is C (Character String) with field length 10
  • MERK1
    Its data type is C (Character String) with field length 30
  • MERK2
    Its data type is C (Character String) with field length 30
  • MERK3
    Its data type is C (Character String) with field length 30