BSEG_ADD

Entry View of Accounting Document for Additional Ledgers | #transactional | Component: Basic Functions
Column Name Description
MANDT FK Client
BUKRS FK Company Code
BELNR Document Number of an Accounting Document
GJAHR Fiscal Year
BUZEI Six-figure number of line item
Column Name Description
💲 Local Currency (BKPF.HWAER):
DMBTR Amount in local currency
RDIFF Exchange Rate Gain/Loss Realized
💲 Currency Key (BKPF.WAERS):
WRBTR Amount in transaction currency
BDIFF Valuation Difference
MWSTS Tax Amount in Local Currency
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
WMWST Tax Amount in Document Currency
💲 Functional Currency (RFCCUR):
FCSL Amount in Functional Currency
💲 Currency Key of Second Local Currency (BKPF.HWAE2):
DMBE2 Amount in Second Local Currency
RDIF2 Exchange Rate Difference Realized for Second Local Currency
BDIF2 Valuation Difference for the Second Local Currency
MWST2 Tax Amount in Second Local Currency
PPDIF2 Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts)
💲 Currency Key of Third Local Currency (BKPF.HWAE3):
DMBE3 Amount in Third Local Currency
RDIF3 Exchange Rate Difference Realized for Third Local Currency
BDIF3 Valuation Difference for the Third Local Currency
MWST3 Tax Amount in Third Local Currency
PPDIF3 Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts)
💲 Update Currency for General Ledger Transaction Figures (PSWSL):
PSWBT Amount for Updating in General Ledger
Column Name Description
📏 Base Unit of Measure (BSEG.MEINS):
MENGE Quantity
Column Name Description
VALUT Value date
AUGDT Clearing Date
AUGCP Clearing Entry Date
_DATAAGING Data Filter Value for Data Aging
ACRVALDAT Accrual Value Date
NETDT Net Due Date
DABRZ Reference date for settlement
PRODPER Production Month (Date to find period and year)
ZFBDT Baseline Date for Due Date Calculation
Column Name Description
BSTAT Document Status Show values
KOART Account type Show values
SHKZG Debit/Credit Indicator Show values
XAUTO Indicator: Line item automatically created Show values
XNCOP Indicator: Items Cannot Be Copied? Show values
XBILK Indicator: Account is a balance sheet account? Show values
XNEGP Indicator: Negative Posting Show values
XLGCLR Open Item Management by Ledger Group Show values
XRAGL Indicator: Clearing Was Reversed Show values
VERTT Contract Type Show values
GKART Offsetting Account Type Show values
SDM_VERSION SDM: Version field for BSEG Show values
WVERW Bill of Exchange Usage Type Show values
XOPVW Indicator: Open Item Management? Show values
Column Name Description Domain name
BUZID Identification of the Line Item CHAR1
KTOSL Transaction Key CHAR3
ZUONR Assignment number ZUONR
SGTXT Item Text TEXT50
ALTKT Group Account Number SAKNR
VORGN Transaction Type for General Ledger VORGN
KOSTL Cost Center KOSTL
ANBWA Asset Transaction Type BWASL
GVTYP P&L statement account type CHAR2
FIPOS Commitment Item FIPOS
KSTRG Cost Object KSTRG
NPLNR Network Number for Account Assignment AUFNR
AUFPL Task List Number for Operations in Order AUFPL
APLZL General Counter for Order CO_APLZL
PROJK Work Breakdown Structure Element (WBS Element) PS_POSNR
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PASUBNR Profitability Segment Changes (CO-PA) RKESUBNR
LOKKT Alternative Account Number in Company Code SAKNR
FISTL Funds Center FISTL
GEBER Fund BP_GEBER
XREF1 Business Partner Reference Key CHAR12
XREF2 Business Partner Reference Key CHAR12
OBZEI Number of Line Item in Original Document BUZEI
XREF3 Reference key for line item CHAR20
KONTT Account Assignment Category for Industry Solution KONTT_FI
KONTL Acct assignment string for industry-specific acct assignmnts CHAR50
LSTAR Activity Type LSTAR
PRZNR Business Process CO_PRZNR
GRANT_NBR Grant GM_GRANT_NBR
FKBER Functional Area FKBER
MEASURE Funded Program FM_MEASURE
SEGMENT Segment for Segmental Reporting FB_SEGMENT
PSEGMENT Partner Segment for Segmental Reporting FB_SEGMENT
GSBER Business Area GSBER
PGEBER Partner Fund BP_GEBER
PGRANT_NBR Partner Grant GM_GRANT_NBR
BUDGET_PD Budget Period FM_BUDGET_PERIOD
PBUDGET_PD FM: Partner Budget Period FM_BUDGET_PERIOD
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes
PFKBER Partner Functional Area FKBER
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
REBZZ Line Item in the Relevant Invoice BUZEI
REBZT Follow-On Document Type REBZT
AUGBL Document Number of the Clearing Document BELNR
AUGGJ Fiscal Year of Clearing Document GJAHR
AGZEI Clearing Item AGZEI
KSTAR Cost Element KSTAR
PARGB Trading partner's business area GSBER
VERTN Contract Number RANL
VBEWA Flow Type SBEWART
VBELN Billing Document VBELN
VBEL2 Sales Document VBELN
POSN2 Sales Document Item POSNR
ETEN2 Schedule Line Number ETENR
EBELN_LOGSYS Logical System of Purchasing Document LOGSYS
EBELN Purchasing Document Number EBELN
EBELP Item Number of Purchasing Document EBELP
ZEKKN Sequential Number of Account Assignment NUM02
GKONT Offsetting Account Number GKONT
GHKON G/L Acct of Offsetting Acct in General Ledger Accounting SAKNR
BUZEI_SENDER Item Number Within Accounting Document in Sender System BUZEI
ACRLOGSYS Logical System of the Accrual Object LOGSYS
ACROBJ_ID Identifier of the Accrual Object ACR_OBJ_ID
ACRSOBJ_ID Identifier of the Accrual Subobject ACR_SUBOBJ_ID
ACRITMTYPE Type of the Item of the Accrual Subobject ACR_ITEM_TYPE
ACRREFOBJ_ID Identifier of the Accrual Reference Object ACR_REFOBJ_ID
VALOBJ_ID Identifier of the Financial Valuation Object VAL_OBJ_ID
VALSOBJ_ID Identifier of the Financial Valuation Subobject VAL_SUBOBJ_ID
RE_BUKRS Cash Ledger: Company Code for Expense/Revenue BUKRS
RE_ACCOUNT Cash Ledger: Expense or Revenue Account SAKNR
CCBTC Payment cards: Settlement run CCBTC
FKONT Financial Budget Item FIPLS
IMKEY Internal Key for Real Estate Object IMKEY
INTRENO Internal Real Estate Master Data Code VVINTRENO
PROJN Old: Project number : No longer used --> PS_POSNR PROJN
QSSKZ Withholding Tax Code QSSKZ
RFZEI Payment Card Item NUM03
UZAWE Payment method supplement UZAWE
BDGT_ACCOUNT Budget Account SAKNR
BDGT_ACCOUNT_COCODE Budget Account Company Code BUKRS
Master Data Relations Join Conditions
Type of the Accrual Object
Order Number
  • Order Number
  • Client
  • BSEG_ADD.AUFNR == AUFK.AUFNR
  • BSEG_ADD.MANDT == AUFK.MANDT
