TXW_S_BKPF - Retrieve BKPF from archive
Retrieve BKPF from archive information is stored in SAP table TXW_S_BKPF.
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".
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_BKPF
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TXW_MANDT | Client | X | MANDT | CLNT | 6 | |
| TXW_BUKRS | Company Code | X | BUKRS | CHAR | 8 | |
| TXW_BELNR | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
| TXW_GJAHR | Fiscal Year | X | GJAHR | NUMC | 8 | |
| .INCLUDE | TXW_FI_HD | 0 | ||||
| MANDT | Client | MANDT | CLNT | 6 | T000 | |
| BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| BELNR | Document Number of an Accounting Document | BELNR_D | CHAR | 20 | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 8 | ||
| MONAT | Fiscal period | MONAT | NUMC | 4 | ||
| BLART | Document Type | BLART | CHAR | 4 | T003 | |
| BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
| BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
| BVORG | Number of Cross-Company Code Posting Transaction | BVORG | CHAR | 32 | ||
| WWERT | Translation date | WWERT_D | DATS | 16 | ||
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 32 | ||
| BKTXT | Document Header Text | BKTXT | CHAR | 50 | ||
| WAERS | Currency Key | WAERS | CUKY | 10 | * | |
| KURSF | Exchange rate | TXW_KURSF | CHAR | 24 | ||
| GLVOR | Business Transaction | GLVOR | CHAR | 8 | ||
| HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 10 | * | |
| HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 10 | * | |
| DBBLG | Recurring Entry Document Number | DBBLG | CHAR | 20 | ||
| DOKID | Document Name in the Archive System | DOKID_BKPF | CHAR | 80 | ||
| HWAER | Local Currency | HWAER | CUKY | 10 | * | |
| KZWRS | Currency Key for the Group Currency | KZWRS | CUKY | 10 | * | |
| KZKRS | Group currency exchange rate | TXW_KZKRS | CHAR | 24 | ||
| STBLG | Reverse Document Number | STBLG | CHAR | 20 | ||
| STJAH | Fiscal Year of Reversal Document | STJAH | NUMC | 8 | ||
| USNAM | User Name | USNAM | CHAR | 24 | * | |
| XRUEB | Indicator: Document Is Posted to a Previous Period | XRUEB | CHAR | 2 | ||
| AWORG | Reference Organizational Units | AWORG | CHAR | 20 | ||
| AWREF | Reference document number | AWREF | CHAR | 20 | ||
| AWSYS | Logical system | LOGSYS | CHAR | 20 | * | |
| AWTYP | Reference procedure | AWTYP | CHAR | 10 | * | |
| AWKEY | Reference Key | AWKEY | CHAR | 40 | ||
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 16 | ||
| .INCLUDE | CI_FI_HD | 0 | ||||
| TCODE | Transaction Code | TCODE | CHAR | 40 | * | |
| RLDNR | Ledger in General Ledger Accounting | FAGL_RLDNR | CHAR | 4 | ||
| LDGRP | Ledger Group | FAGL_LDGRP | CHAR | 8 | * | |
| BSTAT | Document Status | BSTAT_D | CHAR | 2 | ||
| LEDGER | Ledger in General Ledger Accounting | FAGL_RLDNR | CHAR | 4 | ||
| VATDATE | Tax Reporting Date | VATDATE | DATS | 16 | ||
| XMWST | Calculate Tax Automatically | XMWST | CHAR | 2 | ||
| .INCLUDE | TXW_FI_HD_FR | 0 | ||||
| XREF1_HD | Reference Key 1 Internal for Document Header | XREF1_HD | CHAR | 40 | ||
| XREF2_HD | Reference Key 2 Internal for Document Header | XREF2_HD | CHAR | 40 | ||
| BELNR_18 | FEC: Accounting document number | BELNR_18 | CHAR | 36 | ||
| GJAHR_CALC | Fiscal Year (calculated, GL view) | TXW_GJAHR_CALC | NUMC | 8 | ||
| MONAT_CALC | Fiscal Period (calculated, GL view) | TXW_MONAT_CALC | NUMC | 4 | ||
| .INCLUDE | CI_TXWBKPF | 0 |