1. Home
  2. Resources
  3. SAP Tables
  4. TXW_S_BSEG - Retrieve BSEG from archive

SAP Table TXW_S_BSEG

Retrieve BSEG from archive

TXW_S_BSEG (Retrieve BSEG from archive) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TXW_S_BSEG to other SAP tables.

TXW_S_BSEG table fields

Field Data element Checktable Datatype Length Decimals
TXW_MANDT Client MANDT CLNT 3 0
TXW_BUKRS Company Code BUKRS CHAR 4 0
TXW_BELNR Accounting Document Number BELNR_D CHAR 10 0
TXW_GJAHR Fiscal Year GJAHR NUMC 4 0
TXW_BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
TXW_XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
MONAT Fiscal Period MONAT NUMC 2 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BSCHL Posting Key BSCHL CHAR 2 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
HKONT General Ledger Account HKONT CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
VBUND Trading Partner TXW_VBUND CHAR 6 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WRBTR Amount in document currency (TC) TXW_WRBTR CHAR 16 0
DMBTR Amount in Local Currency TXW_DMBTR CHAR 16 0
DMBE2 Amount in second local currency (LC2) TXW_DMBE2 CHAR 16 0
DMBE3 Amount in third local currency (LC3) TXW_DMBE3 CHAR 16 0
WSKTO Cash discount amount in document currency TXW_WSKTO CHAR 16 0
SKNTO Cash discount amount in local currency TXW_SKNTO CHAR 16 0
SKNT2 Cash discount amount in second local currency (LC2) TXW_SKNT2 CHAR 16 0
SKNT3 Cash discount amount in third local currency (LC3) TXW_SKNT3 CHAR 16 0
ZUONR Assignment Number DZUONR CHAR 18 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
MEINS Base Unit of Measure MEINS UNIT 3 0
MENGE Total quantity TXW_QUANT CHAR 16 0
KOKRS Controlling Area KOKRS CHAR 4 0
PROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
WBS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
AUFNR Order Number AUFNR CHAR 12 0
KOSTL Cost Center KOSTL CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 0
WERKS Plant WERKS_D CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
VBELN Billing Document VBELN_VF CHAR 10 0
VBEL2 Sales Document VBELN_VA CHAR 10 0
POSN2 Sales Document Item POSNR_VA NUMC 6 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
ABPER Settlement period ABPER_RF ACCP 6 0
ANBWA Asset Transaction Type ANBWA CHAR 3 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
AUGDT Clearing Date AUGDT DATS 8 0
BEWAR Consolidation Transaction Type BEWAR CHAR 3 0
FILKD Account Number of the Branch FILKD CHAR 10 0
FKBER Functional Area FKBER CHAR 16 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
FWBAS Tax base amount in document currency (TC) TXW_FWBAS CHAR 16 0
HWBAS Tax base amount in local currency TXW_HWBAS CHAR 16 0
WMWST Tax amount in document currency (TC) TXW_WMWST CHAR 16 0
GBETR Hedged amount in foreign currency TXW_GBETR CHAR 16 0
LANDL Supplying Country LANDL CHAR 3 0
REBZT Follow-On Document Type REBZT CHAR 1 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
NEBTR Net payment amount TXW_NEBTR CHAR 16 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
PSWSL Update Currency for General Ledger Transaction Figures PSWSL CUKY 5 0
PSWBT Amount for updating in general ledger (position currency PC) TXW_PSWBT CHAR 16 0
PARGB Trading partner's business area PARGB CHAR 4 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
QSFBT Withholding tax-exempt amount (in document currency) TXW_QSFBT CHAR 16 0
QSSHB Withholding tax base amount TXW_QSSHB CHAR 16 0
QBSHB Withholding tax amount (in document currency) TXW_QBSHB CHAR 16 0
SAKNR G/L Account Number SAKNR CHAR 10 0
SGTXT Item Text SGTXT CHAR 50 0
VALUT Value date VALUT DATS 8 0
TXGRP Group Indicator for Tax Line Items TXGRP NUMC 3 0
HBKID Short Key for a House Bank HBKID CHAR 5 0
MWSTS Tax amount in local currency TXW_MWSTS CHAR 16 0
MWST2 Tax amount in second local currency TXW_MWST2 CHAR 16 0
MWST3 Tax amount in third local currency TXW_MWST3 CHAR 16 0
RSTGR Reason Code for Payments RSTGR CHAR 3 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
ZBD3T Net payment terms period TXW_DZBD3T CHAR 3 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
TXBFW Original tax base amount in document currency TXW_TXBFW CHAR 16 0
TXBHW Original tax base amount in local currency TXW_TXBHW CHAR 16 0
TXBH2 Tax base/original tax base in second local currency TXW_TXBH2 CHAR 16 0
TXBH3 Tax base/original tax base in third local currency TXW_TXBH3 CHAR 16 0
KKBER Credit control area KKBER CHAR 4 0
STCEG VAT Registration Number STCEG CHAR 20 0
EGBLD Country of Destination for Delivery of Goods EGBLD CHAR 3 0
EGLLD Supplying Country for Delivery of Goods EGLLD CHAR 3 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
FKBER_LONG Functional Area FKBER CHAR 16 0
VERTT Contract Type RANTYP CHAR 1 0
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
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
VERTN Contract Number RANL CHAR 13 0
VBEWA Flow Type SBEWART CHAR 4 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR 13 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
BSTAT Document Status BSTAT_D CHAR 1 0
NULL Normal document
A Clearing Document
B Reset clearing document
D Recurring entry document
L Posting Not in Leading Ledger
M Sample document
S Noted items
V Parked document
W Parked document with change of document ID
Z Parked document which was deleted
C Balance Carryforward Line Items
LEDGER Ledger in General Ledger Accounting FAGL_RLDNR CHAR 2 0
MWART Tax Type MWART CHAR 1 0
A Output tax
V Input tax
XBILK Indicator: Account is a balance sheet account? XBILK CHAR 1 0
X Yes
NULL No
GVTYP P&L statement account type GVTYP CHAR 2 0
NAVHW Non-Deductible Input Tax (in Local Currency) TXW_NAVHW CHAR 16 0
KSTRG Cost Object KSTRG CHAR 12 0
ALTKT Group account number BILKT_SKA1 CHAR 10 0
LOKKT Alternative account number in company code ALTKT_SKB1 CHAR 10 0
ZLSCH Payment Method DZLSCH CHAR 1 0
BUZID Identification of the Line Item BUZID CHAR 1 0
AUGCP Clearing Entry Date AUGCP DATS 8 0