1. Home
  2. Resources
  3. SAP Tables
  4. BSIK - Accounting: Secondary Index for Vendors

SAP Table BSIK

Accounting: Secondary Index for Vendors

BSIK (Accounting: Secondary Index for Vendors) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BSIK to other SAP tables.

BSIK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS LFB1 CHAR 4 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
UMSKZ Special G/L Indicator UMSKZ T074U CHAR 1 0
AUGDT Clearing Date AUGDT DATS 8 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
ZUONR Assignment Number DZUONR CHAR 18 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
WAERS Currency Key WAERS TCURC CUKY 5 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BLART Document Type BLART T003 CHAR 2 0
MONAT Fiscal Period MONAT NUMC 2 0
BSCHL Posting Key BSCHL TBSL CHAR 2 0
ZUMSK Target Special G/L Indicator DZUMSK CHAR 1 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
GSBER Business Area GSBER TGSB CHAR 4 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
WRBTR Amount in document currency WRBTR CURR 13 2
MWSTS Tax Amount in Local Currency MWSTS CURR 13 2
WMWST Tax amount in document currency WMWST CURR 13 2
BDIFF Valuation Difference BDIFF CURR 13 2
BDIF2 Valuation Difference for the Second Local Currency BDIF2 CURR 13 2
SGTXT Item Text SGTXT CHAR 50 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
SAKNR G/L Account Number SAKNR CHAR 10 0
HKONT General Ledger Account HKONT CHAR 10 0
FKONT Financial Budget Item FIPLS NUMC 3 0
FILKD Account Number of the Branch FILKD CHAR 10 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
SKFBT Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13 2
SKNTO Cash discount amount in local currency SKNTO CURR 13 2
WSKTO Cash discount amount in document currency WSKTO CURR 13 2
ZLSCH Payment Method DZLSCH T042Z CHAR 1 0
ZLSPR Payment Block Key DZLSPR T008 CHAR 1 0
ZBFIX Fixed Payment Terms DZBFIX CHAR 1 0
NULL No fixing
1 1st cash disc.percentage rate or cash disc.amount is fixed
2 2nd cash discount percentage rate is fixed
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
SAMNR Invoice List Number SAMNR NUMC 8 0
ZOLLT Customs Tariff Number DZOLLT CHAR 8 0
ZOLLD Customs Date DZOLLD DATS 8 0
LZBKZ State Central Bank Indicator LZBKZ T015L CHAR 3 0
LANDL Supplying Country LANDL T005 CHAR 3 0
DIEKZ Service Indicator (Foreign Payment) DIEKZ CHAR 1 0
MANSP Dunning block MANSP T040S CHAR 1 0
MSCHL Dunning key MSCHL T040 CHAR 1 0
MADAT Last dunned on MADAT DATS 8 0
MANST Dunning level MAHNS_D NUMC 1 0
MABER Dunning Area MABER CHAR 2 0
XNETB Indicator: Document posted net ? XNETB CHAR 1 0
X Yes
NULL No
XANET Indicator: Down payment in net procedure ? XANET CHAR 1 0
X Yes
NULL No
XCPDD Indicator: Address and bank data set individually XCPDD CHAR 1 0
X Yes
NULL No
XESRD Indicator: Is any ISR data set in the document ? XESRD CHAR 1 0
X Yes
NULL No
XZAHL Indicator: Is the posting key used in a payment transaction? XZAHL CHAR 1 0
X Yes
NULL No
MWSK1 Tax Code for Distribution MWSKX CHAR 2 0
DMBT1 Amount in Local Currency for Tax Distribution DMBTX CURR 13 2
WRBT1 Amount in foreign currency for tax breakdown WRBTX CURR 13 2
MWSK2 Tax Code for Distribution MWSKX CHAR 2 0
DMBT2 Amount in Local Currency for Tax Distribution DMBTX CURR 13 2
WRBT2 Amount in foreign currency for tax breakdown WRBTX CURR 13 2
MWSK3 Tax Code for Distribution MWSKX CHAR 2 0
DMBT3 Amount in Local Currency for Tax Distribution DMBTX CURR 13 2
WRBT3 Amount in foreign currency for tax breakdown WRBTX CURR 13 2
QSSKZ Withholding Tax Code QSSKZ T059Q CHAR 2 0
QSSHB Withholding Tax Base Amount QSSHB CURR 13 2
QBSHB Withholding Tax Amount (in Document Currency) QBSHB CURR 13 2
BSTAT Document Status BSTAT_D CHAR 1 0
NULL Normal document
A Clearing Document
B Reset clearing document
D Recurring entry document
L Posting Not in Leading Ledger
M Sample document
S Noted items
V Parked document
W Parked document with change of document ID
Z Parked document which was deleted
C Balance Carryforward Line Items
ANFBN Document Number of the Bill of Exchange Payment Request ANFBN CHAR 10 0
ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document ANFBJ NUMC 4 0
ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted ANFBU T001 CHAR 4 0
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
REBZT Follow-On Document Type REBZT CHAR 1 0
STCEG VAT Registration Number STCEG CHAR 20 0
EGBLD Country of Destination for Delivery of Goods EGBLD T005 CHAR 3 0
EGLLD Supplying Country for Delivery of Goods EGLLD T005 CHAR 3 0
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
QSFBT Withholding Tax-Exempt Amount (in Document Currency) QSFBT CURR 13 2
XINVE Indicator: Capital Goods Affected? XINVE CHAR 1 0
X Yes
NULL No
PROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
FIPOS Commitment Item FIPOS CHAR 14 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL Internal counter CIM_COUNT NUMC 8 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
DMBE2 Amount in Second Local Currency DMBE2 CURR 13 2
DMBE3 Amount in Third Local Currency DMBE3 CURR 13 2
DMB21 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 13 2
DMB22 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 13 2
DMB23 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 13 2
DMB31 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 13 2
DMB32 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 13 2
DMB33 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 13 2
MWST2 Tax Amount in Second Local Currency MWST2 CURR 13 2
MWST3 Tax Amount in Third Local Currency MWST3 CURR 13 2
SKNT2 Cash Discount Amount in Second Local Currency SKNT2 CURR 13 2
SKNT3 Cash Discount Amount in Third Local Currency SKNT3 CURR 13 2
BDIF3 Valuation Difference for the Third Local Currency BDIF3 CURR 13 2
XRAGL Indicator: Clearing was Reversed XRAGL CHAR 1 0
X Yes
NULL No
RSTGR Reason Code for Payments RSTGR T053R CHAR 3 0
UZAWE Payment Method Supplement UZAWE T042F CHAR 2 0
KOSTL Cost Center KOSTL CHAR 10 0
LNRAN Sequence number of asset line items in fiscal year LNRAN ANEK NUMC 5 0
XSTOV Indicator: Document is flagged for reversal XSTOV CHAR 1 0
X Yes
NULL No
KZBTR Original Reduction Amount in Local Currency KZBTR_FI CURR 13 2
XREF1 Business partner reference key XREF1 CHAR 12 0
XREF2 Business partner reference key XREF2 CHAR 12 0
XARCH Indicator: Document already archived ? XARCH CHAR 1 0
X Yes
NULL No
PSWSL Update Currency for General Ledger Transaction Figures PSWSL TCURC CUKY 5 0
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
EMPFB Payee/Payer EMPFB CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 0
XREF3 Reference key for line item XREF3 CHAR 20 0
DTWS1 Instruction key 1 DTAT16 NUMC 2 0
DTWS2 Instruction key 2 DTAT17 NUMC 2 0
DTWS3 Instruction key 3 DTAT18 NUMC 2 0
DTWS4 Instruction key 4 DTAT19 NUMC 2 0
XPYPR Indicator: Items from Payment Program Blocked XPYPR CHAR 1 0
X Yes
NULL No
KIDNO Payment Reference KIDNO CHAR 30 0
PYCUR Currency for Automatic Payment PYCUR TCURC CUKY 5 0
PYAMT Amount in Payment Currency PYAMT CURR 13 2
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
SECCO Section Code SECCO SECCODE CHAR 4 0
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFF CURR 13 2
PPDIF2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2 CURR 13 2
PPDIF3 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3 CURR 13 2
PENLC1 Penalty charge amount in first local currency PENALTY1 CURR 13 2
PENLC2 Penalty charge amount in second local currency PENALTY2 CURR 13 2
PENLC3 Penalty Charge Amount in Third Local Currency PENALTY3 CURR 13 2
PENFC Penalty charge amount in document currency PENALTY CURR 13 2
PENDAYS Number of days for penalty charge calculation PDAYS INT4 10 0
PENRC Reason for late payment PENRC CHAR 2 0
VERTT Contract Type RANTYP CHAR 1 0
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
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
VERTN Contract Number RANL CHAR 13 0
VBEWA Flow Type SBEWART CHAR 4 0
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
GMVKZ Item is in Execution FM_GMVKZ CHAR 1 0
NULL Item not transferred to execution
I Item for information transferred to execution
X Item must be executed
SRTYPE Type of Additional Receivable FM_SRTYPE CHAR 2 0
01 Dunning Charge
02 Dunning Interest
03 Deferral Interest
04 General Execution Costs
LOTKZ Lot Number for Requests PSO_LOTKZ CHAR 10 0
ZINKZ Exempted from interest calculation DZINKZ CHAR 2 0
A Reasons for block
FKBER Functional Area FKBER CHAR 16 0
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR 13 0
PPRCT Partner Profit Center PPRCTR CHAR 10 0
BUZID Identification of the Line Item BUZID CHAR 1 0
AUGGJ Fiscal Year of Clearing Document AUGGJ NUMC 4 0
HKTID ID for account details HKTID CHAR 5 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
KONTT Account Assignment Category for Industry Solution KONTT_FI CHAR 2 0
KONTL Acct assignment string for industry-specific acct assignmnts KONTL_FI CHAR 50 0
UEBGDAT Transfer date of an item to legal dunning proceeding UEBGDAT DATS 8 0
VNAME Joint Venture JV_NAME T8JV CHAR 6 0
EGRUP Equity group JV_EGROUP T8JF CHAR 3 0
BTYPE Payroll Type JV_BILIND T8JA CHAR 2 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
PROPMANO Mandate, Mandate-Opening Contract REHORECNNRM CHAR 13 0

