TXW_S_MSEG - Retrieve MSEG from archive

Retrieve MSEG from archive information is stored in SAP table TXW_S_MSEG.
It is part of development package FTW1 in software component CA-GTF-DRT. This development package consists of objects that can be grouped under "Data Retention Tool".

Fields for table TXW_S_MSEG

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
TXW_MANDT	Client	X	MANDT	CLNT	6
TXW_MBLNR	Number of Material Document	X	MBLNR	CHAR	20
TXW_MJAHR	Material Document Year	X	MJAHR	NUMC	8
TXW_ZEILE	Item in Material Document	X	MBLPO	NUMC	8
.INCLUDE				TXW_MM_POS	0
MANDT	Client		MANDT	CLNT	6	*
BUKRS	Company Code		BUKRS	CHAR	8
GJAHR	Fiscal Year		GJAHR	NUMC	8
MBLNR	Number of Material Document		MBLNR	CHAR	20
MJAHR	Material Document Year		MJAHR	NUMC	8
MONAT	Fiscal period		MONAT	NUMC	4
BWART	Movement type (inventory management)		BWART	CHAR	6	*
MATNR	Material Number		MATNR	CHAR	80
WERKS	Plant		WERKS_D	CHAR	8
LGORT	Storage location		LGORT_D	CHAR	8	*
CHARG	Batch Number		CHARG_D	CHAR	20	*
EBELN	Purchasing Document Number		EBELN	CHAR	20
EBELP	Item Number of Purchasing Document		EBELP	NUMC	10	*
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
DMBTR	Amount in Local Currency		TXW_DMBTR	CHAR	62
MEINS	Base Unit of Measure		MEINS	UNIT	6	*
MENGE	Total quantity		TXW_QUANT	CHAR	32
BWTAR	Valuation Type		BWTAR_D	CHAR	20	*
SAKTO	Cost element		SAKTO	CHAR	20	*
LIFNR	Account Number of Supplier		LIFNR	CHAR	20
KUNNR	Customer Number		KUNNR	CHAR	20
GSBER	Business Area		GSBER	CHAR	8	*
ANLN1	Main Asset Number		ANLN1	CHAR	24	*
ANLN2	Asset Subnumber		ANLN2	CHAR	8	*
AUFNR	Order Number		AUFNR	CHAR	24	*
EMLIF	Supplier to be Supplied/Who is to Receive Delivery		EMLIF	CHAR	20	*
FKBER	Functional Area		FKBER	CHAR	32	*
GRUND	Reason for Manual Valuation of Net Assets		GRUND	CHAR	6	*
KDAUF	Sales Order Number		KDAUF	CHAR	20
KDEIN	Delivery schedule for sales order		KDEIN	NUMC	8
KDPOS	Item number in Sales Order		KDPOS	NUMC	12
KOKRS	Controlling Area		KOKRS	CHAR	8	*
KOSTL	Cost Center		KOSTL	CHAR	20	*
KZBEW	Movement Indicator		KZBEW	CHAR	2
NPLNR	Network Number for Account Assignment		NPLNR	CHAR	24	*
PARBU	Clearing company code		PARBU	CHAR	8	*
PARGB	Trading partner's business area		PARGB	CHAR	8	*
PPRCTR	Partner Profit Center		PPRCTR	CHAR	20	*
PRCTR	Profit Center		PRCTR	CHAR	20
PROJN	Old: Project number : No longer used --> PS_POSNR		PROJN	CHAR	32
WBS_POSID	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
SGTXT	Item Text		SGTXT	CHAR	100
SHKUM	Debit/credit indicator in revaluation		SHKUM	CHAR	2
SOBKZ	Special Stock Indicator		SOBKZ	CHAR	2	*
UMMAT	Receiving/Issuing Material		UMMAT	CHAR	80	*
UMWRK	Receiving plant/issuing plant		UMWRK	CHAR	8	*
VPTNR	Partner account number		JV_PART	CHAR	20	*
WAERS	Currency Key		WAERS	CUKY	10	*
WEUNB	Goods Receipt, Non-Valuated		WEUNB	CHAR	2
XRUEJ	Indicator: post to previous year		XRUEJ	CHAR	2
XRUEM	Allow Posting to Previous Period (Backposting)		XRUEM	CHAR	2
BNBTR	Delivery costs in LC		TXW_BNBTR	CHAR	32
DMBUM	Revaluation amount on back-posting to previous period		TXW_DMBUM	CHAR	32
LBKUM	Total valuated stock		TXW_LBKUM	CHAR	32
SALK3	Value of total of valuated stock		TXW_SALK3	CHAR	32
KZZUG	Receipt Indicator		KZZUG	CHAR	2
KZVBR	Consumption posting		KZVBR	CHAR	2
ERFMG	Quantity in Unit of Entry		TXW_ERFMG	CHAR	32
ERFME	Unit of entry		ERFME	UNIT	6	*
.INCLUDE				CI_MM_POS	0
.INCLUDE				CI_TXWMSEG	0