Consolidation Transaction Type
  • BSEG_ADD.MANDT == T856.MANDT
  • BSEG_ADD.BEWAR == T856.TRTYP
Posting Key
  • BSEG_ADD.MANDT == TBSL.MANDT
  • BSEG_ADD.BSCHL == TBSL.BSCHL
Company Code
  • BSEG_ADD.MANDT == T001.MANDT
  • BSEG_ADD.BUKRS == T001.BUKRS
Business Place
  • Company Code
  • Business Place
  • Client
  • ?
Valuation area
  • Valuation area
  • Client
  • BSEG_ADD.BWKEY == T001K.BWKEY
  • BSEG_ADD.MANDT == T001K.MANDT
Valuation Type
  • BSEG_ADD.MANDT == T149D.MANDT
  • BSEG_ADD.BWTAR == T149D.BWTAR
Equity group
  • Joint venture
  • Client
  • Equity group
  • Company Code
  • BSEG_ADD.VNAME == T8JF.VNAME
  • BSEG_ADD.MANDT == T8JF.MANDT
  • BSEG_ADD.EGRUP == T8JF.EGRUP
  • BSEG_ADD.BUKRS == T8JF.BUKRS
Short Key for a House Bank
  • Short Key for a House Bank
  • Company Code
  • BSEG_ADD.MANDT == T012.MANDT
  • BSEG_ADD.HBKID == T012.HBKID
  • BSEG_ADD.BUKRS == T012.BUKRS
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • BSEG_ADD.BUKRS == SKA1.KTOPL
  • BSEG_ADD.MANDT == SKA1.MANDT
  • BSEG_ADD.HKONT == SKA1.SAKNR
