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

BSIS is a standard SAP Table which is used to store Accounting: Secondary Index for G/L Accounts data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The BSIS table consists of various fields, each holding specific information or linking keys about Accounting: Secondary Index for G/L Accounts data available in SAP. These include BUKRS (Company Code), HKONT (General Ledger Account), AUGDT (Clearing Date), AUGBL (Document Number of the Clearing Document)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

BSIS table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP BSIS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BSIS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
AUGDTClearing Date AUGDTDATS8DATUM
AUGBLDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
ZUONRAssignment Number DZUONRCHAR18ZUONR
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BUDATPosting Date in the Document BUDATDATS8DATUM
BLDATDocument Date in Document BLDATDATS8DATUM
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
BLARTDocument Type BLARTCHAR2T003BLARTBAR
MONATFiscal Period MONATNUMC2MONAT
BSCHLPosting Key BSCHLCHAR2TBSLBSCHL
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
MWSKZTax on sales/purchases code MWSKZCHAR2T007AMWSKZ
FKONTFinancial Budget Item FIPLSNUMC3FIPLS
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
MWSTSTax Amount in Local Currency MWSTSCURR13(2) WERT7
WMWSTTax amount in document currency WMWSTCURR13(2) WERT7
SGTXTItem Text SGTXTCHAR50TEXT50
PROJNOld: Project number : No longer used --> PS_POSNR PROJNCHAR16PROJN
AUFNROrder Number AUFNR_NEUCHAR12AUFKALPHAAUFNRANR
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
XOPVWIndicator: Open item management? XOPVWCHAR1XFELD
VALUTValue date VALUTDATS8DATUM
BSTATDocument Status BSTAT_DCHAR1BSTAT
BDIFFValuation Difference BDIFFCURR13(2) WRTV7
BDIF2Valuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
VBUNDCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSLCUKY5TCURCWAERS
WVERWBill of exchange usage type WVERWCHAR1WVERW
DMBE2Amount in Second Local Currency DMBE2CURR13(2) WERT7
DMBE3Amount in Third Local Currency DMBE3CURR13(2) WERT7
MWST2Tax Amount in Second Local Currency MWST2CURR13(2) WERT7
MWST3Tax Amount in Third Local Currency MWST3CURR13(2) WERT7
BDIF3Valuation Difference for the Third Local Currency BDIF3CURR13(2) WRTV7
RDIF3Exchange Rate Difference Realized for Third Local Currency RDIF3CURR13(2) WRTV7
XRAGLIndicator: Clearing was Reversed XRAGLCHAR1XFELD
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
XSTOVIndicator: Document is flagged for reversal XSTOVCHAR1XFELD
XARCHIndicator: Document already archived ? XARCHCHAR1XFELD
PSWBTAmount for Updating in General Ledger PSWBTCURR13(2) WERT7
XNEGPIndicator: Negative posting XNEGPCHAR1XFELD
RFZEIPayment Card Item RFZEI_CCNUMC3NUM03
CCBTCPayment cards: Settlement run CCBTCCHAR10ALPHACCBTC
XREF3Reference key for line item XREF3CHAR20CHAR20
BUPLABusiness Place BUPLACHAR4J_1BBRANCHJ_1BBRANCH
PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFFCURR13(2) WRTV7
PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2CURR13(2) WRTV7
PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3CURR13(2) WRTV7
BEWARTransaction Type RMVCTCHAR3T856RMVCT
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
DABRZReference Date for Settlement DABRBEZDATS8DDAT
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
PPRCTPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
BUZIDIdentification of the Line Item BUZIDCHAR1CHAR1
AUGGJFiscal Year of Clearing Document AUGGJNUMC4GJAHRGJAHR
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
PGEBERPartner Fund FM_PFUNDCHAR10Assigned to domainBP_GEBERPARTNER_FUND
PGRANT_NBRPartner Grant GM_GRANT_PARTNERCHAR20ALPHAGM_GRANT_NBRGRANTS_GENERIC
MEASUREFunded Program FM_MEASURECHAR24Assigned to domainFM_MEASUREFM_MEASURE
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
PBUDGET_PDFM: Partner Budget Period FM_PBUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
.INCLU--AP 0
FIPEXCommitment item - Do not use field - see note 447805 FM_FIPEX_DONT_USECHAR24Assigned to domainFMCILFM_FIPEXFPS
.INCLU--AP 0
PRODPER JVA_PROD_MONTHACCP6BUPER
.INCLU--AP 0
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
.INCLU--AP 0
PROPMANOMandate, Mandate-Opening Contract REHORECNNRMCHAR13ALPHARECNNRREHORECNNRM

Key field Non-key field



How do I retrieve data from SAP table BSIS using ABAP code

The following ABAP code Example will allow you to do a basic selection on BSIS to SELECT all data from the table
DATA: WA_BSIS TYPE BSIS.

SELECT SINGLE *
FROM BSIS
INTO CORRESPONDING FIELDS OF WA_BSIS
WHERE...

How to access SAP table BSIS

Within an ECC or HANA version of SAP you can also view further information about BSIS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to BSIS

    SKA1 - G/L Account Master Record (Chart of Accounts)
        SKB1 - G/L Account Master Record (Company Code)
    GSEG - Offsetting Items for B-Segment in Reporting
    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