	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

181 COLUMNS | 4 INDEXES | ERP 6.0 | BSIK TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting
1	ERP EHP7	6.0	BSIK	181	4	Accounting: Secondary Index for Vendors	Financial Accounting

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BUKRS, LIFNR, UMSKS, UMSKZ, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI, BUDAT, BLDAT, CPUDT, WAERS, XBLNR, BLART, MONAT, BSCHL, ZUMSK, SHKZG, GSBER, MWSKZ, DMBTR, WRBTR, MWSTS, WMWST, BDIFF, BDIF2, SGTXT, PROJN, AUFNR, ANLN1, ANLN2, EBELN, EBELP, SAKNR, HKONT, FKONT, FILKD, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZLSCH, ZLSPR, ZBFIX, HBKID, BVTYP, REBZG, REBZJ, REBZZ, SAMNR, ZOLLT, ZOLLD, LZBKZ, LANDL, DIEKZ, MANSP, MSCHL, MADAT, MANST, MABER, XNETB, XANET, XCPDD, XESRD, XZAHL, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, QSSKZ, QSSHB, QBSHB, BSTAT, ANFBN, ANFBJ, ANFBU, VBUND, REBZT, STCEG, EGBLD, EGLLD, QSZNR, QSFBT, XINVE, PROJK, FIPOS, NPLNR, AUFPL, APLZL, XEGDR, DMBE2, DMBE3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, MWST2, MWST3, SKNT2, SKNT3, BDIF3, XRAGL, RSTGR, UZAWE, KOSTL, LNRAN, XSTOV, KZBTR, XREF1, XREF2, XARCH, PSWSL, PSWBT, IMKEY, ZEKKN, FISTL, GEBER, DABRZ, XNEGP, EMPFB, PRCTR, XREF3, DTWS1, DTWS2, DTWS3, DTWS4, XPYPR, KIDNO, PYCUR, PYAMT, BUPLA, SECCO, PPDIFF, PPDIF2, PPDIF3, PENLC1, PENLC2, PENLC3, PENFC, PENDAYS, PENRC, VERTT, VERTN, VBEWA, KBLNR, KBLPOS, GRANT_NBR, GMVKZ, SRTYPE, LOTKZ, ZINKZ, FKBER, INTRENO, PPRCT, BUZID, AUGGJ, HKTID, BUDGET_PD, KONTT, KONTL, UEBGDAT, VNAME, EGRUP, BTYPE, PROPMANO FROM BSIK

