SAP ABAP Table TXW_S_BSEG (Retrieve BSEG from archive)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ CA-GTF-DRT (Application Component) Data Retention Tool
⤷ FTW1 (Package) Data Retention Tool
⤷ CA-GTF-DRT (Application Component) Data Retention Tool
⤷ FTW1 (Package) Data Retention Tool
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | TXW_S_BSEG | Table Relationship Diagram |
Short Description | Retrieve BSEG from archive |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | L | Table for storing temporary data, delivered empty |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | TXW_MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | TXW_BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
3 | TXW_BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
4 | TXW_GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
5 | TXW_BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
6 | TXW_XNEGP | XNEGP | XFELD | CHAR | 1 | 0 | Indicator: Negative posting | ||
7 | .INCLUDE | 0 | 0 | FI Document item | |||||
8 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
9 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
10 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
11 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
12 | MONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
13 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
14 | BSCHL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
15 | KOART | KOART | KOART | CHAR | 1 | 0 | Account type | ||
16 | UMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * | |
17 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
18 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
19 | VBUND | TXW_VBUND | RCOMP | CHAR | 6 | 0 | Trading Partner | * | |
20 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
21 | WRBTR | TXW_WRBTR | CHAR16 | CHAR | 16 | 0 | Amount in document currency (TC) | ||
22 | DMBTR | TXW_DMBTR | CHAR16 | CHAR | 16 | 0 | Amount in Local Currency | ||
23 | DMBE2 | TXW_DMBE2 | CHAR16 | CHAR | 16 | 0 | Amount in second local currency (LC2) | ||
24 | DMBE3 | TXW_DMBE3 | CHAR16 | CHAR | 16 | 0 | Amount in third local currency (LC3) | ||
25 | WSKTO | TXW_WSKTO | CHAR16 | CHAR | 16 | 0 | Cash discount amount in document currency | ||
26 | SKNTO | TXW_SKNTO | CHAR16 | CHAR | 16 | 0 | Cash discount amount in local currency | ||
27 | SKNT2 | TXW_SKNT2 | CHAR16 | CHAR | 16 | 0 | Cash discount amount in second local currency (LC2) | ||
28 | SKNT3 | TXW_SKNT3 | CHAR16 | CHAR | 16 | 0 | Cash discount amount in third local currency (LC3) | ||
29 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
30 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
31 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
32 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
33 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
34 | MENGE | TXW_QUANT | CHAR16 | CHAR | 16 | 0 | Total quantity | ||
35 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
36 | PROJK | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
37 | WBS_POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
38 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
39 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
40 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
41 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
42 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
43 | VBELN | VBELN_VF | VBELN | CHAR | 10 | 0 | Billing document | * | |
44 | VBEL2 | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
45 | POSN2 | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
46 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
47 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
48 | ABPER | ABPER_RF | BUPER | ACCP | 6 | 0 | Settlement period | ||
49 | ANBWA | ANBWA | BWASL | CHAR | 3 | 0 | Asset Transaction Type | * | |
50 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
51 | ANLN2 | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
52 | AUGBL | AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
53 | AUGDT | AUGDT | DATUM | DATS | 8 | 0 | Clearing Date | ||
54 | BEWAR | BEWAR | RMVCT | CHAR | 3 | 0 | Consolidation Transaction Type | * | |
55 | FILKD | FILKD | MAXKK | CHAR | 10 | 0 | Account Number of the Branch | ||
56 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
57 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
58 | FWBAS | TXW_FWBAS | CHAR16 | CHAR | 16 | 0 | Tax base amount in document currency (TC) | ||
59 | HWBAS | TXW_HWBAS | CHAR16 | CHAR | 16 | 0 | Tax base amount in local currency | ||
60 | WMWST | TXW_WMWST | CHAR16 | CHAR | 16 | 0 | Tax amount in document currency (TC) | ||
61 | GBETR | TXW_GBETR | CHAR16 | CHAR | 16 | 0 | Hedged amount in foreign currency | ||
62 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | * | |
63 | REBZT | REBZT | REBZT | CHAR | 1 | 0 | Follow-On Document Type | ||
64 | REBZJ | REBZJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
65 | REBZG | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
66 | REBZZ | REBZZ | BUZEI | NUMC | 3 | 0 | Line Item in the Relevant Invoice | ||
67 | NEBTR | TXW_NEBTR | CHAR16 | CHAR | 16 | 0 | Net payment amount | ||
68 | NPLNR | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
69 | PSWSL | PSWSL | WAERS | CUKY | 5 | 0 | Update Currency for General Ledger Transaction Figures | * | |
70 | PSWBT | TXW_PSWBT | CHAR16 | CHAR | 16 | 0 | Amount for updating in general ledger (position currency PC) | ||
71 | PARGB | PARGB | GSBER | CHAR | 4 | 0 | Trading partner's business area | * | |
72 | PROJN | PROJN | PROJN | CHAR | 16 | 0 | Old: Project number : No longer used --> PS_POSNR | ||
73 | QSSKZ | QSSKZ | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code | * | |
74 | QSFBT | TXW_QSFBT | CHAR16 | CHAR | 16 | 0 | Withholding tax-exempt amount (in document currency) | ||
75 | QSSHB | TXW_QSSHB | CHAR16 | CHAR | 16 | 0 | Withholding tax base amount | ||
76 | QBSHB | TXW_QBSHB | CHAR16 | CHAR | 16 | 0 | Withholding tax amount (in document currency) | ||
77 | SAKNR | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
78 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
79 | VALUT | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
80 | TXGRP | TXGRP | NUM03 | NUMC | 3 | 0 | Group Indicator for Tax Line Items | ||
81 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
82 | MWSTS | TXW_MWSTS | CHAR16 | CHAR | 16 | 0 | Tax amount in local currency | ||
83 | MWST2 | TXW_MWST2 | CHAR16 | CHAR | 16 | 0 | Tax amount in second local currency | ||
84 | MWST3 | TXW_MWST3 | CHAR16 | CHAR | 16 | 0 | Tax amount in third local currency | ||
85 | RSTGR | RSTGR | RSTGR | CHAR | 3 | 0 | Reason Code for Payments | * | |
86 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * | |
87 | ZBD3T | TXW_DZBD3T | CHAR3 | CHAR | 3 | 0 | Net payment terms period | ||
88 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
89 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
90 | TXBFW | TXW_TXBFW | CHAR16 | CHAR | 16 | 0 | Original tax base amount in document currency | ||
91 | TXBHW | TXW_TXBHW | CHAR16 | CHAR | 16 | 0 | Original tax base amount in local currency | ||
92 | TXBH2 | TXW_TXBH2 | CHAR16 | CHAR | 16 | 0 | Tax base/original tax base in second local currency | ||
93 | TXBH3 | TXW_TXBH3 | CHAR16 | CHAR | 16 | 0 | Tax base/original tax base in third local currency | ||
94 | KKBER | KKBER | KKBER | CHAR | 4 | 0 | Credit control area | * | |
95 | .INCLUDE | 0 | 0 | ||||||
96 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
97 | EGBLD | EGBLD | LAND1 | CHAR | 3 | 0 | Country of Destination for Delivery of Goods | * | |
98 | EGLLD | EGLLD | LAND1 | CHAR | 3 | 0 | Supplying Country for Delivery of Goods | * | |
99 | XEGDR | XEGDR | XFELD | CHAR | 1 | 0 | Indicator: Triangular deal within the EU ? | ||
100 | FKBER_LONG | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
101 | VERTT | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
102 | VERTN | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
103 | VBEWA | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
104 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
105 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
106 | DABRZ | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
107 | BSTAT | BSTAT_D | BSTAT | CHAR | 1 | 0 | Document Status | ||
108 | LEDGER | FAGL_RLDNR | RLDNR | CHAR | 2 | 0 | Ledger in General Ledger Accounting | * | |
109 | MWART | MWART | MWART | CHAR | 1 | 0 | Tax Type | ||
110 | XBILK | XBILK | XFELD | CHAR | 1 | 0 | Indicator: Account is a balance sheet account? | ||
111 | GVTYP | GVTYP | CHAR2 | CHAR | 2 | 0 | P&L statement account type | ||
112 | NAVHW | TXW_NAVHW | CHAR16 | CHAR | 16 | 0 | Non-Deductible Input Tax (in Local Currency) | ||
113 | KSTRG | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | * | |
114 | ALTKT | BILKT_SKA1 | SAKNR | CHAR | 10 | 0 | Group Account Number | * | |
115 | LOKKT | ALTKT_SKB1 | SAKNR | CHAR | 10 | 0 | Alternative Account Number in Company Code | * | |
116 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
117 | BUZID | BUZID | CHAR1 | CHAR | 1 | 0 | Identification of the Line Item | ||
118 | AUGCP | AUGCP | DATUM | DATS | 8 | 0 | Clearing Entry Date | ||
119 | .INCLUDE | 0 | 0 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |