TWISPA_AVERAGERT - Merchandise and Assortment Planning: Average Retail

Merchandise and Assortment Planning: Average Retail information is stored in SAP table TWISPA_AVERAGERT.
It is part of development package WIS_PLANB in software component LO-RFM-OBS. This development package consists of objects that can be grouped under "Merchandise and Assortment Planning, Enterprise Add-On".

Fields for table TWISPA_AVERAGERT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
WGRU2	Material group hierarchy 2	X	MCW_WGRU2	CHAR	36
WGRU1	Material group hierarchy 1	X	MCW_WGRU1	CHAR	36
MATKL	Material Group	X	MATKL	CHAR	18	*
MATNR	Material Number	X	MATNR	CHAR	80	*
ASORT	Assortment	X	ASORT	CHAR	20	*
MERK1	Characteristic 1		MCW_MERK1	CHAR	140
MERK2	Characteristic 2		MCW_MERK2	CHAR	140
MERK3	Characteristic 3		MCW_MERK3	CHAR	140
PLGTP	Price Band Category		PLGTP	CHAR	4	*
LIFNR	Account Number of Supplier		LIFNR	CHAR	20	*
BASME	Base Unit of Measure for BOM		BASME	UNIT	6	*
PSWAE	Database Currency for Planning Data in a Planning Scenario		WISP_PSWAE	CUKY	10	*
AVGDATE	MAP: Date of Average Price Calculation		WISP_AVGDAT	DATS	16
AVGRET1	MAP: Average Price		WISP_AVGRET	CURR	10
AVGRET2	MAP: Average Price		WISP_AVGRET	CURR	10
AVGRET3	MAP: Average Price		WISP_AVGRET	CURR	10