BSEG_ADD SAP (Entry View of Accounting Document for Additional Ledgers) Table details
Dictionary Type: Table
Description: Entry View of Accounting Document for Additional Ledgers
Description: Entry View of Accounting Document for Additional Ledgers
Table field list including key, data, relationships and ABAP select examples
BSEG_ADD is a standard SAP Table which is used to store Entry View of Accounting Document for Additional Ledgers data and is available within R/3 SAP systems depending on the version and release level.
The BSEG_ADD table consists of various fields, each holding specific information or linking keys about Entry View of Accounting Document for Additional Ledgers data available in SAP. These include BUKRS (Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Six-figure number of line item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BSEG_ADD table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| BUZEI | Six-figure number of line item | BUZEI6 | NUMC | 6 | BUZEI6 | BUZ | |||
| BSTAT | Document Status | BSTAT_D | CHAR | 1 | BSTAT | ||||
| BUZID | Identification of the Line Item | BUZID | CHAR | 1 | CHAR1 | ||||
| BSCHL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
| KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
| DMBTR | Amount in local currency | BF_DMBTR | CURR | 23(2) | WERT12 | ||||
| WRBTR | Amount in transaction currency | BF_WRBTR | CURR | 23(2) | WERT12 | ||||
| KTOSL | Transaction Key | KTOSL | CHAR | 3 | CHAR3 | ||||
| VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
| ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
| SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
| VBUND | Company ID | VBUND | CHAR | 6 | T880 | ALPHA | RCOMP | ||
| BEWAR | Consolidation Transaction Type | BEWAR | CHAR | 3 | T856 | RMVCT | |||
| ALTKT | Group account number | BILKT_SKA1 | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
| VORGN | Transaction Type for General Ledger | VORGN | CHAR | 4 | VORGN | ||||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
| AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
| ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
| ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
| ANBWA | Asset Transaction Type | ANBWA | CHAR | 3 | Assigned to domain | BWASL | |||
| XAUTO | Indicator: Line item automatically created | XAUTO | CHAR | 1 | XFELD | ||||
| XNCOP | Indicator: Items cannot be copied? | XNCOP | CHAR | 1 | XFELD | ||||
| HKONT | General Ledger Account | HKONT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
| XBILK | Indicator: Account is a balance sheet account? | XBILK | CHAR | 1 | XFELD | ||||
| GVTYP | P&L statement account type | GVTYP | CHAR | 2 | CHAR2 | ||||
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| VNAME | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
| RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
| EGRUP | Equity group | JV_EGROUP | CHAR | 3 | T8JF | ALPHA | JV_EGROUP | GJE | |
| VPTNR | Partner account number | JV_PART | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
| FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
| KSTRG | Cost Object | KSTRG | CHAR | 12 | Assigned to domain | KSTRG | KTR | ||
| NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
| AUFPL | Task list number for operations in order | AUFPL_CH | NUMC | 10 | AUFPL | ||||
| APLZL | General counter for order | APLZL_CH | NUMC | 8 | Assigned to domain | CO_APLZL | |||
| PROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
| PASUBNR | Profitability segment changes (CO-PA) | RKESUBNR | NUMC | 4 | RKESUBNR | ||||
| DMBE2 | Amount in Second Local Currency | BF_DMBE2 | CURR | 23(2) | WERT12 | ||||
| DMBE3 | Amount in Third Local Currency | BF_DMBE3 | CURR | 23(2) | WERT12 | ||||
| LOKKT | Alternative account number in company code | ALTKT_SKB1 | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
| FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
| GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
| PPRCT | Partner Profit Center | PPRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PPC | |
| XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
| XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
| KBLNR | Document Number for Earmarked Funds | KBLNR_FI | CHAR | 10 | KBLK | ALPHA | KBLNR | KBL | |
| KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | KBLP | KBLPOS | KBP | ||
| OBZEI | Number of Line Item in Original Document | OBZEI | NUMC | 3 | BUZEI | ||||
| XNEGP | Indicator: Negative posting | XNEGP | CHAR | 1 | XFELD | ||||
| XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
| KONTT | Account Assignment Category for Industry Solution | KONTT_FI | CHAR | 2 | KONTT_FI | ||||
| KONTL | Acct assignment string for industry-specific acct assignmnts | KONTL_FI | CHAR | 50 | CHAR50 | ||||
| BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
| SECCO | Section Code | SECCO | CHAR | 4 | SECCODE | SECCO | SECCO_ABA | ||
| LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
| PRZNR | Business Process | CO_PRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | KWP | |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
| FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
| MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
| SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
| PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| PGEBER | Partner Fund | FM_PFUND | CHAR | 10 | Assigned to domain | BP_GEBER | PARTNER_FUND | ||
| PGRANT_NBR | Partner Grant | GM_GRANT_PARTNER | CHAR | 20 | ALPHA | GM_GRANT_NBR | GRANTS_GENERIC | ||
| BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
| PBUDGET_PD | FM: Partner Budget Period | FM_PBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
| PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | Assigned to domain | WAERS | |||
| PSWBT | Amount for Updating in General Ledger | BF_PSWBT | CURR | 23(2) | WERT12 | ||||
| PFKBER | Partner Functional Area | SFKBER | CHAR | 16 | Assigned to domain | FKBER | |||
| REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
| REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
| REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
| XLGCLR | Clearing Specific to Ledger Groups | XLGCLR | CHAR | 1 | XFELD | ||||
| AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
| AUGCP | Clearing Entry Date | AUGCP | DATS | 8 | DATUM | ||||
| AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
| AUGGJ | Fiscal Year of Clearing Document | AUGGJ | NUMC | 4 | GJAHR | GJAHR | |||
| AGZEI | Clearing Item | AGZEI | DEC | 5 | AGZEI | ||||
| RDIFF | Exchange Rate Gain/Loss Realized | RDIFF | CURR | 13(2) | WRTV7 | ||||
| RDIF2 | Exchange Rate Difference Realized for Second Local Currency | RDIF2 | CURR | 13(2) | WRTV7 | ||||
| RDIF3 | Exchange Rate Difference Realized for Third Local Currency | RDIF3 | CURR | 13(2) | WRTV7 | ||||
| XRAGL | Indicator: Clearing was Reversed | XRAGL | CHAR | 1 | XFELD | ||||
| KSTAR | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
| PARGB | Trading partner's business area | PARGB | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| .INCLU--AP | 0 | ||||||||
| RE_BUKRS | Cash Ledger: Company Code for Expense/Revenue | FAGL_RE_BUKRS | CHAR | 4 | Assigned to domain | BUKRS | |||
| RE_ACCOUNT | Cash Ledger: Expense or Revenue Account | FAGL_RE_ACCOUNT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR |
| Key field | Non-key field |
How do I retrieve data from SAP table BSEG_ADD using ABAP code
The following ABAP code Example will allow you to do a basic selection on BSEG_ADD to SELECT all data from the tableDATA: WA_BSEG_ADD TYPE BSEG_ADD.
SELECT SINGLE *
FROM BSEG_ADD
INTO CORRESPONDING FIELDS OF WA_BSEG_ADD
WHERE...
How to access SAP table BSEG_ADD
Within an ECC or HANA version of SAP you can also view further information about BSEG_ADD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects