FAGLBSIS SAP table for – Accounting: Secondary Index for G/L Accounts

Here we would like to draw your attention to FAGLBSIS table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). FAGLBSIS is a SAP standard transp table used for storing Accounting: Secondary Index for G/L Accounts related data in SAP. It comes under the package FAGL_POSTING_SERV_EHP3_SFWC_DD.

SAP FAGLBSIS table

Table FAGLBSIS technical data

TableFAGLBSIS
Data storingAccounting: Secondary Index for G/L Accounts
ModuleFI
Sub ModuleFI-GL
SAP PackageFAGL_POSTING_SERV_EHP3_SFWC_DD
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FAGLBSIS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FAGLBSIS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • HKONT : General Ledger Account
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • AUGDT : Clearing Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUGBL : Document Number of the Clearing Document
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • ZUONR : Assignment number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BUZEI : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • XBLNR : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • MONAT : Fiscal period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • FKONT : Financial Budget Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DMBTR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • WRBTR : Amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • MWSTS : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • WMWST : Tax amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • PROJN : Old: Project number : No longer used –> PS_POSNR
    Its data type is CHAR (Character String) with field length 16
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • ZFBDT : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XOPVW : Indicator: Open Item Management?
    Its data type is CHAR (Character String) with field length 1
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BSTAT : Document Status
    Its data type is CHAR (Character String) with field length 1
  • BDIFF : Valuation Difference
    Its data type is CURR (Currency Field) with field length 13
  • BDIF2 : Valuation Difference for the Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • PSWSL : Update Currency for General Ledger Transaction Figures
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WVERW : Bill of Exchange Usage Type
    Its data type is CHAR (Character String) with field length 1
  • DMBE2 : Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • DMBE3 : Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • MWST2 : Tax Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • MWST3 : Tax Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • BDIF3 : Valuation Difference for the Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • RDIF3 : Exchange Rate Difference Realized for Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • XRAGL : Indicator: Clearing was Reversed
    Its data type is CHAR (Character String) with field length 1
  • PROJK : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • XSTOV : Indicator: Document is flagged for reversal
    Its data type is CHAR (Character String) with field length 1
  • XARCH : Indicator: Document already archived ?
    Its data type is CHAR (Character String) with field length 1
  • PSWBT : Amount for Updating in General Ledger
    Its data type is CURR (Currency Field) with field length 13
  • XNEGP : Indicator: Negative posting
    Its data type is CHAR (Character String) with field length 1
  • RFZEI : Payment Card Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CCBTC : Payment cards: Settlement run
    Its data type is CHAR (Character String) with field length 10
  • XREF3 : Reference key for line item
    Its data type is CHAR (Character String) with field length 20
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • PPDIFF : Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
    Its data type is CURR (Currency Field) with field length 13
  • PPDIF2 : Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
    Its data type is CURR (Currency Field) with field length 13
  • PPDIF3 : Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
    Its data type is CURR (Currency Field) with field length 13
  • BEWAR : Transaction type
    Its data type is CHAR (Character String) with field length 3
  • IMKEY : Internal Key for Real Estate Object
    Its data type is CHAR (Character String) with field length 8
  • DABRZ : Reference date for settlement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INTRENO : Internal Real Estate Master Data Code
    Its data type is CHAR (Character String) with field length 13
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • FKBER : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • FIPOS : Commitment Item
    Its data type is CHAR (Character String) with field length 14
  • FISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • GEBER : Fund
    Its data type is CHAR (Character String) with field length 10
  • PPRCT : Partner Profit Center
    Its data type is CHAR (Character String) with field length 10
  • BUZID : Identification of the Line Item
    Its data type is CHAR (Character String) with field length 1
  • AUGGJ : Fiscal Year of Clearing Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • PSEGMENT : Partner Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • PRODPER : Produktionsmonat
    Its data type is ACCP (Posting period YYYYMM) with field length 6
  • QSSKZ : Withholding Tax Code
    Its data type is CHAR (Character String) with field length 2
  • LDGRP : Ledger Group
    Its data type is CHAR (Character String) with field length 4
  • REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • REBZJ : Fiscal Year of the Relevant Invoice (for Credit Memo)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REBZZ : Line Item in the Relevant Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REBZT : Follow-On Document Type
    Its data type is CHAR (Character String) with field length 1
  • BUDGET_PD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 10