SAP Table FAGL_BSBW_HISTRY

Valuation History for Documents

FAGL_BSBW_HISTRY (Valuation History for Documents) 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 FAGL_BSBW_HISTRY to other SAP tables.

FAGL_BSBW_HISTRY table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
CURTP Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
BWBER Valuation Area for FI Year-End Closing BWBER CHAR 2 0
METHD Valuation Methods in Financial Accounting UMBWM CHAR 3 0
1 Foreign Currency Valuation
2 Discounting
3 Flat-rate individual value adjustment
4 Foreign Currency Valuation of Balances
5 Translation of Balances
6 Adjustment of Realized Exch. Rate Diff. Partial Payment
98 Customer-specific valuation I
99 Customer-specific valuation II
10 Discounting After Entire Term (IFRS)
50 Provisions for Doubtful Receivables
DATUM Date DATUM DATS 8 0
RUNID Run ID FAGL_RUNID NUMC 2 0
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
BWSHB Valuation Difference BWSHB CURR 15 2
REVERSE_ID Reversed by Run ID FAGL_REVERSE_ID NUMC 2 0
FCV_STATUS Status of Foreign Currency Valuation FAGL_FCV_STATUS CHAR 1 0
NULL Initial
V Valuated and Open
C Cleared
A Correction to Realized Difference Partial Payment (RXD_PPA)
R Reversal of Correction to Real. Diff. Part. Paymnt (RXD_PPR)
VALRUNKEY Identification Number of Valuation Run FAGL_FCV_RUNKEY NUMC 10 0
VALTRGTPL_ACCT G/L Account Number SAKNR CHAR 10 0
VALTRGTPL_TYPE Use P&L Target Account for Expenses/Revenues FAGL_FCV_PLTYPE CHAR 1 0
G Target Account: Revenue from Valuation
L Target Account: Expense from Valuation
RXDRUNKEY Identification Number of Valuation Run FAGL_FCV_RUNKEY NUMC 10 0
RXDXKDFT Indicator: Post translations for exchange rate differences ? XKDFT CHAR 1 0
X Yes
NULL No
VALTRGTBA_ACCT Adjustment Account KORRK CHAR 10 0
VALRUNKEY_NRNR Number range number NRNR CHAR 2 0
RXDRUNKEY_NRNR Number range number NRNR CHAR 2 0