SAP TABLES | Financial Accounting(FI) SAP FI

BSIS SAP Accounting: Secondary Index for G/L Accounts Table and data







BSIS is a standard SAP Table which is used to store Accounting: Secondary Index for G/L Accounts data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP BSIS Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP BSIS Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
BUKRSBUKRSCHAR4
*
Company Code
HKONTHKONTCHAR10
*
General Ledger AccountALPHA
AUGDTAUGDTDATS8 Clearing Date
AUGBLAUGBLCHAR10 Document Number of the Clearing DocumentALPHA
ZUONRDZUONRCHAR18 Assignment Number
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
BUDATBUDATDATS8 Posting Date in the Document
BLDATBLDATDATS8 Document Date in Document
WAERSWAERSCUKY5 TCURCCurrency Key
XBLNRXBLNR1CHAR16 Reference Document Number
BLARTBLARTCHAR2 T003Document Type
MONATMONATNUMC2 Fiscal Period
BSCHLBSCHLCHAR2 TBSLPosting Key
SHKZGSHKZGCHAR1 Debit/Credit Indicator
GSBERGSBERCHAR4 TGSBBusiness Area
MWSKZMWSKZCHAR2 T007ATax on sales/purchases code
FKONTFIPLSNUMC3 Financial Budget Item
DMBTRDMBTRCURR13(2) Amount in Local Currency
WRBTRWRBTRCURR13(2) Amount in document currency
MWSTSMWSTSCURR13(2) Tax Amount in Local Currency
WMWSTWMWSTCURR13(2) Tax amount in document currency
SGTXTSGTXTCHAR50 Item Text
PROJNPROJNCHAR16 Old: Project number : No longer used --> PS_POSNR
AUFNRAUFNR_NEUCHAR12 AUFKOrder NumberALPHA
WERKSWERKS_DCHAR4 T001WPlant
KOSTLKOSTLCHAR10
*
Cost CenterALPHA
ZFBDTDZFBDTDATS8 Baseline Date for Due Date Calculation
XOPVWXOPVWCHAR1 Indicator: Open item management?
VALUTVALUTDATS8 Value date
BSTATBSTAT_DCHAR1 Document Status
BDIFFBDIFFCURR13(2) Valuation Difference
BDIF2BDIF2CURR13(2) Valuation Difference for the Second Local Currency
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
PSWSLPSWSLCUKY5 TCURCUpdate Currency for General Ledger Transaction Figures
WVERWWVERWCHAR1 Bill of exchange usage type
DMBE2DMBE2CURR13(2) Amount in Second Local Currency


DMBE3DMBE3CURR13(2) Amount in Third Local Currency
MWST2MWST2CURR13(2) Tax Amount in Second Local Currency
MWST3MWST3CURR13(2) Tax Amount in Third Local Currency
BDIF3BDIF3CURR13(2) Valuation Difference for the Third Local Currency
RDIF3RDIF3CURR13(2) Exchange Rate Difference Realized for Third Local Currency
XRAGLXRAGLCHAR1 Indicator: Clearing was Reversed
PROJKPS_PSP_PNRNUMC8 PRPSWork Breakdown Structure Element (WBS Element)ABPSP
PRCTRPRCTRCHAR10
*
Profit CenterALPHA
XSTOVXSTOVCHAR1 Indicator: Document is flagged for reversal
XARCHXARCHCHAR1 Indicator: Document already archived ?
PSWBTPSWBTCURR13(2) Amount for Updating in General Ledger
XNEGPXNEGPCHAR1 Indicator: Negative posting
RFZEIRFZEI_CCNUMC3 Payment Card Item
CCBTCCCBTCCHAR10 Payment cards: Settlement runALPHA
XREF3XREF3CHAR20 Reference key for line item
BUPLABUPLACHAR4 J_1BBRANCHBusiness Place
PPDIFFPPDIFFCURR13(2) Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
PPDIF2PPDIF2CURR13(2) Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
PPDIF3PPDIF3CURR13(2) Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
BEWARRMVCTCHAR3 T856Transaction Type
IMKEYIMKEYCHAR8 Internal Key for Real Estate ObjectIMKEY
DABRZDABRBEZDATS8 Reference Date for Settlement
INTRENOVVINTRENOCHAR13 Internal Real Estate Master Data Code
GRANT_NBRGM_GRANT_NBRCHAR20 GrantALPHA
FKBERFKBERCHAR16
*
Functional Area
FIPOSFIPOSCHAR14
*
Commitment ItemFMCIS
FISTLFISTLCHAR16
*
Funds Center
GEBERBP_GEBERCHAR10
*
Fund
PPRCTPPRCTRCHAR10
*
Partner Profit CenterALPHA
BUZIDBUZIDCHAR1 Identification of the Line Item
AUGGJAUGGJNUMC4 Fiscal Year of Clearing DocumentGJAHR
UZAWEUZAWECHAR2
*
Payment Method Supplement
SEGMENTFB_SEGMENTCHAR10
*
Segment for Segmental ReportingALPHA
PSEGMENTFB_PSEGMENTCHAR10
*
Partner Segment for Segmental ReportingALPHA
PGEBERFM_PFUNDCHAR10
*
Partner Fund
PGRANT_NBRGM_GRANT_PARTNERCHAR20 Partner GrantALPHA
MEASUREFM_MEASURECHAR24
*
Funded Program
BUDGET_PDFM_BUDGET_PERIODCHAR10
*
FM: Budget Period
PBUDGET_PDFM_PBUDGET_PERIODCHAR10
*
FM: Partner Budget Period


.APPENDABSIS_PSO Local Authorities
FIPEXFM_FIPEX_DONT_USECHAR24
*
Commitment item - Do not use field - see note 447805FMCIL
.APPENDJVA_BSIS Joint Venture Accounting
PRODPERJVA_PROD_MONTHACCP6 Produktionsmonat
.APPENDJ_1IEWTCODE withholding Tax Code
QSSKZQSSKZCHAR2
*
Withholding Tax Code
.APPENDREPR_BSIS Append zur Mandatsverwaltung BSIS
.INCLUDEREPR_APPEND Append Struktur für die Mandatsnummer
PROPMANOREHORECNNRMCHAR13 Mandate, Mandate-Opening ContractALPHA



Key field
Non-key field

BSIS relationships with other tables


SKA1-G/L Account Master Record (Chart of Accounts)
     SKB1-G/L Account Master Record (Company Code)
          SKC1A-G/L Sales Segment Derived from GLDB - Internal
          SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-
          FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
          BSIS-Accounting: Secondary Index for G/L Accounts
               ADMI_FILES-Archive Files
               BSISEXT-Secondary Index & Additions Section (BSEGA)
               BKPF-Accounting Document Header
                    BSEG-Accounting Document Segment
                         GSEG-Offsetting Items for B-Segment in Reporting