SAP table BSIM (Secondary Index, Documents for Material)

SAP table BSIM has 7 primary key fields being MANDT,MATNR,BWKEY,BWTAR,BELNR,GJAHR,BUZEI.

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 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
BWKEY Valuation area CHAR 4 0 T001K BWKEY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
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
BUZID Identification of the Line Item CHAR 1 0 BUZID
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
DMBTR Amount in local currency CURR 23 2 DMBTR
MENGE Quantity QUAN 13 3 MENGE_D
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
BLART Document Type CHAR 2 0 T003 BLART

BSIM foreign key relationships

Table Field Check Table Check Field
0 BSIM BLART T003 Document Types MANDT
1 BSIM BWTAR T149D Global Valuation Types BWTAR
0 BSIM MANDT T000 Clients MANDT
1 BSIM MATNR MARA General Material Data MANDT
1 BSIM MATNR MARA General Material Data MATNR
0 BSIM MEINS T006 Units of Measurement MANDT