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