TXW_S_VBRP - Retrieve VBRP from archive

Retrieve VBRP from archive information is stored in SAP table TXW_S_VBRP.
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_VBRP

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
TXW_POSNR	Billing Item	X	POSNR_VF	NUMC	12
.INCLUDE				TXW_BI_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
VBELN	Billing Document		VBELN_VF	CHAR	20
POSNR	Billing Item		POSNR_VF	NUMC	12
PSTYV	Sales document item category		PSTYV	CHAR	8	*
VGBEL	Document number of the reference document		VGBEL	CHAR	20
VGPOS	Item number of the reference item		VGPOS	NUMC	12
VGTYP	SD Document Category		VBTYPL	CHAR	8
AUBEL	Sales Document		VBELN_VA	CHAR	20
AUPOS	Sales Document Item		POSNR_VA	NUMC	12
AUTYP	SD Document Category		VBTYPL	CHAR	8
GSBER	Business Area		GSBER	CHAR	8	*
KOKRS	Controlling Area		KOKRS	CHAR	8	*
ARKTX	Short text for sales order item		ARKTX	CHAR	80
FBUDA	Date on which services are rendered		FBUDA	DATS	16
FKIMG	Actual invoiced quantity		TXW_FKIMG	CHAR	32
KOWRR	Statistical Values		KOWRR	CHAR	2
LMENG	Required quantity for mat.management in stockkeeping units		TXW_LMENG	CHAR	32
MATKL	Material Group		MATKL	CHAR	18
MATNR	Material Number		MATNR	CHAR	80
MEINS	Base Unit of Measure		MEINS	UNIT	6	*
MWSBP	Tax amount in document currency		TXW_MWSBP	CHAR	32
NETWR	Net value of the billing item in document currency		TXW_NETWRF	CHAR	34
PRCTR	Profit Center		PRCTR	CHAR	20
PRSDT	Date for Pricing and Exchange Rate		PRSDT	DATS	16
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30	*
VRKME	Sales Unit of Measure		TXW_VRKME	UNIT	6	*
WERKS	Plant		WERKS_D	CHAR	8
CHARG	Batch Number		CHARG_D	CHAR	20	*
KZWI1	Subtotal 1 from pricing procedure for condition		TXW_KZWI1	CHAR	40
KZWI2	Subtotal 2 from pricing procedure for condition		TXW_KZWI2	CHAR	40
KZWI3	Subtotal 3 from pricing procedure for condition		TXW_KZWI3	CHAR	40
KZWI4	Subtotal 4 from pricing procedure for condition		TXW_KZWI4	CHAR	40
KZWI5	Subtotal 5 from pricing procedure for condition		TXW_KZWI5	CHAR	40
KZWI6	Subtotal 6 from pricing procedure for condition		TXW_KZWI6	CHAR	40
PRODH	Product hierarchy		PRODH_D	CHAR	36	*
TAXM1	Tax classification material		TAXM1	CHAR	2	*
TAXM2	Tax Classification 2 for Material		TAXM2	CHAR	2	*
TAXM3	Tax Classification 3 for Material		TAXM3	CHAR	2	*
TAXM4	Tax Classification 4 for Material		TAXM4	CHAR	2	*
TAXM5	Tax Classification 5 for Material		TAXM5	CHAR	2	*
TAXM6	Tax Classification 6 for Material		TAXM6	CHAR	2	*
TAXM7	Tax Classification 7 for Material		TAXM7	CHAR	2	*
TAXM8	Tax Classification 8 for Material		TAXM8	CHAR	2	*
TAXM9	Tax Classification 9 for Material		TAXM9	CHAR	2	*
LGORT	Storage location		LGORT_D	CHAR	8	*
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
.INCLUDE				CI_BI_POS	0
.INCLUDE				CI_TXWVBRP	0