	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

191 COLUMNS | 1 INDEXES | ERP 6.0 | REGUP TABLE

ERP EHP7

6.0

191

Processed items from payment program

SQL: selectupdate insert create

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

SELECT MANDT, LAUFD, LAUFI, XVORL, ZBUKR, LIFNR, KUNNR, EMPFG, VBLNR, BUKRS, BELNR, GJAHR, BUZEI, FILKD, ZLSCH, WAERS, HBKID, BVTYP, POKEN, XBLNR, BLART, BUDAT, BLDAT, KOART, BSCHL, HKONT, SAKNR, UMSKZ, UMSKS, ZUMSK, SHKZG, DMBTR, WRBTR, BDIFF, GSBER, MWSKZ, MWSTS, WMWST, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, SGTXT, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZBFIX, ZLSPR, SPLEV, XREBZ, ZOLLT, ZOLLD, LZBKZ, LANDL, DIEKZ, QSSKZ, QSSHB, QBSHB, QBSHH, ESRNR, ESRRE, ESRPZ, ZBDXT, ZBDXP, MSHBT, MSFBT, PROJN, AUFNR, ANLN1, ANLN2, EBELN, EBELP, XANET, XNETB, XNACH, ZWELS, VBUND, STCEG, EGBLD, EGLLD, QSZNR, BDIF2, DSKVH, POKLA, FIPOS, PROJK, NPLNR, AUFPL, APLZL, XEGDR, BDIF3, DMBE2, DMBE3, MWST2, SKNT2, SKNT3, QBSH2, QBSH3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, UZAWE, MWST3, ZUONR, OSKTO, VERTN, IMKEY, REBZT, REBZG, REBZJ, REBZZ, KOSTL, XINVE, VBEL2, VPOS2, ZEKKN, POSN2, ETEN2, FISTL, GEBER, DABRZ, KKBER, EMPFB, PRCTR, XREF1, XREF2, XREF3, ZINKZ, DTWS1, DTWS2, DTWS3, DTWS4, MANSP, KIDNO, XCPDD, VERTT, VBEWA, AGZEI, PSWSL, PSWBT, PSSKT, XPYAM, GDIFF, GDIF2, GDIF3, BUPLA, SECCO, XSAEN, KBLNR, KBLPOS, CESSION_KZ, KEYNO, PAMTF, ORIGIN, PENLC1, PENLC2, PENLC3, PENFC, PENDAYS, PPRCT, GRANT_NBR, FKBER, SNAME1, SORT01, SLAND1, SAMNR, MABER, BUDGET_PD, SNAME2, SNAME3, SNAME4, SSTRAS, SSTRS2, SPSTLZ, SID, EXTACCOUNT FROM REGUP

