	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

CH1030BSG1 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Sales and Distribution :: Sales :: Part Load Lift Orders :: Remaining Beverage - Obsolete Objects
1	ERP EHP7	6.0	/BEV3/CH1030BSG1	242	2	Document Segment CH Event Ledger Part1	Remaining Beverage - Obsolete Objects

SQL: selectupdate insert create

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

SELECT MANDT, EVENT, EVENT_NR, BUZEI, BUKRS, BELNR, GJAHR, BUZID, AUGDT, AUGCP, AUGBL, BSCHL, KOART, UMSKZ, UMSKS, ZUMSK, SHKZG, GSBER, PARGB, MWSKZ, QSSKZ, 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 FROM /BEV3/CH1030BSG1

TOP ERP 6.0 | /BEV3/CH1030BSG1 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	EVENT	Event for export of business data	nvarchar	8	0	CHAR	(N' ')	No	*	BUS_EVENT	Allow NULL?
3	EVENT_NR	CH BTE Sequence Number of Event Receipt	nvarchar	16	0	NUMC	(N'0000000000000000')	No		/BEV3/CHEVENR	Allow NULL?
4	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	No		BUZEI	Allow NULL?
5	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	*	BUKRS	Allow NULL?
6	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	No		BELNR_D	Allow NULL?
7	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
8	BUZID	Identification of the Line Item	char	1	0	CHAR	(N' ')	Yes		BUZID	Allow NULL?
9	AUGDT	Clearing Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGDT	Allow NULL?
10	AUGCP	Clearing Entry Date	nvarchar	8	0	DATS	(N'00000000')	Yes		AUGCP	Allow NULL?
11	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	CHAR	(N' ')	Yes		AUGBL	Allow NULL?
12	BSCHL	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	*	BSCHL	Allow NULL?
13	KOART	Account Type	char	1	0	CHAR	(N' ')	Yes		KOART	Allow NULL?
14	UMSKZ	Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	*	UMSKZ	Allow NULL?
15	UMSKS	Special G/L Transaction Type	char	1	0	CHAR	(N' ')	Yes		UMSKS	Allow NULL?
16	ZUMSK	Target Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	*	DZUMSK	Allow NULL?
17	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
18	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
19	PARGB	Trading partner's business area	nvarchar	4	0	CHAR	(N' ')	Yes	*	PARGB	Allow NULL?
20	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
21	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	*	QSSKZ	Allow NULL?
22	DMBTR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
23	WRBTR	Amount in document currency	decimal	13	2	CURR	((0))	Yes		WRBTR
24	KZBTR	Original Reduction Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		KZBTR_FI
25	PSWBT	Amount for Updating in General Ledger	decimal	13	2	CURR	((0))	Yes		PSWBT
26	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	CUKY	(N' ')	Yes	*	PSWSL	Allow NULL?
27	TXBHW	Original Tax Base Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		TXBHW
28	TXBFW	Original Tax Base Amount in Document Currency	decimal	13	2	CURR	((0))	Yes		TXBFW
29	MWSTS	Tax Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		MWSTS
30	WMWST	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		WMWST
31	HWBAS	Tax Base Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		HWBAS
32	FWBAS	Tax Base Amount in Document Currency	decimal	13	2	CURR	((0))	Yes		FWBAS
33	HWZUZ	Provision Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		HWZUZ
34	FWZUZ	Additional Tax in Document Currency	decimal	13	2	CURR	((0))	Yes		FWZUZ
35	SHZUZ	Debit/Credit Addition for Cash Discount	char	1	0	CHAR	(N' ')	Yes		SHZUZ	Allow NULL?
36	STEKZ	Version Number Component	nvarchar	2	0	CHAR	(N' ')	Yes		CHAR2	Allow NULL?
37	MWART	Tax Type	char	1	0	CHAR	(N' ')	Yes		MWART	Allow NULL?
38	TXGRP	Group Indicator for Tax Line Items	nvarchar	3	0	NUMC	(N'000')	Yes		TXGRP	Allow NULL?
39	KTOSL	Transaction Key	nvarchar	3	0	CHAR	(N' ')	Yes		KTOSL	Allow NULL?
40	QSSHB	Withholding Tax Base Amount	decimal	13	2	CURR	((0))	Yes		QSSHB
41	KURSR	Hedged Exchange Rate	decimal	9	5	DEC	((0))	Yes		KURSR
42	GBETR	Hedged Amount in Foreign Currency	decimal	13	2	CURR	((0))	Yes		GBETR
43	BDIFF	Valuation Difference	decimal	13	2	CURR	((0))	Yes		BDIFF
44	BDIF2	Valuation Difference for the Second Local Currency	decimal	13	2	CURR	((0))	Yes		BDIF2
45	VALUT	Value date	nvarchar	8	0	DATS	(N'00000000')	Yes		VALUT	Allow NULL?
46	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
47	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
48	ZINKZ	Exempted from interest calculation	nvarchar	2	0	CHAR	(N' ')	Yes		DZINKZ	Allow NULL?
49	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	*	RASSC	Allow NULL?
50	BEWAR	Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	*	RMVCT	Allow NULL?
51	ALTKT	Group account number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BILKT_SKA1	Allow NULL?
52	VORGN	Transaction Type for General Ledger	nvarchar	4	0	CHAR	(N' ')	Yes		VORGN	Allow NULL?
53	FDLEV	Planning level	nvarchar	2	0	CHAR	(N' ')	Yes	*	FDLEV	Allow NULL?
54	FDGRP	Planning Group	nvarchar	10	0	CHAR	(N' ')	Yes	*	FDGRP	Allow NULL?
55	FDWBT	Planning amount in document currency	decimal	13	2	CURR	((0))	Yes		FDWBT
56	FDTAG	Planning date	nvarchar	8	0	DATS	(N'00000000')	Yes		FDTAG	Allow NULL?
57	FKONT	Financial Budget Item	nvarchar	3	0	NUMC	(N'000')	Yes		FIPLS	Allow NULL?
58	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	KOKRS	Allow NULL?
59	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
60	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	CHAR	(N' ')	Yes		PROJN	Allow NULL?
61	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	AUFNR	Allow NULL?
62	VBELN	Billing Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VF	Allow NULL?
63	VBEL2	Sales Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VA	Allow NULL?
64	POSN2	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VA	Allow NULL?
65	ETEN2	Delivery Schedule Line Number	nvarchar	4	0	NUMC	(N'0000')	Yes	*	ETENR	Allow NULL?
66	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	ANLN1	Allow NULL?
67	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	*	ANLN2	Allow NULL?
68	ANBWA	Asset Transaction Type	nvarchar	3	0	CHAR	(N' ')	Yes	*	ANBWA	Allow NULL?
69	BZDAT	Asset value date	nvarchar	8	0	DATS	(N'00000000')	Yes		BZDAT	Allow NULL?
70	PERNR	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		PERNR_D	Allow NULL?
71	XUMSW	Indicator: Sales-related item ?	char	1	0	CHAR	(N' ')	Yes		XUMSW	Allow NULL?
72	XHRES	Indicator: Resident G/L account?	char	1	0	CHAR	(N' ')	Yes		XHRES	Allow NULL?
73	XKRES	Indicator: Can Line Items Be Displayed by Account?	char	1	0	CHAR	(N' ')	Yes		XKRES	Allow NULL?
74	XOPVW	Indicator: Open Item Management?	char	1	0	CHAR	(N' ')	Yes		XOPVW	Allow NULL?
75	XCPDD	Indicator: Address and bank data set individually	char	1	0	CHAR	(N' ')	Yes		XCPDD	Allow NULL?
76	XSKST	Indicator: Statistical posting to cost center	char	1	0	CHAR	(N' ')	Yes		XSKST	Allow NULL?
77	XSAUF	Indicator: Posting to order is statistical	char	1	0	CHAR	(N' ')	Yes		XSAUF	Allow NULL?
78	XSPRO	Indicator: Posting to project is statistical	char	1	0	CHAR	(N' ')	Yes		XSPRO	Allow NULL?
79	XSERG	Indicator: Posting to prof.analysis is statistical	char	1	0	CHAR	(N' ')	Yes		XSERG	Allow NULL?
80	XFAKT	Indicator: Billing document update successful ?	char	1	0	CHAR	(N' ')	Yes		XFAKT	Allow NULL?
81	XUMAN	Indicator: Transfer posting from down payment ?	char	1	0	CHAR	(N' ')	Yes		XUMAN	Allow NULL?
82	XANET	Indicator: Down payment in net procedure ?	char	1	0	CHAR	(N' ')	Yes		XANET	Allow NULL?
83	XSKRL	Indicator: Line item not liable to cash discount?	char	1	0	CHAR	(N' ')	Yes		XSKRL	Allow NULL?
84	XINVE	Indicator: Capital Goods Affected?	char	1	0	CHAR	(N' ')	Yes		XINVE	Allow NULL?
85	XPANZ	Display item	char	1	0	CHAR	(N' ')	Yes		XPANZ	Allow NULL?
86	XAUTO	Indicator: Line item automatically created	char	1	0	CHAR	(N' ')	Yes		XAUTO	Allow NULL?
87	XNCOP	Indicator: Items cannot be copied?	char	1	0	CHAR	(N' ')	Yes		XNCOP	Allow NULL?
88	XZAHL	Indicator: Is the posting key used in a payment transaction?	char	1	0	CHAR	(N' ')	Yes		XZAHL	Allow NULL?
89	SAKNR	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SAKNR	Allow NULL?
90	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	HKONT	Allow NULL?
91	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNNR	Allow NULL?
92	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	Yes	*	LIFNR	Allow NULL?
93	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
94	XBILK	Indicator: Account is a balance sheet account?	char	1	0	CHAR	(N' ')	Yes		XBILK	Allow NULL?
95	GVTYP	P&L statement account type	nvarchar	2	0	CHAR	(N' ')	Yes		GVTYP	Allow NULL?
96	HZUON	Assignment Number for Special G/L Accounts	nvarchar	18	0	CHAR	(N' ')	Yes		HZUON	Allow NULL?
97	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
98	ZTERM	Terms of Payment Key	nvarchar	4	0	CHAR	(N' ')	Yes		DZTERM	Allow NULL?
99	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	Yes		DZBD1T
100	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	Yes		DZBD2T
101	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	Yes		DZBD3T
102	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	Yes		DZBD1P
103	ZBD2P	Cash Discount Percentage 2	decimal	5	3	DEC	((0))	Yes		DZBD2P
104	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2	CURR	((0))	Yes		SKFBT
105	SKNTO	Cash discount amount in local currency	decimal	13	2	CURR	((0))	Yes		SKNTO
106	WSKTO	Cash discount amount in document currency	decimal	13	2	CURR	((0))	Yes		WSKTO
107	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	*	SCHZW_BSEG	Allow NULL?
108	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	*	DZLSPR	Allow NULL?
109	ZBFIX	Fixed Payment Terms	char	1	0	CHAR	(N' ')	Yes		DZBFIX	Allow NULL?
110	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	*	HBKID	Allow NULL?
111	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
112	NEBTR	Net Payment Amount	decimal	13	2	CURR	((0))	Yes		NEBTR
113	MWSK1	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
114	DMBT1	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
115	WRBT1	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
116	MWSK2	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
117	DMBT2	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
118	WRBT2	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
119	MWSK3	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
120	DMBT3	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
121	WRBT3	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
122	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	CHAR	(N' ')	Yes		REBZG	Allow NULL?
123	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
124	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		REBZZ	Allow NULL?
125	REBZT	Follow-On Document Type	char	1	0	CHAR	(N' ')	Yes		REBZT	Allow NULL?
126	ZOLLT	Customs Tariff Number	nvarchar	8	0	CHAR	(N' ')	Yes		DZOLLT	Allow NULL?
127	ZOLLD	Customs Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DZOLLD	Allow NULL?
128	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	*	LZBKZ	Allow NULL?
129	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	*	LANDL	Allow NULL?
130	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	CHAR	(N' ')	Yes		DIEKZ	Allow NULL?
131	SAMNR	Invoice List Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		SAMNR	Allow NULL?
132	ABPER	Settlement period	nvarchar	6	0	ACCP	(N' ')	Yes		ABPER_RF	Allow NULL?
133	VRSKZ	Insurance indicator	char	1	0	CHAR	(N' ')	Yes		VRSKZ	Allow NULL?
134	VRSDT	Insurance date	nvarchar	8	0	DATS	(N'00000000')	Yes		VRSDT	Allow NULL?
135	DISBN	Number of Bill of Exchange Usage Document (Discount Doc.)	nvarchar	10	0	CHAR	(N' ')	Yes		DISBN	Allow NULL?
136	DISBJ	Fiscal Year of Bill of Exchange Usage Document	nvarchar	4	0	NUMC	(N'0000')	Yes		DISBJ	Allow NULL?
137	DISBZ	Line Item within the Bill of Exchange Usage Document	nvarchar	3	0	NUMC	(N'000')	Yes		DISBZ	Allow NULL?
138	WVERW	Bill of exchange usage type	char	1	0	CHAR	(N' ')	Yes		WVERW	Allow NULL?
139	ANFBN	Document Number of the Bill of Exchange Payment Request	nvarchar	10	0	CHAR	(N' ')	Yes		ANFBN	Allow NULL?
140	ANFBJ	Fiscal Year of the Bill of Exchange Payment Request Document	nvarchar	4	0	NUMC	(N'0000')	Yes		ANFBJ	Allow NULL?
141	ANFBU	Company Code in Which Bill of Exch.Payment Request Is Posted	nvarchar	4	0	CHAR	(N' ')	Yes	*	ANFBU	Allow NULL?
142	ANFAE	Bill of Exchange Payment Request Due Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ANFAE	Allow NULL?
143	BLNBT	Base Amount for Determining the Preference Amount	decimal	13	2	CURR	((0))	Yes		BLNBT
144	BLNKZ	Subsidy indicator for determining the reduction rates	nvarchar	2	0	CHAR	(N' ')	Yes	*	BLNKZ	Allow NULL?
145	BLNPZ	Preference Percentage Rate	decimal	7	2	DEC	((0))	Yes		BLNPZ
146	MSCHL	Dunning key	char	1	0	CHAR	(N' ')	Yes	*	MSCHL	Allow NULL?
147	MANSP	Dunning block	char	1	0	CHAR	(N' ')	Yes	*	MANSP	Allow NULL?
148	MADAT	Last dunned on	nvarchar	8	0	DATS	(N'00000000')	Yes		MADAT	Allow NULL?
149	MANST	Dunning level	char	1	0	NUMC	(N'0')	Yes		MAHNS_D	Allow NULL?
150	MABER	Dunning Area	nvarchar	2	0	CHAR	(N' ')	Yes	*	MABER	Allow NULL?
151	ESRNR	ISR Subscriber Number	nvarchar	11	0	CHAR	(N' ')	Yes		ESRNR	Allow NULL?
152	ESRRE	ISR Reference Number	nvarchar	27	0	CHAR	(N' ')	Yes		ESRRE	Allow NULL?
153	ESRPZ	ISR Check Digit	nvarchar	2	0	CHAR	(N' ')	Yes		ESRPZ	Allow NULL?
154	KLIBT	Credit Control Amount	decimal	13	2	CURR	((0))	Yes		KLIBT
155	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	CHAR	(N' ')	Yes		QSZNR	Allow NULL?
156	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QBSHB
157	QSFBT	Withholding Tax-Exempt Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QSFBT
158	NAVHW	Non-Deductible Input Tax (in Local Currency)	decimal	13	2	CURR	((0))	Yes		NAVHW
159	NAVFW	Non-Deductible Input Tax (in Document Currency)	decimal	13	2	CURR	((0))	Yes		NAVFW
160	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	*	MATNR	Allow NULL?
161	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	*	WERKS_D	Allow NULL?
162	MENGE	Quantity	decimal	13	3	QUAN	((0))	Yes		MENGE_D
163	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
164	ERFMG	Quantity in Unit of Entry	decimal	13	3	QUAN	((0))	Yes		ERFMG
165	ERFME	Unit of Entry	nvarchar	3	0	UNIT	(N' ')	Yes	*	ERFME	Allow NULL?
166	BPMNG	Quantity in Purchase Order Price Unit	decimal	13	3	QUAN	((0))	Yes		BPMNG
167	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	UNIT	(N' ')	Yes	*	BPRME	Allow NULL?
168	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	EBELN	Allow NULL?
169	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	*	EBELP	Allow NULL?
170	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	NUMC	(N'00')	Yes		DZEKKN	Allow NULL?
171	ELIKZ	"Delivery Completed" Indicator	char	1	0	CHAR	(N' ')	Yes		ELIKZ	Allow NULL?
172	VPRSV	Price control indicator	char	1	0	CHAR	(N' ')	Yes		VPRSV	Allow NULL?
173	PEINH	Price Unit	decimal	5	0	DEC	((0))	Yes		PEINH
174	BWKEY	Valuation Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	BWKEY	Allow NULL?
175	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	BWTAR_D	Allow NULL?
176	BUSTW	Posting string for values	nvarchar	4	0	CHAR	(N' ')	Yes		BUSTW	Allow NULL?
177	REWRT	Invoice Value Entered (in Local Currency)	decimal	13	2	CURR	((0))	Yes		REEWR
178	REWWR	Invoice value in foreign currency	decimal	13	2	CURR	((0))	Yes		REFWR
179	BONFB	Amount Qualifying for Bonus in Local Currency	decimal	13	2	CURR	((0))	Yes		BONFB
180	BUALT	Amount posted in alternative price control	decimal	13	2	CURR	((0))	Yes		BUALT
181	PSALT	Alternative Price Control	char	1	0	CHAR	(N' ')	Yes		PSALT	Allow NULL?
182	NPREI	New price	decimal	11	2	CURR	((0))	Yes		NPREI
183	TBTKZ	Indicator: subsequent debit/credit	char	1	0	CHAR	(N' ')	Yes		TBTKZ	Allow NULL?
184	SPGRP	Blocking reason: price	char	1	0	CHAR	(N' ')	Yes		SPGRP	Allow NULL?
185	SPGRM	Blocking reason: quantity	char	1	0	CHAR	(N' ')	Yes		SPGRM	Allow NULL?
186	SPGRT	Blocking Reason: Date	char	1	0	CHAR	(N' ')	Yes		SPGRT	Allow NULL?
187	SPGRG	Blocking reason: order price quantity	char	1	0	CHAR	(N' ')	Yes		SPGRG	Allow NULL?
188	SPGRV	Blocking reason: project budget	char	1	0	CHAR	(N' ')	Yes		SPGRV	Allow NULL?
189	SPGRQ	Manual Blocking Reason	char	1	0	CHAR	(N' ')	Yes		SPGRQ	Allow NULL?
190	STCEG	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
191	EGBLD	Country of Destination for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	*	EGBLD	Allow NULL?
192	EGLLD	Supplying Country for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	*	EGLLD	Allow NULL?
193	RSTGR	Reason Code for Payments	nvarchar	3	0	CHAR	(N' ')	Yes	*	RSTGR	Allow NULL?
194	RYACQ	Year of acquisition	nvarchar	4	0	CHAR	(N' ')	Yes		RYACQ	Allow NULL?
195	RPACQ	Period of Acquisition	nvarchar	3	0	NUMC	(N'000')	Yes		RPACQ	Allow NULL?
196	RDIFF	Exchange Rate Gain/Loss Realized	decimal	13	2	CURR	((0))	Yes		RDIFF
197	RDIF2	Exchange Rate Difference Realized for Second Local Currency	decimal	13	2	CURR	((0))	Yes		RDIF2
198	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
199	XHKOM	Indicator: G/L account assigned manually ?	char	1	0	CHAR	(N' ')	Yes		XHKOM	Allow NULL?
200	VNAME	Joint Venture	nvarchar	6	0	CHAR	(N' ')	Yes	*	JV_NAME	Allow NULL?
201	RECID	Recovery Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	*	JV_RECIND	Allow NULL?
202	EGRUP	Equity group	nvarchar	3	0	CHAR	(N' ')	Yes	*	JV_EGROUP	Allow NULL?
203	VPTNR	Partner account number	nvarchar	10	0	CHAR	(N' ')	Yes	*	JV_PART	Allow NULL?
204	VERTT	Contract Type	char	1	0	CHAR	(N' ')	Yes		RANTYP	Allow NULL?
205	VERTN	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
206	VBEWA	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	SBEWART	Allow NULL?
207	DEPOT	Securities Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	RLDEPO	Allow NULL?
208	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	*	TXJCD	Allow NULL?
209	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
210	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
211	POPTS	Real estate option rate	decimal	9	6	DEC	((0))	Yes		POPTSATZ
212	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
213	KSTRG	Cost Object	nvarchar	12	0	CHAR	(N' ')	Yes	*	KSTRG	Allow NULL?
214	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	*	NPLNR	Allow NULL?
215	AUFPL	Task list number for operations in order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		AUFPL_CH	Allow NULL?
216	APLZL	General counter for order	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	APLZL_CH	Allow NULL?
217	PROJK	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
218	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEOBJNR	Allow NULL?
219	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	0	NUMC	(N'0000')	Yes		RKESUBNR	Allow NULL?
220	SPGRS	Blocking Reason: Item Amount	char	1	0	CHAR	(N' ')	Yes		SPGRS	Allow NULL?
221	SPGRC	Block.reason: quality	char	1	0	CHAR	(N' ')	Yes		SPGRC	Allow NULL?
222	BTYPE	Payroll Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	JV_BILIND	Allow NULL?
223	ETYPE	Equity type	nvarchar	3	0	CHAR	(N' ')	Yes	*	JV_ETYPE	Allow NULL?
224	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	CHAR	(N' ')	Yes		XEGDR	Allow NULL?
225	LNRAN	Sequence number of asset line items in fiscal year	nvarchar	5	0	NUMC	(N'00000')	Yes	*	LNRAN	Allow NULL?
226	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	CHAR	(N' ')	Yes	*	HRKFT	Allow NULL?
227	DMBE2	Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE2
228	DMBE3	Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE3
229	DMB21	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
230	DMB22	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
231	DMB23	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
232	DMB31	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
233	DMB32	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
234	DMB33	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
235	MWST2	Tax Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		MWST2
236	MWST3	Tax Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		MWST3
237	NAVH2	Non-Deductible Input Tax in Second Local Currency	decimal	13	2	CURR	((0))	Yes		NAVH2
238	NAVH3	Non-Deductible Input Tax in Third Local Currency	decimal	13	2	CURR	((0))	Yes		NAVH3
239	SKNT2	Cash Discount Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		SKNT2
240	SKNT3	Cash Discount Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		SKNT3
241	BDIF3	Valuation Difference for the Third Local Currency	decimal	13	2	CURR	((0))	Yes		BDIF3
242	RDIF3	Exchange Rate Difference Realized for Third Local Currency	decimal	13	2	CURR	((0))	Yes		RDIF3

TOP ERP 6.0 | /BEV3/CH1030BSG1 INDEXES

Name	Primary	Unique	Type	Columns
/BEV3/CH1030BSG1EN	No	No	NONCLUSTERED	EVENT_NR
/BEV3/CH1030BSG1~0	Yes	Yes	CLUSTERED	BUZEI, EVENT_NR, EVENT, 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

242 COLUMNS | 2 INDEXES | ERP 6.0 | /BEV3/CH1030BSG1 TABLE

TOP ERP 6.0 | /BEV3/CH1030BSG1 COLUMNS

TOP ERP 6.0 | /BEV3/CH1030BSG1 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

242 COLUMNS | 2 INDEXES | ERP 6.0 | /BEV3/CH1030BSG1 TABLE

TOPERP 6.0 | /BEV3/CH1030BSG1 COLUMNS

TOPERP 6.0 | /BEV3/CH1030BSG1 INDEXES

TOP ERP 6.0 | /BEV3/CH1030BSG1 COLUMNS

TOP ERP 6.0 | /BEV3/CH1030BSG1 INDEXES