TXW_FI_OP SAP (FI open item) Structure details

Dictionary Type: Structure
Description: FI open item




ABAP Code to SELECT data from TXW_FI_OP
Related tables to TXW_FI_OP
Access table TXW_FI_OP




Structure field list including key, data, relationships and ABAP select examples

TXW_FI_OP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "FI open item" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TXW_FI_OP TYPE TXW_FI_OP.

The TXW_FI_OP table consists of various fields, each holding specific information or linking keys about FI open item data available in SAP. These include BUKRS (Company Code), KOART (Account Type), LIFNR (Account Number of Vendor or Creditor), KUNNR (Customer Numbers).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TXW_FI_OP structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
KOARTAccount Type KOARTCHAR1KOART
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
AUGDTClearing Date AUGDTDATS8DATUM
AUGBLDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
ZUONRAssignment Number DZUONRCHAR18ZUONR
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BUDATPosting Date in the Document BUDATDATS8DATUM
BLDATDocument Date in Document BLDATDATS8DATUM
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
MONATFiscal Period MONATNUMC2MONAT
BSCHLPosting Key BSCHLCHAR2Assigned to domainBSCHL
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
DMBTRAmount in Local Currency TXW_DMBTRCHAR16CHAR16
WRBTRAmount in document currency (TC) TXW_WRBTRCHAR16CHAR16
MWSTSTax amount in local currency TXW_MWSTSCHAR16CHAR16
WMWSTTax amount in document currency (TC) TXW_WMWSTCHAR16CHAR16
SGTXTItem Text SGTXTCHAR50TEXT50
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
SAKNRG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZBD1TCash discount days 1 TXW_DZBD1TCHAR3CHAR3
ZBD2TCash discount days 2 TXW_DZBD2TCHAR3CHAR3
ZBD3TNet payment terms period TXW_DZBD3TCHAR3CHAR3
ZBD1PCash discount percentage 1 TXW_DZBD1PCHAR6CHAR6
ZBD2PCash Discount Percentage 2 TXW_DZBD2PCHAR6CHAR6
ZBFIXFixed Payment Terms DZBFIXCHAR1ZBFIX
SKNTOCash discount amount in local currency TXW_SKNTOCHAR16CHAR16
WSKTOCash discount amount in document currency TXW_WSKTOCHAR16CHAR16
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
ZOLLTCustoms Tariff Number DZOLLTCHAR8ZOLLT
ZOLLDCustoms Date DZOLLDDATS8DATUM
LANDLSupplying Country LANDLCHAR3Assigned to domainLAND1
XNETBIndicator: Document posted net ? XNETBCHAR1XFELD
XANETIndicator: Down payment in net procedure ? XANETCHAR1XFELD
XCPDDIndicator: Address and bank data set individually XCPDDCHAR1XFELD
XESRDIndicator: Is any ISR data set in the document ? XESRDCHAR1XFELD
XZAHLIndicator: Is the posting key used in a payment transaction? XZAHLCHAR1XFELD
MWSK1Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
DMBT1Amount in Local Currency for Tax Distribution TXW_DMBTXCHAR16CHAR16
WRBT1Amount in foreign currency for tax breakdown TXW_WRBTXCHAR16CHAR16
MWSK2Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
DMBT2Amount in Local Currency for Tax Distribution TXW_DMBTXCHAR16CHAR16
WRBT2Amount in foreign currency for tax breakdown TXW_WRBTXCHAR16CHAR16
MWSK3Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
DMBT3Amount in Local Currency for Tax Distribution TXW_DMBTXCHAR16CHAR16
WRBT3Amount in foreign currency for tax breakdown TXW_WRBTXCHAR16CHAR16
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
QSSHBWithholding tax base amount TXW_QSSHBCHAR16CHAR16
QBSHBWithholding tax amount (in document currency) TXW_QBSHBCHAR16CHAR16
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
REBZTFollow-On Document Type REBZTCHAR1REBZT
STCEGVAT Registration Number STCEGCHAR20STCEG
EGBLDCountry of Destination for Delivery of Goods EGBLDCHAR3Assigned to domainLAND1
EGLLDSupplying Country for Delivery of Goods EGLLDCHAR3Assigned to domainLAND1
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QSFBTWithholding tax-exempt amount (in document currency) TXW_QSFBTCHAR16CHAR16
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
XEGDRIndicator: Triangular deal within the EU ? XEGDRCHAR1XFELD
DMBE2Amount in second local currency (LC2) TXW_DMBE2CHAR16CHAR16
DMBE3Amount in third local currency (LC3) TXW_DMBE3CHAR16CHAR16
DMB21Amount in Second Local Currency for Tax Breakdown TXW_DMB2XCHAR16CHAR16
DMB22Amount in Second Local Currency for Tax Breakdown TXW_DMB2XCHAR16CHAR16
DMB23Amount in Second Local Currency for Tax Breakdown TXW_DMB2XCHAR16CHAR16
DMB31Amount in Third Local Currency for Tax Breakdown TXW_DMB3XCHAR16CHAR16
DMB32Amount in Third Local Currency for Tax Breakdown TXW_DMB3XCHAR16CHAR16
DMB33Amount in Third Local Currency for Tax Breakdown TXW_DMB3XCHAR16CHAR16
MWST2Tax amount in second local currency TXW_MWST2CHAR16CHAR16
MWST3Tax amount in third local currency TXW_MWST3CHAR16CHAR16
SKNT2Cash discount amount in second local currency (LC2) TXW_SKNT2CHAR16CHAR16
SKNT3Cash discount amount in third local currency (LC3) TXW_SKNT3CHAR16CHAR16
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
EMPFBPayee/Payer EMPFBCHAR10ALPHAMAXKK
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
KIDNOPayment Reference KIDNOCHAR30CHAR30
PYCURCurrency for Automatic Payment PYCURCUKY5Assigned to domainWAERS
PYAMTAmount in Payment Currency TXW_PYAMTCHAR16CHAR16
SECCOSection Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
VBELNBilling Document VBELN_VFCHAR10Assigned to domainALPHAVBELNVF
VBEL2Sales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
POSN2Sales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
VALUTValue date VALUTDATS8DATUM
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE

Key field Non-key field



How do I retrieve data from SAP structure TXW_FI_OP using ABAP code?

As TXW_FI_OP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TXW_FI_OP as there is no data to select.

How to access SAP table TXW_FI_OP

Within an ECC or HANA version of SAP you can also view further information about TXW_FI_OP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!