1. Home
  2. Resources
  3. SAP Tables
  4. BSIS - Accounting: Secondary Index for G/L Accounts

SAP Table BSIS

Accounting: Secondary Index for G/L Accounts

BSIS (Accounting: Secondary Index for G/L Accounts) 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 BSIS to other SAP tables.

BSIS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
HKONT General Ledger Account HKONT CHAR 10 0
AUGDT Clearing Date AUGDT DATS 8 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
ZUONR Assignment Number DZUONR CHAR 18 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
WAERS Currency Key WAERS TCURC CUKY 5 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BLART Document Type BLART T003 CHAR 2 0
MONAT Fiscal Period MONAT NUMC 2 0
BSCHL Posting Key BSCHL TBSL CHAR 2 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
GSBER Business Area GSBER TGSB CHAR 4 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
FKONT Financial Budget Item FIPLS NUMC 3 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
WRBTR Amount in document currency WRBTR CURR 13 2
MWSTS Tax Amount in Local Currency MWSTS CURR 13 2
WMWST Tax amount in document currency WMWST CURR 13 2
SGTXT Item Text SGTXT CHAR 50 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
AUFNR Order Number AUFNR_NEU AUFK CHAR 12 0
WERKS Plant WERKS_D T001W CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
XOPVW Indicator: Open item management? XOPVW CHAR 1 0
X Yes
NULL No
VALUT Value date VALUT DATS 8 0
BSTAT Document Status BSTAT_D CHAR 1 0
NULL Normal document
A Clearing Document
B Reset clearing document
D Recurring entry document
L Posting Not in Leading Ledger
M Sample document
S Noted items
V Parked document
W Parked document with change of document ID
Z Parked document which was deleted
C Balance Carryforward Line Items
BDIFF Valuation Difference BDIFF CURR 13 2
BDIF2 Valuation Difference for the Second Local Currency BDIF2 CURR 13 2
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
PSWSL Update Currency for General Ledger Transaction Figures PSWSL TCURC CUKY 5 0
WVERW Bill of exchange usage type WVERW CHAR 1 0
D Discounting
F Forfeiting
I Collection
DMBE2 Amount in Second Local Currency DMBE2 CURR 13 2
DMBE3 Amount in Third Local Currency DMBE3 CURR 13 2
MWST2 Tax Amount in Second Local Currency MWST2 CURR 13 2
MWST3 Tax Amount in Third Local Currency MWST3 CURR 13 2
BDIF3 Valuation Difference for the Third Local Currency BDIF3 CURR 13 2
RDIF3 Exchange Rate Difference Realized for Third Local Currency RDIF3 CURR 13 2
XRAGL Indicator: Clearing was Reversed XRAGL CHAR 1 0
X Yes
NULL No
PROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
PRCTR Profit Center PRCTR CHAR 10 0
XSTOV Indicator: Document is flagged for reversal XSTOV CHAR 1 0
X Yes
NULL No
XARCH Indicator: Document already archived ? XARCH CHAR 1 0
X Yes
NULL No
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
RFZEI Payment Card Item RFZEI_CC NUMC 3 0
CCBTC Payment cards: Settlement run CCBTC CHAR 10 0
XREF3 Reference key for line item XREF3 CHAR 20 0
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFF CURR 13 2
PPDIF2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2 CURR 13 2
PPDIF3 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3 CURR 13 2
BEWAR Transaction Type RMVCT T856 CHAR 3 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR 13 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
FKBER Functional Area FKBER CHAR 16 0
FIPOS Commitment Item FIPOS CHAR 14 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
PPRCT Partner Profit Center PPRCTR CHAR 10 0
BUZID Identification of the Line Item BUZID CHAR 1 0
AUGGJ Fiscal Year of Clearing Document AUGGJ NUMC 4 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT CHAR 10 0
PGEBER Partner Fund FM_PFUND CHAR 10 0
PGRANT_NBR Partner Grant GM_GRANT_PARTNER CHAR 20 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
PBUDGET_PD FM: Partner Budget Period FM_PBUDGET_PERIOD CHAR 10 0
FIPEX Commitment item - Do not use field - see note 447805 FM_FIPEX_DONT_USE CHAR 24 0
PRODPER JVA_PROD_MONTH ACCP 6 0
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OINEGPSTG Negative posting line (exchange fees) OIA_NGPSTL CHAR 1 0
X Yes
NULL No
PROPMANO Mandate, Mandate-Opening Contract REHORECNNRM CHAR 13 0

BSIS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BSIS AUFNR BSIS MANDT AUFK Order master data MANDT
BSIS AUFNR BSIS AUFNR AUFK Order master data AUFNR
BSIS BEWAR BSIS BEWAR T856 Transaction Types TRTYP
BSIS BEWAR BSIS MANDT T856 Transaction Types MANDT
BSIS BLART BSIS BLART T003 Document Types BLART
BSIS BLART BSIS MANDT T003 Document Types MANDT
BSIS BSCHL BSIS MANDT TBSL Posting Key MANDT
BSIS BSCHL BSIS BSCHL TBSL Posting Key BSCHL
BSIS BUPLA BSIS BUPLA J_1BBRANCH Business Place BRANCH
BSIS BUPLA BSIS MANDT J_1BBRANCH Business Place MANDT
BSIS BUPLA * J_1BBRANCH Business Place BUKRS
BSIS GSBER SYST MANDT TGSB Business Areas MANDT
BSIS GSBER BSIS GSBER TGSB Business Areas GSBER
BSIS MWSKZ BSIS MANDT T007A Tax Keys MANDT
BSIS MWSKZ * T007A Tax Keys KALSM
BSIS MWSKZ BSIS MWSKZ T007A Tax Keys MWSKZ
BSIS PROJK BSIS MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
BSIS PROJK BSIS PROJK PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
BSIS PSWSL BSIS MANDT TCURC Currency Codes MANDT
BSIS PSWSL BSIS PSWSL TCURC Currency Codes WAERS
BSIS VBUND BSIS MANDT T880 Global Company Data (for KONS Ledger) MANDT
BSIS VBUND BSIS VBUND T880 Global Company Data (for KONS Ledger) RCOMP
BSIS WAERS BSIS MANDT TCURC Currency Codes MANDT
BSIS WAERS BSIS WAERS TCURC Currency Codes WAERS
BSIS WERKS BSIS MANDT T001W Plants/Branches MANDT
BSIS WERKS BSIS WERKS T001W Plants/Branches WERKS