Search by table name, fields

SAP BSIS_BAK Table – Accounting: Secondary Index for G/L Accounts

The BSIS_BAK table in SAP ERP or S/4HANA stores Accounting: Secondary Index for G/L Accounts data. There are total 82 fields in BSIS_BAK table. The Accounting: Secondary Index for G/L Accounts table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BSIS_BAK table. It is in Financial Accounting “Basis” (FBAS) ABAP package and is part of the Financial Accounting (FI) module.

SAP BSIS_BAK Table Fields

Following is the list of fields that are available in SAP BSIS_BAK table. The primary key fields of the table are MANDT (Client), BUKRS (Company Code), HKONT (General Ledger Account), AUGDT (Clearing Date), AUGBL (Document Number of the Clearing Document), ZUONR (Assignment number), GJAHR (Fiscal Year), BELNR (Accounting Document Number), BUZEI (Number of Line Item Within Accounting Document).

Field Description Data Element Check Table Data Type
MANDT Client MANDT CLNT (3)
BUKRS Company Code BUKRS CHAR (4)
HKONT General Ledger Account HKONT CHAR (10)
AUGDT Clearing Date AUGDT DATS (8)
AUGBL Document Number of the Clearing Document AUGBL CHAR (10)
ZUONR Assignment number DZUONR CHAR (18)
GJAHR Fiscal Year GJAHR NUMC (4)
BELNR Accounting Document Number BELNR_D CHAR (10)
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC (3)
BUDAT Posting Date in the Document BUDAT DATS (8)
BLDAT Document Date in Document BLDAT DATS (8)
WAERS Currency Key WAERS TCURC CUKY (5)
XBLNR Reference Document Number XBLNR1 CHAR (16)
BLART Document Type BLART T003 CHAR (2)
MONAT Fiscal period MONAT NUMC (2)
BSCHL Posting Key BSCHL TBSL CHAR (2)
SHKZG Debit/Credit Indicator SHKZG CHAR (1)
GSBER Business Area GSBER TGSB CHAR (4)
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR (2)
FKONT Financial Budget Item FIPLS NUMC (3)
DMBTR Amount in local currency DMBTR CURR (23)
WRBTR Amount in document currency WRBTR CURR (23)
MWSTS Tax Amount in Local Currency MWSTS CURR (23)
WMWST Tax Amount in Document Currency WMWST CURR (23)
SGTXT Item Text SGTXT CHAR (50)
PROJN Old: Project number : No longer used –> PS_POSNR PROJN CHAR (16)
AUFNR Order Number AUFNR_NEU AUFK CHAR (12)
WERKS Plant WERKS_D T001W CHAR (4)
KOSTL Cost Center KOSTL CHAR (10)
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS (8)
XOPVW Indicator: Open Item Management? XOPVW CHAR (1)
VALUT Value date VALUT DATS (8)
BSTAT Document Status BSTAT_D CHAR (1)
BDIFF Valuation Difference BDIFF CURR (23)
BDIF2 Valuation Difference for the Second Local Currency BDIF2 CURR (23)
VBUND Company ID of Trading Partner RASSC T880 CHAR (6)
PSWSL Update Currency for General Ledger Transaction Figures PSWSL TCURC CUKY (5)
WVERW Bill of Exchange Usage Type WVERW CHAR (1)
DMBE2 Amount in Second Local Currency or General Currency DMBE2 CURR (23)
DMBE3 Amount in Third Local Currency or First Freely-Def. Currency DMBE3 CURR (23)
MWST2 Tax Amount in Second Local Currency MWST2 CURR (23)
MWST3 Tax Amount in Third Local Currency MWST3 CURR (23)
BDIF3 Valuation Difference for the Third Local Currency BDIF3 CURR (23)
RDIF3 Exchange Rate Difference Realized for Third Local Currency RDIF3 CURR (23)
XRAGL Indicator: Clearing Was Reversed XRAGL CHAR (1)
PROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC (8)
PRCTR Profit Center PRCTR CHAR (10)
XSTOV Indicator: Document Is Flagged for Reversal XSTOV CHAR (1)
XARCH Indicator: Document Already Archived? XARCH CHAR (1)
PSWBT Amount for Updating in General Ledger PSWBT CURR (23)
XNEGP Indicator: Negative Posting XNEGP CHAR (1)
RFZEI Payment Card Item RFZEI_CC NUMC (3)
CCBTC Payment cards: Settlement run CCBTC CHAR (10)
XREF3 Reference key for line item XREF3 CHAR (20)
BUPLA Business Place BUPLA J_1BBRANCH CHAR (4)
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFF CURR (23)
PPDIF2 Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts) PPDIF2 CURR (23)
PPDIF3 Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts) PPDIF3 CURR (23)
BEWAR Transaction type RMVCT T856 CHAR (3)
IMKEY Internal Key for Real Estate Object IMKEY CHAR (8)
DABRZ Reference date for settlement DABRBEZ DATS (8)
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR (13)
GRANT_NBR Grant GM_GRANT_NBR CHAR (20)
FKBER Functional Area FKBER CHAR (16)
FIPOS Commitment Item FIPOS CHAR (14)
FISTL Funds Center FISTL CHAR (16)
GEBER Fund BP_GEBER CHAR (10)
PPRCT Partner Profit Center PPRCTR CHAR (10)
BUZID Identification of the Line Item BUZID CHAR (1)
AUGGJ Fiscal Year of Clearing Document AUGGJ NUMC (4)
UZAWE Payment method supplement UZAWE CHAR (2)
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR (10)
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT CHAR (10)
PGEBER Partner Fund FM_PFUND CHAR (10)
PGRANT_NBR Partner Grant GM_GRANT_PARTNER CHAR (20)
MEASURE Funded Program FM_MEASURE CHAR (24)
BUDGET_PD Budget Period FM_BUDGET_PERIOD CHAR (10)
PBUDGET_PD FM: Partner Budget Period FM_PBUDGET_PERIOD CHAR (10)
FIPEX Commitment item – Do not use field – see note 447805 FM_FIPEX_DONT_USE CHAR (24)
PRODPER Production Month JVA_PROD_MONTH ACCP (6)
QSSKZ Withholding Tax Code QSSKZ CHAR (2)
PROPMANO Mandate, Mandate-Opening Contract REHORECNNRM CHAR (13)