	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	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

345 COLUMNS | 1 INDEXES | ERP 6.0 | BSEG TABLE

ERP EHP7

6.0

345

Accounting Document Segment

SQL: selectupdate insert create

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

SELECT MANDT, BUKRS, BELNR, GJAHR, BUZEI, BUZID, AUGDT, AUGCP, AUGBL, BSCHL, KOART, UMSKZ, UMSKS, ZUMSK, SHKZG, GSBER, PARGB, MWSKZ, QSSKZ, ZZSPREG, ZZBUSPARTN, ZZCHAN, ZZPRODUCT, ZZLOCA, ZZLOB, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZSTATE, ZZREGION, DMBTR, WRBTR, KZBTR, PSWBT, PSWSL, TXBHW, TXBFW, MWSTS, WMWST, HWBAS, FWBAS, HWZUZ, FWZUZ, SHZUZ, STEKZ, MWART, TXGRP, KTOSL, QSSHB, KURSR, GBETR, BDIFF, BDIF2, VALUT, ZUONR, SGTXT, ZINKZ, VBUND, BEWAR, ALTKT, VORGN, FDLEV, FDGRP, FDWBT, FDTAG, FKONT, KOKRS, KOSTL, PROJN, AUFNR, VBELN, VBEL2, POSN2, ETEN2, ANLN1, ANLN2, ANBWA, BZDAT, PERNR, XUMSW, XHRES, XKRES, XOPVW, XCPDD, XSKST, XSAUF, XSPRO, XSERG, XFAKT, XUMAN, XANET, XSKRL, XINVE, XPANZ, XAUTO, XNCOP, XZAHL, SAKNR, HKONT, KUNNR, LIFNR, FILKD, XBILK, GVTYP, HZUON, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZLSCH, ZLSPR, ZBFIX, HBKID, BVTYP, NEBTR, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, REBZG, REBZJ, REBZZ, REBZT, ZOLLT, ZOLLD, LZBKZ, LANDL, DIEKZ, SAMNR, ABPER, VRSKZ, VRSDT, DISBN, DISBJ, DISBZ, WVERW, ANFBN, ANFBJ, ANFBU, ANFAE, BLNBT, BLNKZ, BLNPZ, MSCHL, MANSP, MADAT, MANST, MABER, ESRNR, ESRRE, ESRPZ, KLIBT, QSZNR, QBSHB, QSFBT, NAVHW, NAVFW, MATNR, WERKS, MENGE, MEINS, ERFMG, ERFME, BPMNG, BPRME, EBELN, EBELP, ZEKKN, ELIKZ, VPRSV, PEINH, BWKEY, BWTAR, BUSTW, REWRT, REWWR, BONFB, BUALT, PSALT, NPREI, TBTKZ, SPGRP, SPGRM, SPGRT, SPGRG, SPGRV, SPGRQ, STCEG, EGBLD, EGLLD, RSTGR, RYACQ, RPACQ, RDIFF, RDIF2, PRCTR, XHKOM, VNAME, RECID, EGRUP, VPTNR, VERTT, VERTN, VBEWA, DEPOT, TXJCD, IMKEY, DABRZ, POPTS, FIPOS, KSTRG, NPLNR, AUFPL, APLZL, PROJK, PAOBJNR, PASUBNR, SPGRS, SPGRC, BTYPE, ETYPE, XEGDR, LNRAN, HRKFT, DMBE2, DMBE3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, MWST2, MWST3, NAVH2, NAVH3, SKNT2, SKNT3, BDIF3, RDIF3, HWMET, GLUPM, XRAGL, UZAWE, LOKKT, FISTL, GEBER, STBUK, TXBH2, TXBH3, PPRCT, XREF1, XREF2, KBLNR, KBLPOS, STTAX, FKBER, OBZEI, XNEGP, RFZEI, CCBTC, KKBER, EMPFB, XREF3, DTWS1, DTWS2, DTWS3, DTWS4, GRICD, GRIRG, GITYP, XPYPR, KIDNO, ABSBT, IDXSP, LINFV, KONTT, KONTL, TXDAT, AGZEI, PYCUR, PYAMT, BUPLA, SECCO, LSTAR, CESSION_KZ, PRZNR, PPDIFF, PPDIF2, PPDIF3, PENLC1, PENLC2, PENLC3, PENFC, PENDAYS, PENRC, GRANT_NBR, SCTAX, FKBER_LONG, GMVKZ, SRTYPE, INTRENO, MEASURE, AUGGJ, PPA_EX_IND, DOCLN, SEGMENT, PSEGMENT, PFKBER, HKTID, KSTAR, XLGCLR, TAXPS, PAYS_PROV, PAYS_TRAN, MNDID, XFRGE_BSEG, RE_BUKRS, RE_ACCOUNT, PGEBER, PGRANT_NBR, BUDGET_PD, PBUDGET_PD, J_1TPBUPL, PEROP_BEG, PEROP_END, FASTPAY, IGNR_IVREF, FMFGUS_KEY, FMXDOCNR, FMXYEAR, FMXDOCLN, FMXZEKKN, PRODPER FROM BSEG

