BSEG

Accounting Document Segment

Explore another table

Enter a table code or keyword to continue exploring.

SAP table BSEG (Accounting Document Segment) is one of the core tables in the Financial Accounting (FI) module. It is used to store detailed information about individual line items in accounting documents. Each entry in BSEG represents a single line item from an accounting document, which provides granular data about financial transactions within the SAP system.

SAP table BSEG has 5 primary key fields: MANDT,BUKRS,BELNR,GJAHR,BUZEI.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

BSEG fields.

417 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key BUKRS Company CodeCHAR40 T001 BUKRS
Key BELNR Document Number of an Accounting DocumentCHAR100 BELNR_D
Key GJAHR Fiscal YearNUMC40 GJAHR
Key BUZEI Number of Line Item Within Accounting DocumentNUMC30 BUZEI
BUZID Identification of the Line ItemCHAR10 BUZID
AUGDT Clearing DateDATS80 AUGDT
AUGCP Clearing Entry DateDATS80 AUGCP
AUGBL Document Number of the Clearing DocumentCHAR100 AUGBL
BSCHL Posting KeyCHAR20 TBSL BSCHL
KOART Account typeCHAR10 KOART
UMSKZ Special G/L IndicatorCHAR10 T074U UMSKZ
UMSKS Special G/L Transaction TypeCHAR10 UMSKS
ZUMSK Target Special G/L IndicatorCHAR10 T074U DZUMSK
SHKZG Debit/Credit IndicatorCHAR10 SHKZG
GSBER Business AreaCHAR40 TGSB GSBER
PARGB Trading partner's business areaCHAR40 TGSB PARGB
TAX_COUNTRY Tax Reporting Country/RegionCHAR30 FOT_TAX_COUNTRY
MWSKZ Tax on sales/purchases codeCHAR20 T007A MWSKZ
TXDAT_FROM Valid-From Date of the Tax RateDATS80 FOT_TXDAT_FROM
QSSKZ Withholding Tax CodeCHAR20 T059Q QSSKZ
DMBTR Amount in local currencyCURR232 DMBTR
WRBTR Amount in document currencyCURR232 WRBTR
FCSL Amount in Functional CurrencyCURR232 FINS_VFCCUR12
RFCCUR Functional CurrencyCUKY50 FINS_CURRFC
KZBTR Original Reduction Amount in Local CurrencyCURR232 KZBTR_FI
PSWBT Amount for Updating in General LedgerCURR232 PSWBT
PSWSL Update Currency for General Ledger Transaction FiguresCUKY50 TCURC PSWSL
TXBHW Original Tax Base Amount in Local CurrencyCURR232 TXBHW
TXBFW Original Tax Base Amount in Document CurrencyCURR232 TXBFW
MWSTS Tax Amount in Local CurrencyCURR232 MWSTS
WMWST Tax Amount in Document CurrencyCURR232 WMWST
LWSTS Tax amount in Reporting CurrencyCURR232 LWSTS
LWBTR Amount in Reporting Currency for Tax BreakdownCURR232 LWBTX
HWBAS Tax Base Amount in Local CurrencyCURR232 HWBAS
FWBAS Tax Base Amount in Document CurrencyCURR232 FWBAS
HWZUZ Provision Amount in Local CurrencyCURR232 HWZUZ
FWZUZ Additional Tax in Document CurrencyCURR232 FWZUZ
SHZUZ Debit/Credit Addition for Cash DiscountCHAR10 SHZUZ
STEKZ Component of the Version NumberCHAR20 CHAR2
MWART Tax TypeCHAR10 MWART
TXGRP Group Indicator for Tax Line ItemsNUMC30 TXGRP
KTOSL Transaction KeyCHAR30 KTOSL
QSSHB Withholding Tax Base AmountCURR232 QSSHB
KURSR Hedged Exchange RateDEC95 KURSR
GBETR Hedged Amount in Foreign CurrencyCURR232 GBETR
BDIFF Valuation DifferenceCURR232 BDIFF
BDIF2 Valuation Difference for the Second Local CurrencyCURR232 BDIF2
VALUT Value dateDATS80 VALUT
ZUONR Assignment numberCHAR180 DZUONR
SGTXT Item TextCHAR500 SGTXT
ZINKZ Exempted from Interest CalculationCHAR20 DZINKZ
VBUND Company ID of Trading PartnerCHAR60 T880 RASSC
BEWAR Transaction typeCHAR30 T856 RMVCT
ALTKT Group Account NumberCHAR100 BILKT_SKA1
VORGN Transaction Type for General LedgerCHAR40 VORGN
FDLEV Planning LevelCHAR20 T036 FDLEV
FDGRP Planning GroupCHAR100 T035 FDGRP
FDWBT Planned Amount in Document or G/L Account CurrencyCURR232 FDWBT
FDTAG Planning DateDATS80 FDTAG
FKONT Financial Budget ItemNUMC30 FIPLS
KOKRS Controlling AreaCHAR40 TKA01 KOKRS
KOSTL Cost CenterCHAR100 KOSTL
PROJN Old: Project number : No longer used --> PS_POSNRCHAR160 PROJN
AUFNR Order NumberCHAR120 AUFK AUFNR
VBELN Billing DocumentCHAR100 VBELN_VF
VBEL2 Sales DocumentCHAR100 VBELN_VA
POSN2 Sales Document ItemNUMC60 POSNR_VA
ETEN2 Schedule Line NumberNUMC40 VBEP ETENR
SERVICE_DOC_TYPE Service Document TypeCHAR40 FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document IDCHAR100 FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item IDNUMC60 FCO_SRVDOC_ITEM_ID
ANLN1 Main Asset NumberCHAR120 IFIMASTFIXASSET ANLN1
ANLN2 Asset SubnumberCHAR40 IFIXASSET ANLN2
ANBWA Asset Transaction TypeCHAR30 TABW ANBWA
BZDAT Asset Value DateDATS80 BZDAT
PERNR Personnel NumberNUMC80 PERNR_D
XUMSW Indicator: Sales-Related Item ?CHAR10 XUMSW
XHRES Indicator: Resident G/L Account?CHAR10 XHRES
XKRES Indicator: Can Line Items Be Displayed by Account?CHAR10 XKRES
XOPVW Indicator: Open Item Management?CHAR10 XOPVW
XCPDD Indicator: Address and Bank Data Set IndividuallyCHAR10 XCPDD
XSKST Indicator: Statistical Posting to Cost CenterCHAR10 XSKST
XSAUF Indicator: Posting to Order Is StatisticalCHAR10 XSAUF
XSPRO Indicator: Posting to Project Is StatisticalCHAR10 XSPRO
XSERG Indicator: Posting to Profitability Analysis Is StatisticalCHAR10 XSERG
XFAKT Indicator: Billing Document Update Successful?CHAR10 XFAKT
XUMAN Indicator: Transfer Posting from Down Payment?CHAR10 XUMAN
XANET Indicator: Down Payment in Net Procedure?CHAR10 XANET
XSKRL Indicator: Line Item Not Liable to Cash Discount?CHAR10 XSKRL
XINVE Indicator: Capital Goods Affected?CHAR10 XINVE
XPANZ Display ItemCHAR10 XPANZ
XAUTO Indicator: Line item automatically createdCHAR10 XAUTO
XNCOP Indicator: Items Cannot Be Copied?CHAR10 XNCOP
XZAHL Indicator: Is Posting Key Used in a Payment Transaction?CHAR10 XZAHL
SAKNR G/L Account NumberCHAR100 SKB1 SAKNR
HKONT General Ledger AccountCHAR100 SKB1 HKONT
KUNNR Customer NumberCHAR100 KNA1 KUNNR
LIFNR Account Number of SupplierCHAR100 LFA1 LIFNR
FILKD Account Number of the BranchCHAR100 FILKD
XBILK Indicator: Account is a balance sheet account?CHAR10 XBILK
GVTYP P&L statement account typeCHAR20 GVTYP
HZUON Assignment Number for Special G/L AccountsCHAR180 HZUON
ZFBDT Baseline Date for Due Date CalculationDATS80 DZFBDT
ZTERM Terms of payment keyCHAR40 DZTERM
ZBD1T Cash discount days 1DEC30 DZBD1T
ZBD2T Cash discount days 2DEC30 DZBD2T
ZBD3T Net Payment Terms PeriodDEC30 DZBD3T
ZBD1P Cash discount percentage 1DEC53 DZBD1P
ZBD2P Cash Discount Percentage 2DEC53 DZBD2P
SKFBT Amount Eligible for Cash Discount in Document CurrencyCURR232 SKFBT
SKNTO Cash Discount Amount in Local CurrencyCURR232 SKNTO
WSKTO Cash Discount Amount in Document CurrencyCURR232 WSKTO
ZLSCH Payment MethodCHAR10 T042Z SCHZW_BSEG
ZLSPR Payment Block KeyCHAR10 T008 DZLSPR
ZBFIX Fixed Payment TermsCHAR10 DZBFIX
HBKID Short Key for a House BankCHAR50 T012 HBKID
BVTYP Partner bank typeCHAR40 BVTYP
NEBTR Net Payment AmountCURR232 NEBTR
MWSK1 Tax Code for DistributionCHAR20 T007A MWSKX
TXDAT_FROM1 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack)DATS80 FOT_TXDAT_FROMX
TAX_COUNTRY1 Tax Country or Region for Tax BreakdownCHAR30 FOT_TAX_COUNTRYX
DMBT1 Amount in Local Currency for Tax DistributionCURR232 DMBTX
WRBT1 Amount in Foreign Currency for Tax BreakdownCURR232 WRBTX
HIST_TAX_FACTOR1 Historical Factor for calculating Tax AmountD34R340 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
MWSK2 Tax Code for DistributionCHAR20 T007A MWSKX
TXDAT_FROM2 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack)DATS80 FOT_TXDAT_FROMX
TAX_COUNTRY2 Tax Country or Region for Tax BreakdownCHAR30 FOT_TAX_COUNTRYX
DMBT2 Amount in Local Currency for Tax DistributionCURR232 DMBTX
WRBT2 Amount in Foreign Currency for Tax BreakdownCURR232 WRBTX
HIST_TAX_FACTOR2 Historical Factor for calculating Tax AmountD34R340 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
MWSK3 Tax Code for DistributionCHAR20 T007A MWSKX
TXDAT_FROM3 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack)DATS80 FOT_TXDAT_FROMX
TAX_COUNTRY3 Tax Country or Region for Tax BreakdownCHAR30 FOT_TAX_COUNTRYX
DMBT3 Amount in Local Currency for Tax DistributionCURR232 DMBTX
WRBT3 Amount in Foreign Currency for Tax BreakdownCURR232 WRBTX
HIST_TAX_FACTOR3 Historical Factor for calculating Tax AmountD34R340 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
HIST_TAX_FACTOR Historical Factor for calculating Tax AmountD34R340 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
REBZG Document No. of the Invoice to Which the Transaction BelongsCHAR100 REBZG
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo)NUMC40 REBZJ
REBZZ Line Item in the Relevant InvoiceNUMC30 REBZZ
REBZT Follow-On Document TypeCHAR10 REBZT
ZOLLT Customs Tariff NumberCHAR80 DZOLLT
ZOLLD Customs DateDATS80 DZOLLD
LZBKZ State Central Bank IndicatorCHAR30 T015L LZBKZ
LANDL Supplying Country/RegionCHAR30 T005 LANDL
DIEKZ Service Indicator (Foreign Payment)CHAR10 DIEKZ
SAMNR Invoice List NumberNUMC80 SAMNR
ABPER Settlement PeriodACCP60 ABPER_RF
VRSKZ Insurance IndicatorCHAR10 VRSKZ
VRSDT Insurance DateDATS80 VRSDT
DISBN Number of Bill of Exchange Usage Document (Discount Doc.)CHAR100 DISBN
DISBJ Fiscal Year of Bill of Exchange Usage DocumentNUMC40 DISBJ
DISBZ Line Item Within the Bill of Exchange Usage DocumentNUMC30 DISBZ
WVERW Bill of Exchange Usage TypeCHAR10 WVERW
ANFBN Document Number of the Bill of Exchange Payment RequestCHAR100 ANFBN
ANFBJ Fiscal Year of the Bill of Exchange Payment Request DocumentNUMC40 ANFBJ
ANFBU Company Code in Which Bill of Exch.Payment Request Is PostedCHAR40 T001 ANFBU
ANFAE Bill of Exchange Payment Request Due DateDATS80 ANFAE
BLNBT Base Amount for Determining the Preference AmountCURR232 BLNBT
BLNKZ (Obsolete) Subsidy Ind. for Determining the Reduction RateCHAR20 BLNKZ
BLNPZ Preference Percentage RateDEC72 BLNPZ
MSCHL Dunning KeyCHAR10 T040 MSCHL
MANSP Dunning BlockCHAR10 T040S MANSP
MADAT Date of Last Dunning NoticeDATS80 MADAT
MANST Dunning LevelNUMC10 MAHNS_D
MABER Dunning AreaCHAR20 T047M MABER
ESRNR ISR subscriber numberCHAR110 ESRNR
ESRRE ISR/QR Reference NumberCHAR270 ESRRE
ESRPZ POR check digitCHAR20 ESRPZ
KLIBT Credit Control AmountCURR232 KLIBT
QSZNR Certificate Number of the Withholding Tax ExemptionCHAR100 QSZNR
QBSHB Withholding Tax Amount (in Document Currency)CURR232 QBSHB
QSFBT Withholding Tax-Exempt Amount (in Document Currency)CURR232 QSFBT
NAVHW Non-Deductible Input Tax (in Local Currency)CURR232 NAVHW
NAVFW Non-Deductible Input Tax (in Document Currency)CURR232 NAVFW
MATNR Material NumberCHAR400 MARA MATNR
WERKS PlantCHAR40 T001W WERKS_D
MENGE QuantityQUAN133 MENGE_D
MEINS Base Unit of MeasureUNIT30 T006 MEINS
ERFMG Quantity in unit of entryQUAN133 ERFMG
ERFME Unit of entryUNIT30 T006 ERFME
BPMNG Quantity in Purchase Order Price UnitQUAN133 BPMNG
BPRME Order Price Unit (Purchasing)UNIT30 T006 BPRME
EBELN_LOGSYS Logical System of Purchasing DocumentCHAR100 EBELN_LOGSYS
EBELN Purchasing Document NumberCHAR100 EKKO EBELN
EBELP Item Number of Purchasing DocumentNUMC50 EKPO EBELP
ZEKKN Sequential Number of Account AssignmentNUMC20 DZEKKN
ELIKZ "Delivery Completed" IndicatorCHAR10 ELIKZ
VPRSV Price control indicatorCHAR10 VPRSV
PEINH Price unitDEC50 PEINH
BWKEY Valuation areaCHAR40 T001K BWKEY
BWTAR Valuation TypeCHAR100 T149D BWTAR_D
BUSTW Posting String for ValuesCHAR40 BUSTW
REWRT Invoice Value Entered (in Local Currency)CURR132 REEWR
REWWR Invoice Amount in Foreign CurrencyCURR232 REWWR
BONFB Amount Qualifying for Bonus in Local CurrencyCURR232 BONFB
BUALT Amount Posted in Alternative Price ControlCURR132 BUALT
PSALT Alternative Price ControlCHAR10 PSALT
NPREI New PriceCURR112 NPREI
TBTKZ Indicator: Subsequent Debit/CreditCHAR10 TBTKZ
SPGRP Blocking Reason: PriceCHAR10 SPGRP
SPGRM Blocking Reason: QuantityCHAR10 SPGRM
SPGRT Blocking Reason: DateCHAR10 SPGRT
SPGRG Blocking Reason: Order Price QuantityCHAR10 SPGRG
SPGRV Blocking Reason: Project BudgetCHAR10 SPGRV
SPGRQ Manual Blocking ReasonCHAR10 SPGRQ
STCEG VAT Registration NumberCHAR200 STCEG
EGBLD Country/Region of Destination for Delivery of GoodsCHAR30 T005 EGBLD
EGLLD Supplying Country/Region for Delivery of GoodsCHAR30 T005 EGLLD
RSTGR Reason Code for PaymentsCHAR30 T053R RSTGR
RYACQ Year of acquisitionCHAR40 RYACQ
RPACQ Period of AcquisitionNUMC30 RPACQ
RDIFF Exchange Rate Gain/Loss RealizedCURR232 RDIFF
RDIF2 Exchange Rate Difference Realized for Second Local CurrencyCURR232 RDIF2
PRCTR Profit CenterCHAR100 PRCTR
XHKOM Indicator: G/L Account Assigned Manually?CHAR10 XHKOM
VNAME Joint ventureCHAR60 T8JV JV_NAME
RECID Recovery IndicatorCHAR20 T8JJ JV_RECIND
EGRUP Equity groupCHAR30 T8JF JV_EGROUP
VPTNR Partner account numberCHAR100 KNA1 JV_PART
VERTT Contract TypeCHAR10 RANTYP
VERTN Contract NumberCHAR130 RANL
VBEWA Flow TypeCHAR40 SBEWART
DEPOT Securities AccountCHAR100 RLDEPO
TXJCD Tax JurisdictionCHAR150 TTXJ TXJCD
IMKEY Internal Key for Real Estate ObjectCHAR80 IMKEY
DABRZ Reference date for settlementDATS80 DABRBEZ
POPTS Real Estate Option RateDEC96 POPTSATZ
FIPOS Commitment ItemCHAR140 FIPOS
KSTRG Cost ObjectCHAR120 KSTRG
NPLNR Network Number for Account AssignmentCHAR120 NPLNR
AUFPL Task List Number for Operations in OrderNUMC100 AUFPL_CH
APLZL General Counter for OrderNUMC80 APLZL_CH
PROJK Work Breakdown Structure Element (WBS Element)NUMC80 PS_PSP_PNR
PAOBJNR Profitability Segment Number (CO-PA)NUMC100 RKEOBJNR
PASUBNR Profitability Segment Changes (CO-PA)NUMC40 RKESUBNR
SPGRS Blocking Reason: Item AmountCHAR10 SPGRS
SPGRC Blocking Reason: QualityCHAR10 SPGRC
BTYPE Billing IndicatorCHAR20 T8JA JV_BILIND
ETYPE Equity typeCHAR30 T8JE JV_ETYPE
XEGDR Indicator: Triangular Deal Within the EUCHAR10 XEGDR
LNRAN Sequence Number of Asset Line Items in Fiscal YearNUMC50 LNRAN
HRKFT Origin Group as Subdivision of Cost ElementCHAR40 HRKFT
DMBE2 Amount in Second Local Currency or Global CurrencyCURR232 DMBE2
DMBE3 Amount in Third Local Currency or First Freely-Def. CurrencyCURR232 DMBE3
DMB21 Amount in Second Local Currency for Tax BreakdownCURR232 DMB2X
DMB22 Amount in Second Local Currency for Tax BreakdownCURR232 DMB2X
DMB23 Amount in Second Local Currency for Tax BreakdownCURR232 DMB2X
DMB31 Amount in Third Local Currency for Tax BreakdownCURR232 DMB3X
DMB32 Amount in Third Local Currency for Tax BreakdownCURR232 DMB3X
DMB33 Amount in Third Local Currency for Tax BreakdownCURR232 DMB3X
MWST2 Tax Amount in Second Local CurrencyCURR232 MWST2
MWST3 Tax Amount in Third Local CurrencyCURR232 MWST3
NAVH2 Non-Deductible Input Tax in Second Local CurrencyCURR232 NAVH2
NAVH3 Non-Deductible Input Tax in Third Local CurrencyCURR232 NAVH3
SKNT2 Cash Discount Amount in Second Local CurrencyCURR232 SKNT2
SKNT3 Cash Discount Amount in Third Local CurrencyCURR232 SKNT3
BDIF3 Valuation Difference for the Third Local CurrencyCURR232 BDIF3
RDIF3 Exchange Rate Difference Realized for Third Local CurrencyCURR232 RDIF3
HWMET Method with Which the Local Currency Amount Was DeterminedCHAR10 HWMET
GLUPM Update Method for FM - FI-CA IntegrationCHAR10 GLUPM
XRAGL Indicator: Clearing Was ReversedCHAR10 XRAGL
UZAWE Payment method supplementCHAR20 T042F UZAWE
LOKKT Alternative Account Number in Company CodeCHAR100 ALTKT_SKB1
FISTL Funds CenterCHAR160 FISTL
GEBER FundCHAR100 BP_GEBER
STBUK Tax Company CodeCHAR40 STBUK
TXBH2 Tax Base/Original Tax Base in Second Local CurrencyCURR232 TXBH2
TXBH3 Tax Base/Original Tax Base in Third Local CurrencyCURR232 TXBH3
PPRCT Partner Profit CenterCHAR100 CEPC PPRCTR
XREF1 Business Partner Reference KeyCHAR120 XREF1
XREF2 Business Partner Reference KeyCHAR120 XREF2
KBLNR Document Number for Earmarked FundsCHAR100 KBLK KBLNR_FI
KBLPOS Earmarked Funds: Document ItemNUMC30 KBLP KBLPOS
STTAX Tax Amount as Statistical Information in Document CurrencyCURR132 STTAX
FKBER Functional AreaCHAR40 FKBER_SHORT
OBZEI Number of Line Item in Original DocumentNUMC30 OBZEI
XNEGP Indicator: Negative PostingCHAR10 XNEGP
RFZEI Payment Card ItemNUMC30 RFZEI_CC
CCBTC Payment cards: Settlement runCHAR100 CCBTC
KKBER Credit control areaCHAR40 T014 KKBER
EMPFB Payee/PayerCHAR100 EMPFB
XREF3 Reference key for line itemCHAR200 XREF3
DTWS1 Instruction Key 1NUMC20 DTAT16
DTWS2 Instruction Key 2NUMC20 DTAT17
DTWS3 Instruction key 3NUMC20 DTAT18
DTWS4 Instruction key 4NUMC20 DTAT19
GRICD Activity Code for Gross Income TaxCHAR20 J_1AGICD J_1AGICD_D
GRIRG Region (State, Province, County)CHAR30 T005S REGIO
GITYP Distribution Type for Employment TaxCHAR20 J_1ADTYP J_1ADTYP_D
XPYPR Indicator: Items from Payment Program BlockedCHAR10 XPYPR
KIDNO Payment ReferenceCHAR300 KIDNO
ABSBT Credit Management: Hedged AmountCURR232 ABSBT
IDXSP Inflation IndexCHAR50 J_1AINFT20 J_1AINDXSP
LINFV Last Adjustment DateDATS80 J_1ALINFVL
KONTT Account Assignment Category for Industry SolutionCHAR20 KONTT_FI
KONTL Acct assignment string for industry-specific acct assignmntsCHAR500 KONTL_FI
UEBGDAT Transfer Date of an Item to Legal Dunning ProceedingDATS80 UEBGDATUM
TXDAT Date for Determining Tax RatesDATS80 TXDAT
AGZEI Clearing ItemDEC50 AGZEI
PYCUR Currency for Automatic PaymentCUKY50 TCURC PYCUR
PYAMT Amount in Payment CurrencyCURR232 PYAMT
BUPLA Business PlaceCHAR40 PBUSINESSPLACE BUPLA
SECCO Section CodeCHAR40 SECCODE SECCO
LSTAR Activity TypeCHAR60 LSTAR
CESSION_KZ Accounts Receivable Pledging IndicatorCHAR20 TCESSION CESSION_KZ
PRZNR Business ProcessCHAR120 CO_PRZNR
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)CURR232 PPDIFF
PPDIF2 Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts)CURR232 PPDIF2
PPDIF3 Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts)CURR232 PPDIF3
PENLC1 Penalty Charge Amount in First Local CurrencyCURR232 PENALTY1
PENLC2 Penalty Charge Amount in Second Local CurrencyCURR232 PENALTY2
PENLC3 Penalty Charge Amount in Third Local CurrencyCURR232 PENALTY3
PENFC Penalty Charge Amount in Document CurrencyCURR232 PENALTY
PENDAYS Number of Days for Penalty Charge CalculationINT4100 PDAYS
PENRC Reason for Late PaymentCHAR20 PENRC
GRANT_NBR GrantCHAR200 GM_GRANT_NBR
SCTAX Tax Portion FI-CA Local CurrencyCURR132 SCTAX
FKBER_LONG Functional AreaCHAR160 FKBER
GMVKZ Item is in ExecutionCHAR10 FM_GMVKZ
SRTYPE Type of Additional ReceivableCHAR20 FM_SRTYPE
INTRENO Internal Real Estate Master Data CodeCHAR130 VVINTRENO
MEASURE Funded ProgramCHAR240 FM_MEASURE
AUGGJ Fiscal Year of Clearing DocumentNUMC40 AUGGJ
PPA_EX_IND PPA Exclude IndicatorCHAR10 EXCLUDE_FLG
DOCLN Six-Character Posting Item for LedgerCHAR60 DOCLN6
SEGMENT Segment for Segmental ReportingCHAR100 FB_SEGMENT
PSEGMENT Partner Segment for Segmental ReportingCHAR100 FB_PSEGMENT
PFKBER Partner Functional AreaCHAR160 SFKBER
HKTID ID for Account DetailsCHAR50 T012K HKTID
KSTAR Cost ElementCHAR100 KSTAR
XLGCLR Open Item Management by Ledger GroupCHAR10 XLGCLR
TAXPS Tax document item numberNUMC60 TAX_POSNR
PAYS_PROV Payment Service ProviderCHAR40 COM_WEC_PAYMENT_SRV_PROVIDER
PAYS_TRAN Payment Reference of Payment Service ProviderCHAR350 FPS_TRANSACTION
MNDID Unique Reference to Mandate for each PayeeCHAR350 SEPA_MNDID
XFRGE_BSEG Payment Is ReleasedCHAR10 XFRGE_BSEG
AWTYP Reference procedureCHAR50 AWTYP
AWKEY Reference KeyCHAR200 AWKEY
AWSYS Logical system of source documentCHAR100 AWSYS
POSNR Accounting Document Line Item NumberNUMC100 POSNR_ACC
BUZEI_SENDER Item Number Within Accounting Document in Sender SystemNUMC30 BUZEI_SENDER
H_MONAT Fiscal periodNUMC20 MONAT
H_BSTAT Document StatusCHAR10 BSTAT_D
H_BUDAT Posting Date in the DocumentDATS80 BUDAT
H_BLDAT Document Date in DocumentDATS80 BLDAT
H_WAERS Currency KeyCUKY50 TCURC WAERS
H_BLART Document TypeCHAR20 T003 BLART
H_HWAER Local CurrencyCUKY50 HWAER
H_HWAE2 Currency Key of Second Local CurrencyCUKY50 HWAE2
H_HWAE3 Currency Key of Third Local CurrencyCUKY50 HWAE3
SK1DT Due Date for Cash Discount 1DATS80 SK1DT
SK2DT Due Date for Cash Discount 2DATS80 SK2DT
PRCTR_DRVTN_SOURCE_TYPE Profit Center Derivation Source TypeCHAR20 FINOC_PRCTR_DRVTN_SOURCE_TYPE
PAYT_RSN Payment ReasonCHAR40 FARP_PAYT_RSN_T FARP_PAYT_RSN
_DATAAGING Data Filter Value for Data AgingDATS80 DATA_TEMPERATURE
FQFTYPE Flow TypeCHAR60 FQM_FLOW_TYPE
LQITEM Liquidity ItemCHAR160 FLQPOS
GKONT Offsetting Account NumberCHAR100 GKONT
GKART Offsetting Account TypeCHAR10 GKOAR
GHKON G/L Acct of Offsetting Acct in General Ledger AccountingCHAR100 GHKONT
SQUAN Quantity +/- SignCHAR10 SIGN_QUANTITY
ANLN2_PN Asset SubnumberCHAR40 * ANLN2
BWASL_PN Asset Transaction TypeCHAR30 * BWASL
BZDAT_PN Asset Value DateDATS80 BZDAT
XVABG_PN Indicator: Post Complete RetirementCHAR10 XVABG
ANBTR_PN Amount PostedCURR232 ANBTR
PROZS_PN Asset Retirement: Percentage RateDEC52 PROZS
ACDOC_EEW_DUMMY Custom Fields: Dummy for Use in Extension IncludesCHAR10 CFD_DUMMY
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension IncludesCHAR10 CFD_DUMMY
ACROBJTYPE Type of the Accrual ObjectCHAR40 TACR_OBJ_TYPE ACR_OBJ_TYPE
ACRLOGSYS Logical System of the Accrual ObjectCHAR100 ACR_LOGSYS
ACROBJ_ID Identifier of the Accrual ObjectCHAR320 ACR_OBJ_ID
ACRSOBJ_ID Identifier of the Accrual SubobjectCHAR320 ACR_SUBOBJ_ID
ACRITMTYPE Type of the Item of the Accrual SubobjectCHAR110 ACR_ITEM_TYPE
ACRREFOBJ_ID Identifier of the Accrual Reference ObjectCHAR320 ACR_REFOBJ_ID
ACRVALDAT Accrual Value DateDATS80 ACR_VALUE_DATE
VALOBJTYPE Type of the Financial Valuation ObjectCHAR40 FINSC_VAL_TYPE VAL_OBJ_TYPE
VALOBJ_ID Identifier of the Financial Valuation ObjectCHAR320 VAL_OBJ_ID
VALSOBJ_ID Identifier of the Financial Valuation SubobjectCHAR320 VAL_SUBOBJ_ID
NETDT Net Due DateDATS80 NETDT
RISK_CLASS Risk ClassCHAR30 UKM_RISK_CL UKM_RISK_CLASS
SDM_VERSION SDM: Version field for BSEGCHAR20 FINS_SDM_VERSION_BSEG
GLO_REF1 Country/Region Specific Reference 1 on line itemCHAR500 FAC_GLO_REF1
RE_BUKRS Cash Ledger: Company Code for Expense/RevenueCHAR40 * FAGL_RE_BUKRS
RE_ACCOUNT Cash Ledger: Expense or Revenue AccountCHAR100 * FAGL_RE_ACCOUNT
DP_PAYMENT_TYPE Digital Payments Payment TypeCHAR20 DP_PAYMENT_TYPE
DP_TRANS_ID Transaction/Payment ID of SAP Digital PaymentsCHAR440 DP_TRANSID
PGEBER Partner FundCHAR100 * FM_PFUND
PGRANT_NBR Partner GrantCHAR200 GM_GRANT_PARTNER
BUDGET_PD Budget PeriodCHAR100 * FM_BUDGET_PERIOD
PBUDGET_PD FM: Partner Budget PeriodCHAR100 * FM_PBUDGET_PERIOD
J_1TPBUPL Branch CodeCHAR50 BCODE
PEROP_BEG Billing Period of Performance Start DateDATS80 FM_PEROP_FI_LOW
PEROP_END Billing Period of Performance End DateDATS80 FM_PEROP_FI_HIGH
FASTPAY PPA Fast Pay IndicatorCHAR10 FMFG_FASTPAY_FLG
IGNR_IVREF FMFG: Ignore the invoice reference during FI doc splittingCHAR10 FMFG_IGNORE_INV_REF
FMFGUS_KEY United States Federal Government FieldsCHAR220 FMFG_US_KEY
FMXDOCNR FM Reference Document NumberCHAR100 FM_XDOCNR
FMXYEAR FM Reference YearNUMC40 FM_XYEAR
FMXDOCLN FM Reference Line ItemNUMC60 FM_XDOCLN
FMXZEKKN FM Reference Sequence Account AssignmentNUMC50 FM_XZEKKN
PRODPER Production Month (Date to find period and year)DATS80 JV_PRODPER
GST_PART GST PartnerCHAR100 J_1IG_PARTNER
PLC_SUP Place of SupplyCHAR30 T005S J_1IG_REGION
HSN_SAC HSN or SAC CodeCHAR160 J_1IG_HSN_SAC
IRN Invoice Reference NumberCHAR640 J_1IG_IRN
RECRF Service tax recredit flagCHAR10 J_1IRECRF
BDGT_ACCOUNT Budget AccountCHAR100 * PSM_BDGT_ACCOUNT
BDGT_ACCOUNT_COCODE Budget Account Company CodeCHAR40 * PSM_BDGT_ACCOUNT_COCODE
INWARD_NO Incoming Document NumberCHAR300 SAFM_AP_INWARD_NO
INWARD_DT Incoming Document DateDATS80 SAFM_AP_INWARD_DT
GROUND_NO Payment Basis Document NumberCHAR160 SAFM_AP_PYBSNO
GROUND_DT Payment Basis Document DateDATS80 SAFM_AP_PYBSDAT
GROUND_TYP Type of Payment Basis DocumentCHAR20 SAFM_AP_PYBSTYP
PYMTKEY Payment or Proposal KeyCHAR200 SAFM_AP_PYMNTKEY