TOP ERP 6.0 | REGUP 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	T000	MANDT	Allow NULL?
2	LAUFD	Date on Which the Program Is to Be Run	nvarchar	8	0	DATS	(N'00000000')	No		LAUFD	Allow NULL?
3	LAUFI	Additional Identification	nvarchar	6	0	CHAR	(N' ')	No		LAUFI	Allow NULL?
4	XVORL	Indicator: Only Proposal Run?	char	1	0	CHAR	(N' ')	No		XVORL	Allow NULL?
5	ZBUKR	Paying company code	nvarchar	4	0	CHAR	(N' ')	No	T001	DZBUKR	Allow NULL?
6	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR	(N' ')	No	LFA1	LIFNR	Allow NULL?
7	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	No	KNA1	KUNNR	Allow NULL?
8	EMPFG	Payee code	nvarchar	16	0	CHAR	(N' ')	No		EMPFG	Allow NULL?
9	VBLNR	Document Number of the Payment Document	nvarchar	10	0	CHAR	(N' ')	No		VBLNR	Allow NULL?
10	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
11	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	No		BELNR_D	Allow NULL?
12	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
13	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	No		BUZEI	Allow NULL?
14	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
15	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	T042Z	DZLSCH	Allow NULL?
16	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
17	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
18	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
19	POKEN	Item Indicator	nvarchar	3	0	CHAR	(N' ')	Yes		POKEN	Allow NULL?
20	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	Yes		XBLNR1	Allow NULL?
21	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	T003	BLART	Allow NULL?
22	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
23	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BLDAT	Allow NULL?
24	KOART	Account Type	char	1	0	CHAR	(N' ')	Yes		KOART	Allow NULL?
25	BSCHL	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	TBSL	BSCHL	Allow NULL?
26	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	SKB1	HKONT	Allow NULL?
27	SAKNR	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	SKB1	SAKNR	Allow NULL?
28	UMSKZ	Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	T074U	UMSKZ	Allow NULL?
29	UMSKS	Special G/L Transaction Type	char	1	0	CHAR	(N' ')	Yes		UMSKS	Allow NULL?
30	ZUMSK	Target Special G/L Indicator	char	1	0	CHAR	(N' ')	Yes	T074U	DZUMSK	Allow NULL?
31	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
32	DMBTR	Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		DMBTR
33	WRBTR	Amount in document currency	decimal	13	2	CURR	((0))	Yes		WRBTR
34	BDIFF	Valuation Difference	decimal	13	2	CURR	((0))	Yes		BDIFF
35	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
36	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKZ	Allow NULL?
37	MWSTS	Tax Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		MWSTS
38	WMWST	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		WMWST
39	MWSK1	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
40	DMBT1	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
41	WRBT1	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
42	MWSK2	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
43	DMBT2	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
44	WRBT2	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
45	MWSK3	Tax Code for Distribution	nvarchar	2	0	CHAR	(N' ')	Yes	*	MWSKX	Allow NULL?
46	DMBT3	Amount in Local Currency for Tax Distribution	decimal	13	2	CURR	((0))	Yes		DMBTX
47	WRBT3	Amount in foreign currency for tax breakdown	decimal	13	2	CURR	((0))	Yes		WRBTX
48	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
49	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
50	ZTERM	Terms of Payment Key	nvarchar	4	0	CHAR	(N' ')	Yes		DZTERM	Allow NULL?
51	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	Yes		DZBD1T
52	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	Yes		DZBD2T
53	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	Yes		DZBD3T
54	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	Yes		DZBD1P
55	ZBD2P	Cash Discount Percentage 2	decimal	5	3	DEC	((0))	Yes		DZBD2P
56	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2	CURR	((0))	Yes		SKFBT
57	SKNTO	Cash discount amount in local currency	decimal	13	2	CURR	((0))	Yes		SKNTO
58	WSKTO	Cash discount amount in document currency	decimal	13	2	CURR	((0))	Yes		WSKTO
59	ZBFIX	Fixed Payment Terms	char	1	0	CHAR	(N' ')	Yes		DZBFIX	Allow NULL?
60	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
61	SPLEV	Level on Which a Payment Block has Taken Place	char	1	0	CHAR	(N' ')	Yes		SPLEV	Allow NULL?
62	XREBZ	Indicator: Item is an Invoice-Related Credit Memo	char	1	0	CHAR	(N' ')	Yes		XREBZ	Allow NULL?
63	ZOLLT	Customs Tariff Number	nvarchar	8	0	CHAR	(N' ')	Yes		DZOLLT	Allow NULL?
64	ZOLLD	Customs Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DZOLLD	Allow NULL?
65	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	T015L	LZBKZ	Allow NULL?
66	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL	Allow NULL?
67	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	CHAR	(N' ')	Yes		DIEKZ	Allow NULL?
68	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	*	QSSKZ	Allow NULL?
69	QSSHB	Withholding Tax Base Amount	decimal	13	2	CURR	((0))	Yes		QSSHB
70	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QBSHB
71	QBSHH	Withholding Tax Amount (in Local Currency)	decimal	13	2	CURR	((0))	Yes		QBSHH
72	ESRNR	ISR Subscriber Number	nvarchar	11	0	CHAR	(N' ')	Yes		ESRNR	Allow NULL?
73	ESRRE	ISR Reference Number	nvarchar	27	0	CHAR	(N' ')	Yes		ESRRE	Allow NULL?
74	ESRPZ	ISR Check Digit	nvarchar	2	0	CHAR	(N' ')	Yes		ESRPZ	Allow NULL?
75	ZBDXT	Selected cash discount days	decimal	3	0	DEC	((0))	Yes		DZBDXT
76	ZBDXP	Selected cash discount percentage rate	decimal	5	3	DEC	((0))	Yes		DZBDXP
77	MSHBT	Maximum Cash Discount Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		MSHBT
78	MSFBT	Maximum Cash Discount Amount in Foreign Currency	decimal	13	2	CURR	((0))	Yes		MSFBT
79	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	CHAR	(N' ')	Yes		PROJN	Allow NULL?
80	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
81	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	ANLH	ANLN1	Allow NULL?
82	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	ANLA	ANLN2	Allow NULL?
83	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	EBELN	Allow NULL?
84	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	EBELP	Allow NULL?
85	XANET	Indicator: Down payment in net procedure ?	char	1	0	CHAR	(N' ')	Yes		XANET	Allow NULL?
86	XNETB	Indicator: Document posted net ?	char	1	0	CHAR	(N' ')	Yes		XNETB	Allow NULL?
87	XNACH	Indicator: Document Data Must be Reread	char	1	0	CHAR	(N' ')	Yes		XNACH	Allow NULL?
88	ZWELS	List of the Payment Methods to be Considered	nvarchar	10	0	CHAR	(N' ')	Yes		DZWELS	Allow NULL?
89	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	T880	RASSC	Allow NULL?
90	STCEG	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
91	EGBLD	Country of Destination for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	*	EGBLD	Allow NULL?
92	EGLLD	Supplying Country for Delivery of Goods	nvarchar	3	0	CHAR	(N' ')	Yes	*	EGLLD	Allow NULL?
93	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	CHAR	(N' ')	Yes		QSZNR	Allow NULL?
94	BDIF2	Valuation Difference for the Second Local Currency	decimal	13	2	CURR	((0))	Yes		BDIF2
95	DSKVH	Impending Lost Cash Discount in Local Currency	decimal	13	2	CURR	((0))	Yes		DSKVH
96	POKLA	Item Classification for Online Check Printing	char	1	0	CHAR	(N' ')	Yes		POKLA	Allow NULL?
97	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
98	PROJK	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_PSP_PNR	Allow NULL?
99	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	*	NPLNR	Allow NULL?
100	AUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
101	APLZL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
102	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	CHAR	(N' ')	Yes		XEGDR	Allow NULL?
103	BDIF3	Valuation Difference for the Third Local Currency	decimal	13	2	CURR	((0))	Yes		BDIF3
104	DMBE2	Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE2
105	DMBE3	Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		DMBE3
106	MWST2	Tax Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		MWST2
107	SKNT2	Cash Discount Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		SKNT2
108	SKNT3	Cash Discount Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		SKNT3
109	QBSH2	Withholding Tax Amount in Second Local Currency	decimal	13	2	CURR	((0))	Yes		QBSH2
110	QBSH3	Withholding Tax Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		QBSH3
111	DMB21	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
112	DMB22	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
113	DMB23	Amount in Second Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB2X
114	DMB31	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
115	DMB32	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
116	DMB33	Amount in Third Local Currency for Tax Breakdown	decimal	13	2	CURR	((0))	Yes		DMB3X
117	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	T042F	UZAWE	Allow NULL?
118	MWST3	Tax Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		MWST3
119	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
120	OSKTO	Cash discount amount in local currency	decimal	13	2	CURR	((0))	Yes		SKNTO
121	VERTN	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
122	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
123	REBZT	Follow-On Document Type	char	1	0	CHAR	(N' ')	Yes		REBZT	Allow NULL?
124	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	CHAR	(N' ')	Yes		REBZG	Allow NULL?
125	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
126	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	NUMC	(N'000')	Yes		REBZZ	Allow NULL?
127	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
128	XINVE	Indicator: Capital Goods Affected?	char	1	0	CHAR	(N' ')	Yes		XINVE	Allow NULL?
129	VBEL2	Sales Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	VBELN_VA	Allow NULL?
130	VPOS2	Numeric field: Length 6	nvarchar	6	0	NUMC	(N'000000')	Yes		NUM06	Allow NULL?
131	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	NUMC	(N'00')	Yes		DZEKKN	Allow NULL?
132	POSN2	Sales Document Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	POSNR_VA	Allow NULL?
133	ETEN2	Delivery Schedule Line Number	nvarchar	4	0	NUMC	(N'0000')	Yes	*	ETENR	Allow NULL?
134	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
135	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
136	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
137	KKBER	Credit control area	nvarchar	4	0	CHAR	(N' ')	Yes	T014	KKBER	Allow NULL?
138	EMPFB	Payee/Payer	nvarchar	10	0	CHAR	(N' ')	Yes		EMPFB	Allow NULL?
139	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
140	XREF1	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF1	Allow NULL?
141	XREF2	Business partner reference key	nvarchar	12	0	CHAR	(N' ')	Yes		XREF2	Allow NULL?
142	XREF3	Reference key for line item	nvarchar	20	0	CHAR	(N' ')	Yes		XREF3	Allow NULL?
143	ZINKZ	Exempted from interest calculation	nvarchar	2	0	CHAR	(N' ')	Yes		DZINKZ	Allow NULL?
144	DTWS1	Instruction key 1	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT16	Allow NULL?
145	DTWS2	Instruction key 2	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT17	Allow NULL?
146	DTWS3	Instruction key 3	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT18	Allow NULL?
147	DTWS4	Instruction key 4	nvarchar	2	0	NUMC	(N'00')	Yes	*	DTAT19	Allow NULL?
148	MANSP	Dunning block	char	1	0	CHAR	(N' ')	Yes	*	MANSP	Allow NULL?
149	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
150	XCPDD	Indicator: Address and bank data set individually	char	1	0	CHAR	(N' ')	Yes		XCPDD	Allow NULL?
151	VERTT	Contract Type	char	1	0	CHAR	(N' ')	Yes		RANTYP	Allow NULL?
152	VBEWA	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	SBEWART	Allow NULL?
153	AGZEI	Clearing Item	decimal	5	0	DEC	((0))	Yes		AGZEI
154	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	CUKY	(N' ')	Yes	*	PSWSL	Allow NULL?
155	PSWBT	Amount for Updating in General Ledger	decimal	13	2	CURR	((0))	Yes		PSWBT
156	PSSKT	Cash Discount Deduction for the Item	decimal	13	2	CURR	((0))	Yes		PSSKT
157	XPYAM	Indicator: Payment Amount Predefined	char	1	0	CHAR	(N' ')	Yes		XPYAM	Allow NULL?
158	GDIFF	Total Exchange Rate Difference	decimal	13	2	CURR	((0))	Yes		GDIFF
159	GDIF2	Total Exchange Rate Difference	decimal	13	2	CURR	((0))	Yes		GDIFF
160	GDIF3	Total Exchange Rate Difference	decimal	13	2	CURR	((0))	Yes		GDIFF
161	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUPLA	Allow NULL?
162	SECCO	Section Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	SECCO	Allow NULL?
163	XSAEN	Indicator: Unconfirmed master data change	char	1	0	CHAR	(N' ')	Yes		XSAEN	Allow NULL?
164	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	*	KBLNR_FI	Allow NULL?
165	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	*	KBLPOS	Allow NULL?
166	CESSION_KZ	Accounts Receivable Pledging Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	TCESSION	CESSION_KZ	Allow NULL?
167	KEYNO	Key Number for Payment Request	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRQ_KEYNO	Allow NULL?
168	PAMTF	Payment Request Amount in Payment Currency	decimal	13	2	CURR	((0))	Yes		PRQ_AMTFC
169	ORIGIN	Origin Indicator	nvarchar	8	0	CHAR	(N' ')	Yes	TFIBLORIGIN	FIBL_ORIGIN	Allow NULL?
170	PENLC1	Penalty charge amount in first local currency	decimal	13	2	CURR	((0))	Yes		PENALTY1
171	PENLC2	Penalty charge amount in second local currency	decimal	13	2	CURR	((0))	Yes		PENALTY2
172	PENLC3	Penalty Charge Amount in Third Local Currency	decimal	13	2	CURR	((0))	Yes		PENALTY3
173	PENFC	Penalty charge amount in document currency	decimal	13	2	CURR	((0))	Yes		PENALTY
174	PENDAYS	Number of days for penalty charge calculation	int	10	0	INT4	((0))	Yes		PDAYS	Allow NULL?
175	PPRCT	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PPRCTR	Allow NULL?
176	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
177	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
178	SNAME1	Name 1	nvarchar	35	0	CHAR	(N' ')	Yes		NAME1_GP	Allow NULL?
179	SORT01	City	nvarchar	35	0	CHAR	(N' ')	Yes		ORT01_GP	Allow NULL?
180	SLAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	LAND1_GP	Allow NULL?
181	SAMNR	Invoice List Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		SAMNR	Allow NULL?
182	MABER	Dunning Area	nvarchar	2	0	CHAR	(N' ')	Yes	*	MABER	Allow NULL?
183	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
184	SNAME2	Name 2	nvarchar	35	0	CHAR	(N' ')	Yes		NAME2_GP	Allow NULL?
185	SNAME3	Name 3	nvarchar	35	0	CHAR	(N' ')	Yes		NAME3_GP	Allow NULL?
186	SNAME4	Name 4	nvarchar	35	0	CHAR	(N' ')	Yes		NAME4_GP	Allow NULL?
187	SSTRAS	House number and street	nvarchar	35	0	CHAR	(N' ')	Yes		STRAS_GP	Allow NULL?
188	SSTRS2	House number and street	nvarchar	35	0	CHAR	(N' ')	Yes		STRAS_GP	Allow NULL?
189	SPSTLZ	Postal code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTLZ_BAS	Allow NULL?
190	SID	Original Payer of a Payment (ID)	nvarchar	35	0	CHAR	(N' ')	Yes		SENDER_ID	Allow NULL?
191	EXTACCOUNT	External Account	nvarchar	10	0	CHAR	(N' ')	Yes		TPM_EXT_ACCOUNT	Allow NULL?

TOP ERP 6.0 | REGUP INDEXES

Name	Primary	Unique	Type	Columns
REGUP~0	Yes	Yes	CLUSTERED	BUZEI, GJAHR, BELNR, BUKRS, VBLNR, EMPFG, KUNNR, LIFNR, ZBUKR, XVORL, LAUFI, LAUFD, 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

191 COLUMNS | 1 INDEXES | ERP 6.0 | REGUP TABLE

TOP ERP 6.0 | REGUP COLUMNS

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

191 COLUMNS | 1 INDEXES | ERP 6.0 | REGUP TABLE

TOPERP 6.0 | REGUP COLUMNS

TOPERP 6.0 | REGUP INDEXES

TOP ERP 6.0 | REGUP COLUMNS

TOP ERP 6.0 | REGUP INDEXES