TXW_S_BSEG - Retrieve BSEG from archive

Retrieve BSEG from archive information is stored in SAP table TXW_S_BSEG.
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_BSEG

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
TXW_MANDT	Client	X	MANDT	CLNT	6
TXW_BUKRS	Company Code	X	BUKRS	CHAR	8
TXW_BELNR	Document Number of an Accounting Document	X	BELNR_D	CHAR	20
TXW_GJAHR	Fiscal Year	X	GJAHR	NUMC	8
TXW_BUZEI	Number of Line Item Within Accounting Document	X	BUZEI	NUMC	6
TXW_XNEGP	Indicator: Negative Posting		XNEGP	CHAR	2
.INCLUDE				TXW_FI_POS	0
MANDT	Client		MANDT	CLNT	6	*
BUKRS	Company Code		BUKRS	CHAR	8
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
GJAHR	Fiscal Year		GJAHR	NUMC	8
MONAT	Fiscal period		MONAT	NUMC	4
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
BSCHL	Posting Key		BSCHL	CHAR	4	*
KOART	Account type		KOART	CHAR	2
UMSKZ	Special G/L Indicator		UMSKZ	CHAR	2	*
HKONT	General Ledger Account		HKONT	CHAR	20	*
GSBER	Business Area		GSBER	CHAR	8	*
VBUND	Trading Partner		TXW_VBUND	CHAR	12	*
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
WRBTR	Amount in document currency (TC)		TXW_WRBTR	CHAR	62
DMBTR	Amount in Local Currency		TXW_DMBTR	CHAR	62
DMBE2	Amount in second local currency (LC2)		TXW_DMBE2	CHAR	62
DMBE3	Amount in third local currency (LC3)		TXW_DMBE3	CHAR	62
WSKTO	Cash discount amount in document currency		TXW_WSKTO	CHAR	62
SKNTO	Cash discount amount in local currency		TXW_SKNTO	CHAR	62
SKNT2	Cash discount amount in second local currency (LC2)		TXW_SKNT2	CHAR	62
SKNT3	Cash discount amount in third local currency (LC3)		TXW_SKNT3	CHAR	62
LIFNR	Account Number of Supplier		LIFNR	CHAR	20
KUNNR	Customer Number		KUNNR	CHAR	20
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30	*
MEINS	Base Unit of Measure		MEINS	UNIT	6	*
MENGE	Total quantity		TXW_QUANT	CHAR	32
KOKRS	Controlling Area		KOKRS	CHAR	8	*
PROJK	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
WBS_POSID	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
AUFNR	Order Number		AUFNR	CHAR	24	*
KOSTL	Cost Center		KOSTL	CHAR	20	*
PRCTR	Profit Center		PRCTR	CHAR	20
WERKS	Plant		WERKS_D	CHAR	8
MATNR	Material Number		MATNR	CHAR	80
VBELN	Billing Document		VBELN_VF	CHAR	20
VBEL2	Sales Document		VBELN_VA	CHAR	20
POSN2	Sales Document Item		POSNR_VA	NUMC	12
EBELN	Purchasing Document Number		EBELN	CHAR	20
EBELP	Item Number of Purchasing Document		EBELP	NUMC	10	*
ABPER	Settlement Period		ABPER_RF	ACCP	12
ANBWA	Asset Transaction Type		ANBWA	CHAR	6	*
ANLN1	Main Asset Number		ANLN1	CHAR	24	*
ANLN2	Asset Subnumber		ANLN2	CHAR	8	*
AUGBL	Document Number of the Clearing Document		AUGBL	CHAR	20
AUGDT	Clearing Date		AUGDT	DATS	16
BEWAR	Consolidation Transaction Type		BEWAR	CHAR	6	*
FILKD	Account Number of the Branch		FILKD	CHAR	20
FKBER	Functional Area		FKBER	CHAR	32	*
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
FWBAS	Tax base amount in document currency (TC)		TXW_FWBAS	CHAR	62
HWBAS	Tax base amount in local currency		TXW_HWBAS	CHAR	62
WMWST	Tax amount in document currency (TC)		TXW_WMWST	CHAR	62
GBETR	Hedged amount in foreign currency		TXW_GBETR	CHAR	62
LANDL	Supplying Country/Region		LANDL	CHAR	6	*
REBZT	Follow-On Document Type		REBZT	CHAR	2
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)		REBZJ	NUMC	8
REBZG	Document No. of the Invoice to Which the Transaction Belongs		REBZG	CHAR	20
REBZZ	Line Item in the Relevant Invoice		REBZZ	NUMC	6
NEBTR	Net payment amount		TXW_NEBTR	CHAR	62
NPLNR	Network Number for Account Assignment		NPLNR	CHAR	24	*
PSWSL	Update Currency for General Ledger Transaction Figures		PSWSL	CUKY	10	*
PSWBT	Amount for updating in general ledger (position currency PC)		TXW_PSWBT	CHAR	62
PARGB	Trading partner's business area		PARGB	CHAR	8	*
PROJN	Old: Project number : No longer used --> PS_POSNR		PROJN	CHAR	32
QSSKZ	Withholding Tax Code		QSSKZ	CHAR	4	*
QSFBT	Withholding tax-exempt amount (in document currency)		TXW_QSFBT	CHAR	62
QSSHB	Withholding tax base amount		TXW_QSSHB	CHAR	62
QBSHB	Withholding tax amount (in document currency)		TXW_QBSHB	CHAR	62
SAKNR	G/L Account Number		SAKNR	CHAR	20
SGTXT	Item Text		SGTXT	CHAR	100
VALUT	Value date		VALUT	DATS	16
TXGRP	Group Indicator for Tax Line Items		TXGRP	NUMC	6
HBKID	Short Key for a House Bank		HBKID	CHAR	10	*
MWSTS	Tax amount in local currency		TXW_MWSTS	CHAR	62
MWST2	Tax amount in second local currency		TXW_MWST2	CHAR	62
MWST3	Tax amount in third local currency		TXW_MWST3	CHAR	62
RSTGR	Reason Code for Payments		RSTGR	CHAR	6	*
UZAWE	Payment method supplement		UZAWE	CHAR	4	*
TXBFW	Original tax base amount in document currency		TXW_TXBFW	CHAR	62
TXBHW	Original tax base amount in local currency		TXW_TXBHW	CHAR	62
TXBH2	Tax base/original tax base in second local currency		TXW_TXBH2	CHAR	62
TXBH3	Tax base/original tax base in third local currency		TXW_TXBH3	CHAR	62
KKBER	Credit control area		KKBER	CHAR	8	*
.INCLUDE				CI_FI_POS	0
STCEG	VAT Registration Number		STCEG	CHAR	40
EGBLD	Country/Region of Destination for Delivery of Goods		EGBLD	CHAR	6	*
EGLLD	Supplying Country/Region for Delivery of Goods		EGLLD	CHAR	6	*
XEGDR	Indicator: Triangular Deal Within the EU		XEGDR	CHAR	2
FKBER_LONG	Functional Area		FKBER	CHAR	32	*
VERTT	Contract Type		RANTYP	CHAR	2
VERTN	Contract Number		RANL	CHAR	26
VBEWA	Flow Type		SBEWART	CHAR	8	*
IMKEY	Internal Key for Real Estate Object		IMKEY	CHAR	16
INTRENO	Internal Real Estate Master Data Code		VVINTRENO	CHAR	26
DABRZ	Reference date for settlement		DABRBEZ	DATS	16
BSTAT	Document Status		BSTAT_D	CHAR	2
LEDGER	Ledger in General Ledger Accounting		FAGL_RLDNR	CHAR	4
MWART	Tax Type		MWART	CHAR	2
XBILK	Indicator: Account is a balance sheet account?		XBILK	CHAR	2
GVTYP	P&L statement account type		GVTYP	CHAR	4
NAVHW	Non-Deductible Input Tax (in Local Currency)		TXW_NAVHW	CHAR	62
KSTRG	Cost Object		KSTRG	CHAR	24	*
ALTKT	Group Account Number		BILKT_SKA1	CHAR	20	*
LOKKT	Alternative Account Number in Company Code		ALTKT_SKB1	CHAR	20	*
BUZID	Identification of the Line Item		BUZID	CHAR	2
AUGCP	Clearing Entry Date		AUGCP	DATS	16
XCPDD	Indicator: Address and Bank Data Set Individually		XCPDD	CHAR	2
.INCLUDE				TXW_FI_POS_FR	0
ACC_NUM	Account number of Customer or Vendor		TXW_ACC_NUM	CHAR	20
NAME1	Name 1		NAME1_GP	CHAR	70
NAME2	Name 2		NAME2_GP	CHAR	70
GACC_NUM	Group ledger or group account number		TXW_GACC_NUM	CHAR	20
TXT20	Account short text		TXW_TXT20	CHAR	40
TXT50	Text		TXW_TXT50	CHAR	100
XREF1	Business Partner Reference Key		XREF1	CHAR	24
XBLNR	Reference Document Number		XBLNR1	CHAR	32
GJAHR_CALC	Fiscal Year (calculated, GL view)		TXW_GJAHR_CALC	NUMC	8
MONAT_CALC	Fiscal Period (calculated, GL view)		TXW_MONAT_CALC	NUMC	4
GLVOR	Business Transaction		GLVOR	CHAR	8
.INCLUDE				CI_TXWBSEG	0