BSIM is a standard Invoice Verification Transparent Table in SAP MM application, which stores Secondary Index, Documents for Material data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for BSIM. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

BSIM — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 MANDT Client MANDT X CLNT 3 T000
    2 MATNR Material MATNR X CHAR 40 MARA
    3 BWKEY Valuation Area BWKEY X CHAR 4 T001K
    4 BWTAR Valuation Type BWTAR_D X CHAR 10 T149D
    5 BELNR Document Number BELNR_D X CHAR 10
    6 GJAHR Fiscal Year GJAHR X NUMC 4
    7 BUZEI Posting row BUZEI X NUMC 3
    8 BUZID Line item ID BUZID CHAR 1
    9 SHKZG Debit/Credit SHKZG CHAR 1
    10 DMBTR Amount in LC DMBTR CURR 23
    11 MENGE Quantity in base unit of measure MENGE_D QUAN 13
    12 MEINS Base Unit MEINS UNIT 3 T006
    13 BUDAT Posting Date BUDAT DATS 8
    14 BLDAT Document Date BLDAT DATS 8
    15 BLART Document Type BLART CHAR 2 T003

SAP Help, Wiki, Q&A and other resources for BSIM

Click the above link for the full list of resources and help pages, only the first few are posted below

  • Nachlaufprogramm (FI) - SAP Help Portal

     Table of Contents Menu 

    "Das Programm lscht die Sekundrindizes aus den Tabellen BSIS, BSAS, BSAD, BSAK und BSIP. Die Sekundrindexeintrge in der Tabelle BSIM werden nicht vom Nachlaufprogramm gelscht. Stattdessen werden sie vom Lschprogramm direkt zusammen mit den Belegdaten gelscht."

    https://help.sap.com/viewer/a193f2ae056e41b38356402f8e12bb50/6.06.22/de-DE/6c764a5305fcf563e10000000a4450e5.html

  • %FUNC% Nachlaufprogramm (FI) - SAP Help Portal

     Table of Contents Menu 

    "Das Programm lscht die Sekundrindizes aus den Tabellen BSIS, BSAS, BSAD, BSAK und BSIP. Die Sekundrindexeintrge in der Tabelle BSIM werden nicht vom Nachlaufprogramm gelscht. Stattdessen werden sie vom Lschprogramm direkt zusammen mit den Belegdaten gelscht."

    https://help.sap.com/viewer/92fcba4b877842928f841e778cd7aa37/6.06.19/de-DE/8e55d7531a4d424de10000000a174cb4.html

  • %FUNC% Postprocessing Program (FI) - SAP Help Portal

     Table of Contents Menu 

    "The program deletes the secondary indexes from tables BSIS, BSAS, BASAD BSAK and BSIP. The secondary index entries in table BSIM are not deleted by the postprocessing program. Instead they are deleted directly together with the document data by the delete program."

    https://help.sap.com/viewer/92fcba4b877842928f841e778cd7aa37/6.06.20/en-US/8e55d7531a4d424de10000000a174cb4.html

  • Postprocessing Program (FI) - SAP Help Portal

     Table of Contents Menu 

    "The program deletes the secondary indexes from tables BSIS, BSAS, BASAD BSAK and BSIP. The secondary index entries in table BSIM are not deleted by the postprocessing program. Instead they are deleted directly together with the document data by the delete program."

    https://help.sap.com/viewer/92fcba4b877842928f841e778cd7aa37/6.06.20/en-US/6c764a5305fcf563e10000000a4450e5.html

  • %FUNC% Nachlaufprogramm (FI) | SAP Help Portal

    Das Nachlaufprogramm dient dazu, die Sekundärindizes der Finanzbuchhaltung entsprechend ihrer im Customizing eingestellten Sekundärindexlaufzeit aus der Datenbank zu löschen.

    "Das Programm lscht die Sekundrindizes aus den Tabellen BSIS, BSAS, BSAD, BSAK und BSIP. Die Sekundrindexeintrge in der Tabelle BSIM werden nicht vom Nachlaufprogramm gelscht. Stattdessen werden sie vom Lschprogramm direkt zusammen mit den Belegdaten gelscht."

    https://help.sap.com/docs/SAP_ERP_SPV/9c989e8618f44e1bbcd8da2f79319d82/8e55d7531a4d424de10000000a174cb4.html?locale=de-DE

  • Nachlaufprogramm (FI) | SAP Help Portal

    Das Nachlaufprogramm dient dazu, die Sekundärindizes der Finanzbuchhaltung entsprechend ihrer im Customizing eingestellten Sekundärindexlaufzeit aus der Datenbank zu löschen.

    "Das Programm lscht die Sekundrindizes aus den Tabellen BSIS, BSAS, BSAD, BSAK und BSIP. Die Sekundrindexeintrge in der Tabelle BSIM werden nicht vom Nachlaufprogramm gelscht. Stattdessen werden sie vom Lschprogramm direkt zusammen mit den Belegdaten gelscht."

    https://help.sap.com/docs/SAP_ERP_SPV/9c989e8618f44e1bbcd8da2f79319d82/6c764a5305fcf563e10000000a4450e5.html?locale=de-DE

  • Buchhaltungsbelege archivieren (FI-GL, FI-AR, FI-AP) - SAP Help Portal

     Table of Contents Menu 

    https://help.sap.com/viewer/a193f2ae056e41b38356402f8e12bb50/6.06.19/de-DE/84e8265313b9383ee10000000a423f68.html

  • Archiving Financial Accounting Documents (FI-GL, FI-AR, FI-AP) - SAP Help Portal

     Table of Contents Menu 

    "During the posting of a financial accounting document the actual document data is stored in tables BKPF and BSEG, and additionally data from these tables is written redundantly to secondary index tables BSIS, BSAS, BSAD, BSAK, BSIM and BSIP. The purpose of this redundancy is to provide faster access to data in some applications, such as the line item report function. See Displaying Archived Accounting Documents (FI)."

    https://help.sap.com/viewer/a193f2ae056e41b38356402f8e12bb50/6.06.20/en-US/84e8265313b9383ee10000000a423f68.html

  • Buchhaltungsbelege archivieren (FI-GL, FI-AR, FI-AP) | SAP Help Portal

    Finanzbuchhaltungsbelege (FI-Belege) werden mit dem Archivierungsobjekt FI_DOCUMNT archiviert und gelöscht.

    "Beim Buchen eines Finanzbuchhaltungsbelegs werden die eigentlichen Belegdaten in den Tabellen BKPF und BSEG gespeichert und zustzliche Daten aus diesen Tabellen werden auch in die Sekundrindextabellen BSIS, BSAS, BSAD, BSAK, BSIM und BSIP geschrieben. Der Zweck dieser Redundanz dient dem schnelleren Zugriff auf Daten in einigen Anwendungen wie die Einzelpostenberichtsfunktion. Weitere Informationen finden Sie unter Anzeige archivierter Finanzbuchhaltungsbelege (FI)."

    https://help.sap.com/docs/SAP_ERP_SPV/a193f2ae056e41b38356402f8e12bb50/84e8265313b9383ee10000000a423f68.html?locale=de-DE

  • Selecting data from BSEG. - SAP Q&A

    I have written one query to select data from BSEG table, but it is taking too much time to execute (40 sec per record) . I want to improve the performance of it. Please suggest the solutions. Query is below.

    "BSIM Secondary Index, Documents for Material"

    https://answers.sap.com/answers/2055073/view.html

  • View the full list of resources, SAP Help/Wiki pages and Q&A for BSIM


Related Tables

TABLE Description Functional Area
BSIS Accounting: Secondary Index for G/L Accounts FI - Financial Accounting
BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items) FI - Financial Accounting
BSAK Accounting: Secondary Index for Vendors (Cleared Items) FI - Financial Accounting
BSEG Accounting Document Segment FI - Financial Accounting
BSAD Accounting: Secondary Index for Customers (Cleared Items) FI - Financial Accounting

Transaction Codes for SAP Table BSIM

TCODE Description Functional Area
KEPH Segment-Specific Events CO - Profitability Analysis
MCHB RIS: Till Receipt - Selection Logistics - Retail Information System (RIS)
GLPCT Display Table GLPCT Enterprice Controlling - Profit Center Accounting
CSKB Start order Browser LO - Bills of Material
COSS Transport of C Tables PP - Production Orders
CEPC Display Table CEPC EC - Profit Center Accounting

FMs for SAP Table BSIM

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
REUSE_ALV_HIERSEQ_LIST_DISPLAY Hierarchical sequential list output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
PF_STATUS_SET Set general function key status RE - Real Estate Management

ABAP Reports for SAP Table BSIM

ABAP REPORT Description Functional Area
RM07MLBD Stock on Posting Date MM - Inventory Management
RFFOUS_C International Payment Medium - Check (with check management) FI - Payment Transactions
RFFOUS_T Payment Medium USA - Transfers/Bank Direct Debits in ACH Format FI - Payment Transactions
RHSOBJCH Transport: Reconcile OBJS with HR Database Tables Basis - Organizational Management
RMVKON00 Consignment and Pipeline Settlement MM - Invoice Verification
RSPC_MONITOR Monitoring of Selected Process Chains (Last Run) BW - Data Staging

BW Datasources for SAP Table BSIM

BW DATASOURCE Description Functional Area
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable
0CO_PC_PCP_01 Product Cost Planning: All Calculations CO - Product Cost Controlling
0CO_PC_PCP_03 Product Cost Planning: Itemizations Costing CO - Product Cost Controlling
2LIS_03_S198 Periodic plant stock MM - Materials Management
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management

Authorization Objects for SAP Table BSIM

AUTHORIZATION OBJECT Description Functional Area
M_MATE_WRK Material Master: Plants
ECM_REQ Change Management: Change Request
ECM_ORD Change Management: Change Order
J_1IRG23D Authorisation object for Depo Transactions
ECM_VAL Change Management: Validity
J_1IEWT_HC health check for Migration to EWT

Most searched SAP Materials Management Tables