TOP ERP 6.0 | BSIK COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	LFB1	BUKRS	Allow NULL?
3	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	No	LFA1	LIFNR	Allow NULL?
4	UMSKS	Special G/L Transaction Type	char	1	0	CHAR	(N' ')	No		UMSKS	Allow NULL?
5	UMSKZ	Special G/L Indicator	char	1	0	CHAR	(N' ')	No	T074U	UMSKZ	Allow NULL?
6	AUGDT	Clearing Date	nvarchar	8	0	DATS	(N'00000000')	No		AUGDT	Allow NULL?
7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	CHAR	(N' ')	No		AUGBL	Allow NULL?
8	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	No		DZUONR	Allow NULL?
9	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
10	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	No		BELNR_D	Allow NULL?
11	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	No		BUZEI	Allow NULL?
12	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
13	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
14	CPUDT	Day On Which Accounting Document Was Entered	nvarchar	8	0	DATS	(N'00000000')	Yes		CPUDT	Allow NULL?
15	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
16	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR1	Allow NULL?
17	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	T003	BLART	Allow NULL?
18	MONAT	Fiscal Period	nvarchar	2	0	NUMC	(N'00')	Yes		MONAT	Allow NULL?
19	BSCHL	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	TBSL	BSCHL	Allow NULL?
20	ZUMSK	Target Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	*	DZUMSK	Allow NULL?
21	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
22	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
23	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ	Allow NULL?
24	DMBTR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
25	WRBTR	Amount in document currency	decimal	13	2	CURR	((0))	Yes		WRBTR
26	MWSTS	Tax Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		MWSTS
27	WMWST	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		WMWST
28	BDIFF	Valuation Difference	decimal	13	2	CURR	((0))	Yes		BDIFF
29	BDIF2	Valuation Difference for the Second Local Currency	decimal	13	2	CURR	((0))	Yes		BDIF2
30	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
31	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	CHAR	(N' ')	Yes		PROJN	Allow NULL?
32	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
33	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	ANLN1	Allow NULL?
34	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	*	ANLN2	Allow NULL?
35	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	EBELN	Allow NULL?
36	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	*	EBELP	Allow NULL?
37	SAKNR	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SAKNR	Allow NULL?
38	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	HKONT	Allow NULL?
39	FKONT	Financial Budget Item	nvarchar	3	0	NUMC	(N'000')	Yes		FIPLS	Allow NULL?
40	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
41	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
42	ZTERM	Terms of Payment Key	nvarchar	4	0	CHAR	(N' ')	Yes		DZTERM	Allow NULL?
43	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	Yes		DZBD1T
44	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	Yes		DZBD2T
45	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	Yes		DZBD3T
46	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	Yes		DZBD1P
47	ZBD2P	Cash Discount Percentage 2	decimal	5	3	DEC	((0))	Yes		DZBD2P
48	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2	CURR	((0))	Yes		SKFBT
49	SKNTO	Cash discount amount in local currency	decimal	13	2	CURR	((0))	Yes		SKNTO
50	WSKTO	Cash discount amount in document currency	decimal	13	2	CURR	((0))	Yes		WSKTO
51	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	T042Z	DZLSCH	Allow NULL?
52	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
53	ZBFIX	Fixed Payment Terms	char	1	0	CHAR	(N' ')	Yes		DZBFIX	Allow NULL?
54	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
55	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
56	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	CHAR	(N' ')	Yes		REBZG	Allow NULL?
57	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
58	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		REBZZ	Allow NULL?
59	SAMNR	Invoice List Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		SAMNR	Allow NULL?
60	ZOLLT	Customs Tariff Number	nvarchar	8	0	CHAR	(N' ')	Yes		DZOLLT	Allow NULL?
61	ZOLLD	Customs Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DZOLLD	Allow NULL?
62	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	T015L	LZBKZ	Allow NULL?
63	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL	Allow NULL?
64	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	CHAR	(N' ')	Yes		DIEKZ	Allow NULL?
65	MANSP	Dunning block	char	1	0	CHAR	(N' ')	Yes	T040S	MANSP	Allow NULL?
66	MSCHL	Dunning key	char	1	0	CHAR	(N' ')	Yes	T040	MSCHL	Allow NULL?
67	MADAT	Last dunned on	nvarchar	8	0	DATS	(N'00000000')	Yes		MADAT	Allow NULL?
68	MANST	Dunning level	char	1	0	NUMC	(N'0')	Yes		MAHNS_D	Allow NULL?
69	MABER	Dunning Area	nvarchar	2	0	CHAR	(N' ')	Yes	*	MABER	Allow NULL?
70	XNETB	Indicator: Document posted net ?	char	1	0	CHAR	(N' ')	Yes		XNETB	Allow NULL?
71	XANET	Indicator: Down payment in net procedure ?	char	1	0	CHAR	(N' ')	Yes		XANET	Allow NULL?
72	XCPDD	Indicator: Address and bank data set individually	char	1	0	CHAR	(N' ')	Yes		XCPDD	Allow NULL?
73	XESRD	Indicator: Is any ISR data set in the document ?	char	1	0	CHAR	(N' ')	Yes		XESRD	Allow NULL?
74	XZAHL	Indicator: Is the posting key used in a payment transaction?	char	1	0	CHAR	(N' ')	Yes		XZAHL	Allow NULL?
75	MWSK1	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
76	DMBT1	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
77	WRBT1	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
78	MWSK2	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
79	DMBT2	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
80	WRBT2	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
81	MWSK3	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
82	DMBT3	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
83	WRBT3	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
84	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	T059Q	QSSKZ	Allow NULL?
85	QSSHB	Withholding Tax Base Amount	decimal	13	2	CURR	((0))	Yes		QSSHB
86	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QBSHB
87	BSTAT	Document Status	char	1	0	CHAR	(N' ')	Yes		BSTAT_D	Allow NULL?
88	ANFBN	Document Number of the Bill of Exchange Payment Request	nvarchar	10	0	CHAR	(N' ')	Yes		ANFBN	Allow NULL?
89	ANFBJ	Fiscal Year of the Bill of Exchange Payment Request Document	nvarchar	4	0	NUMC	(N'0000')	Yes		ANFBJ	Allow NULL?
90	ANFBU	Company Code in Which Bill of Exch.Payment Request Is Posted	nvarchar	4	0	CHAR	(N' ')	Yes	T001	ANFBU	Allow NULL?
91	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	T880	RASSC	Allow NULL?
92	REBZT	Follow-On Document Type	char	1	0	CHAR	(N' ')	Yes		REBZT	Allow NULL?
93	STCEG	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
94	EGBLD	Country of Destination for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	T005	EGBLD	Allow NULL?
95	EGLLD	Supplying Country for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	T005	EGLLD	Allow NULL?
96	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	CHAR	(N' ')	Yes		QSZNR	Allow NULL?
97	QSFBT	Withholding Tax-Exempt Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QSFBT
98	XINVE	Indicator: Capital Goods Affected?	char	1	0	CHAR	(N' ')	Yes		XINVE	Allow NULL?
99	PROJK	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
100	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
101	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	*	NPLNR	Allow NULL?
102	AUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
103	APLZL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
104	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	CHAR	(N' ')	Yes		XEGDR	Allow NULL?
105	DMBE2	Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE2
106	DMBE3	Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE3
107	DMB21	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
108	DMB22	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
109	DMB23	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
110	DMB31	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
111	DMB32	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
112	DMB33	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
113	MWST2	Tax Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		MWST2
114	MWST3	Tax Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		MWST3
115	SKNT2	Cash Discount Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		SKNT2
116	SKNT3	Cash Discount Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		SKNT3
117	BDIF3	Valuation Difference for the Third Local Currency	decimal	13	2	CURR	((0))	Yes		BDIF3
118	XRAGL	Indicator: Clearing was Reversed	char	1	0	CHAR	(N' ')	Yes		XRAGL	Allow NULL?
119	RSTGR	Reason Code for Payments	nvarchar	3	0	CHAR	(N' ')	Yes	T053R	RSTGR	Allow NULL?
120	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	T042F	UZAWE	Allow NULL?
121	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
122	LNRAN	Sequence number of asset line items in fiscal year	nvarchar	5	0	NUMC	(N'00000')	Yes	ANEK	LNRAN	Allow NULL?
123	XSTOV	Indicator: Document is flagged for reversal	char	1	0	CHAR	(N' ')	Yes		XSTOV	Allow NULL?
124	KZBTR	Original Reduction Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		KZBTR_FI
125	XREF1	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF1	Allow NULL?
126	XREF2	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF2	Allow NULL?
127	XARCH	Indicator: Document already archived ?	char	1	0	CHAR	(N' ')	Yes		XARCH	Allow NULL?
128	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PSWSL	Allow NULL?
129	PSWBT	Amount for Updating in General Ledger	decimal	13	2	CURR	((0))	Yes		PSWBT
130	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
131	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	NUMC	(N'00')	Yes		DZEKKN	Allow NULL?
132	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
133	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
134	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
135	XNEGP	Indicator: Negative posting	char	1	0	CHAR	(N' ')	Yes		XNEGP	Allow NULL?
136	EMPFB	Payee/Payer	nvarchar	10	0	CHAR	(N' ')	Yes		EMPFB	Allow NULL?
137	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
138	XREF3	Reference key for line item	nvarchar	20	0	CHAR	(N' ')	Yes		XREF3	Allow NULL?
139	DTWS1	Instruction key 1	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT16	Allow NULL?
140	DTWS2	Instruction key 2	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT17	Allow NULL?
141	DTWS3	Instruction key 3	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT18	Allow NULL?
142	DTWS4	Instruction key 4	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT19	Allow NULL?
143	XPYPR	Indicator: Items from Payment Program Blocked	char	1	0	CHAR	(N' ')	Yes		XPYPR	Allow NULL?
144	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
145	PYCUR	Currency for Automatic Payment	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PYCUR	Allow NULL?
146	PYAMT	Amount in Payment Currency	decimal	13	2	CURR	((0))	Yes		PYAMT
147	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	J_1BBRANCH	BUPLA	Allow NULL?
148	SECCO	Section Code	nvarchar	4	0	CHAR	(N' ')	Yes	SECCODE	SECCO	Allow NULL?
149	PPDIFF	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)	decimal	13	2	CURR	((0))	Yes		PPDIFF
150	PPDIF2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)	decimal	13	2	CURR	((0))	Yes		PPDIF2
151	PPDIF3	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)	decimal	13	2	CURR	((0))	Yes		PPDIF3
152	PENLC1	Penalty charge amount in first local currency	decimal	13	2	CURR	((0))	Yes		PENALTY1
153	PENLC2	Penalty charge amount in second local currency	decimal	13	2	CURR	((0))	Yes		PENALTY2
154	PENLC3	Penalty Charge Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		PENALTY3
155	PENFC	Penalty charge amount in document currency	decimal	13	2	CURR	((0))	Yes		PENALTY
156	PENDAYS	Number of days for penalty charge calculation	int	10	0	INT4	((0))	Yes		PDAYS	Allow NULL?
157	PENRC	Reason for late payment	nvarchar	2	0	CHAR	(N' ')	Yes		PENRC	Allow NULL?
158	VERTT	Contract Type	char	1	0	CHAR	(N' ')	Yes		RANTYP	Allow NULL?
159	VERTN	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
160	VBEWA	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	SBEWART	Allow NULL?
161	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	*	KBLNR_FI	Allow NULL?
162	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	*	KBLPOS	Allow NULL?
163	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
164	GMVKZ	Item is in Execution	char	1	0	CHAR	(N' ')	Yes		FM_GMVKZ	Allow NULL?
165	SRTYPE	Type of Additional Receivable	nvarchar	2	0	CHAR	(N' ')	Yes		FM_SRTYPE	Allow NULL?
166	LOTKZ	Lot Number for Requests	nvarchar	10	0	CHAR	(N' ')	Yes		PSO_LOTKZ	Allow NULL?
167	ZINKZ	Exempted from interest calculation	nvarchar	2	0	CHAR	(N' ')	Yes		DZINKZ	Allow NULL?
168	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
169	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	CHAR	(N' ')	Yes		VVINTRENO	Allow NULL?
170	PPRCT	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PPRCTR	Allow NULL?
171	BUZID	Identification of the Line Item	char	1	0	CHAR	(N' ')	Yes		BUZID	Allow NULL?
172	AUGGJ	Fiscal Year of Clearing Document	nvarchar	4	0	NUMC	(N'0000')	Yes		AUGGJ	Allow NULL?
173	HKTID	ID for account details	nvarchar	5	0	CHAR	(N' ')	Yes	*	HKTID	Allow NULL?
174	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
175	KONTT	Account Assignment Category for Industry Solution	nvarchar	2	0	CHAR	(N' ')	Yes		KONTT_FI	Allow NULL?
176	KONTL	Acct assignment string for industry-specific acct assignmnts	nvarchar	50	0	CHAR	(N' ')	Yes		KONTL_FI	Allow NULL?
177	UEBGDAT	Transfer date of an item to legal dunning proceeding	nvarchar	8	0	DATS	(N'00000000')	Yes		UEBGDAT	Allow NULL?
178	VNAME	Joint Venture	nvarchar	6	0	CHAR	(N' ')	Yes	T8JV	JV_NAME	Allow NULL?
179	EGRUP	Equity group	nvarchar	3	0	CHAR	(N' ')	Yes	T8JF	JV_EGROUP	Allow NULL?
180	BTYPE	Payroll Type	nvarchar	2	0	CHAR	(N' ')	Yes	T8JA	JV_BILIND	Allow NULL?
181	PROPMANO	Mandate, Mandate-Opening Contract	nvarchar	13	0	CHAR	(N' ')	Yes		REHORECNNRM	Allow NULL?

TOP ERP 6.0 | BSIK INDEXES

Name	Primary	Unique	Type	Columns
BSIK~0	Yes	Yes	CLUSTERED	BUZEI, BELNR, GJAHR, ZUONR, AUGBL, AUGDT, UMSKZ, UMSKS, LIFNR, BUKRS, MANDT
BSIK~1	No	Yes	NONCLUSTERED	BUZEI, BELNR, GJAHR, BUKRS, LIFNR, MANDT
BSIK~4	No	No	NONCLUSTERED	REBZT, UMSKS, LIFNR, REBZZ, REBZJ, REBZG, BUKRS, MANDT
BSIK~5	No	No	NONCLUSTERED	BUZEI, GJAHR, BELNR, BUKRS, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

181 COLUMNS | 4 INDEXES | ERP 6.0 | BSIK TABLE

TOP ERP 6.0 | BSIK COLUMNS

TOP ERP 6.0 | BSIK INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

181 COLUMNS | 4 INDEXES | ERP 6.0 | BSIK TABLE

TOPERP 6.0 | BSIK COLUMNS

TOPERP 6.0 | BSIK INDEXES

TOP ERP 6.0 | BSIK COLUMNS

TOP ERP 6.0 | BSIK INDEXES