TXW_S_BKPF SAP (Retrieve BKPF from archive) Table details
Dictionary Type: Table
Description: Retrieve BKPF from archive
Description: Retrieve BKPF from archive
Table field list including key, data, relationships and ABAP select examples
TXW_S_BKPF is a standard SAP Table which is used to store Retrieve BKPF from archive data and is available within R/3 SAP systems depending on the version and release level.
The TXW_S_BKPF table consists of various fields, each holding specific information or linking keys about Retrieve BKPF from archive data available in SAP. These include TXW_BUKRS (Company Code), TXW_BELNR (Accounting Document Number), TXW_GJAHR (Fiscal Year), MANDT (Client).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TXW_S_BKPF table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| TXW_MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| TXW_BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| TXW_BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
| TXW_GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
| BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
| BVORG | Number of Cross-Company Code Posting Transaction | BVORG | CHAR | 16 | BVORG | ||||
| WWERT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
| BKTXT | Document Header Text | BKTXT | CHAR | 25 | TEXT25 | ||||
| WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| KURSF | Exchange rate | TXW_KURSF | CHAR | 12 | CHAR12 | ||||
| GLVOR | Business Transaction | GLVOR | CHAR | 4 | CHAR4 | ||||
| HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 5 | Assigned to domain | WAERS | |||
| HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 5 | Assigned to domain | WAERS | |||
| DBBLG | Recurring Entry Document Number | DBBLG | CHAR | 10 | ALPHA | BELNR | |||
| DOKID | Document Name in the Archive System | DOKID_BKPF | CHAR | 40 | CHAR40 | ||||
| HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
| KZWRS | Currency Key for the Group Currency | KZWRS | CUKY | 5 | Assigned to domain | WAERS | |||
| KZKRS | Group currency exchange rate | TXW_KZKRS | CHAR | 12 | CHAR12 | ||||
| STBLG | Reverse Document Number | STBLG | CHAR | 10 | ALPHA | BELNR | |||
| STJAH | Reverse document fiscal year | STJAH | NUMC | 4 | GJAHR | GJAHR | |||
| USNAM | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
| XRUEB | Indicator: Document is posted to a previous period | XRUEB | CHAR | 1 | XFELD | ||||
| AWORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
| AWREF | Reference Document Number | AWREF | CHAR | 10 | ALPHA | AWREF | |||
| AWSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| AWTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
| AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
| TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD | ||
| RLDNR | Ledger in General Ledger Accounting | FAGL_RLDNR | CHAR | 2 | Assigned to domain | ALPHA | RLDNR | GLN_FLEX | FAGL_RLDNR |
| LDGRP | Ledger Group | FAGL_LDGRP | CHAR | 4 | Assigned to domain | FAGL_LDGRP | GLDGRP_FLEX | ||
| BSTAT | Document Status | BSTAT_D | CHAR | 1 | BSTAT | ||||
| LEDGER | Ledger in General Ledger Accounting | FAGL_RLDNR | CHAR | 2 | Assigned to domain | ALPHA | RLDNR | GLN_FLEX | FAGL_RLDNR |
| VATDATE | Tax Reporting Date | VATDATE | DATS | 8 | DATUM | ||||
| XMWST | Calculate tax automatically | XMWST | CHAR | 1 | XFELD | XTX |
| Key field | Non-key field |
How do I retrieve data from SAP table TXW_S_BKPF using ABAP code
The following ABAP code Example will allow you to do a basic selection on TXW_S_BKPF to SELECT all data from the tableDATA: WA_TXW_S_BKPF TYPE TXW_S_BKPF.
SELECT SINGLE *
FROM TXW_S_BKPF
INTO CORRESPONDING FIELDS OF WA_TXW_S_BKPF
WHERE...
How to access SAP table TXW_S_BKPF
Within an ECC or HANA version of SAP you can also view further information about TXW_S_BKPF and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects