SAP Table BSIM
Secondary Index, Documents for Material
BSIM (Secondary Index, Documents for Material) 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 BSIM to other SAP tables.
BSIM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||
| BWKEY | Valuation Area | BWKEY | T001K | CHAR | 4 | 0 | ||||||
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 | 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 | |||||||
| BUZID | Identification of the Line Item | BUZID | CHAR | 1 | 0 | |||||||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | 0 |
Possible values
|
||||||
| DMBTR | Amount in Local Currency | DMBTR | CURR | 13 | 2 | |||||||
| MENGE | Quantity | MENGE_D | QUAN | 13 | 3 | |||||||
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | 0 | |||||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | 0 | |||||||
| BLART | Document Type | BLART | T003 | CHAR | 2 | 0 | ||||||
BSIM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BSIM | BLART | BSIM | MANDT | T003 | Document Types | MANDT |
| BSIM | BLART | BSIM | BLART | T003 | Document Types | BLART |
| BSIM | BWKEY | BSIM | MANDT | T001K | Valuation area | MANDT |
| BSIM | BWKEY | BSIM | BWKEY | T001K | Valuation area | BWKEY |
| BSIM | BWTAR | BSIM | MANDT | T149D | Global Valuation Types | MANDT |
| BSIM | BWTAR | BSIM | BWTAR | T149D | Global Valuation Types | BWTAR |
| BSIM | MANDT | BSIM | MANDT | T000 | Clients | MANDT |
| BSIM | MATNR | BSIM | MANDT | MARA | General Material Data | MANDT |
| BSIM | MATNR | BSIM | MATNR | MARA | General Material Data | MATNR |
| BSIM | MEINS | BSIM | MANDT | T006 | Units of Measurement | MANDT |
| BSIM | MEINS | BSIM | MEINS | T006 | Units of Measurement | MSEHI |
