	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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

179 COLUMNS | 4 INDEXES | ERP 6.0 | BSAD TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting
1	ERP EHP7	6.0	BSAD	179	4	Accounting: Secondary Index for Customers (Cleared Items)	Financial Accounting

SQL: selectupdate insert create

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

SELECT MANDT, BUKRS, KUNNR, 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, SAKNR, HKONT, FKONT, FILKD, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZLSCH, ZLSPR, ZBFIX, HBKID, BVTYP, REBZG, REBZJ, REBZZ, SAMNR, ANFBN, ANFBJ, ANFBU, ANFAE, MANSP, MSCHL, MADAT, MANST, MABER, XNETB, XANET, XCPDD, XINVE, XZAHL, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, BSTAT, VBUND, VBELN, REBZT, INFAE, STCEG, EGBLD, EGLLD, RSTGR, XNOZA, VERTT, VERTN, VBEWA, WVERW, PROJK, FIPOS, NPLNR, AUFPL, APLZL, XEGDR, DMBE2, DMBE3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, BDIF3, XRAGL, UZAWE, XSTOV, MWST2, MWST3, SKNT2, SKNT3, XREF1, XREF2, XARCH, PSWSL, PSWBT, LZBKZ, LANDL, IMKEY, VBEL2, VPOS2, POSN2, ETEN2, FISTL, GEBER, DABRZ, XNEGP, KOSTL, RFZEI, KKBER, EMPFB, PRCTR, XREF3, QSSKZ, ZINKZ, DTWS1, DTWS2, DTWS3, DTWS4, XPYPR, KIDNO, ABSBT, CCBTC, PYCUR, PYAMT, BUPLA, SECCO, CESSION_KZ, PPDIFF, PPDIF2, PPDIF3, KBLNR, KBLPOS, GRANT_NBR, GMVKZ, SRTYPE, LOTKZ, FKBER, INTRENO, PPRCT, BUZID, AUGGJ, HKTID, BUDGET_PD, PAYS_PROV, PAYS_TRAN, MNDID, KONTT, KONTL, UEBGDAT, VNAME, EGRUP, BTYPE, PROPMANO FROM BSAD