ID for Account Details
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • BSEG_ADD.BUKRS == T012K.BUKRS
  • BSEG_ADD.HKTID == T012K.HKTID
  • BSEG_ADD.MANDT == T012K.MANDT
  • BSEG_ADD.HBKID == T012K.HBKID
Controlling Area
  • BSEG_ADD.MANDT == TKA01.MANDT
  • BSEG_ADD.KOKRS == TKA01.KOKRS
Client BSEG_ADD.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • BSEG_ADD.MATNR == MARA.MATNR
  • BSEG_ADD.MANDT == MARA.MANDT
Base Unit of Measure
  • BSEG_ADD.MANDT == T006.MANDT
  • BSEG_ADD.MEINS == T006.MSEHI
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • BSEG_ADD.MANDT == T007A.MANDT
  • BSEG_ADD.[column in domain "KALSM_D"] == T007A.KALSM
  • BSEG_ADD.MWSKZ == T007A.MWSKZ
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • BSEG_ADD.MANDT == CEPC.MANDT
  • BSEG_ADD.[column in domain "DATBI"] == CEPC.DATBI
  • BSEG_ADD.KOKRS == CEPC.KOKRS
  • BSEG_ADD.PPRCT == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • BSEG_ADD.MANDT == CEPC.MANDT
  • BSEG_ADD.[column in domain "DATBI"] == CEPC.DATBI
  • BSEG_ADD.KOKRS == CEPC.KOKRS
  • BSEG_ADD.PRCTR == CEPC.PRCTR
Recovery Indicator
  • Company Code
  • Recovery Indicator
  • BSEG_ADD.MANDT == T8JJ.MANDT
  • BSEG_ADD.BUKRS == T8JJ.BUKRS
  • BSEG_ADD.RECID == T8JJ.RECID
Risk Class
  • Risk Class
  • Client
Section Code
  • Company Code
  • Section Code
  • Client
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • BSEG_ADD.MANDT == TTXJ.MANDT
  • BSEG_ADD.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • BSEG_ADD.TXJCD == TTXJ.TXJCD
Type of the Financial Valuation Object
  • Type of the Financial Valuation Object
  • Client
Company ID
  • BSEG_ADD.MANDT == T880.MANDT
  • BSEG_ADD.VBUND == T880.RCOMP
Joint venture
  • Company Code
  • Joint venture
  • Client
  • BSEG_ADD.BUKRS == T8JV.BUKRS
  • BSEG_ADD.VNAME == T8JV.VNAME
  • BSEG_ADD.MANDT == T8JV.MANDT
Partner account number
  • BSEG_ADD.MANDT == KNA1.MANDT
  • BSEG_ADD.VPTNR == KNA1.KUNNR
Plant
  • BSEG_ADD.MANDT == T001W.MANDT
  • BSEG_ADD.WERKS == T001W.WERKS