SAP TABLES | Cross-Application Components | General Application Functions | Data Retention Tool(CA-GTF-DRT) SAP CA

TXW_S_BSEG SAP Retrieve BSEG from archive Table and data







TXW_S_BSEG is a standard SAP Table which is used to store Retrieve BSEG from archive data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP TXW_S_BSEG Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: L - Table for storing temporary data, delivered empty

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP TXW_S_BSEG Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
TXW_MANDTMANDTCLNT3
*
Client
TXW_BUKRSBUKRSCHAR4
*
Company Code
TXW_BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
TXW_GJAHRGJAHRNUMC4 Fiscal YearGJAHR
TXW_BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
TXW_XNEGPXNEGPCHAR1 Indicator: Negative posting
.INCLUDETXW_FI_POS FI Document item
MANDTMANDTCLNT3
*
Client
BUKRSBUKRSCHAR4
*
Company Code
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
MONATMONATNUMC2 Fiscal Period
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
BSCHLBSCHLCHAR2
*
Posting Key
KOARTKOARTCHAR1 Account Type
UMSKZUMSKZCHAR1
*
Special G/L Indicator
HKONTHKONTCHAR10
*
General Ledger AccountALPHA
GSBERGSBERCHAR4
*
Business Area
VBUNDTXW_VBUNDCHAR6
*
Trading PartnerALPHA
SHKZGSHKZGCHAR1 Debit/Credit Indicator
WRBTRTXW_WRBTRCHAR16 Amount in document currency (TC)
DMBTRTXW_DMBTRCHAR16 Amount in Local Currency
DMBE2TXW_DMBE2CHAR16 Amount in second local currency (LC2)
DMBE3TXW_DMBE3CHAR16 Amount in third local currency (LC3)
WSKTOTXW_WSKTOCHAR16 Cash discount amount in document currency
SKNTOTXW_SKNTOCHAR16 Cash discount amount in local currency
SKNT2TXW_SKNT2CHAR16 Cash discount amount in second local currency (LC2)
SKNT3TXW_SKNT3CHAR16 Cash discount amount in third local currency (LC3)
ZUONRDZUONRCHAR18 Assignment Number
LIFNRLIFNRCHAR10
*
Account Number of Vendor or CreditorALPHA
KUNNRKUNNRCHAR10
*
Customer NumberALPHA
TXJCDTXJCDCHAR15
*
Tax Jurisdiction
MEINSMEINSUNIT3
*
Base Unit of MeasureCUNIT
MENGETXW_QUANTCHAR16 Total quantity
KOKRSKOKRSCHAR4
*
Controlling Area
PROJKPS_PSP_PNRNUMC8
*
Work Breakdown Structure Element (WBS Element)ABPSP
WBS_POSIDPS_POSIDCHAR24 Work Breakdown Structure Element (WBS Element)ABPSN
AUFNRAUFNRCHAR12
*
Order NumberALPHA
KOSTLKOSTLCHAR10
*
Cost CenterALPHA


PRCTRPRCTRCHAR10
*
Profit CenterALPHA
WERKSWERKS_DCHAR4
*
Plant
MATNRMATNRCHAR18
*
Material NumberMATN1
VBELNVBELN_VFCHAR10
*
Billing DocumentALPHA
VBEL2VBELN_VACHAR10
*
Sales DocumentALPHA
POSN2POSNR_VANUMC6
*
Sales Document Item
EBELNEBELNCHAR10
*
Purchasing Document NumberALPHA
EBELPEBELPNUMC5
*
Item Number of Purchasing Document
ABPERABPER_RFACCP6 Settlement period
ANBWAANBWACHAR3
*
Asset Transaction Type
ANLN1ANLN1CHAR12
*
Main Asset NumberALPHA
ANLN2ANLN2CHAR4
*
Asset SubnumberALPHA
AUGBLAUGBLCHAR10 Document Number of the Clearing DocumentALPHA
AUGDTAUGDTDATS8 Clearing Date
BEWARBEWARCHAR3
*
Consolidation Transaction Type
FILKDFILKDCHAR10 Account Number of the BranchALPHA
FKBERFKBERCHAR16
*
Functional Area
MWSKZMWSKZCHAR2
*
Tax on sales/purchases code
FWBASTXW_FWBASCHAR16 Tax base amount in document currency (TC)
HWBASTXW_HWBASCHAR16 Tax base amount in local currency
WMWSTTXW_WMWSTCHAR16 Tax amount in document currency (TC)
GBETRTXW_GBETRCHAR16 Hedged amount in foreign currency
LANDLLANDLCHAR3
*
Supplying Country
REBZTREBZTCHAR1 Follow-On Document Type
REBZJREBZJNUMC4 Fiscal Year of the Relevant Invoice (for Credit Memo)GJAHR
REBZGREBZGCHAR10 Number of the Invoice the Transaction Belongs toALPHA
REBZZREBZZNUMC3 Line Item in the Relevant Invoice
NEBTRTXW_NEBTRCHAR16 Net payment amount
NPLNRNPLNRCHAR12
*
Network Number for Account AssignmentALPHA
PSWSLPSWSLCUKY5
*
Update Currency for General Ledger Transaction Figures
PSWBTTXW_PSWBTCHAR16 Amount for updating in general ledger (position currency PC)
PARGBPARGBCHAR4
*
Trading partner's business area
PROJNPROJNCHAR16 Old: Project number : No longer used --> PS_POSNR
QSSKZQSSKZCHAR2
*
Withholding Tax Code
QSFBTTXW_QSFBTCHAR16 Withholding tax-exempt amount (in document currency)
QSSHBTXW_QSSHBCHAR16 Withholding tax base amount
QBSHBTXW_QBSHBCHAR16 Withholding tax amount (in document currency)
SAKNRSAKNRCHAR10
*
G/L Account NumberALPHA
SGTXTSGTXTCHAR50 Item Text


VALUTVALUTDATS8 Value date
TXGRPTXGRPNUMC3 Group Indicator for Tax Line Items
HBKIDHBKIDCHAR5
*
Short Key for a House Bank
MWSTSTXW_MWSTSCHAR16 Tax amount in local currency
MWST2TXW_MWST2CHAR16 Tax amount in second local currency
MWST3TXW_MWST3CHAR16 Tax amount in third local currency
RSTGRRSTGRCHAR3
*
Reason Code for Payments
UZAWEUZAWECHAR2
*
Payment Method Supplement
ZBD3TTXW_DZBD3TCHAR3 Net payment terms period
ZFBDTDZFBDTDATS8 Baseline Date for Due Date Calculation
ZTERMDZTERMCHAR4 Terms of Payment Key
TXBFWTXW_TXBFWCHAR16 Original tax base amount in document currency
TXBHWTXW_TXBHWCHAR16 Original tax base amount in local currency
TXBH2TXW_TXBH2CHAR16 Tax base/original tax base in second local currency
TXBH3TXW_TXBH3CHAR16 Tax base/original tax base in third local currency
KKBERKKBERCHAR4
*
Credit control area
STCEGSTCEGCHAR20 VAT Registration Number
EGBLDEGBLDCHAR3
*
Country of Destination for Delivery of Goods
EGLLDEGLLDCHAR3
*
Supplying Country for Delivery of Goods
XEGDRXEGDRCHAR1 Indicator: Triangular deal within the EU ?
FKBER_LONGFKBERCHAR16
*
Functional Area
VERTTRANTYPCHAR1 Contract Type
VERTNRANLCHAR13 Contract NumberALPHA
VBEWASBEWARTCHAR4
*
Flow Type
IMKEYIMKEYCHAR8 Internal Key for Real Estate ObjectIMKEY
INTRENOVVINTRENOCHAR13 Internal Real Estate Master Data Code
DABRZDABRBEZDATS8 Reference Date for Settlement
BSTATBSTAT_DCHAR1 Document Status
LEDGERFAGL_RLDNRCHAR2
*
Ledger in General Ledger AccountingALPHA
MWARTMWARTCHAR1 Tax Type
XBILKXBILKCHAR1 Indicator: Account is a balance sheet account?
GVTYPGVTYPCHAR2 P&L statement account type
NAVHWTXW_NAVHWCHAR16 Non-Deductible Input Tax (in Local Currency)
KSTRGKSTRGCHAR12
*
Cost Object
ALTKTBILKT_SKA1CHAR10
*
Group account numberALPHA
LOKKTALTKT_SKB1CHAR10
*
Alternative account number in company codeALPHA
ZLSCHDZLSCHCHAR1
*
Payment Method
BUZIDBUZIDCHAR1 Identification of the Line Item
AUGCPAUGCPDATS8 Clearing Entry Date



Key field
Non-key field