SAP table TXW_FI_POS (FI Document item)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
MONAT Fiscal period NUMC 2 0 MONAT
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BSCHL Posting Key CHAR 2 0 BSCHL
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
UMSKZ Special G/L Indicator CHAR 1 0 UMSKZ
HKONT General Ledger Account CHAR 10 0 HKONT
GSBER Business Area CHAR 4 0 GSBER
VBUND Trading Partner CHAR 6 0 TXW_VBUND
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
WRBTR Amount in document currency (TC) CHAR 31 0 TXW_WRBTR
DMBTR Amount in Local Currency CHAR 31 0 TXW_DMBTR
DMBE2 Amount in second local currency (LC2) CHAR 31 0 TXW_DMBE2
DMBE3 Amount in third local currency (LC3) CHAR 31 0 TXW_DMBE3
WSKTO Cash discount amount in document currency CHAR 31 0 TXW_WSKTO
SKNTO Cash discount amount in local currency CHAR 31 0 TXW_SKNTO
SKNT2 Cash discount amount in second local currency (LC2) CHAR 31 0 TXW_SKNT2
SKNT3 Cash discount amount in third local currency (LC3) CHAR 31 0 TXW_SKNT3
ZUONR Assignment number CHAR 18 0 DZUONR
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
KUNNR Customer Number CHAR 10 0 KUNNR
TXJCD Tax Jurisdiction CHAR 15 0 TXJCD
MEINS Base Unit of Measure UNIT 3 0 MEINS
MENGE Total quantity CHAR 16 0 TXW_QUANT
KOKRS Controlling Area CHAR 4 0 KOKRS
PROJK Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
WBS_POSID Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
AUFNR Order Number CHAR 12 0 AUFNR
KOSTL Cost Center CHAR 10 0 KOSTL
PRCTR Profit Center CHAR 10 0 PRCTR
WERKS Plant CHAR 4 0 WERKS_D
MATNR Material Number CHAR 40 0 MATNR
VBELN Billing Document CHAR 10 0 VBELN_VF
VBEL2 Sales Document CHAR 10 0 VBELN_VA
POSN2 Sales Document Item NUMC 6 0 POSNR_VA
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
ABPER Settlement Period ACCP 6 0 ABPER_RF
ANBWA Asset Transaction Type CHAR 3 0 ANBWA
ANLN1 Main Asset Number CHAR 12 0 ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLN2
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
AUGDT Clearing Date DATS 8 0 AUGDT
BEWAR Consolidation Transaction Type CHAR 3 0 BEWAR
FILKD Account Number of the Branch CHAR 10 0 FILKD
FKBER Functional Area CHAR 16 0 FKBER
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
FWBAS Tax base amount in document currency (TC) CHAR 31 0 TXW_FWBAS
HWBAS Tax base amount in local currency CHAR 31 0 TXW_HWBAS
WMWST Tax amount in document currency (TC) CHAR 31 0 TXW_WMWST
GBETR Hedged amount in foreign currency CHAR 31 0 TXW_GBETR
LANDL Supplying Country/Region CHAR 3 0 LANDL
REBZT Follow-On Document Type CHAR 1 0 REBZT
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) NUMC 4 0 REBZJ
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
REBZZ Line Item in the Relevant Invoice NUMC 3 0 REBZZ
NEBTR Net payment amount CHAR 31 0 TXW_NEBTR
NPLNR Network Number for Account Assignment CHAR 12 0 NPLNR
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 PSWSL
PSWBT Amount for updating in general ledger (position currency PC) CHAR 31 0 TXW_PSWBT
PARGB Trading partner's business area CHAR 4 0 PARGB
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
QSSKZ Withholding Tax Code CHAR 2 0 QSSKZ
QSFBT Withholding tax-exempt amount (in document currency) CHAR 31 0 TXW_QSFBT
QSSHB Withholding tax base amount CHAR 31 0 TXW_QSSHB
QBSHB Withholding tax amount (in document currency) CHAR 31 0 TXW_QBSHB
SAKNR G/L Account Number CHAR 10 0 SAKNR
SGTXT Item Text CHAR 50 0 SGTXT
VALUT Value date DATS 8 0 VALUT
TXGRP Group Indicator for Tax Line Items NUMC 3 0 TXGRP
HBKID Short Key for a House Bank CHAR 5 0 HBKID
MWSTS Tax amount in local currency CHAR 31 0 TXW_MWSTS
MWST2 Tax amount in second local currency CHAR 31 0 TXW_MWST2
MWST3 Tax amount in third local currency CHAR 31 0 TXW_MWST3
RSTGR Reason Code for Payments CHAR 3 0 RSTGR
UZAWE Payment method supplement CHAR 2 0 UZAWE
ZBD3T Net payment terms period CHAR 3 0 TXW_DZBD3T
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
ZTERM Terms of payment key CHAR 4 0 DZTERM
TXBFW Original tax base amount in document currency CHAR 31 0 TXW_TXBFW
TXBHW Original tax base amount in local currency CHAR 31 0 TXW_TXBHW
TXBH2 Tax base/original tax base in second local currency CHAR 31 0 TXW_TXBH2
TXBH3 Tax base/original tax base in third local currency CHAR 31 0 TXW_TXBH3
KKBER Credit control area CHAR 4 0 KKBER
STCEG VAT Registration Number CHAR 20 0 STCEG
EGBLD Country/Region of Destination for Delivery of Goods CHAR 3 0 EGBLD
EGLLD Supplying Country/Region for Delivery of Goods CHAR 3 0 EGLLD
XEGDR Indicator: Triangular Deal Within the EU CHAR 1 0 XEGDR
FKBER_LONG Functional Area CHAR 16 0 FKBER
VERTT Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
VERTN Contract Number CHAR 13 0 RANL
VBEWA Flow Type CHAR 4 0 SBEWART
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
INTRENO Internal Real Estate Master Data Code CHAR 13 0 VVINTRENO
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
BSTAT Document Status CHAR 1 0 BSTAT_D
LEDGER Ledger in General Ledger Accounting CHAR 2 0 FAGL_RLDNR
MWART Tax Type CHAR 1 0 MWART
A Output tax
V Input tax
XBILK Indicator: Account is a balance sheet account? CHAR 1 0 XBILK
GVTYP P&L statement account type CHAR 2 0 GVTYP
NAVHW Non-Deductible Input Tax (in Local Currency) CHAR 31 0 TXW_NAVHW
KSTRG Cost Object CHAR 12 0 KSTRG
ALTKT Group Account Number CHAR 10 0 BILKT_SKA1
LOKKT Alternative Account Number in Company Code CHAR 10 0 ALTKT_SKB1
ZLSCH Payment Method CHAR 1 0 DZLSCH
BUZID Identification of the Line Item CHAR 1 0 BUZID
AUGCP Clearing Entry Date DATS 8 0 AUGCP
XCPDD Indicator: Address and Bank Data Set Individually CHAR 1 0 XCPDD
ACC_NUM Account number of Customer or Vendor CHAR 10 0 TXW_ACC_NUM
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
GACC_NUM Group ledger or group account number CHAR 10 0 TXW_GACC_NUM
TXT20 Account short text CHAR 20 0 TXW_TXT20
TXT50 Text CHAR 50 0 TXW_TXT50
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
XBLNR Reference Document Number CHAR 16 0 XBLNR1
GJAHR_CALC Fiscal Year (calculated, GL view) NUMC 4 0 TXW_GJAHR_CALC
MONAT_CALC Fiscal Period (calculated, GL view) NUMC 2 0 TXW_MONAT_CALC
GLVOR Business Transaction CHAR 4 0 GLVOR