TOP ERP 6.0 | BSEG COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
3	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
4	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
5	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
6	BUZID	Identification of the Line Item	char	1	0	Allow NULL?
7	AUGDT	Clearing Date	nvarchar	8	0	Allow NULL?
8	AUGCP	Clearing Entry Date	nvarchar	8	0	Allow NULL?
9	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	Allow NULL?
10	BSCHL	Posting Key	nvarchar	2	0	Allow NULL?
11	KOART	Account Type	char	1	0	Allow NULL?
12	UMSKZ	Special G/L Indicator	char	1	0	Allow NULL?
13	UMSKS	Special G/L Transaction Type	char	1	0	Allow NULL?
14	ZUMSK	Target Special G/L Indicator	char	1	0	Allow NULL?
15	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
16	GSBER	Business Area	nvarchar	4	0	Allow NULL?
17	PARGB	Trading partner's business area	nvarchar	4	0	Allow NULL?
18	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
19	QSSKZ	Withholding Tax Code	nvarchar	2	0	Allow NULL?
20	ZZSPREG	Special Region	nvarchar	5	0	Allow NULL?
21	ZZBUSPARTN	Business partner	nvarchar	10	0	Allow NULL?
22	ZZCHAN	Distribution channel	nvarchar	4	0	Allow NULL?
23	ZZPRODUCT	Product group	nvarchar	10	0	Allow NULL?
24	ZZLOCA	City	nvarchar	4	0	Allow NULL?
25	ZZLOB	BUSINESS LINE	nvarchar	7	0	Allow NULL?
26	ZZUSERFLD1	Territory	nvarchar	9	0	Allow NULL?
27	ZZUSERFLD2	Owner/Cont.	nvarchar	12	0	Allow NULL?
28	ZZUSERFLD3	Vein	nvarchar	22	0	Allow NULL?
29	ZZSTATE	State/Province Code	nvarchar	3	0	Allow NULL?
30	ZZREGION	Location	nvarchar	3	0	Allow NULL?
31	DMBTR	Amount in Local Currency	decimal	13	2
32	WRBTR	Amount in document currency	decimal	13	2
33	KZBTR	Original Reduction Amount in Local Currency	decimal	13	2
34	PSWBT	Amount for Updating in General Ledger	decimal	13	2
35	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	Allow NULL?
36	TXBHW	Original Tax Base Amount in Local Currency	decimal	13	2
37	TXBFW	Original Tax Base Amount in Document Currency	decimal	13	2
38	MWSTS	Tax Amount in Local Currency	decimal	13	2
39	WMWST	Tax amount in document currency	decimal	13	2
40	HWBAS	Tax Base Amount in Local Currency	decimal	13	2
41	FWBAS	Tax Base Amount in Document Currency	decimal	13	2
42	HWZUZ	Provision Amount in Local Currency	decimal	13	2
43	FWZUZ	Additional Tax in Document Currency	decimal	13	2
44	SHZUZ	Debit/Credit Addition for Cash Discount	char	1	0	Allow NULL?
45	STEKZ	Version Number Component	nvarchar	2	0	Allow NULL?
46	MWART	Tax Type	char	1	0	Allow NULL?
47	TXGRP	Group Indicator for Tax Line Items	nvarchar	3	0	Allow NULL?
48	KTOSL	Transaction Key	nvarchar	3	0	Allow NULL?
49	QSSHB	Withholding Tax Base Amount	decimal	13	2
50	KURSR	Hedged Exchange Rate	decimal	9	5
51	GBETR	Hedged Amount in Foreign Currency	decimal	13	2
52	BDIFF	Valuation Difference	decimal	13	2
53	BDIF2	Valuation Difference for the Second Local Currency	decimal	13	2
54	VALUT	Value date	nvarchar	8	0	Allow NULL?
55	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
56	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
57	ZINKZ	Exempted from interest calculation	nvarchar	2	0	Allow NULL?
58	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
59	BEWAR	Transaction Type	nvarchar	3	0	Allow NULL?
60	ALTKT	Group account number	nvarchar	10	0	Allow NULL?
61	VORGN	Transaction Type for General Ledger	nvarchar	4	0	Allow NULL?
62	FDLEV	Planning level	nvarchar	2	0	Allow NULL?
63	FDGRP	Planning Group	nvarchar	10	0	Allow NULL?
64	FDWBT	Planning amount in document currency	decimal	13	2
65	FDTAG	Planning date	nvarchar	8	0	Allow NULL?
66	FKONT	Financial Budget Item	nvarchar	3	0	Allow NULL?
67	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
68	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
69	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	Allow NULL?
70	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
71	VBELN	Billing Document	nvarchar	10	0	Allow NULL?
72	VBEL2	Sales Document	nvarchar	10	0	Allow NULL?
73	POSN2	Sales Document Item	nvarchar	6	0	Allow NULL?
74	ETEN2	Delivery Schedule Line Number	nvarchar	4	0	Allow NULL?
75	ANLN1	Main Asset Number	nvarchar	12	0	Allow NULL?
76	ANLN2	Asset Subnumber	nvarchar	4	0	Allow NULL?
77	ANBWA	Asset Transaction Type	nvarchar	3	0	Allow NULL?
78	BZDAT	Asset value date	nvarchar	8	0	Allow NULL?
79	PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
80	XUMSW	Indicator: Sales-related item ?	char	1	0	Allow NULL?
81	XHRES	Indicator: Resident G/L account?	char	1	0	Allow NULL?
82	XKRES	Indicator: Can Line Items Be Displayed by Account?	char	1	0	Allow NULL?
83	XOPVW	Indicator: Open Item Management?	char	1	0	Allow NULL?
84	XCPDD	Indicator: Address and bank data set individually	char	1	0	Allow NULL?
85	XSKST	Indicator: Statistical posting to cost center	char	1	0	Allow NULL?
86	XSAUF	Indicator: Posting to order is statistical	char	1	0	Allow NULL?
87	XSPRO	Indicator: Posting to project is statistical	char	1	0	Allow NULL?
88	XSERG	Indicator: Posting to prof.analysis is statistical	char	1	0	Allow NULL?
89	XFAKT	Indicator: Billing document update successful ?	char	1	0	Allow NULL?
90	XUMAN	Indicator: Transfer posting from down payment ?	char	1	0	Allow NULL?
91	XANET	Indicator: Down payment in net procedure ?	char	1	0	Allow NULL?
92	XSKRL	Indicator: Line item not liable to cash discount?	char	1	0	Allow NULL?
93	XINVE	Indicator: Capital Goods Affected?	char	1	0	Allow NULL?
94	XPANZ	Display item	char	1	0	Allow NULL?
95	XAUTO	Indicator: Line item automatically created	char	1	0	Allow NULL?
96	XNCOP	Indicator: Items cannot be copied?	char	1	0	Allow NULL?
97	XZAHL	Indicator: Is the posting key used in a payment transaction?	char	1	0	Allow NULL?
98	SAKNR	G/L Account Number	nvarchar	10	0	Allow NULL?
99	HKONT	General Ledger Account	nvarchar	10	0	Allow NULL?
100	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
101	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
102	FILKD	Account Number of the Branch	nvarchar	10	0	Allow NULL?
103	XBILK	Indicator: Account is a balance sheet account?	char	1	0	Allow NULL?
104	GVTYP	P&L statement account type	nvarchar	2	0	Allow NULL?
105	HZUON	Assignment Number for Special G/L Accounts	nvarchar	18	0	Allow NULL?
106	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	Allow NULL?
107	ZTERM	Terms of Payment Key	nvarchar	4	0	Allow NULL?
108	ZBD1T	Cash discount days 1	decimal	3	0
109	ZBD2T	Cash discount days 2	decimal	3	0
110	ZBD3T	Net Payment Terms Period	decimal	3	0
111	ZBD1P	Cash Discount Percentage 1	decimal	5	3
112	ZBD2P	Cash Discount Percentage 2	decimal	5	3
113	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2
114	SKNTO	Cash discount amount in local currency	decimal	13	2
115	WSKTO	Cash discount amount in document currency	decimal	13	2
116	ZLSCH	Payment Method	char	1	0	Allow NULL?
117	ZLSPR	Payment Block Key	char	1	0	Allow NULL?
118	ZBFIX	Fixed Payment Terms	char	1	0	Allow NULL?
119	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
120	BVTYP	Partner Bank Type	nvarchar	4	0	Allow NULL?
121	NEBTR	Net Payment Amount	decimal	13	2
122	MWSK1	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
123	DMBT1	Amount in Local Currency for Tax Distribution	decimal	13	2
124	WRBT1	Amount in foreign currency for tax breakdown	decimal	13	2
125	MWSK2	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
126	DMBT2	Amount in Local Currency for Tax Distribution	decimal	13	2
127	WRBT2	Amount in foreign currency for tax breakdown	decimal	13	2
128	MWSK3	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
129	DMBT3	Amount in Local Currency for Tax Distribution	decimal	13	2
130	WRBT3	Amount in foreign currency for tax breakdown	decimal	13	2
131	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	Allow NULL?
132	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	Allow NULL?
133	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	Allow NULL?
134	REBZT	Follow-On Document Type	char	1	0	Allow NULL?
135	ZOLLT	Customs Tariff Number	nvarchar	8	0	Allow NULL?
136	ZOLLD	Customs Date	nvarchar	8	0	Allow NULL?
137	LZBKZ	State Central Bank Indicator	nvarchar	3	0	Allow NULL?
138	LANDL	Supplying Country	nvarchar	3	0	Allow NULL?
139	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	Allow NULL?
140	SAMNR	Invoice List Number	nvarchar	8	0	Allow NULL?
141	ABPER	Settlement period	nvarchar	6	0	Allow NULL?
142	VRSKZ	Insurance indicator	char	1	0	Allow NULL?
143	VRSDT	Insurance date	nvarchar	8	0	Allow NULL?
144	DISBN	Number of Bill of Exchange Usage Document (Discount Doc.)	nvarchar	10	0	Allow NULL?
145	DISBJ	Fiscal Year of Bill of Exchange Usage Document	nvarchar	4	0	Allow NULL?
146	DISBZ	Line Item within the Bill of Exchange Usage Document	nvarchar	3	0	Allow NULL?
147	WVERW	Bill of exchange usage type	char	1	0	Allow NULL?
148	ANFBN	Document Number of the Bill of Exchange Payment Request	nvarchar	10	0	Allow NULL?
149	ANFBJ	Fiscal Year of the Bill of Exchange Payment Request Document	nvarchar	4	0	Allow NULL?
150	ANFBU	Company Code in Which Bill of Exch.Payment Request Is Posted	nvarchar	4	0	Allow NULL?
151	ANFAE	Bill of Exchange Payment Request Due Date	nvarchar	8	0	Allow NULL?
152	BLNBT	Base Amount for Determining the Preference Amount	decimal	13	2
153	BLNKZ	Subsidy indicator for determining the reduction rates	nvarchar	2	0	Allow NULL?
154	BLNPZ	Preference Percentage Rate	decimal	7	2
155	MSCHL	Dunning key	char	1	0	Allow NULL?
156	MANSP	Dunning block	char	1	0	Allow NULL?
157	MADAT	Last dunned on	nvarchar	8	0	Allow NULL?
158	MANST	Dunning level	char	1	0	Allow NULL?
159	MABER	Dunning Area	nvarchar	2	0	Allow NULL?
160	ESRNR	ISR Subscriber Number	nvarchar	11	0	Allow NULL?
161	ESRRE	ISR Reference Number	nvarchar	27	0	Allow NULL?
162	ESRPZ	ISR Check Digit	nvarchar	2	0	Allow NULL?
163	KLIBT	Credit Control Amount	decimal	13	2
164	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	Allow NULL?
165	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2
166	QSFBT	Withholding Tax-Exempt Amount (in Document Currency)	decimal	13	2
167	NAVHW	Non-Deductible Input Tax (in Local Currency)	decimal	13	2
168	NAVFW	Non-Deductible Input Tax (in Document Currency)	decimal	13	2
169	MATNR	Material Number	nvarchar	18	0	Allow NULL?
170	WERKS	Plant	nvarchar	4	0	Allow NULL?
171	MENGE	Quantity	decimal	13	3
172	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
173	ERFMG	Quantity in Unit of Entry	decimal	13	3
174	ERFME	Unit of Entry	nvarchar	3	0	Allow NULL?
175	BPMNG	Quantity in Purchase Order Price Unit	decimal	13	3
176	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	Allow NULL?
177	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
178	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
179	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	Allow NULL?
180	ELIKZ	"Delivery Completed" Indicator	char	1	0	Allow NULL?
181	VPRSV	Price control indicator	char	1	0	Allow NULL?
182	PEINH	Price Unit	decimal	5	0
183	BWKEY	Valuation Area	nvarchar	4	0	Allow NULL?
184	BWTAR	Valuation Type	nvarchar	10	0	Allow NULL?
185	BUSTW	Posting string for values	nvarchar	4	0	Allow NULL?
186	REWRT	Invoice Value Entered (in Local Currency)	decimal	13	2
187	REWWR	Invoice value in foreign currency	decimal	13	2
188	BONFB	Amount Qualifying for Bonus in Local Currency	decimal	13	2
189	BUALT	Amount posted in alternative price control	decimal	13	2
190	PSALT	Alternative Price Control	char	1	0	Allow NULL?
191	NPREI	New price	decimal	11	2
192	TBTKZ	Indicator: subsequent debit/credit	char	1	0	Allow NULL?
193	SPGRP	Blocking reason: price	char	1	0	Allow NULL?
194	SPGRM	Blocking reason: quantity	char	1	0	Allow NULL?
195	SPGRT	Blocking Reason: Date	char	1	0	Allow NULL?
196	SPGRG	Blocking reason: order price quantity	char	1	0	Allow NULL?
197	SPGRV	Blocking reason: project budget	char	1	0	Allow NULL?
198	SPGRQ	Manual Blocking Reason	char	1	0	Allow NULL?
199	STCEG	VAT Registration Number	nvarchar	20	0	Allow NULL?
200	EGBLD	Country of Destination for Delivery of Goods	nvarchar	3	0	Allow NULL?
201	EGLLD	Supplying Country for Delivery of Goods	nvarchar	3	0	Allow NULL?
202	RSTGR	Reason Code for Payments	nvarchar	3	0	Allow NULL?
203	RYACQ	Year of acquisition	nvarchar	4	0	Allow NULL?
204	RPACQ	Period of Acquisition	nvarchar	3	0	Allow NULL?
205	RDIFF	Exchange Rate Gain/Loss Realized	decimal	13	2
206	RDIF2	Exchange Rate Difference Realized for Second Local Currency	decimal	13	2
207	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
208	XHKOM	Indicator: G/L account assigned manually ?	char	1	0	Allow NULL?
209	VNAME	Joint Venture	nvarchar	6	0	Allow NULL?
210	RECID	Recovery Indicator	nvarchar	2	0	Allow NULL?
211	EGRUP	Equity group	nvarchar	3	0	Allow NULL?
212	VPTNR	Partner account number	nvarchar	10	0	Allow NULL?
213	VERTT	Contract Type	char	1	0	Allow NULL?
214	VERTN	Contract Number	nvarchar	13	0	Allow NULL?
215	VBEWA	Flow Type	nvarchar	4	0	Allow NULL?
216	DEPOT	Securities Account	nvarchar	10	0	Allow NULL?
217	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
218	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	Allow NULL?
219	DABRZ	Reference Date for Settlement	nvarchar	8	0	Allow NULL?
220	POPTS	Real estate option rate	decimal	9	6
221	FIPOS	Commitment Item	nvarchar	14	0	Allow NULL?
222	KSTRG	Cost Object	nvarchar	12	0	Allow NULL?
223	NPLNR	Network Number for Account Assignment	nvarchar	12	0	Allow NULL?
224	AUFPL	Task list number for operations in order	nvarchar	10	0	Allow NULL?
225	APLZL	General counter for order	nvarchar	8	0	Allow NULL?
226	PROJK	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
227	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
228	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	0	Allow NULL?
229	SPGRS	Blocking Reason: Item Amount	char	1	0	Allow NULL?
230	SPGRC	Block.reason: quality	char	1	0	Allow NULL?
231	BTYPE	Payroll Type	nvarchar	2	0	Allow NULL?
232	ETYPE	Equity type	nvarchar	3	0	Allow NULL?
233	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	Allow NULL?
234	LNRAN	Sequence number of asset line items in fiscal year	nvarchar	5	0	Allow NULL?
235	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	Allow NULL?
236	DMBE2	Amount in Second Local Currency	decimal	13	2
237	DMBE3	Amount in Third Local Currency	decimal	13	2
238	DMB21	Amount in Second Local Currency for Tax Breakdown	decimal	13	2
239	DMB22	Amount in Second Local Currency for Tax Breakdown	decimal	13	2
240	DMB23	Amount in Second Local Currency for Tax Breakdown	decimal	13	2
241	DMB31	Amount in Third Local Currency for Tax Breakdown	decimal	13	2
242	DMB32	Amount in Third Local Currency for Tax Breakdown	decimal	13	2
243	DMB33	Amount in Third Local Currency for Tax Breakdown	decimal	13	2
244	MWST2	Tax Amount in Second Local Currency	decimal	13	2
245	MWST3	Tax Amount in Third Local Currency	decimal	13	2
246	NAVH2	Non-Deductible Input Tax in Second Local Currency	decimal	13	2
247	NAVH3	Non-Deductible Input Tax in Third Local Currency	decimal	13	2
248	SKNT2	Cash Discount Amount in Second Local Currency	decimal	13	2
249	SKNT3	Cash Discount Amount in Third Local Currency	decimal	13	2
250	BDIF3	Valuation Difference for the Third Local Currency	decimal	13	2
251	RDIF3	Exchange Rate Difference Realized for Third Local Currency	decimal	13	2
252	HWMET	Method with Which the Local Currency Amount Was Determined	char	1	0	Allow NULL?
253	GLUPM	Update Method for FM - FI-CA Integration	char	1	0	Allow NULL?
254	XRAGL	Indicator: Clearing was Reversed	char	1	0	Allow NULL?
255	UZAWE	Payment Method Supplement	nvarchar	2	0	Allow NULL?
256	LOKKT	Alternative account number in company code	nvarchar	10	0	Allow NULL?
257	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
258	GEBER	Fund	nvarchar	10	0	Allow NULL?
259	STBUK	Tax Company Code	nvarchar	4	0	Allow NULL?
260	TXBH2	Tax Base/Original Tax Base in Second Local Currency	decimal	13	2
261	TXBH3	Tax Base/Original Tax Base in Third Local Currency	decimal	13	2
262	PPRCT	Partner Profit Center	nvarchar	10	0	Allow NULL?
263	XREF1	Business partner reference key	nvarchar	12	0	Allow NULL?
264	XREF2	Business partner reference key	nvarchar	12	0	Allow NULL?
265	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	Allow NULL?
266	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	Allow NULL?
267	STTAX	Tax amount as statistical information in document currency	decimal	13	2
268	FKBER	Functional Area	nvarchar	4	0	Allow NULL?
269	OBZEI	Number of Line Item in Original Document	nvarchar	3	0	Allow NULL?
270	XNEGP	Indicator: Negative posting	char	1	0	Allow NULL?
271	RFZEI	Payment Card Item	nvarchar	3	0	Allow NULL?
272	CCBTC	Payment cards: Settlement run	nvarchar	10	0	Allow NULL?
273	KKBER	Credit control area	nvarchar	4	0	Allow NULL?
274	EMPFB	Payee/Payer	nvarchar	10	0	Allow NULL?
275	XREF3	Reference key for line item	nvarchar	20	0	Allow NULL?
276	DTWS1	Instruction key 1	nvarchar	2	0	Allow NULL?
277	DTWS2	Instruction key 2	nvarchar	2	0	Allow NULL?
278	DTWS3	Instruction key 3	nvarchar	2	0	Allow NULL?
279	DTWS4	Instruction key 4	nvarchar	2	0	Allow NULL?
280	GRICD	Activity Code for Gross Income Tax	nvarchar	2	0	Allow NULL?
281	GRIRG	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
282	GITYP	Distribution Type for Employment Tax	nvarchar	2	0	Allow NULL?
283	XPYPR	Indicator: Items from Payment Program Blocked	char	1	0	Allow NULL?
284	KIDNO	Payment Reference	nvarchar	30	0	Allow NULL?
285	ABSBT	Credit management: Hedged amount	decimal	13	2
286	IDXSP	Inflation Index	nvarchar	5	0	Allow NULL?
287	LINFV	Last Adjustment Date	nvarchar	8	0	Allow NULL?
288	KONTT	Account Assignment Category for Industry Solution	nvarchar	2	0	Allow NULL?
289	KONTL	Acct assignment string for industry-specific acct assignmnts	nvarchar	50	0	Allow NULL?
290	TXDAT	Date for defining tax rates	nvarchar	8	0	Allow NULL?
291	AGZEI	Clearing Item	decimal	5	0
292	PYCUR	Currency for Automatic Payment	nvarchar	5	0	Allow NULL?
293	PYAMT	Amount in Payment Currency	decimal	13	2
294	BUPLA	Business Place	nvarchar	4	0	Allow NULL?
295	SECCO	Section Code	nvarchar	4	0	Allow NULL?
296	LSTAR	Activity Type	nvarchar	6	0	Allow NULL?
297	CESSION_KZ	Accounts Receivable Pledging Indicator	nvarchar	2	0	Allow NULL?
298	PRZNR	Business Process	nvarchar	12	0	Allow NULL?
299	PPDIFF	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)	decimal	13	2
300	PPDIF2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)	decimal	13	2
301	PPDIF3	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)	decimal	13	2
302	PENLC1	Penalty charge amount in first local currency	decimal	13	2
303	PENLC2	Penalty charge amount in second local currency	decimal	13	2
304	PENLC3	Penalty Charge Amount in Third Local Currency	decimal	13	2
305	PENFC	Penalty charge amount in document currency	decimal	13	2
306	PENDAYS	Number of days for penalty charge calculation	int	10	0	Allow NULL?
307	PENRC	Reason for late payment	nvarchar	2	0	Allow NULL?
308	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
309	SCTAX	Tax portion FI-CA local currency	decimal	13	2
310	FKBER_LONG	Functional Area	nvarchar	16	0	Allow NULL?
311	GMVKZ	Item is in Execution	char	1	0	Allow NULL?
312	SRTYPE	Type of Additional Receivable	nvarchar	2	0	Allow NULL?
313	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	Allow NULL?
314	MEASURE	Funded Program	nvarchar	24	0	Allow NULL?
315	AUGGJ	Fiscal Year of Clearing Document	nvarchar	4	0	Allow NULL?
316	PPA_EX_IND	PPA Exclude Indicator	char	1	0	Allow NULL?
317	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0	Allow NULL?
318	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	Allow NULL?
319	PSEGMENT	Partner Segment for Segmental Reporting	nvarchar	10	0	Allow NULL?
320	PFKBER	Partner Functional Area	nvarchar	16	0	Allow NULL?
321	HKTID	ID for account details	nvarchar	5	0	Allow NULL?
322	KSTAR	Cost Element	nvarchar	10	0	Allow NULL?
323	XLGCLR	Clearing Specific to Ledger Groups	char	1	0	Allow NULL?
324	TAXPS	Tax document item number	nvarchar	6	0	Allow NULL?
325	PAYS_PROV	Payment Service Provider	nvarchar	4	0	Allow NULL?
326	PAYS_TRAN	Payment Reference of Payment Service Provider	nvarchar	35	0	Allow NULL?
327	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	Allow NULL?
328	XFRGE_BSEG	Payment Is Released	char	1	0	Allow NULL?
329	RE_BUKRS	Cash Ledger: Company Code for Expense/Revenue	nvarchar	4	0	Allow NULL?
330	RE_ACCOUNT	Cash Ledger: Expense or Revenue Account	nvarchar	10	0	Allow NULL?
331	PGEBER	Partner Fund	nvarchar	10	0	Allow NULL?
332	PGRANT_NBR	Partner Grant	nvarchar	20	0	Allow NULL?
333	BUDGET_PD	FM: Budget Period	nvarchar	10	0	Allow NULL?
334	PBUDGET_PD	FM: Partner Budget Period	nvarchar	10	0	Allow NULL?
335	J_1TPBUPL	Branch Code	nvarchar	5	0	Allow NULL?
336	PEROP_BEG	Billing Period of Performance Start Date	nvarchar	8	0	Allow NULL?
337	PEROP_END	Billing Period of Performance End Date	nvarchar	8	0	Allow NULL?
338	FASTPAY	PPA Fast Pay Indicator	char	1	0	Allow NULL?
339	IGNR_IVREF	FMFG: Ignore the invoice reference during FI doc splitting	char	1	0	Allow NULL?
340	FMFGUS_KEY	United States Federal Government Fields	nvarchar	22	0	Allow NULL?
341	FMXDOCNR	FM Reference Document Number	nvarchar	10	0	Allow NULL?
342	FMXYEAR	FM Reference Year	nvarchar	4	0	Allow NULL?
343	FMXDOCLN	FM Reference Line Item	nvarchar	6	0	Allow NULL?
344	FMXZEKKN	FM Reference Sequence Account Assignment	nvarchar	5	0	Allow NULL?
345	PRODPER	Production Month (Date to find period and year)	nvarchar	8	0	Allow NULL?

TOP ERP 6.0 | BSEG INDEXES

Name	Primary	Unique	Type	Columns
BSEG~0	Yes	Yes	CLUSTERED	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

345 COLUMNS | 1 INDEXES | ERP 6.0 | BSEG TABLE

TOP ERP 6.0 | BSEG COLUMNS

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

345 COLUMNS | 1 INDEXES | ERP 6.0 | BSEG TABLE

TOPERP 6.0 | BSEG COLUMNS

TOPERP 6.0 | BSEG INDEXES

TOP ERP 6.0 | BSEG COLUMNS

TOP ERP 6.0 | BSEG INDEXES