SAP table FAGL_BSBW_HISTRY (Valuation History for Documents)

SAP table FAGL_BSBW_HISTRY has 10 primary key fields being MANDT,BUKRS,BELNR,GJAHR,BUZEI,CURTP,BWBER,METHD,DATUM,RUNID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
CURTP Currency Type CHAR 2 0 FINS_CURTYPE
BWBER Valuation Area for FI Year-End Closing CHAR 2 0 BWBER
METHD Valuation Methods in Financial Accounting CHAR 3 0 UMBWM
1 Foreign Currency Valuation
10 Discounting After Entire Term (IFRS)
11 Reclassification for Valuation Objects
2 Discounting
3 Flat-rate individual value adjustment
4 Foreign Currency Valuation of Balances
5 Translation of Balances
50 Provisions for Doubtful Receivables
6 Adjustment of Realized Exch. Rate Diff. Partial Payment
7 Inception Posting
98 Customer-specific valuation I
99 Customer-specific valuation II
DATUM Date DATS 8 0 DATUM
RUNID Run ID NUMC 2 0 FAGL_RUNID
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
BWSHB Valuation Difference CURR 23 2 BWSHB
REVERSE_ID Reversed by Run ID NUMC 2 0 FAGL_REVERSE_ID
FCV_STATUS Status of Foreign Currency Valuation CHAR 1 0 FAGL_FCV_STATUS
Initial
A Correction to Realized Difference Partial Payment (RXD_PPA)
C Cleared
R Reversal of Correction to Real. Diff. Part. Paymnt (RXD_PPR)
V Valuated and Open
VALRUNKEY Identification Number of Valuation Run NUMC 10 0 FAGL_FCV_RUNKEY
VALTRGTPL_ACCT G/L Account Number CHAR 10 0 SAKNR
VALTRGTPL_TYPE Use P&L Target Account for Expenses/Revenues CHAR 1 0 FAGL_FCV_PLTYPE
G Target Account: Revenue from Valuation
L Target Account: Expense from Valuation
RXDRUNKEY Identification Number of Valuation Run NUMC 10 0 FAGL_FCV_RUNKEY
RXDXKDFT Indicator: Post Translations for Exchange Rate Differences? CHAR 1 0 XKDFT
VALTRGTBA_ACCT Adjustment Account CHAR 10 0 KORRK
VALRUNKEY_NRNR Number range number CHAR 2 0 NRNR
RXDRUNKEY_NRNR Number range number CHAR 2 0 NRNR
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE