1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to BSEG_ADD 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). BSEG_ADD is a SAP standard transp table used for storing Entry View of Accounting Document for Additional Ledgers related data in SAP. It comes under the package FAGL_DB_PERSISTENCY.

SAP BSEG_ADD table

Table BSEG_ADD technical data

TableBSEG_ADD
Data storingEntry View of Accounting Document for Additional Ledgers
ModuleFI
Sub ModuleFI-GL
SAP PackageFAGL_DB_PERSISTENCY
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP BSEG_ADD 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 BSEG_ADD 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
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI : Six-figure number of line item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • BSTAT : Document Status
    Its data type is CHAR (Character String) with field length 1
  • BUZID : Identification of the Line Item
    Its data type is CHAR (Character String) with field length 1
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • DMBTR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 23
  • WRBTR : Amount in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • KTOSL : Transaction Key
    Its data type is CHAR (Character String) with field length 3
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • VBUND : Company ID
    Its data type is CHAR (Character String) with field length 6
  • BEWAR : Consolidation Transaction Type
    Its data type is CHAR (Character String) with field length 3
  • ALTKT : Group Account Number
    Its data type is CHAR (Character String) with field length 10
  • VORGN : Transaction Type for General Ledger
    Its data type is CHAR (Character String) with field length 4
  • KOKRS : Controlling Area
    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
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • ANBWA : Asset Transaction Type
    Its data type is CHAR (Character String) with field length 3
  • XAUTO : Indicator: Line item automatically created
    Its data type is CHAR (Character String) with field length 1
  • XNCOP : Indicator: Items Cannot Be Copied?
    Its data type is CHAR (Character String) with field length 1
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • XBILK : Indicator: Account is a balance sheet account?
    Its data type is CHAR (Character String) with field length 1
  • GVTYP : P&L statement account type
    Its data type is CHAR (Character String) with field length 2
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • MENGE : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • RECID : Recovery Indicator
    Its data type is CHAR (Character String) with field length 2
  • EGRUP : Equity group
    Its data type is CHAR (Character String) with field length 3
  • VPTNR : Partner account number
    Its data type is CHAR (Character String) with field length 10
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • FIPOS : Commitment Item
    Its data type is CHAR (Character String) with field length 14
  • KSTRG : Cost Object
    Its data type is CHAR (Character String) with field length 12
  • NPLNR : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • AUFPL : Task List Number for Operations in Order
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • APLZL : General Counter for Order
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PROJK : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • PASUBNR : Profitability Segment Changes (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DMBE2 : Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 23
  • DMBE3 : Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 23
  • LOKKT : Alternative Account Number in Company Code
    Its data type is CHAR (Character String) with field length 10
  • 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
  • XREF1 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XREF2 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • KBLNR : Document number for earmarked funds
    Its data type is CHAR (Character String) with field length 10
  • KBLPOS : Earmarked Funds: Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • OBZEI : Number of Line Item in Original Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • XNEGP : Indicator: Negative posting
    Its data type is CHAR (Character String) with field length 1
  • XREF3 : Reference key for line item
    Its data type is CHAR (Character String) with field length 20
  • KONTT : Account Assignment Category for Industry Solution
    Its data type is CHAR (Character String) with field length 2
  • KONTL : Acct assignment string for industry-specific acct assignmnts
    Its data type is CHAR (Character String) with field length 50
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • SECCO : Section Code
    Its data type is CHAR (Character String) with field length 4
  • LSTAR : Activity Type
    Its data type is CHAR (Character String) with field length 6
  • PRZNR : Business Process
    Its data type is CHAR (Character String) with field length 12
  • 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
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • 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
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PGEBER : Partner Fund
    Its data type is CHAR (Character String) with field length 10
  • PGRANT_NBR : Partner Grant
    Its data type is CHAR (Character String) with field length 20
  • BUDGET_PD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 10
  • PBUDGET_PD : FM: Partner Budget Period
    Its data type is CHAR (Character String) with field length 10
  • PSWSL : Update Currency for General Ledger Transaction Figures
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PSWBT : Amount for Updating in General Ledger
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • PFKBER : Partner Functional Area
    Its data type is CHAR (Character String) with field length 16
  • 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
  • XLGCLR : Clearing Specific to Ledger Groups
    Its data type is CHAR (Character String) with field length 1
  • AUGDT : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUGCP : Clearing Entry Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUGBL : Document Number of the Clearing Document
    Its data type is CHAR (Character String) with field length 10
  • AUGGJ : Fiscal Year of Clearing Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • AGZEI : Clearing Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • RDIFF : Exchange Rate Gain/Loss Realized
    Its data type is CURR (Currency Field) with field length 13
  • RDIF2 : Exchange Rate Difference Realized for Second 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
  • KSTAR : Cost Element
    Its data type is CHAR (Character String) with field length 10
  • PARGB : Trading partner’s business area
    Its data type is CHAR (Character String) with field length 4

    • BSEG_ADD related tables

    • FAGLFLEX02 : General ledger: Main account assignment
    • FAGLFLEX01 : General ledger: Technical fields
    • FAGLFLEX00 : General ledger: Transaction attributes
    • FAGLFLEX05 : General Ledger: Additional Acct Assignment: Customer 2
    • FAGLFLEX03 : General ledger: SAP additional account assignment
    • FAGLFLEX06 : General ledger: Sender SAP additional account assignment
    • FAGLFLEX08 : General Ledger: Reserve Table 2
    • FAGLFLEXP : General Ledger: Plan Line Items
    • FAGLFLEX07 : General Ledger: Reserve Table 1
    • FAGLFLEXT : General Ledger: Totals
    • FAGLFLEX04 : General ledger: Customer additional account assignment
    • FAGL_MIG_BUKRS : Activation of New General Ledger Accounting for Company Code
    • BKPF_ADD : Accounting Document Header
    • FAGLFLEXT_BAK : General Ledger: Totals
    • BSEG_ADD : Entry View of Accounting Document for Additional Ledgers
    • FAGLFLEXT_DIF : Delta Table: G/L Totals
    • FAGLFLEXA : General Ledger: Actual Line Items

    Related References

    Related Tutorials

    FAGL_BELNR_LD SAP table for – Document Types for Entry View in a Ledger

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

    GLPOS_C_CT SAP table for – FI Document: Entry View

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

    BKPF_ADD SAP table for – Accounting Document Header

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

    KBLE SAP table for – Document Item Processing: Manual Document Entry

    KBLE table in SAP FI (Funds Management in FI) module. This table is used for storing data of Document Item...

    GLE_MCA_ME_CREAT SAP table for – Manual entry data

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

    KBLP SAP table for – Document Item: Manual Document Entry

    KBLP table in SAP FI (Funds Management in FI) module. This table is used for storing data of Document Item:...

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

    «
    »