BSIM SAP table for – Secondary Index, Documents for Material

Here we would like to draw your attention to BSIM table in SAP. As we know it is being mainly used with the SAP MM-IV (Invoice Verification in MM) component which is coming under MM module (Material Management). BSIM is a SAP standard transparent table used for storing Secondary Index, Documents for Material related data in SAP. It comes under the package FBAS.

SAP BSIM table

Table BSIM technical data

TableBSIM
Data storingSecondary Index, Documents for Material
ModuleMM
ComponentMM-IV
SAP PackageFBAS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP BSIM Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in BSIM table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • DMBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • BUDAT : Posting Date in the Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BLDAT : Document Date in Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BLART : Document type
    Its data type is C (Character String) with field length 2
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • BWKEY : Valuation area
    Its a key field. Its data type is C (Character String) with field length 4
  • BWTAR : Valuation type
    Its a key field. Its data type is C (Character String) with field length 10
  • BELNR : Accounting Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • BUZEI : Document Item in Invoice Document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 3
  • BUZID : Identification of the Line Item
    Its data type is C (Character String) with field length 1
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1