SAP table BSBM (Document Valuation Fields)

SAP table BSBM has 8 primary key fields being MANDT,BUKRS,BELNR,GJAHR,BUZEI,CURTP,BWBER,METHD.

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 FINSC_CURTYPE FINS_CURTYPE
BWBER Valuation Area for FI Year-End Closing CHAR 2 0 T033 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
WBRSL Value Adjustment Key CHAR 2 0 WBRSL
PWBTR Flat-Rate Value for Value Adjustment CURR 23 2 PWBTR
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
KUNNR Customer Number CHAR 10 0 KUNNR

BSBM foreign key relationships

Table Field Check Table Check Field
0 BSBM BWBER T033 FI Depreciation Area BWBER
1 BSBM CURTP FINSC_CURTYPE Currency type CURTYPE