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

Here we would like to draw your attention to TWISPA_AVGRET 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_AVGRET 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_PLAN.

SAP TWISPA_AVGRET table

Table TWISPA_AVGRET technical data

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

SAP TWISPA_AVGRET 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_AVGRET table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PSWAE
    Its data type is C (Character String) with field length 5
  • AVRUMSGEO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • AVRUMSGVO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 10
  • AVRUMSGVP
    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
  • 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
  • BASME
    Its data type is C (Character String) with field length 3