1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to FAGLBSAS_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). FAGLBSAS_BAK is a SAP standard transp table used for storing Accounting: Secondary Index for G/L Accounts (Cleared Items) related data in SAP. It comes under the package FAGL_POSTING_SERV_EHP3_SFWC_DD.

SAP FAGLBSAS_BAK table

Table FAGLBSAS_BAK technical data

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

SAP FAGLBSAS_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 FAGLBSAS_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

    • FAGLBSAS_BAK related tables

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

    Related References

    Related Tutorials

    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:...

    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:...

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

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

    /SAPPCE/TDPCIDXC SAP table for – Down Payment Chain: Index for Cleared Items

    /SAPPCE/TDPCIDXC table in SAP FI (Additional Functions in FI) module. This table is used for storing data of Down Payment...

    DFKKCIBW SAP table for – FICA: Extraction of Cleared Items

    DFKKCIBW table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    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...

    TCJ_WTAX_ITEMS SAP table for – Withholding Tax Items for Cash Journal Document Items

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

    «
    »