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".

Fields for table TXW_S_BKPF

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
TXW_MANDTClientXMANDTCLNT6
TXW_BUKRSCompany CodeXBUKRSCHAR8
TXW_BELNRDocument Number of an Accounting DocumentXBELNR_DCHAR20
TXW_GJAHRFiscal YearXGJAHRNUMC8
.INCLUDETXW_FI_HD0
MANDTClientMANDTCLNT6T000
BUKRSCompany CodeBUKRSCHAR8T001
BELNRDocument Number of an Accounting DocumentBELNR_DCHAR20
GJAHRFiscal YearGJAHRNUMC8
MONATFiscal periodMONATNUMC4
BLARTDocument TypeBLARTCHAR4T003
BUDATPosting Date in the DocumentBUDATDATS16
BLDATDocument Date in DocumentBLDATDATS16
BVORGNumber of Cross-Company Code Posting TransactionBVORGCHAR32
WWERTTranslation dateWWERT_DDATS16
XBLNRReference Document NumberXBLNR1CHAR32
BKTXTDocument Header TextBKTXTCHAR50
WAERSCurrency KeyWAERSCUKY10*
KURSFExchange rateTXW_KURSFCHAR24
GLVORBusiness TransactionGLVORCHAR8
HWAE2Currency Key of Second Local CurrencyHWAE2CUKY10*
HWAE3Currency Key of Third Local CurrencyHWAE3CUKY10*
DBBLGRecurring Entry Document NumberDBBLGCHAR20
DOKIDDocument Name in the Archive SystemDOKID_BKPFCHAR80
HWAERLocal CurrencyHWAERCUKY10*
KZWRSCurrency Key for the Group CurrencyKZWRSCUKY10*
KZKRSGroup currency exchange rateTXW_KZKRSCHAR24
STBLGReverse Document NumberSTBLGCHAR20
STJAHFiscal Year of Reversal DocumentSTJAHNUMC8
USNAMUser NameUSNAMCHAR24*
XRUEBIndicator: Document Is Posted to a Previous PeriodXRUEBCHAR2
AWORGReference Organizational UnitsAWORGCHAR20
AWREFReference document numberAWREFCHAR20
AWSYSLogical systemLOGSYSCHAR20*
AWTYPReference procedureAWTYPCHAR10*
AWKEYReference KeyAWKEYCHAR40
CPUDTDay On Which Accounting Document Was EnteredCPUDTDATS16
.INCLUDECI_FI_HD0
TCODETransaction CodeTCODECHAR40*
RLDNRLedger in General Ledger AccountingFAGL_RLDNRCHAR4
LDGRPLedger GroupFAGL_LDGRPCHAR8*
BSTATDocument StatusBSTAT_DCHAR2
LEDGERLedger in General Ledger AccountingFAGL_RLDNRCHAR4
VATDATETax Reporting DateVATDATEDATS16
XMWSTCalculate Tax AutomaticallyXMWSTCHAR2
.INCLUDETXW_FI_HD_FR0
XREF1_HDReference Key 1 Internal for Document HeaderXREF1_HDCHAR40
XREF2_HDReference Key 2 Internal for Document HeaderXREF2_HDCHAR40
BELNR_18FEC: Accounting document numberBELNR_18CHAR36
GJAHR_CALCFiscal Year (calculated, GL view)TXW_GJAHR_CALCNUMC8
MONAT_CALCFiscal Period (calculated, GL view)TXW_MONAT_CALCNUMC4
.INCLUDECI_TXWBKPF0
Privacy Policy