	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

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

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