BSEG relationships.

136 relationships

BSEG is a central table in the SAP FI module and has important connections with several other SAP tables. The most significant connections include:

  • BKPF (Accounting Document Header): Each entry in BSEG is linked to an entry in BKPF through the fields BELNR (Document Number), BUKRS (Company Code), and GJAHR (Fiscal Year). BKPF contains the header information of accounting documents, such as the document type, posting date, and entry date.

  • BSIK (Vendor Line Items) and BSID (Customer Line Items): These tables store open items for vendors and customers, respectively. They are linked to BSEG through the document number (BELNR), company code (BUKRS), and fiscal year (GJAHR). These tables help manage and clear vendor and customer transactions.

  • COEP (Controlling Document Line Items): This table stores line items for internal cost accounting and is linked to BSEG through fields like cost center (KOSTL) and order (AUFNR). This connection allows integration between financial and management accounting.

  • LFA1 (Vendor Master) and KNA1 (Customer Master): These master data tables store vendor and customer details. BSEG references these tables through fields like vendor account (LIFNR) and customer account (KUNNR) to provide context for the line items.

  • MSEG (Document Segment: Material): This table stores material document line items in the Materials Management (MM) module. BSEG connects with MSEG for transactions involving goods movements, with links through the document number (BELNR) and item number (BUZEI).

  • ANEP (Asset Line Items): This table contains asset accounting line items and is linked to BSEG for transactions related to fixed assets. The connection is through fields like asset number (ANLN1) and asset sub-number (ANLN2).