BSIK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BSIK ANFBU BSIK ANFBU T001 Company Codes BUKRS
BSIK ANFBU BSIK MANDT T001 Company Codes MANDT
BSIK AUFNR BSIK MANDT AUFK Order master data MANDT
BSIK AUFNR BSIK AUFNR AUFK Order master data AUFNR
BSIK BLART BSIK MANDT T003 Document Types MANDT
BSIK BLART BSIK BLART T003 Document Types BLART
BSIK BSCHL BSIK MANDT TBSL Posting Key MANDT
BSIK BSCHL BSIK BSCHL TBSL Posting Key BSCHL
BSIK BTYPE BSIK MANDT T8JA Payroll Type MANDT
BSIK BTYPE BSIK BTYPE T8JA Payroll Type BILIND
BSIK BUKRS BSIK BUKRS LFB1 Vendor Master (Company Code) BUKRS
BSIK BUKRS BSIK MANDT LFB1 Vendor Master (Company Code) MANDT
BSIK BUKRS BSIK LIFNR LFB1 Vendor Master (Company Code) LIFNR
BSIK BUPLA BSIK BUPLA J_1BBRANCH Business Place BRANCH
BSIK BUPLA BSIK MANDT J_1BBRANCH Business Place MANDT
BSIK BUPLA * J_1BBRANCH Business Place BUKRS
BSIK EGBLD BSIK MANDT T005 Countries MANDT
BSIK EGBLD BSIK EGBLD T005 Countries LAND1
BSIK EGLLD BSIK EGLLD T005 Countries LAND1
BSIK EGLLD BSIK MANDT T005 Countries MANDT
BSIK EGRUP BSIK VNAME T8JF Investment Group VNAME
BSIK EGRUP BSIK EGRUP T8JF Investment Group EGRUP
BSIK EGRUP BSIK MANDT T8JF Investment Group MANDT
BSIK EGRUP BSIK BUKRS T8JF Investment Group BUKRS
BSIK GSBER BSIK MANDT TGSB Business Areas MANDT
BSIK GSBER BSIK GSBER TGSB Business Areas GSBER
BSIK HBKID BSIK HBKID T012 House Banks HBKID
BSIK HBKID BSIK MANDT T012 House Banks MANDT
BSIK HBKID * T012 House Banks BUKRS
BSIK LANDL BSIK MANDT T005 Countries MANDT
BSIK LANDL BSIK LANDL T005 Countries LAND1
BSIK LIFNR BSIK MANDT LFA1 Vendor Master (General Section) MANDT
BSIK LIFNR BSIK LIFNR LFA1 Vendor Master (General Section) LIFNR
BSIK LNRAN BSIK ANFBJ ANEK Document Header Asset Posting GJAHR
BSIK LNRAN BSIK LNRAN ANEK Document Header Asset Posting LNRAN
BSIK LNRAN BSIK MANDT ANEK Document Header Asset Posting MANDT
BSIK LNRAN BSIK BUKRS ANEK Document Header Asset Posting BUKRS
BSIK LNRAN BSIK ANLN1 ANEK Document Header Asset Posting ANLN1
BSIK LNRAN BSIK ANLN2 ANEK Document Header Asset Posting ANLN2
BSIK LZBKZ BSIK MANDT T015L SCB Ratios MANDT
BSIK LZBKZ BSIK LZBKZ T015L SCB Ratios LZBKZ
BSIK MANSP BSIK MANSP T040S Blocking reasons for dunning notices MANSP
BSIK MANSP BSIK MANDT T040S Blocking reasons for dunning notices MANDT
BSIK MSCHL BSIK MANDT T040 Dunning keys MANDT
BSIK MSCHL BSIK MSCHL T040 Dunning keys MSCHL
BSIK MWSKZ BSIK MWSKZ T007A Tax Keys MWSKZ
BSIK MWSKZ BSIK MANDT T007A Tax Keys MANDT
BSIK MWSKZ * T007A Tax Keys KALSM
BSIK PSWSL BSIK MANDT TCURC Currency Codes MANDT
BSIK PSWSL BSIK PSWSL TCURC Currency Codes WAERS
BSIK PYCUR BSIK MANDT TCURC Currency Codes MANDT
BSIK PYCUR BSIK PYCUR TCURC Currency Codes WAERS
BSIK QSSKZ * T059Q Withholding Tax LAND1
BSIK QSSKZ BSIK QSSKZ T059Q Withholding Tax QSSKZ
BSIK QSSKZ BSIK MANDT T059Q Withholding Tax MANDT
BSIK RSTGR BSIK MANDT T053R Classification of Payment Differences MANDT
BSIK RSTGR * T053R Classification of Payment Differences BUKRS
BSIK RSTGR BSIK RSTGR T053R Classification of Payment Differences RSTGR
BSIK SECCO BSIK MANDT SECCODE Section Code MANDT
BSIK SECCO * SECCODE Section Code BUKRS
BSIK SECCO BSIK SECCO SECCODE Section Code SECCODE
BSIK UMSKZ BSIK MANDT T074U Special G/L Indicator Properties MANDT
BSIK UMSKZ * T074U Special G/L Indicator Properties KOART
BSIK UMSKZ BSIK UMSKZ T074U Special G/L Indicator Properties UMSKZ
BSIK UZAWE BSIK MANDT T042F Payment method supplements MANDT
BSIK UZAWE BSIK UZAWE T042F Payment method supplements UZAWE
BSIK VBUND BSIK VBUND T880 Global Company Data (for KONS Ledger) RCOMP
BSIK VBUND BSIK MANDT T880 Global Company Data (for KONS Ledger) MANDT
BSIK VNAME BSIK MANDT T8JV Joint Venture MANDT
BSIK VNAME BSIK BUKRS T8JV Joint Venture BUKRS
BSIK VNAME BSIK VNAME T8JV Joint Venture VNAME
BSIK WAERS BSIK MANDT TCURC Currency Codes MANDT
BSIK WAERS BSIK WAERS TCURC Currency Codes WAERS
BSIK ZLSCH BSIK ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
BSIK ZLSCH BSIK MANDT T042Z Payment Methods for Automatic Payment MANDT
BSIK ZLSCH * T042Z Payment Methods for Automatic Payment LAND1
BSIK ZLSPR BSIK MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
BSIK ZLSPR BSIK ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS