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