SAP Table TXW_S_BSEG - Retrieve BSEG from archive

Field Key Data Element Type Offset Leng Decimals Check Table Text
TXW_MANDT X MANDT CLNT 0 3 0 T000 Client
TXW_BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
TXW_BELNR X BELNR_D CHAR 7 10 0 Accounting Document Number
TXW_GJAHR X GJAHR NUMC 17 4 0 Fiscal Year
TXW_BUZEI X BUZEI NUMC 21 3 0 Number of Line Item Within Accounting Document
TXW_XNEGP XNEGP CHAR 24 1 0 Indicator: Negative posting
MANDT MANDT CLNT 25 3 0 T000 Client
BUKRS BUKRS CHAR 28 4 0 T001 Company Code
BELNR BELNR_D CHAR 32 10 0 Accounting Document Number
GJAHR GJAHR NUMC 42 4 0 Fiscal Year
MONAT MONAT NUMC 46 2 0 Fiscal Period
BUZEI BUZEI NUMC 48 3 0 Number of Line Item Within Accounting Document
BSCHL BSCHL CHAR 51 2 0 TBSL Posting Key
KOART KOART CHAR 53 1 0 Account Type
UMSKZ UMSKZ CHAR 54 1 0 Special G/L Indicator
HKONT HKONT CHAR 55 10 0 General Ledger Account
GSBER GSBER CHAR 65 4 0 TGSB Business Area
VBUND TXW_VBUND CHAR 69 6 0 T880 Trading Partner
SHKZG SHKZG CHAR 75 1 0 Debit/Credit Indicator
WRBTR TXW_WRBTR CHAR 76 16 0 Amount in document currency (TC)
DMBTR TXW_DMBTR CHAR 92 16 0 Amount in Local Currency
DMBE2 TXW_DMBE2 CHAR 108 16 0 Amount in second local currency (LC2)
DMBE3 TXW_DMBE3 CHAR 124 16 0 Amount in third local currency (LC3)
WSKTO TXW_WSKTO CHAR 140 16 0 Cash discount amount in document currency
SKNTO TXW_SKNTO CHAR 156 16 0 Cash discount amount in local currency
SKNT2 TXW_SKNT2 CHAR 172 16 0 Cash discount amount in second local currency (LC2)
SKNT3 TXW_SKNT3 CHAR 188 16 0 Cash discount amount in third local currency (LC3)
ZUONR DZUONR CHAR 204 18 0 Assignment Number
LIFNR LIFNR CHAR 222 10 0 LFA1 Account Number of Vendor or Creditor
KUNNR KUNNR CHAR 232 10 0 KNA1 Customer Number
TXJCD TXJCD CHAR 242 15 0 TTXJ Tax Jurisdiction
MEINS MEINS UNIT 257 3 0 T006 Base Unit of Measure
MENGE TXW_QUANT CHAR 260 16 0 Total quantity
KOKRS KOKRS CHAR 276 4 0 TKA01 Controlling Area
PROJK PS_PSP_PNR NUMC 280 8 0 PRPS Work Breakdown Structure Element (WBS Element)
WBS_POSID PS_POSID CHAR 288 24 0 Work Breakdown Structure Element (WBS Element)
AUFNR AUFNR CHAR 312 12 0 AUFK Order Number
KOSTL KOSTL CHAR 324 10 0 Cost Center
PRCTR PRCTR CHAR 334 10 0 Profit Center
WERKS WERKS_D CHAR 344 4 0 T001W Plant
MATNR MATNR CHAR 348 18 0 MARA Material Number
VBELN VBELN_VF CHAR 366 10 0 Billing Document
VBEL2 VBELN_VA CHAR 376 10 0 Sales Document
POSN2 POSNR_VA NUMC 386 6 0 Sales Document Item
EBELN EBELN CHAR 392 10 0 EKKO Purchasing Document Number
EBELP EBELP NUMC 402 5 0 EKPO Item Number of Purchasing Document
ABPER ABPER_RF ACCP 407 6 0 Settlement Period
ANBWA ANBWA CHAR 413 3 0 TABW Asset Transaction Type
ANLN1 ANLN1 CHAR 416 12 0 ANLH Main Asset Number
ANLN2 ANLN2 CHAR 428 4 0 ANLA Asset Subnumber
AUGBL AUGBL CHAR 432 10 0 Document Number of the Clearing Document
AUGDT AUGDT DATS 442 8 0 Clearing Date
BEWAR BEWAR CHAR 450 3 0 T856 Consolidation Transaction Type
FILKD FILKD CHAR 453 10 0 Account Number of the Branch
FKBER FKBER CHAR 463 16 0 Functional Area
MWSKZ MWSKZ CHAR 479 2 0 Sales Tax Code
FWBAS TXW_FWBAS CHAR 481 16 0 Tax base amount in document currency (TC)
HWBAS TXW_HWBAS CHAR 497 16 0 Tax base amount in local currency
WMWST TXW_WMWST CHAR 513 16 0 Tax amount in document currency (TC)
GBETR TXW_GBETR CHAR 529 16 0 Hedged amount in foreign currency
LANDL LANDL CHAR 545 3 0 T005 Supplying Country
REBZT REBZT CHAR 548 1 0 Follow-On Document Type
REBZJ REBZJ NUMC 549 4 0 Fiscal Year of the Relevant Invoice (for Credit Memo)
REBZG REBZG CHAR 553 10 0 Number of the Invoice the Transaction Belongs to
REBZZ REBZZ NUMC 563 3 0 Line Item in the Relevant Invoice
NEBTR TXW_NEBTR CHAR 566 16 0 Net payment amount
NPLNR NPLNR CHAR 582 12 0 AUFK Network Number for Account Assignment
PSWSL PSWSL CUKY 594 5 0 TCURC Update Currency for General Ledger Transaction Figures
PSWBT TXW_PSWBT CHAR 599 16 0 Amount for updating in general ledger (position currency PC)
PARGB PARGB CHAR 615 4 0 TGSB Trading Partner's Business Area
PROJN PROJN CHAR 619 16 0 Old: Project number : No longer used --> PS_POSNR
QSSKZ QSSKZ CHAR 635 2 0 T059Q Withholding Tax Code
QSFBT TXW_QSFBT CHAR 637 16 0 Withholding tax-exempt amount (in document currency)
QSSHB TXW_QSSHB CHAR 653 16 0 Withholding tax base amount
QBSHB TXW_QBSHB CHAR 669 16 0 Withholding tax amount (in document currency)
SAKNR SAKNR CHAR 685 10 0 G/L Account Number
SGTXT SGTXT CHAR 695 50 0 Item Text
VALUT VALUT DATS 745 8 0 Value Date
TXGRP TXGRP NUMC 753 3 0 Group Indicator for Tax Line Items
HBKID HBKID CHAR 756 5 0 T012 Short Key for a House Bank
MWSTS TXW_MWSTS CHAR 761 16 0 Tax amount in local currency
MWST2 TXW_MWST2 CHAR 777 16 0 Tax amount in second local currency
MWST3 TXW_MWST3 CHAR 793 16 0 Tax amount in third local currency
RSTGR RSTGR CHAR 809 3 0 T053R Reason Code for Payments
UZAWE UZAWE CHAR 812 2 0 Payment Method Supplement
ZBD3T TXW_DZBD3T CHAR 814 3 0 Net payment terms period
ZFBDT DZFBDT DATS 817 8 0 Baseline Date for Due Date Calculation
ZTERM DZTERM CHAR 825 4 0 Terms of Payment Key
TXBFW TXW_TXBFW CHAR 829 16 0 Original tax base amount in document currency
TXBHW TXW_TXBHW CHAR 845 16 0 Original tax base amount in local currency
TXBH2 TXW_TXBH2 CHAR 861 16 0 Tax base/original tax base in second local currency
TXBH3 TXW_TXBH3 CHAR 877 16 0 Tax base/original tax base in third local currency
KKBER KKBER CHAR 893 4 0 T014 Credit Control Area
STCEG STCEG CHAR 897 20 0 VAT Registration Number
EGBLD EGBLD CHAR 917 3 0 T005 Country of Destination for Delivery of Goods
EGLLD EGLLD CHAR 920 3 0 T005 Supplying Country for Delivery of Goods
XEGDR XEGDR CHAR 923 1 0 Indicator: Triangular deal within the EU ?
FKBER_LONG FKBER CHAR 924 16 0 Functional Area
VERTT RANTYP CHAR 940 1 0 Contract Type
VERTN RANL CHAR 941 13 0 Contract Number
VBEWA SBEWART CHAR 954 4 0 TZB0A Flow Type
IMKEY IMKEY CHAR 958 8 0 Internal Key for Real Estate Object
INTRENO VVINTRENO CHAR 966 13 0 Internal Real Estate Master Data Code
DABRZ DABRBEZ DATS 979 8 0 Reference Date for Settlement
BSTAT BSTAT_D CHAR 987 1 0 Document Status
LEDGER FAGL_RLDNR CHAR 988 2 0 T881 Ledger in General Ledger Accounting
MWART MWART CHAR 990 1 0 Tax Type
XBILK XBILK CHAR 991 1 0 Indicator: Account Is a Balance Sheet Account?
GVTYP GVTYP CHAR 992 2 0 P&L Statement Account Type
NAVHW TXW_NAVHW CHAR 994 16 0 Non-Deductible Input Tax (in Local Currency)
KSTRG KSTRG CHAR 1010 12 0 CKPH Cost Object
ALTKT BILKT_SKA1 CHAR 1022 10 0 Group Account Number
LOKKT ALTKT_SKB1 CHAR 1032 10 0 Alternative Account Number in Company Code
ZLSCH DZLSCH CHAR 1042 1 0 T042E Payment Method

873125DART: Ledger can be selected if NewGl is active