SAP ABAP Table TXW_S_VBRK (Retrieve VBRK from archive)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TXW_S_VBRK	Table Relationship Diagram
Short Description	Retrieve VBRK from archive

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TXW_MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	TXW_VBELN	☑	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
3	.INCLUDE	☐				0	0	SD Billing document header
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
7	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
9	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
10	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
11	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
12	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
13	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
14	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	*
15	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
16	FKSTO	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
17	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
18	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
19	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	*
20	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
21	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
22	SFAKN	☐	SFAKN	VBELN	CHAR	10	0	Cancelled billing document number	*
23	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
24	NETWR	☐	TXW_NETWR	CHAR16	CHAR	16	0	Value of invoice
25	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
26	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
27	BSTNK_VF	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
28	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
29	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
30	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
31	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	*
32	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	*
33	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
34	.INCLUDE	☐				0	0
35	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	*
36	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
37	STCEG_H	☐	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
38	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	*
39	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
40	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
41	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
42	KURRF	☐	TXW_KURRF	CHAR12	CHAR	12	0	Exchange rate for FI postings
43	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
44	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
45	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
46	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
47	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
48	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
49	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
50	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
51	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
52	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
53	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20130529
SAP Release Created in