BSIS is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting: Secondary Index for G/L Accounts data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for BSIS. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

BSIS — Meta Data

Description: Accounting: Secondary Index for G/L Accounts
Main Category: FI
Sub Category: Financial Accounting
Table type: Transparent Table (TRANSP)

BSIS — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3
    2 BUKRS Company Code X CHAR 4
    3 HKONT G/L X CHAR 10
    4 AUGDT Clearing X DATS 8
    5 AUGBL Clrng doc. X CHAR 10
    6 ZUONR Assignment X CHAR 18
    7 GJAHR Fiscal Year X NUMC 4
    8 BELNR Document Number X CHAR 10
    9 BUZEI Posting row X NUMC 3
    10 BUDAT Posting Date DATS 8
    11 BLDAT Document Date DATS 8
    12 WAERS Currency CUKY 5 TCURC
    13 XBLNR Reference CHAR 16
    14 BLART Document Type CHAR 2 T003
    15 MONAT Period NUMC 2
    16 BSCHL Posting key CHAR 2 TBSL
    17 SHKZG Debit/Credit CHAR 1
    18 GSBER Business Area CHAR 4 TGSB
    19 MWSKZ Tax code CHAR 2 T007A
    20 FKONT Financial Budget Item NUMC 3
    21 DMBTR Amount in LC CURR 23
    22 WRBTR Amount CURR 23
    23 MWSTS Tax Amount in Local Currency CURR 23
    24 WMWST Tax Amount in Document Currency CURR 23
    25 SGTXT Name CHAR 50
    26 PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16
    27 AUFNR Order CHAR 12 AUFK
    28 WERKS Plant CHAR 4 T001W
    29 KOSTL Cost Center CHAR 10
    30 ZFBDT Baseline date DATS 8
    31 XOPVW OI management CHAR 1
    32 VALUT Value date DATS 8
    33 BSTAT Doc.status CHAR 1
    34 BDIFF Valuation diff. CURR 23
    35 BDIF2 Valuation diff. 2 CURR 23
    36 VBUND Trading Partner CHAR 6 T880
    37 PSWSL G/L currency CUKY 5 TCURC
    38 WVERW Usage CHAR 1
    39 DMBE2 Amt loc.curr.2 CURR 23
    40 DMBE3 Amt loc. curr.3 CURR 23
    41 MWST2 Tax Amount in Second Local Currency CURR 23
    42 MWST3 Tax Amount in Third Local Currency CURR 23
    43 BDIF3 Valuation diff. 3 CURR 23
    44 RDIF3 Exchange Rate Difference Realized for Third Local Currency CURR 23
    45 XRAGL Indicator: Clearing Was Reversed CHAR 1
    46 PROJK WBS element NUMC 8 PRPS
    47 PRCTR Profit Center CHAR 10
    48 XSTOV Indicator: Document Is Flagged for Reversal CHAR 1
    49 XARCH Character Field of Length 1 CHAR 1
    50 PSWBT General ledger amt CURR 23
    51 XNEGP Negative pstng CHAR 1
    52 RFZEI Pmnt card item NUMC 3
    53 CCBTC Settlement CHAR 10
    54 XREF3 Reference key 3 CHAR 20
    55 BUPLA Business Place CHAR 4 J_1BBRANCH
    56 PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) CURR 23
    57 PPDIF2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) CURR 23
    58 PPDIF3 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) CURR 23
    59 BEWAR Transactn Type CHAR 3 T856
    60 IMKEY Real Estate Key CHAR 8
    61 DABRZ Reference Date DATS 8
    62 INTRENO Internal Key of Real Estate Object CHAR 13
    63 GRANT_NBR Grant CHAR 20
    64 FKBER Functional Area CHAR 16
    65 FIPOS Commitment Item CHAR 14
    66 FISTL Funds Center CHAR 16
    67 GEBER Fund CHAR 10
    68 PPRCT Partner PC CHAR 10
    69 BUZID Line item ID CHAR 1
    70 AUGGJ Clrg Fiscal Yr NUMC 4
    71 UZAWE Pmt meth.supl. CHAR 2
    72 SEGMENT Segment CHAR 10
    73 PSEGMENT Partner Segment CHAR 10
    74 PGEBER Partner Fund CHAR 10
    75 PGRANT_NBR Partner Grant CHAR 20
    76 MEASURE Funded Program CHAR 24
    77 BUDGET_PD Budget Period CHAR 10
    78 PBUDGET_PD Par. BudPer CHAR 10
    79 FIPEX Commitment Item CHAR 1
    80 _DATAAGING Data Filter Value for Data Aging DATS 8
    81 KIDNO Payment Ref. CHAR 30
    82 PRODPER Joint Venture Production Date ACCP 6
    83 QSSKZ Withholding Tax Code CHAR 2
    84 PROPMANO Real Estate Management Mandate CHAR 13
    85 GKONT Offsetting acct CHAR 10
    86 GKART Offst.acct type CHAR 1
    87 GHKON CHAR 10
    88 LOGSYSTEM_SENDER Logical destination (specified in function call) CHAR 10
    89 BUKRS_SENDER Company Code CHAR 4
    90 BELNR_SENDER Accounting Document Number CHAR 10
    91 GJAHR_SENDER Fiscal Year of Document in Sender System NUMC 4
    92 BUZEI_SENDER Number of Line Item Within Accounting Document NUMC 3

