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 |