TXI_BSIK SAP (Accounting: Secondary Index for Vendors) Structure details

Dictionary Type: Structure
Description: Accounting: Secondary Index for Vendors




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




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

TXI_BSIK 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 "Accounting: Secondary Index for Vendors" 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_TXI_BSIK TYPE TXI_BSIK.

The TXI_BSIK table consists of various fields, each holding specific information or linking keys about Accounting: Secondary Index for Vendors data available in SAP. These include MANDT (Client), BUKRS (Company Code), LIFNR (Account Number of Vendor or Creditor), UMSKS (Special G/L Transaction Type).. 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 TXI_BSIK 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 BUKRSCHAR4LFB1BUKRSBUKC_T001
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
UMSKSSpecial G/L Transaction Type UMSKSCHAR1UMSKS
UMSKZSpecial G/L Indicator UMSKZCHAR1T074UUMSKZ
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 WAERSCUKY5TCURCWAERSFWS
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
BLARTDocument Type BLARTCHAR2T003BLARTBAR
MONATFiscal Period MONATNUMC2MONAT
BSCHLPosting Key BSCHLCHAR2TBSLBSCHL
ZUMSKTarget Special G/L Indicator DZUMSKCHAR1Assigned to domainUMSKZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
MWSKZTax on sales/purchases code MWSKZCHAR2T007AMWSKZ
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
MWSTSTax Amount in Local Currency MWSTSCURR13(2) WERT7
WMWSTTax amount in document currency WMWSTCURR13(2) WERT7
BDIFFValuation Difference BDIFFCURR13(2) WRTV7
BDIF2Valuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
SGTXTItem Text SGTXTCHAR50TEXT50
PROJNOld: Project number : No longer used --> PS_POSNR PROJNCHAR16PROJN
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
ANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
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
FKONTFinancial Budget Item FIPLSNUMC3FIPLS
FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZBD1TCash discount days 1 DZBD1TDEC3ZBDXT
ZBD2TCash discount days 2 DZBD2TDEC3ZBDXT
ZBD3TNet Payment Terms Period DZBD3TDEC3ZBDXT
ZBD1PCash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
ZBD2PCash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
SKFBTAmount Eligible for Cash Discount in Document Currency SKFBTCURR13(2) WERT7
SKNTOCash discount amount in local currency SKNTOCURR13(2) WERT7
WSKTOCash discount amount in document currency WSKTOCURR13(2) WERT7
ZLSCHPayment Method DZLSCHCHAR1T042ZZLSCH
ZLSPRPayment Block Key DZLSPRCHAR1T008ZAHLSSPE
ZBFIXFixed Payment Terms DZBFIXCHAR1ZBFIX
HBKIDShort Key for a House Bank HBKIDCHAR5T012HBKID
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
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
SAMNRInvoice List Number SAMNRNUMC8SAMNR
ZOLLTCustoms Tariff Number DZOLLTCHAR8ZOLLT
ZOLLDCustoms Date DZOLLDDATS8DATUM
LZBKZState Central Bank Indicator LZBKZCHAR3T015LLZBKZ
LANDLSupplying Country LANDLCHAR3T005LAND1
DIEKZService Indicator (Foreign Payment) DIEKZCHAR1DIEKZ
MANSPDunning block MANSPCHAR1T040SMANSP
MSCHLDunning key MSCHLCHAR1T040MSCHL
MADATLast dunned on MADATDATS8DATUM
MANSTDunning level MAHNS_DNUMC1MAHNS
MABERDunning Area MABERCHAR2Assigned to domainMABER
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 DMBTXCURR13(2) WRTV7
WRBT1Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
MWSK2Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
DMBT2Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
WRBT2Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
MWSK3Tax Code for Distribution MWSKXCHAR2Assigned to domainMWSKZ
DMBT3Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
WRBT3Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
QSSKZWithholding Tax Code QSSKZCHAR2T059QQSSKZ
QSSHBWithholding Tax Base Amount QSSHBCURR13(2) WERT7
QBSHBWithholding Tax Amount (in Document Currency) QBSHBCURR13(2) WERT7
BSTATDocument Status BSTAT_DCHAR1BSTAT
ANFBNDocument Number of the Bill of Exchange Payment Request ANFBNCHAR10ALPHABELNR
ANFBJFiscal Year of the Bill of Exchange Payment Request Document ANFBJNUMC4GJAHRGJAHR
ANFBUCompany Code in Which Bill of Exch.Payment Request Is Posted ANFBUCHAR4T001BUKRS
VBUNDCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
REBZTFollow-On Document Type REBZTCHAR1REBZT
STCEGVAT Registration Number STCEGCHAR20STCEG
EGBLDCountry of Destination for Delivery of Goods EGBLDCHAR3T005LAND1
EGLLDSupplying Country for Delivery of Goods EGLLDCHAR3T005LAND1
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QSFBTWithholding Tax-Exempt Amount (in Document Currency) QSFBTCURR13(2) WERT7
XINVEIndicator: Capital Goods Affected? XINVECHAR1XFELD
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
NPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
XEGDRIndicator: Triangular deal within the EU ? XEGDRCHAR1XFELD
DMBE2Amount in Second Local Currency DMBE2CURR13(2) WERT7
DMBE3Amount in Third Local Currency DMBE3CURR13(2) WERT7
DMB21Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB22Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB23Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB31Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
DMB32Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
DMB33Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
MWST2Tax Amount in Second Local Currency MWST2CURR13(2) WERT7
MWST3Tax Amount in Third Local Currency MWST3CURR13(2) WERT7
SKNT2Cash Discount Amount in Second Local Currency SKNT2CURR13(2) WERT7
SKNT3Cash Discount Amount in Third Local Currency SKNT3CURR13(2) WERT7
BDIF3Valuation Difference for the Third Local Currency BDIF3CURR13(2) WRTV7
XRAGLIndicator: Clearing was Reversed XRAGLCHAR1XFELD
RSTGRReason Code for Payments RSTGRCHAR3T053RRSTGR
UZAWEPayment Method Supplement UZAWECHAR2T042FUZAWE
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
LNRANSequence number of asset line items in fiscal year LNRANNUMC5ANEKLNRAN
XSTOVIndicator: Document is flagged for reversal XSTOVCHAR1XFELD
KZBTROriginal Reduction Amount in Local Currency KZBTR_FICURR13(2) WERT7
XREF1Business partner reference key XREF1CHAR12CHAR12
XREF2Business partner reference key XREF2CHAR12CHAR12
XARCHIndicator: Document already archived ? XARCHCHAR1XFELD
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSLCUKY5TCURCWAERS
PSWBTAmount for Updating in General Ledger PSWBTCURR13(2) WERT7
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
DABRZReference Date for Settlement DABRBEZDATS8DDAT
XNEGPIndicator: Negative posting XNEGPCHAR1XFELD
EMPFBPayee/Payer EMPFBCHAR10ALPHAMAXKK
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
XREF3Reference key for line item XREF3CHAR20CHAR20
DTWS1Instruction key 1 DTAT16NUMC2Assigned to domainDTWSX
DTWS2Instruction key 2 DTAT17NUMC2Assigned to domainDTWSX
DTWS3Instruction key 3 DTAT18NUMC2Assigned to domainDTWSX
DTWS4Instruction key 4 DTAT19NUMC2Assigned to domainDTWSX
XPYPRIndicator: Items from Payment Program Blocked XPYPRCHAR1XFELD
KIDNOPayment Reference KIDNOCHAR30CHAR30
PYCURCurrency for Automatic Payment PYCURCUKY5TCURCWAERS
PYAMTAmount in Payment Currency PYAMTCURR13(2) WERT7
BUPLABusiness Place BUPLACHAR4J_1BBRANCHJ_1BBRANCH
SECCOSection Code SECCOCHAR4SECCODESECCOSECCO_ABA
PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFFCURR13(2) WRTV7
PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2CURR13(2) WRTV7
PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3CURR13(2) WRTV7
PENLC1Penalty charge amount in first local currency PENALTY1CURR13(2) WERT13
PENLC2Penalty charge amount in second local currency PENALTY2CURR13(2) WERT13
PENLC3Penalty Charge Amount in Third Local Currency PENALTY3CURR13(2) WERT13
PENFCPenalty charge amount in document currency PENALTYCURR13(2) WERT13
PENDAYSNumber of days for penalty charge calculation PDAYSINT410INT4
PENRCReason for late payment PENRCCHAR2CHAR2FM_PENRC
VERTTContract Type RANTYPCHAR1RANTYP
VERTNContract Number RANLCHAR13ALPHARANLRAN
VBEWAFlow Type SBEWARTCHAR4Assigned to domainSBEWART
KBLNRDocument Number for Earmarked Funds KBLNR_FICHAR10Assigned to domainALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3Assigned to domainKBLPOSKBP
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
GMVKZItem is in Execution FM_GMVKZCHAR1FM_GMVKZ
SRTYPEType of Additional Receivable FM_SRTYPECHAR2FM_SRTYPE
LOTKZLot Number for Requests PSO_LOTKZCHAR10ALPHALOTKZLOT
ZINKZExempted from interest calculation DZINKZCHAR2ZINKZ
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
PPRCTPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
BUZIDIdentification of the Line Item BUZIDCHAR1CHAR1
AUGGJFiscal Year of Clearing Document AUGGJNUMC4GJAHRGJAHR
HKTIDID for account details HKTIDCHAR5Assigned to domainHKTID
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
.INCLU--AP 0
KONTTAccount Assignment Category for Industry Solution KONTT_FICHAR2KONTT_FI
KONTLAcct assignment string for industry-specific acct assignmnts KONTL_FICHAR50CHAR50
UEBGDATTransfer date of an item to legal dunning proceeding UEBGDATDATS8DATUM
.INCLU--AP 0
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
BTYPEPayroll Type JV_BILINDCHAR2Assigned to domainALPHAJV_BILIND
.INCLU--AP 0
PROPMANOMandate, Mandate-Opening Contract REHORECNNRMCHAR13ALPHARECNNRREHORECNNRM
DMBTR_CYCUKY for SYST SYCUKYCUKY5SYCUKY
WRBTR_CYCUKY for SYST SYCUKYCUKY5SYCUKY
MWSTS_CYCUKY for SYST SYCUKYCUKY5SYCUKY
WMWST_CYCUKY for SYST SYCUKYCUKY5SYCUKY
BDIFF_CYCUKY for SYST SYCUKYCUKY5SYCUKY
BDIF2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ZBD2P_CYCUKY for SYST SYCUKYCUKY5SYCUKY
SKFBT_CYCUKY for SYST SYCUKYCUKY5SYCUKY
SKNTO_CYCUKY for SYST SYCUKYCUKY5SYCUKY
WSKTO_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMBT1_CYCUKY for SYST SYCUKYCUKY5SYCUKY
WRBT1_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMBT2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
WRBT2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMBT3_CYCUKY for SYST SYCUKYCUKY5SYCUKY
WRBT3_CYCUKY for SYST SYCUKYCUKY5SYCUKY
QSSHB_CYCUKY for SYST SYCUKYCUKY5SYCUKY
QBSHB_CYCUKY for SYST SYCUKYCUKY5SYCUKY
QSFBT_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMBE2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMBE3_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMB21_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMB22_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMB23_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMB31_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMB32_CYCUKY for SYST SYCUKYCUKY5SYCUKY
DMB33_CYCUKY for SYST SYCUKYCUKY5SYCUKY
MWST2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
MWST3_CYCUKY for SYST SYCUKYCUKY5SYCUKY
SKNT2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
SKNT3_CYCUKY for SYST SYCUKYCUKY5SYCUKY
BDIF3_CYCUKY for SYST SYCUKYCUKY5SYCUKY
KZBTR_CYCUKY for SYST SYCUKYCUKY5SYCUKY
PSWBT_CYCUKY for SYST SYCUKYCUKY5SYCUKY
PYAMT_CYCUKY for SYST SYCUKYCUKY5SYCUKY
PPDIFF_CYCUKY for SYST SYCUKYCUKY5SYCUKY
PPDIF2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
PPDIF3_CYCUKY for SYST SYCUKYCUKY5SYCUKY
PENLC1_CYCUKY for SYST SYCUKYCUKY5SYCUKY
PENLC2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
PENLC3_CYCUKY for SYST SYCUKYCUKY5SYCUKY
PENFC_CYCUKY for SYST SYCUKYCUKY5SYCUKY

Key field Non-key field



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

As TXI_BSIK 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 TXI_BSIK as there is no data to select.

How to access SAP table TXI_BSIK

Within an ECC or HANA version of SAP you can also view further information about TXI_BSIK 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!