TXW_S_VBRK - Retrieve VBRK from archive

Retrieve VBRK from archive information is stored in SAP table TXW_S_VBRK.
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_VBRK

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
TXW_MANDT	Client	X	MANDT	CLNT	6
TXW_VBELN	Billing Document	X	VBELN_VF	CHAR	20
.INCLUDE				TXW_BI_HD	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
VBELN	Sales and Distribution Document Number		VBELN	CHAR	20
XBLNR	Reference Document Number		XBLNR1	CHAR	32
WAERK	SD Document Currency		WAERK	CUKY	10	*
VBUND	Company ID of Trading Partner		RASSC	CHAR	12	*
EXPKZ	Export indicator		EXPKZ	CHAR	2
FKART	Billing Type		FKART	CHAR	8	*
FKDAT	Billing Date		FKDAT	DATS	16
FKSTO	Billing document is canceled		FKSTO	CHAR	2
INCO1	Incoterms (Part 1)		INCO1	CHAR	6	*
INCO2	Incoterms (Part 2)		INCO2	CHAR	56
KALSM	Procedure (Pricing, Output Control, Acct. Det., Costing,...)		KALSM_D	CHAR	12	*
KUNAG	Sold-to Party		KUNAG	CHAR	20	*
KUNRG	Payer		KUNRG	CHAR	20	*
SFAKN	Number of canceled billing document		SFAKN	CHAR	20
VBTYP	SD Document Category		VBTYPL	CHAR	8
NETWR	Value of invoice		TXW_NETWR	CHAR	62
AWTYP	Reference procedure		AWTYP	CHAR	10	*
AWKEY	Reference Key		AWKEY	CHAR	40
BSTNK_VF	Customer Reference		BSTKD	CHAR	70
KNUMV	Number of the Document Condition		KNUMV	CHAR	20
VKORG	Sales Organization		VKORG	CHAR	8
LAND1	Destination Country/Region		LLAND	CHAR	6	*
LANDTX	Tax Departure Country/Region		LANDTX	CHAR	6	*
LOGSYS	Logical system		LOGSYS	CHAR	20	*
.INCLUDE				CI_BI_HD	0
EXNUM	Number of foreign trade data in MM and SD documents		EXNUM	CHAR	20
STCEG	VAT Registration Number		STCEG	CHAR	40
STCEG_H	Origin of Sales Tax ID Number		STCEG_H	CHAR	2
STCEG_L	Country/Region of Sales Tax ID Number		STCEG_L	CHAR	6	*
XEGDR	Indicator: Triangular Deal Within the EU		XEGDR	CHAR	2
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
ERDAT	Date on which the record was created		ERDAT	DATS	16
KURRF	Exchange rate for FI postings		TXW_KURRF	CHAR	24
POPER	Posting period		POPER	NUMC	6
TAXK1	Tax Classification 1 for Customer		TAXK1	CHAR	2	*
TAXK2	Tax Classification 2 for Customer		TAXK2	CHAR	2	*
TAXK3	Tax Classification 3 for Customer		TAXK3	CHAR	2	*
TAXK4	Tax Classification 4 for Customer		TAXK4	CHAR	2	*
TAXK5	Tax Classification 5 for Customer		TAXK5	CHAR	2	*
TAXK6	Tax Classification 6 for Customer		TAXK6	CHAR	2	*
TAXK7	Tax Classification 7 for Customer		TAXK7	CHAR	2	*
TAXK8	Tax Classification 8 for Customer		TAXK8	CHAR	2	*
TAXK9	Tax Classification 9 for Customer		TAXK9	CHAR	2	*
.INCLUDE				CI_TXWVBRK	0