SAP Table TXW_FI_HD

FI Document header

TXW_FI_HD (FI Document header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TXW_FI_HD to other SAP tables.

TXW_FI_HD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
MONAT Fiscal Period MONAT NUMC 2 0
BLART Document Type BLART T003 CHAR 2 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
BVORG Number of Cross-Company Code Posting Transaction BVORG CHAR 16 0
WWERT Translation Date WWERT_D DATS 8 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BKTXT Document Header Text BKTXT CHAR 25 0
WAERS Currency Key WAERS CUKY 5 0
KURSF Exchange rate TXW_KURSF CHAR 12 0
GLVOR Business Transaction GLVOR CHAR 4 0
HWAE2 Currency Key of Second Local Currency HWAE2 CUKY 5 0
HWAE3 Currency Key of Third Local Currency HWAE3 CUKY 5 0
DBBLG Recurring Entry Document Number DBBLG CHAR 10 0
DOKID Document Name in the Archive System DOKID_BKPF CHAR 40 0
HWAER Local Currency HWAER CUKY 5 0
KZWRS Currency Key for the Group Currency KZWRS CUKY 5 0
KZKRS Group currency exchange rate TXW_KZKRS CHAR 12 0
STBLG Reverse Document Number STBLG CHAR 10 0
STJAH Reverse document fiscal year STJAH NUMC 4 0
USNAM User name USNAM CHAR 12 0
XRUEB Indicator: Document is posted to a previous period XRUEB CHAR 1 0
X Yes
NULL No
AWORG Reference Organizational Units AWORG CHAR 10 0
AWREF Reference Document Number AWREF CHAR 10 0
AWSYS Logical system LOGSYS CHAR 10 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWKEY Reference Key AWKEY CHAR 20 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
TCODE Transaction Code TCODE CHAR 20 0
RLDNR Ledger in General Ledger Accounting FAGL_RLDNR CHAR 2 0
LDGRP Ledger Group FAGL_LDGRP CHAR 4 0
BSTAT Document Status BSTAT_D CHAR 1 0
NULL Normal document
A Clearing Document
B Reset clearing document
D Recurring entry document
L Posting Not in Leading Ledger
M Sample document
S Noted items
V Parked document
W Parked document with change of document ID
Z Parked document which was deleted
C Balance Carryforward Line Items
LEDGER Ledger in General Ledger Accounting FAGL_RLDNR CHAR 2 0
VATDATE Tax Reporting Date VATDATE DATS 8 0
XMWST Calculate tax automatically XMWST CHAR 1 0
X Yes
NULL No

TXW_FI_HD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TXW_FI_HD BLART TXW_FI_HD BLART T003 Document Types BLART
TXW_FI_HD BLART TXW_FI_HD MANDT T003 Document Types MANDT
TXW_FI_HD BUKRS TXW_FI_HD MANDT T001 Company Codes MANDT
TXW_FI_HD BUKRS TXW_FI_HD BUKRS T001 Company Codes BUKRS
TXW_FI_HD MANDT TXW_FI_HD MANDT T000 Clients MANDT