SAP table BSEG_ADD (Entry View of Accounting Document for Additional Ledgers)

SAP table BSEG_ADD has 5 primary key fields being MANDT,BUKRS,BELNR,GJAHR,BUZEI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Six-figure number of line item NUMC 6 0 BUZEI6
BSTAT Document Status CHAR 1 0 BSTAT_D
BUZID Identification of the Line Item CHAR 1 0 BUZID
BSCHL Posting Key CHAR 2 0 TBSL BSCHL
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
DMBTR Amount in local currency CURR 23 2 BF_DMBTR
WRBTR Amount in transaction currency CURR 23 2 BF_WRBTR
FCSL Amount in Functional Currency CURR 23 2 FINS_VFCCUR12
RFCCUR Functional Currency CUKY 5 0 FINS_CURRFC
KTOSL Transaction Key CHAR 3 0 KTOSL
VALUT Value date DATS 8 0 VALUT
ZUONR Assignment number CHAR 18 0 DZUONR
SGTXT Item Text CHAR 50 0 SGTXT
VBUND Company ID CHAR 6 0 T880 VBUND
BEWAR Consolidation Transaction Type CHAR 3 0 T856 BEWAR
ALTKT Group Account Number CHAR 10 0 BILKT_SKA1
VORGN Transaction Type for General Ledger CHAR 4 0 VORGN
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 KOSTL
AUFNR Order Number CHAR 12 0 AUFK AUFNR
ANLN1 Main Asset Number CHAR 12 0 IFIMASTFIXASSET ANLN1
ANLN2 Asset Subnumber CHAR 4 0 IFIXASSET ANLN2
ANBWA Asset Transaction Type CHAR 3 0 ANBWA
XAUTO Indicator: Line item automatically created CHAR 1 0 XAUTO
XNCOP Indicator: Items Cannot Be Copied? CHAR 1 0 XNCOP
HKONT General Ledger Account CHAR 10 0 SKA1 HKONT
XBILK Indicator: Account is a balance sheet account? CHAR 1 0 XBILK
GVTYP P&L statement account type CHAR 2 0 GVTYP
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
MENGE Quantity QUAN 13 3 MENGE_D
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
EGRUP Equity group CHAR 3 0 T8JF JV_EGROUP
VPTNR Partner account number CHAR 10 0 KNA1 JV_PART
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
FIPOS Commitment Item CHAR 14 0 FIPOS
KSTRG Cost Object CHAR 12 0 KSTRG
NPLNR Network Number for Account Assignment CHAR 12 0 NPLNR
AUFPL Task List Number for Operations in Order NUMC 10 0 AUFPL_CH
APLZL General Counter for Order NUMC 8 0 APLZL_CH
PROJK Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PASUBNR Profitability Segment Changes (CO-PA) NUMC 4 0 RKESUBNR
DMBE2 Amount in Second Local Currency CURR 23 2 BF_DMBE2
DMBE3 Amount in Third Local Currency CURR 23 2 BF_DMBE3
LOKKT Alternative Account Number in Company Code CHAR 10 0 ALTKT_SKB1
FISTL Funds Center CHAR 16 0 FISTL
GEBER Fund CHAR 10 0 BP_GEBER
PPRCT Partner Profit Center CHAR 10 0 CEPC PPRCTR
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
XREF2 Business Partner Reference Key CHAR 12 0 XREF2
KBLNR Document Number for Earmarked Funds CHAR 10 0 KBLK KBLNR_FI
KBLPOS Earmarked Funds: Document Item NUMC 3 0 KBLP KBLPOS
OBZEI Number of Line Item in Original Document NUMC 3 0 OBZEI
XNEGP Indicator: Negative Posting CHAR 1 0 XNEGP
XREF3 Reference key for line item CHAR 20 0 XREF3
KONTT Account Assignment Category for Industry Solution CHAR 2 0 KONTT_FI
KONTL Acct assignment string for industry-specific acct assignmnts CHAR 50 0 KONTL_FI
BUPLA Business Place CHAR 4 0 J_1BBRANCH BUPLA
SECCO Section Code CHAR 4 0 SECCODE SECCO
LSTAR Activity Type CHAR 6 0 LSTAR
PRZNR Business Process CHAR 12 0 CO_PRZNR
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
FKBER Functional Area CHAR 16 0 FKBER
MEASURE Funded Program CHAR 24 0 FM_MEASURE
SEGMENT Segment for Segmental Reporting CHAR 10 0 FB_SEGMENT
PSEGMENT Partner Segment for Segmental Reporting CHAR 10 0 FB_PSEGMENT
GSBER Business Area CHAR 4 0 GSBER
PGEBER Partner Fund CHAR 10 0 FM_PFUND
PGRANT_NBR Partner Grant CHAR 20 0 GM_GRANT_PARTNER
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
PBUDGET_PD FM: Partner Budget Period CHAR 10 0 FM_PBUDGET_PERIOD
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 PSWSL
PSWBT Amount for Updating in General Ledger CURR 23 2 BF_PSWBT
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
PFKBER Partner Functional Area CHAR 16 0 SFKBER
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) NUMC 4 0 REBZJ
REBZZ Line Item in the Relevant Invoice NUMC 3 0 REBZZ
REBZT Follow-On Document Type CHAR 1 0 REBZT
XLGCLR Open Item Management by Ledger Group CHAR 1 0 XLGCLR
AUGDT Clearing Date DATS 8 0 AUGDT
AUGCP Clearing Entry Date DATS 8 0 AUGCP
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
AUGGJ Fiscal Year of Clearing Document NUMC 4 0 AUGGJ
AGZEI Clearing Item DEC 5 0 AGZEI
RDIFF Exchange Rate Gain/Loss Realized CURR 23 2 RDIFF
RDIF2 Exchange Rate Difference Realized for Second Local Currency CURR 23 2 RDIF2
RDIF3 Exchange Rate Difference Realized for Third Local Currency CURR 23 2 RDIF3
XRAGL Indicator: Clearing Was Reversed CHAR 1 0 XRAGL
KSTAR Cost Element CHAR 10 0 KSTAR
PARGB Trading partner's business area CHAR 4 0 PARGB
BWKEY Valuation area CHAR 4 0 T001K BWKEY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
VERTT Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
VERTN Contract Number CHAR 13 0 RANL
VBEWA Flow Type CHAR 4 0 SBEWART
VBELN Billing Document CHAR 10 0 VBELN_VF
VBEL2 Sales Document CHAR 10 0 VBELN_VA
POSN2 Sales Document Item NUMC 6 0 POSNR_VA
ETEN2 Schedule Line Number NUMC 4 0 ETENR
EBELN_LOGSYS Logical System of Purchasing Document CHAR 10 0 EBELN_LOGSYS
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
GKONT Offsetting Account Number CHAR 10 0 GKONT
GKART Offsetting Account Type CHAR 1 0 GKOAR
GHKON G/L Acct of Offsetting Acct in General Ledger Accounting CHAR 10 0 GHKONT
BUZEI_SENDER Item Number Within Accounting Document in Sender System NUMC 3 0 BUZEI_SENDER
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
ACROBJTYPE Type of the Accrual Object CHAR 4 0 TACR_OBJ_TYPE ACR_OBJ_TYPE
ACRLOGSYS Logical System of the Accrual Object CHAR 10 0 ACR_LOGSYS
ACROBJ_ID Identifier of the Accrual Object CHAR 32 0 ACR_OBJ_ID
ACRSOBJ_ID Identifier of the Accrual Subobject CHAR 32 0 ACR_SUBOBJ_ID
ACRITMTYPE Type of the Item of the Accrual Subobject CHAR 11 0 ACR_ITEM_TYPE
ACRREFOBJ_ID Identifier of the Accrual Reference Object CHAR 32 0 ACR_REFOBJ_ID
ACRVALDAT Accrual Value Date DATS 8 0 ACR_VALUE_DATE
VALOBJTYPE Type of the Financial Valuation Object CHAR 4 0 FINSC_VAL_TYPE VAL_OBJ_TYPE
VALOBJ_ID Identifier of the Financial Valuation Object CHAR 32 0 VAL_OBJ_ID
VALSOBJ_ID Identifier of the Financial Valuation Subobject CHAR 32 0 VAL_SUBOBJ_ID
NETDT Net Due Date DATS 8 0 NETDT
RISK_CLASS Risk Class CHAR 3 0 UKM_RISK_CL UKM_RISK_CLASS
SDM_VERSION SDM: Version field for BSEG CHAR 2 0 FINS_SDM_VERSION_BSEG
01 ACRVALDAT
02 GLO_REF1 with BR_BARCODE
03 RFCCUR, FCSL
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
HKTID ID for Account Details CHAR 5 0 T012K HKTID
RE_BUKRS Cash Ledger: Company Code for Expense/Revenue CHAR 4 0 * FAGL_RE_BUKRS
RE_ACCOUNT Cash Ledger: Expense or Revenue Account CHAR 10 0 * FAGL_RE_ACCOUNT
BDIF2 Valuation Difference for the Second Local Currency CURR 23 2 BDIF2
BDIF3 Valuation Difference for the Third Local Currency CURR 23 2 BDIF3
BDIFF Valuation Difference CURR 23 2 BDIFF
CCBTC Payment cards: Settlement run CHAR 10 0 CCBTC
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
FKONT Financial Budget Item NUMC 3 0 FIPLS
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
INTRENO Internal Real Estate Master Data Code CHAR 13 0 VVINTRENO
MWST2 Tax Amount in Second Local Currency CURR 23 2 MWST2
MWST3 Tax Amount in Third Local Currency CURR 23 2 MWST3
MWSTS Tax Amount in Local Currency CURR 23 2 MWSTS
PPDIF2 Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts) CURR 23 2 PPDIF2
PPDIF3 Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts) CURR 23 2 PPDIF3
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) CURR 23 2 PPDIFF
PRODPER Production Month (Date to find period and year) DATS 8 0 JV_PRODPER
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
QSSKZ Withholding Tax Code CHAR 2 0 * QSSKZ
RFZEI Payment Card Item NUMC 3 0 RFZEI_CC
UZAWE Payment method supplement CHAR 2 0 * UZAWE
WMWST Tax Amount in Document Currency CURR 23 2 WMWST
WVERW Bill of Exchange Usage Type CHAR 1 0 WVERW
D Discounting
F Forfeiting
I Collection
XOPVW Indicator: Open Item Management? CHAR 1 0 XOPVW
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
BDGT_ACCOUNT Budget Account CHAR 10 0 * PSM_BDGT_ACCOUNT
BDGT_ACCOUNT_COCODE Budget Account Company Code CHAR 4 0 * PSM_BDGT_ACCOUNT_COCODE

