SAP Table BSIK

Accounting: Secondary Index for Vendors

The table BSIK (Accounting: Secondary Index for Vendors) is a standard table in SAP ERP. It belongs to the package FBAS.

Technical Information

Table	BSIK
Short Text	Accounting: Secondary Index for Vendors
Package	FBAS
Table Type	Transparent Table

Fields for Table BSIK

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