SAP Help, Wiki Resources, and Forum Discussions on BSIS

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


Related Tables

TABLE Description Functional Area
BSEG Accounting Document Segment FI - Financial Accounting
BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items) FI - Financial Accounting
BSIK Accounting: Secondary Index for Vendors FI - Financial Accounting
BSID Accounting: Secondary Index for Customers FI - Financial Accounting
BSAK Accounting: Secondary Index for Vendors (Cleared Items) FI - Financial Accounting
BSAD Accounting: Secondary Index for Customers (Cleared Items) FI - Financial Accounting
SKA1 G/L Account Master (Chart of Accounts) FI - Financial Accounting

Transaction Codes for SAP Table BSIS

TCODE Description Functional Area
FBL3N G/L Account Line Items FI - Information System
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
MIRO Enter Incoming Invoice MM - Invoice Verification
SE16 Data Browser Basis - Workbench Utilities
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
FB03 Display Document FI - Financial Accounting
FS10N Balance Display FI - Financial Accounting

FMs for SAP Table BSIS

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_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
SET_PF_STATUS Setzen Pf-Status Basis - ABAP Editor
F4IF_INT_TABLE_VALUE_REQUEST F4 help also returning the value to be displayed in internal table Basis - F4 Help

ABAP Reports for SAP Table BSIS

ABAP REPORT Description Functional Area
RFSEPA01 Switch On Line Item Display by Changing Master Record FI - Financial Accounting
RFSEPA02 Switch On Open Item Management by Changing Master Record FI - Financial Accounting
RFITEMGL G/L Account Line Item Display FI - Information System
RECON Include RECON PP - Material Identification and Reconciliation
BALVBUFDEL Reset ALV buffer Basis - SAP List Viewer
SAPF124 Automatic Clearing FI - Financial Accounting
RFSEPA03 Switch Off Open Item Management by Changing Master Record FI - Financial Accounting
RFBIBL00 Batch Input Documents FI - Financial Accounting

BW Datasources for SAP Table BSIS

BW DATASOURCE Description Functional Area
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable
0FI_AR_3 Customers: Line Items FI - Accounts Receivable
0FI_AP_3 Vendors: Line Items FI - Accounts Payable
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
0GLACCEXT_T011_HIER Financial Statement Item FI - Financial Accounting
0FI_GL_6 General Ledger Sales Figures via Delta Extraction FI - General Ledger Accounting

Authorization Objects for SAP Table BSIS

AUTHORIZATION OBJECT Description Functional Area
E_GRID Authorization Object for Grid
F_BKPF_BES Accounting Document: Account Authorization for G/L Accounts
CMS_CAG Authorization object for CAG
S_RFC Authorization Check for RFC Access
F_BKPF_KOA Accounting Document: Authorization for Account Types
M_MATE_WRK Material Master: Plants
CMS_RBL Authorization object for receivable in CMS