1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to FAGLBSIS_BAK 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_BAK 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_BAK table

Table FAGLBSIS_BAK technical data

TableFAGLBSIS_BAK
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_BAK 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_BAK 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

    • FAGLBSIS_BAK related tables

    • FAGL_DRPROV_PERC : Provisions for Doubtful Receivables: Percentages
    • FAGLBSIS_BAK : Accounting: Secondary Index for G/L Accounts
    • FAGL_DRPROV_METH : Provision Method for Provisons for Doubtful Receivables
    • FAGL_DRPROV_ACC : Provisions for Doubtful Receivables: Account Determination
    • FAGLBSAS_BAK : Accounting: Secondary Index for G/L Accounts (Cleared Items)
    • FAGLBSAS : Accounting: Secondary Index for G/L Accounts (Cleared Items)
    • FAGLBSIS : Accounting: Secondary Index for G/L Accounts

    Related References

    Related Tutorials

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

    FAGLBSIS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Accounting:...

    FAGLBSAS SAP table for – Accounting: Secondary Index for G/L Accounts (Cleared Items)

    FAGLBSAS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Accounting:...

    FAGLBSAS_BAK SAP table for – Accounting: Secondary Index for G/L Accounts (Cleared Items)

    FAGLBSAS_BAK table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Accounting:...

    J_3RTSE SAP table for – Secondary index table for VAT

    J_3RTSE table in SAP FI (Localization in FI) module. This table is used for storing data of Secondary index table...

    J_3RDOPDEB SAP table for – Secondary index table for VAT

    J_3RDOPDEB table in SAP FI (Localization in FI) module. This table is used for storing data of Secondary index table...

    J_3RFSEC_ITEM SAP table for – Data for Secondary events for deferred tax

    J_3RFSEC_ITEM table in SAP FI (Localization in FI) module. This table is used for storing data of Data for Secondary...

    BSEG_ADD SAP table for – Entry View of Accounting Document for Additional Ledgers

    BSEG_ADD table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Entry...

    «
    »