SAP ABAP Table TXW_FI_OP (FI open item)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷
CA-GTF-DRT (Application Component) Data Retention Tool
⤷
FTW1 (Package) Data Retention Tool

⤷

⤷

Basic Data
Table Category | INTTAB | Structure |
Structure | TXW_FI_OP |
![]() |
Short Description | FI open item |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | ![]() |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
3 | ![]() |
KOART | KOART | CHAR | 1 | 0 | Account type | ||
4 | ![]() |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
5 | ![]() |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
6 | ![]() |
UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * | |
7 | ![]() |
AUGDT | DATUM | DATS | 8 | 0 | Clearing Date | ||
8 | ![]() |
AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
9 | ![]() |
DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
10 | ![]() |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
11 | ![]() |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
12 | ![]() |
BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
13 | ![]() |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
14 | ![]() |
BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
15 | ![]() |
CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
16 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
17 | ![]() |
XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
18 | ![]() |
BLART | BLART | CHAR | 2 | 0 | Document type | * | |
19 | ![]() |
MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
20 | ![]() |
BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
21 | ![]() |
SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
22 | ![]() |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
23 | ![]() |
MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
24 | ![]() |
TXW_DMBTR | CHAR16 | CHAR | 16 | 0 | Amount in Local Currency | ||
25 | ![]() |
TXW_WRBTR | CHAR16 | CHAR | 16 | 0 | Amount in document currency (TC) | ||
26 | ![]() |
TXW_MWSTS | CHAR16 | CHAR | 16 | 0 | Tax amount in local currency | ||
27 | ![]() |
TXW_WMWST | CHAR16 | CHAR | 16 | 0 | Tax amount in document currency (TC) | ||
28 | ![]() |
SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
29 | ![]() |
AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
30 | ![]() |
EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
31 | ![]() |
EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
32 | ![]() |
SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | * | |
33 | ![]() |
HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
34 | ![]() |
FILKD | MAXKK | CHAR | 10 | 0 | Account Number of the Branch | ||
35 | ![]() |
DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
36 | ![]() |
DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
37 | ![]() |
TXW_DZBD1T | CHAR3 | CHAR | 3 | 0 | Cash discount days 1 | ||
38 | ![]() |
TXW_DZBD2T | CHAR3 | CHAR | 3 | 0 | Cash discount days 2 | ||
39 | ![]() |
TXW_DZBD3T | CHAR3 | CHAR | 3 | 0 | Net payment terms period | ||
40 | ![]() |
TXW_DZBD1P | CHAR6 | CHAR | 6 | 0 | Cash discount percentage 1 | ||
41 | ![]() |
TXW_DZBD2P | CHAR6 | CHAR | 6 | 0 | Cash Discount Percentage 2 | ||
42 | ![]() |
DZBFIX | ZBFIX | CHAR | 1 | 0 | Fixed Payment Terms | ||
43 | ![]() |
TXW_SKNTO | CHAR16 | CHAR | 16 | 0 | Cash discount amount in local currency | ||
44 | ![]() |
TXW_WSKTO | CHAR16 | CHAR | 16 | 0 | Cash discount amount in document currency | ||
45 | ![]() |
DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
46 | ![]() |
HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
47 | ![]() |
REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
48 | ![]() |
REBZJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
49 | ![]() |
REBZZ | BUZEI | NUMC | 3 | 0 | Line Item in the Relevant Invoice | ||
50 | ![]() |
DZOLLT | ZOLLT | CHAR | 8 | 0 | Customs Tariff Number | ||
51 | ![]() |
DZOLLD | DATUM | DATS | 8 | 0 | Customs Date | ||
52 | ![]() |
LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | * | |
53 | ![]() |
XNETB | XFELD | CHAR | 1 | 0 | Indicator: Document posted net ? | ||
54 | ![]() |
XANET | XFELD | CHAR | 1 | 0 | Indicator: Down Payment in Net Procedure? | ||
55 | ![]() |
XCPDD | XFELD | CHAR | 1 | 0 | Indicator: Address and Bank Data Set Individually | ||
56 | ![]() |
XESRD | XFELD | CHAR | 1 | 0 | Indicator: Is any ISR data set in the document ? | ||
57 | ![]() |
XZAHL | XFELD | CHAR | 1 | 0 | Indicator: Is Posting Key Used in a Payment Transaction? | ||
58 | ![]() |
MWSKX | MWSKZ | CHAR | 2 | 0 | Tax Code for Distribution | * | |
59 | ![]() |
TXW_DMBTX | CHAR16 | CHAR | 16 | 0 | Amount in Local Currency for Tax Distribution | ||
60 | ![]() |
TXW_WRBTX | CHAR16 | CHAR | 16 | 0 | Amount in foreign currency for tax breakdown | ||
61 | ![]() |
MWSKX | MWSKZ | CHAR | 2 | 0 | Tax Code for Distribution | * | |
62 | ![]() |
TXW_DMBTX | CHAR16 | CHAR | 16 | 0 | Amount in Local Currency for Tax Distribution | ||
63 | ![]() |
TXW_WRBTX | CHAR16 | CHAR | 16 | 0 | Amount in foreign currency for tax breakdown | ||
64 | ![]() |
MWSKX | MWSKZ | CHAR | 2 | 0 | Tax Code for Distribution | * | |
65 | ![]() |
TXW_DMBTX | CHAR16 | CHAR | 16 | 0 | Amount in Local Currency for Tax Distribution | ||
66 | ![]() |
TXW_WRBTX | CHAR16 | CHAR | 16 | 0 | Amount in foreign currency for tax breakdown | ||
67 | ![]() |
QSSKZ | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code | * | |
68 | ![]() |
TXW_QSSHB | CHAR16 | CHAR | 16 | 0 | Withholding tax base amount | ||
69 | ![]() |
TXW_QBSHB | CHAR16 | CHAR | 16 | 0 | Withholding tax amount (in document currency) | ||
70 | ![]() |
RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
71 | ![]() |
REBZT | REBZT | CHAR | 1 | 0 | Follow-On Document Type | ||
72 | ![]() |
STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
73 | ![]() |
EGBLD | LAND1 | CHAR | 3 | 0 | Country of Destination for Delivery of Goods | * | |
74 | ![]() |
EGLLD | LAND1 | CHAR | 3 | 0 | Supplying Country for Delivery of Goods | * | |
75 | ![]() |
QSZNR | CHAR10 | CHAR | 10 | 0 | Certificate Number of the Withholding Tax Exemption | ||
76 | ![]() |
TXW_QSFBT | CHAR16 | CHAR | 16 | 0 | Withholding tax-exempt amount (in document currency) | ||
77 | ![]() |
PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
78 | ![]() |
XEGDR | XFELD | CHAR | 1 | 0 | Indicator: Triangular deal within the EU ? | ||
79 | ![]() |
TXW_DMBE2 | CHAR16 | CHAR | 16 | 0 | Amount in second local currency (LC2) | ||
80 | ![]() |
TXW_DMBE3 | CHAR16 | CHAR | 16 | 0 | Amount in third local currency (LC3) | ||
81 | ![]() |
TXW_DMB2X | CHAR16 | CHAR | 16 | 0 | Amount in Second Local Currency for Tax Breakdown | ||
82 | ![]() |
TXW_DMB2X | CHAR16 | CHAR | 16 | 0 | Amount in Second Local Currency for Tax Breakdown | ||
83 | ![]() |
TXW_DMB2X | CHAR16 | CHAR | 16 | 0 | Amount in Second Local Currency for Tax Breakdown | ||
84 | ![]() |
TXW_DMB3X | CHAR16 | CHAR | 16 | 0 | Amount in Third Local Currency for Tax Breakdown | ||
85 | ![]() |
TXW_DMB3X | CHAR16 | CHAR | 16 | 0 | Amount in Third Local Currency for Tax Breakdown | ||
86 | ![]() |
TXW_DMB3X | CHAR16 | CHAR | 16 | 0 | Amount in Third Local Currency for Tax Breakdown | ||
87 | ![]() |
TXW_MWST2 | CHAR16 | CHAR | 16 | 0 | Tax amount in second local currency | ||
88 | ![]() |
TXW_MWST3 | CHAR16 | CHAR | 16 | 0 | Tax amount in third local currency | ||
89 | ![]() |
TXW_SKNT2 | CHAR16 | CHAR | 16 | 0 | Cash discount amount in second local currency (LC2) | ||
90 | ![]() |
TXW_SKNT3 | CHAR16 | CHAR | 16 | 0 | Cash discount amount in third local currency (LC3) | ||
91 | ![]() |
KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
92 | ![]() |
EMPFB | MAXKK | CHAR | 10 | 0 | Payee/Payer | ||
93 | ![]() |
PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
94 | ![]() |
KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
95 | ![]() |
PYCUR | WAERS | CUKY | 5 | 0 | Currency for Automatic Payment | * | |
96 | ![]() |
TXW_PYAMT | CHAR16 | CHAR | 16 | 0 | Amount in Payment Currency | ||
97 | ![]() |
SECCO | SECCO | CHAR | 4 | 0 | Section Code | * | |
98 | ![]() |
FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
99 | ![]() |
VBELN_VF | VBELN | CHAR | 10 | 0 | Billing document | * | |
100 | ![]() |
VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
101 | ![]() |
POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
102 | ![]() |
VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
103 | ![]() |
UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 470 |