SAP ABAP Table TXW_S_BKPF (Retrieve BKPF 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_BKPF	Table Relationship Diagram
Short Description	Retrieve BKPF 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_BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	TXW_BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	TXW_GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	.INCLUDE	☐				0	0	FI Document header
6	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
9	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
10	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
11	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
12	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
13	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
14	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
15	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
16	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
17	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
19	KURSF	☐	TXW_KURSF	CHAR12	CHAR	12	0	Exchange rate
20	GLVOR	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
21	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
22	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
23	DBBLG	☐	DBBLG	BELNR	CHAR	10	0	Recurring Entry Document Number
24	DOKID	☐	DOKID_BKPF	CHAR40	CHAR	40	0	Document Name in the Archive System
25	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
26	KZWRS	☐	KZWRS	WAERS	CUKY	5	0	Currency Key for the Group Currency	*
27	KZKRS	☐	TXW_KZKRS	CHAR12	CHAR	12	0	Group currency exchange rate
28	STBLG	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
29	STJAH	☐	STJAH	GJAHR	NUMC	4	0	Reverse document fiscal year
30	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
31	XRUEB	☐	XRUEB	XFELD	CHAR	1	0	Indicator: Document is posted to a previous period
32	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
33	AWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
34	AWSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
35	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
36	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
37	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
38	.INCLUDE	☐				0	0
39	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
40	RLDNR	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	*
41	LDGRP	☐	FAGL_LDGRP	FAGL_LDGRP	CHAR	4	0	Ledger Group	*
42	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
43	LEDGER	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	*
44	VATDATE	☐	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
45	XMWST	☐	XMWST	XFELD	CHAR	1	0	Calculate tax automatically
46	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXW_S_BKPF	BLART	T003	BLART		1	CN
2	TXW_S_BKPF	BUKRS	T001	BUKRS
3	TXW_S_BKPF	MANDT	T000	MANDT		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in