BSEG_ADD foreign key relationships

Table Field Check Table Check Field
0 BSEG_ADD ACROBJTYPE TACR_OBJ_TYPE Accrual object type MANDT
1 BSEG_ADD ANLN1 IFIMASTFIXASSET Generated Table for View MANDT
1 BSEG_ADD ANLN1 IFIMASTFIXASSET Generated Table for View COMPANYCODE
1 BSEG_ADD ANLN1 IFIMASTFIXASSET Generated Table for View MASTERFIXEDASSET
0 BSEG_ADD ANLN2 IFIXASSET Generated Table for View MANDT
0 BSEG_ADD ANLN2 IFIXASSET Generated Table for View COMPANYCODE
0 BSEG_ADD ANLN2 IFIXASSET Generated Table for View MASTERFIXEDASSET
0 BSEG_ADD ANLN2 IFIXASSET Generated Table for View FIXEDASSET
1 BSEG_ADD AUFNR AUFK Order master data AUFNR
0 BSEG_ADD BEWAR T856 Transaction Types MANDT
0 BSEG_ADD BEWAR T856 Transaction Types TRTYP
1 BSEG_ADD BSCHL TBSL Posting Key MANDT
1 BSEG_ADD BSCHL TBSL Posting Key BSCHL
0 BSEG_ADD BUKRS T001 Company Codes BUKRS
1 BSEG_ADD BUPLA J_1BBRANCH Business Place BUKRS
1 BSEG_ADD BUPLA J_1BBRANCH Business Place BRANCH
1 BSEG_ADD BUPLA J_1BBRANCH Business Place BUPLA_TYPE
0 BSEG_ADD BWTAR T149D Global Valuation Types MANDT
0 BSEG_ADD BWTAR T149D Global Valuation Types BWTAR
1 BSEG_ADD EGRUP T8JF Investment Group MANDT
1 BSEG_ADD EGRUP T8JF Investment Group BUKRS
1 BSEG_ADD EGRUP T8JF Investment Group VNAME
1 BSEG_ADD EGRUP T8JF Investment Group EGRUP
0 BSEG_ADD HBKID T012 House Banks BUKRS
1 BSEG_ADD HKONT SKA1 G/L Account Master (Chart of Accounts) MANDT
1 BSEG_ADD HKONT SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 BSEG_ADD HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 BSEG_ADD HKTID T012K House Bank Accounts MANDT
0 BSEG_ADD HKTID T012K House Bank Accounts BUKRS
0 BSEG_ADD HKTID T012K House Bank Accounts HBKID
0 BSEG_ADD HKTID T012K House Bank Accounts HKTID
1 BSEG_ADD KBLNR KBLK Document Header: Manual Document Entry MANDT
1 BSEG_ADD KBLNR KBLK Document Header: Manual Document Entry BELNR
0 BSEG_ADD KBLPOS KBLP Document Item: Manual Document Entry MANDT
0 BSEG_ADD KBLPOS KBLP Document Item: Manual Document Entry BELNR
1 BSEG_ADD KOKRS TKA01 Controlling Areas MANDT
0 BSEG_ADD MANDT T000 Clients MANDT
1 BSEG_ADD MATNR MARA General Material Data MANDT
1 BSEG_ADD MATNR MARA General Material Data MATNR
0 BSEG_ADD MEINS T006 Units of Measurement MANDT
0 BSEG_ADD MEINS T006 Units of Measurement MSEHI
1 BSEG_ADD MWSKZ T007A Tax Keys KALSM
1 BSEG_ADD MWSKZ T007A Tax Keys MWSKZ
0 BSEG_ADD PPRCT CEPC Profit Center Master Data Table PRCTR
0 BSEG_ADD PPRCT CEPC Profit Center Master Data Table DATBI
0 BSEG_ADD PPRCT CEPC Profit Center Master Data Table KOKRS
1 BSEG_ADD PRCTR CEPC Profit Center Master Data Table PRCTR
1 BSEG_ADD PRCTR CEPC Profit Center Master Data Table DATBI
1 BSEG_ADD PRCTR CEPC Profit Center Master Data Table KOKRS
0 BSEG_ADD RECID T8JJ Recovery Indicator MANDT
0 BSEG_ADD RECID T8JJ Recovery Indicator BUKRS
1 BSEG_ADD SECCO SECCODE Section Code MANDT
1 BSEG_ADD SECCO SECCODE Section Code BUKRS
1 BSEG_ADD SECCO SECCODE Section Code SECCODE
0 BSEG_ADD TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 BSEG_ADD TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 BSEG_ADD VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 BSEG_ADD VBUND T880 Global Company Data (for KONS Ledger) RCOMP
0 BSEG_ADD VNAME T8JV Joint Venture MANDT
0 BSEG_ADD VNAME T8JV Joint Venture BUKRS
0 BSEG_ADD VNAME T8JV Joint Venture VNAME
1 BSEG_ADD VPTNR KNA1 General Data in Customer Master MANDT
1 BSEG_ADD VPTNR KNA1 General Data in Customer Master KUNNR
0 BSEG_ADD WERKS T001W Plants/Branches MANDT
0 BSEG_ADD WERKS T001W Plants/Branches WERKS