TOP ERP 6.0 | BSAD 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	KNB1	BUKRS	Allow NULL?
3	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	No	KNA1	KUNNR	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	*	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	*	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	*	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	*	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	*	GSBER	Allow NULL?
23	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	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	*	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	SAKNR	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SAKNR	Allow NULL?
36	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	HKONT	Allow NULL?
37	FKONT	Financial Budget Item	nvarchar	3	0	NUMC	(N'000')	Yes		FIPLS	Allow NULL?
38	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
39	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
40	ZTERM	Terms of Payment Key	nvarchar	4	0	CHAR	(N' ')	Yes		DZTERM	Allow NULL?
41	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	Yes		DZBD1T
42	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	Yes		DZBD2T
43	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	Yes		DZBD3T
44	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	Yes		DZBD1P
45	ZBD2P	Cash Discount Percentage 2	decimal	5	3	DEC	((0))	Yes		DZBD2P
46	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2	CURR	((0))	Yes		SKFBT
47	SKNTO	Cash discount amount in local currency	decimal	13	2	CURR	((0))	Yes		SKNTO
48	WSKTO	Cash discount amount in document currency	decimal	13	2	CURR	((0))	Yes		WSKTO
49	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	*	DZLSCH	Allow NULL?
50	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	*	DZLSPR	Allow NULL?
51	ZBFIX	Fixed Payment Terms	char	1	0	CHAR	(N' ')	Yes		DZBFIX	Allow NULL?
52	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	*	HBKID	Allow NULL?
53	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
54	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	CHAR	(N' ')	Yes		REBZG	Allow NULL?
55	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
56	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		REBZZ	Allow NULL?
57	SAMNR	Invoice List Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		SAMNR	Allow NULL?
58	ANFBN	Document Number of the Bill of Exchange Payment Request	nvarchar	10	0	CHAR	(N' ')	Yes		ANFBN	Allow NULL?
59	ANFBJ	Fiscal Year of the Bill of Exchange Payment Request Document	nvarchar	4	0	NUMC	(N'0000')	Yes		ANFBJ	Allow NULL?
60	ANFBU	Company Code in Which Bill of Exch.Payment Request Is Posted	nvarchar	4	0	CHAR	(N' ')	Yes	*	ANFBU	Allow NULL?
61	ANFAE	Bill of Exchange Payment Request Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ANFAE	Allow NULL?
62	MANSP	Dunning block	char	1	0	CHAR	(N' ')	Yes	*	MANSP	Allow NULL?
63	MSCHL	Dunning key	char	1	0	CHAR	(N' ')	Yes	*	MSCHL	Allow NULL?
64	MADAT	Last dunned on	nvarchar	8	0	DATS	(N'00000000')	Yes		MADAT	Allow NULL?
65	MANST	Dunning level	char	1	0	NUMC	(N'0')	Yes		MAHNS_D	Allow NULL?
66	MABER	Dunning Area	nvarchar	2	0	CHAR	(N' ')	Yes	*	MABER	Allow NULL?
67	XNETB	Indicator: Document posted net ?	char	1	0	CHAR	(N' ')	Yes		XNETB	Allow NULL?
68	XANET	Indicator: Down payment in net procedure ?	char	1	0	CHAR	(N' ')	Yes		XANET	Allow NULL?
69	XCPDD	Indicator: Address and bank data set individually	char	1	0	CHAR	(N' ')	Yes		XCPDD	Allow NULL?
70	XINVE	Indicator: Capital Goods Affected?	char	1	0	CHAR	(N' ')	Yes		XINVE	Allow NULL?
71	XZAHL	Indicator: Is the posting key used in a payment transaction?	char	1	0	CHAR	(N' ')	Yes		XZAHL	Allow NULL?
72	MWSK1	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
73	DMBT1	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
74	WRBT1	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
75	MWSK2	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
76	DMBT2	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
77	WRBT2	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
78	MWSK3	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
79	DMBT3	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
80	WRBT3	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
81	BSTAT	Document Status	char	1	0	CHAR	(N' ')	Yes		BSTAT_D	Allow NULL?
82	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	*	RASSC	Allow NULL?
83	VBELN	Billing Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VF	Allow NULL?
84	REBZT	Follow-On Document Type	char	1	0	CHAR	(N' ')	Yes		REBZT	Allow NULL?
85	INFAE	Inverted Date for Net Due Date	nvarchar	8	0	CHAR	(N' ')	Yes		INFAE	Allow NULL?
86	STCEG	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
87	EGBLD	Country of Destination for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	*	EGBLD	Allow NULL?
88	EGLLD	Supplying Country for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	*	EGLLD	Allow NULL?
89	RSTGR	Reason Code for Payments	nvarchar	3	0	CHAR	(N' ')	Yes	*	RSTGR	Allow NULL?
90	XNOZA	Indicator: Account is not counted	char	1	0	CHAR	(N' ')	Yes		XNOZA	Allow NULL?
91	VERTT	Contract Type	char	1	0	CHAR	(N' ')	Yes		RANTYP	Allow NULL?
92	VERTN	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
93	VBEWA	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	SBEWART	Allow NULL?
94	WVERW	Bill of exchange usage type	char	1	0	CHAR	(N' ')	Yes		WVERW	Allow NULL?
95	PROJK	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
96	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
97	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	*	NPLNR	Allow NULL?
98	AUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
99	APLZL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
100	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	CHAR	(N' ')	Yes		XEGDR	Allow NULL?
101	DMBE2	Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE2
102	DMBE3	Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE3
103	DMB21	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
104	DMB22	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
105	DMB23	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
106	DMB31	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
107	DMB32	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
108	DMB33	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
109	BDIF3	Valuation Difference for the Third Local Currency	decimal	13	2	CURR	((0))	Yes		BDIF3
110	XRAGL	Indicator: Clearing was Reversed	char	1	0	CHAR	(N' ')	Yes		XRAGL	Allow NULL?
111	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	T042F	UZAWE	Allow NULL?
112	XSTOV	Indicator: Document is flagged for reversal	char	1	0	CHAR	(N' ')	Yes		XSTOV	Allow NULL?
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	XREF1	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF1	Allow NULL?
118	XREF2	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF2	Allow NULL?
119	XARCH	Indicator: Document already archived ?	char	1	0	CHAR	(N' ')	Yes		XARCH	Allow NULL?
120	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PSWSL	Allow NULL?
121	PSWBT	Amount for Updating in General Ledger	decimal	13	2	CURR	((0))	Yes		PSWBT
122	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	*	LZBKZ	Allow NULL?
123	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	*	LANDL	Allow NULL?
124	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
125	VBEL2	Sales Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VA	Allow NULL?
126	VPOS2	Numeric field: Length 6	nvarchar	6	0	NUMC	(N'000000')	Yes		NUM06	Allow NULL?
127	POSN2	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VA	Allow NULL?
128	ETEN2	Delivery Schedule Line Number	nvarchar	4	0	NUMC	(N'0000')	Yes	*	ETENR	Allow NULL?
129	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
130	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
131	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
132	XNEGP	Indicator: Negative posting	char	1	0	CHAR	(N' ')	Yes		XNEGP	Allow NULL?
133	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
134	RFZEI	Payment Card Item	nvarchar	3	0	NUMC	(N'000')	Yes		RFZEI_CC	Allow NULL?
135	KKBER	Credit control area	nvarchar	4	0	CHAR	(N' ')	Yes	T014	KKBER	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	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	*	QSSKZ	Allow NULL?
140	ZINKZ	Exempted from interest calculation	nvarchar	2	0	CHAR	(N' ')	Yes		DZINKZ	Allow NULL?
141	DTWS1	Instruction key 1	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT16	Allow NULL?
142	DTWS2	Instruction key 2	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT17	Allow NULL?
143	DTWS3	Instruction key 3	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT18	Allow NULL?
144	DTWS4	Instruction key 4	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT19	Allow NULL?
145	XPYPR	Indicator: Items from Payment Program Blocked	char	1	0	CHAR	(N' ')	Yes		XPYPR	Allow NULL?
146	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
147	ABSBT	Credit management: Hedged amount	decimal	13	2	CURR	((0))	Yes		ABSBT
148	CCBTC	Payment cards: Settlement run	nvarchar	10	0	CHAR	(N' ')	Yes		CCBTC	Allow NULL?
149	PYCUR	Currency for Automatic Payment	nvarchar	5	0	CUKY	(N' ')	Yes	*	PYCUR	Allow NULL?
150	PYAMT	Amount in Payment Currency	decimal	13	2	CURR	((0))	Yes		PYAMT
151	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUPLA	Allow NULL?
152	SECCO	Section Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	SECCO	Allow NULL?
153	CESSION_KZ	Accounts Receivable Pledging Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	TCESSION	CESSION_KZ	Allow NULL?
154	PPDIFF	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)	decimal	13	2	CURR	((0))	Yes		PPDIFF
155	PPDIF2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)	decimal	13	2	CURR	((0))	Yes		PPDIF2
156	PPDIF3	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)	decimal	13	2	CURR	((0))	Yes		PPDIF3
157	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	*	KBLNR_FI	Allow NULL?
158	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	*	KBLPOS	Allow NULL?
159	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
160	GMVKZ	Item is in Execution	char	1	0	CHAR	(N' ')	Yes		FM_GMVKZ	Allow NULL?
161	SRTYPE	Type of Additional Receivable	nvarchar	2	0	CHAR	(N' ')	Yes		FM_SRTYPE	Allow NULL?
162	LOTKZ	Lot Number for Requests	nvarchar	10	0	CHAR	(N' ')	Yes		PSO_LOTKZ	Allow NULL?
163	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
164	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	CHAR	(N' ')	Yes		VVINTRENO	Allow NULL?
165	PPRCT	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PPRCTR	Allow NULL?
166	BUZID	Identification of the Line Item	char	1	0	CHAR	(N' ')	Yes		BUZID	Allow NULL?
167	AUGGJ	Fiscal Year of Clearing Document	nvarchar	4	0	NUMC	(N'0000')	Yes		AUGGJ	Allow NULL?
168	HKTID	ID for account details	nvarchar	5	0	CHAR	(N' ')	Yes	*	HKTID	Allow NULL?
169	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
170	PAYS_PROV	Payment Service Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	COM_WEC_PAYMENT_SRV_PROVIDER	Allow NULL?
171	PAYS_TRAN	Payment Reference of Payment Service Provider	nvarchar	35	0	CHAR	(N' ')	Yes		FPS_TRANSACTION	Allow NULL?
172	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	CHAR	(N' ')	Yes		SEPA_MNDID	Allow NULL?
173	KONTT	Account Assignment Category for Industry Solution	nvarchar	2	0	CHAR	(N' ')	Yes		KONTT_FI	Allow NULL?
174	KONTL	Acct assignment string for industry-specific acct assignmnts	nvarchar	50	0	CHAR	(N' ')	Yes		KONTL_FI	Allow NULL?
175	UEBGDAT	Transfer date of an item to legal dunning proceeding	nvarchar	8	0	DATS	(N'00000000')	Yes		UEBGDAT	Allow NULL?
176	VNAME	Joint Venture	nvarchar	6	0	CHAR	(N' ')	Yes	T8JV	JV_NAME	Allow NULL?
177	EGRUP	Equity group	nvarchar	3	0	CHAR	(N' ')	Yes	T8JF	JV_EGROUP	Allow NULL?
178	BTYPE	Payroll Type	nvarchar	2	0	CHAR	(N' ')	Yes	T8JA	JV_BILIND	Allow NULL?
179	PROPMANO	Mandate, Mandate-Opening Contract	nvarchar	13	0	CHAR	(N' ')	Yes		REHORECNNRM	Allow NULL?

TOP ERP 6.0 | BSAD INDEXES

Name	Primary	Unique	Type	Columns
BSAD~0	Yes	Yes	CLUSTERED	BUZEI, BELNR, GJAHR, ZUONR, AUGBL, AUGDT, UMSKZ, UMSKS, KUNNR, BUKRS, MANDT
BSAD~1	No	No	NONCLUSTERED	BUZEI, BELNR, GJAHR, AUGBL, AUGDT, BUKRS, KUNNR, MANDT
BSAD~4	No	No	NONCLUSTERED	REBZT, UMSKS, KUNNR, REBZZ, REBZJ, REBZG, BUKRS, MANDT
BSAD~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

179 COLUMNS | 4 INDEXES | ERP 6.0 | BSAD TABLE

TOP ERP 6.0 | BSAD COLUMNS

TOP ERP 6.0 | BSAD 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

179 COLUMNS | 4 INDEXES | ERP 6.0 | BSAD TABLE

TOPERP 6.0 | BSAD COLUMNS

TOPERP 6.0 | BSAD INDEXES

TOP ERP 6.0 | BSAD COLUMNS

TOP ERP 6.0 | BSAD INDEXES