These connections enable BSEG to serve as a central repository of detailed financial data, facilitating comprehensive financial management and reporting across various functional areas within SAP.

TableFieldCheck tableDescriptionCheck field
BSEGACROBJTYPETACR_OBJ_TYPEAccrual object typeMANDT
BSEGANBWATABWAsset transaction typesMANDT
BSEGANFBUT001Company CodesBUKRS
BSEGANLN1IFIMASTFIXASSETGenerated Table for ViewMANDT
BSEGANLN1IFIMASTFIXASSETGenerated Table for ViewCOMPANYCODE
BSEGANLN1IFIMASTFIXASSETGenerated Table for ViewMASTERFIXEDASSET
BSEGANLN2IFIXASSETGenerated Table for ViewMANDT
BSEGANLN2IFIXASSETGenerated Table for ViewCOMPANYCODE
BSEGANLN2IFIXASSETGenerated Table for ViewMASTERFIXEDASSET
BSEGANLN2IFIXASSETGenerated Table for ViewFIXEDASSET
BSEGAUFNRAUFKOrder master dataAUFNR
BSEGBEWART856Transaction TypesMANDT
BSEGBEWART856Transaction TypesTRTYP
BSEGBPRMET006Units of MeasurementMANDT
BSEGBSCHLTBSLPosting KeyMANDT
BSEGBSCHLTBSLPosting KeyBSCHL
BSEGBTYPET8JAPayroll TypeMANDT
BSEGBTYPET8JAPayroll TypeBILIND
BSEGBUKRST001Company CodesBUKRS
BSEGBUPLAPBUSINESSPLACEGenerated Table for ViewBUKRS
BSEGBUPLAPBUSINESSPLACEGenerated Table for ViewBRANCH
BSEGBWTART149DGlobal Valuation TypesMANDT
BSEGBWTART149DGlobal Valuation TypesBWTAR
BSEGCESSION_KZTCESSIONAccounts Receivable PledgingCLIENT
BSEGCESSION_KZTCESSIONAccounts Receivable PledgingCOMPANY
BSEGEBELNEKKOPurchasing Document HeaderEBELN
BSEGEBELPEKPOPurchasing Document ItemMANDT
BSEGEBELPEKPOPurchasing Document ItemEBELN
BSEGEGBLDT005CountriesMANDT
BSEGEGBLDT005CountriesLAND1
BSEGEGLLDT005CountriesMANDT
BSEGEGLLDT005CountriesLAND1
BSEGEGRUPT8JFInvestment GroupMANDT
BSEGEGRUPT8JFInvestment GroupBUKRS
BSEGEGRUPT8JFInvestment GroupVNAME
BSEGEGRUPT8JFInvestment GroupEGRUP
BSEGERFMET006Units of MeasurementMANDT
BSEGETEN2VBEPSales Document: Schedule Line DataMANDT
BSEGETEN2VBEPSales Document: Schedule Line DataVBELN
BSEGETEN2VBEPSales Document: Schedule Line DataPOSNR
BSEGETEN2VBEPSales Document: Schedule Line DataETENR
BSEGETYPET8JEInvestment TypeMANDT
BSEGETYPET8JEInvestment TypeBUKRS
BSEGETYPET8JEInvestment TypeETYPE
BSEGFDGRPT035Planning groupsGRUPP
BSEGFDLEVT036Planning levelsEBENE
BSEGGITYPJ_1ADTYPDistribution Types for Gross Income TaxMANDT
BSEGGITYPJ_1ADTYPDistribution Types for Gross Income TaxBUKRS
BSEGGRICDJ_1AGICDActivity codes for gross income tax declarationMANDT
BSEGGRICDJ_1AGICDActivity codes for gross income tax declarationLAND1
BSEGGRIRGT005STaxes: Region (Province) KeyLAND1
BSEGGSBERTGSBBusiness AreasMANDT
BSEGGSBERTGSBBusiness AreasGSBER
BSEGHBKIDT012House BanksBUKRS
BSEGHKONTSKB1G/L account master (company code)MANDT
BSEGHKONTSKB1G/L account master (company code)BUKRS
BSEGHKTIDT012KHouse Bank AccountsMANDT
BSEGHKTIDT012KHouse Bank AccountsBUKRS
BSEGHKTIDT012KHouse Bank AccountsHBKID
BSEGHKTIDT012KHouse Bank AccountsHKTID
BSEGH_BLARTT003Document TypesMANDT
BSEGH_WAERSTCURCCurrency CodesMANDT
BSEGH_WAERSTCURCCurrency CodesWAERS
BSEGIDXSPJ_1AINFT20Inflation: Index DefinitionMANDT
BSEGKBLNRKBLKDocument Header: Manual Document EntryMANDT
BSEGKBLNRKBLKDocument Header: Manual Document EntryBELNR
BSEGKBLPOSKBLPDocument Item: Manual Document EntryMANDT
BSEGKBLPOSKBLPDocument Item: Manual Document EntryBELNR
BSEGKKBERT014Credit control areasKKBER
BSEGKOKRSTKA01Controlling AreasMANDT
BSEGKUNNRKNA1General Data in Customer MasterMANDT
BSEGKUNNRKNA1General Data in Customer MasterKUNNR
BSEGLANDLT005CountriesMANDT
BSEGLANDLT005CountriesLAND1
BSEGLIFNRLFA1Supplier Master (General Section)MANDT
BSEGLIFNRLFA1Supplier Master (General Section)LIFNR
BSEGLZBKZT015LSCB RatiosLZBKZ
BSEGMABERT047MDunning areasMANDT
BSEGMABERT047MDunning areasBUKRS
BSEGMANDTT000ClientsMANDT
BSEGMATNRMARAGeneral Material DataMANDT
BSEGMATNRMARAGeneral Material DataMATNR
BSEGMEINST006Units of MeasurementMANDT
BSEGMEINST006Units of MeasurementMSEHI
BSEGMSCHLT040Dunning keysMSCHL
BSEGMWSK1T007ATax KeysKALSM
BSEGMWSK1T007ATax KeysMWSKZ
BSEGMWSK2T007ATax KeysKALSM
BSEGMWSK2T007ATax KeysMWSKZ
BSEGMWSK3T007ATax KeysKALSM
BSEGMWSK3T007ATax KeysMWSKZ
BSEGMWSKZT007ATax KeysKALSM
BSEGMWSKZT007ATax KeysMWSKZ
BSEGPARGBTGSBBusiness AreasMANDT
BSEGPARGBTGSBBusiness AreasGSBER
BSEGPLC_SUPT005STaxes: Region (Province) KeyLAND1
BSEGPPRCTCEPCProfit Center Master Data TablePRCTR
BSEGPPRCTCEPCProfit Center Master Data TableDATBI
BSEGPPRCTCEPCProfit Center Master Data TableKOKRS
BSEGPSWSLTCURCCurrency CodesMANDT
BSEGPSWSLTCURCCurrency CodesWAERS
BSEGPYCURTCURCCurrency CodesMANDT
BSEGPYCURTCURCCurrency CodesWAERS
BSEGQSSKZT059QWithholding TaxMANDT
BSEGQSSKZT059QWithholding TaxLAND1
BSEGQSSKZT059QWithholding TaxQSSKZ
BSEGRECIDT8JJRecovery IndicatorMANDT
BSEGRECIDT8JJRecovery IndicatorBUKRS
BSEGRSTGRT053RClassification of Payment DifferencesMANDT
BSEGRSTGRT053RClassification of Payment DifferencesBUKRS
BSEGRSTGRT053RClassification of Payment DifferencesRSTGR
BSEGSAKNRSKB1G/L account master (company code)MANDT
BSEGSAKNRSKB1G/L account master (company code)BUKRS
BSEGSECCOSECCODESection CodeMANDT
BSEGSECCOSECCODESection CodeBUKRS
BSEGSECCOSECCODESection CodeSECCODE
BSEGTXJCDTTXJCheck Table for Tax JurisdictionMANDT
BSEGTXJCDTTXJCheck Table for Tax JurisdictionKALSM
BSEGUMSKZT074USpecial G/L Indicator PropertiesMANDT
BSEGUZAWET042FPayment method supplementsMANDT
BSEGUZAWET042FPayment method supplementsUZAWE
BSEGVBUNDT880Global Company Data (for KONS Ledger)MANDT
BSEGVBUNDT880Global Company Data (for KONS Ledger)RCOMP
BSEGVNAMET8JVJoint VentureMANDT
BSEGVNAMET8JVJoint VentureBUKRS
BSEGVNAMET8JVJoint VentureVNAME
BSEGVPTNRKNA1General Data in Customer MasterMANDT
BSEGVPTNRKNA1General Data in Customer MasterKUNNR
BSEGWERKST001WPlants/BranchesMANDT
BSEGWERKST001WPlants/BranchesWERKS
BSEGZLSCHT042ZPayment Methods for Automatic PaymentMANDT
BSEGZLSCHT042ZPayment Methods for Automatic PaymentLAND1
BSEGZLSCHT042ZPayment Methods for Automatic PaymentZLSCH
BSEGZLSPRT008Blocking Reasons for Automatic Payment TranscationsMANDT
BSEGZLSPRT008Blocking Reasons for Automatic Payment TranscationsZAHLS
BSEGZUMSKT074USpecial G/L Indicator PropertiesMANDT