	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

197 COLUMNS | 2 INDEXES | ERP 6.0 | RESB TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Inventory Management
1	ERP EHP7	6.0	RESB	197	2	Reservation/dependent requirements	Inventory Management

SQL: selectupdate insert create

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

SELECT MANDT, RSNUM, RSPOS, RSART, BDART, RSSTA, XLOEK, XWAOK, KZEAR, XFEHL, MATNR, WERKS, LGORT, PRVBE, CHARG, PLPLA, SOBKZ, BDTER, BDMNG, MEINS, SHKZG, FMENG, ENMNG, ENWRT, WAERS, ERFMG, ERFME, PLNUM, BANFN, BNFPO, AUFNR, BAUGR, SERNR, KDAUF, KDPOS, KDEIN, PROJN, BWART, SAKNR, GSBER, UMWRK, UMLGO, NAFKZ, NOMAT, NOMNG, POSTP, POSNR, ROMS1, ROMS2, ROMS3, ROMEI, ROMEN, SGTXT, LMENG, ROHPS, RFORM, ROANZ, FLMNG, STLTY, STLNR, STLKN, STPOZ, LTXSP, POTX1, POTX2, SANKA, ALPOS, EWAHR, AUSCH, AVOAU, NETAU, NLFZT, AENNR, UMREZ, UMREN, SORTF, SBTER, VERTI, SCHGT, UPSKZ, DBSKZ, TXTPS, DUMPS, BEIKZ, ERSKZ, AUFST, AUFWG, BAUST, BAUWG, AUFPS, EBELN, EBELP, EBELE, KNTTP, KZVBR, PSPEL, AUFPL, PLNFL, VORNR, APLZL, OBJNR, FLGAT, GPREIS, FPREIS, PEINH, RGEKZ, EKGRP, ROKME, ZUMEI, ZUMS1, ZUMS2, ZUMS3, ZUDIV, VMENG, PRREG, LIFZT, CUOBJ, KFPOS, REVLV, BERKZ, LGNUM, LGTYP, LGPLA, TBMNG, NPTXTKY, KBNKZ, KZKUP, AFPOS, NO_DISP, BDZTP, ESMNG, ALPGR, ALPRF, ALPST, KZAUS, NFEAG, NFPKZ, NFGRP, NFUML, ADRNR, CHOBJ, SPLKZ, SPLRV, KNUMH, WEMPF, ABLAD, HKMAT, HRKFT, VORAB, MATKL, FRUNV, CLAKZ, INPOS, WEBAZ, LIFNR, FLGEX, FUNCT, GPREIS_2, FPREIS_2, PEINH_2, INFNR, KZECH, KZMPF, STLAL, PBDNR, STVKN, KTOMA, VRPLA, KZBWS, NLFZV, NLFMV, TECHS, OBJTYPE, CH_PROC, FXPRU, UMSOK, VORAB_SM, FIPOS, FIPEX, FISTL, GEBER, GRANT_NBR, FKBER, PRIO_URG, PRIO_REQ, KBLNR, KBLPOS, BUDGET_PD, SC_OBJECT_ID, SC_ITM_NO, SGT_SCAT, SGT_RCAT, FMFGUS_KEY, ADVCODE, WTY_IND, R_PART_INDICATOR, WTYSC_CLMITEM FROM RESB

TOP ERP 6.0 | RESB 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	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	NUMC	(N'0000000000')	No		RSNUM	Allow NULL?
3	RSPOS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	NUMC	(N'0000')	No		RSPOS	Allow NULL?
4	RSART	Record type	char	1	0	CHAR	(N' ')	No		RSART	Allow NULL?
5	BDART	Requirement type	nvarchar	2	0	CHAR	(N' ')	Yes		BDART	Allow NULL?
6	RSSTA	Status of reservation	char	1	0	CHAR	(N' ')	Yes		RSSTA	Allow NULL?
7	XLOEK	Item is Deleted	char	1	0	CHAR	(N' ')	Yes		XLOEK	Allow NULL?
8	XWAOK	Goods Movement for Reservation Allowed	char	1	0	CHAR	(N' ')	Yes		XWAOK	Allow NULL?
9	KZEAR	Final Issue for This Reservation	char	1	0	CHAR	(N' ')	Yes		KZEAR	Allow NULL?
10	XFEHL	Missing Part	char	1	0	CHAR	(N' ')	Yes		XFEHL	Allow NULL?
11	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
12	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
13	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
14	PRVBE	Production Supply Area	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRVBE	Allow NULL?
15	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCHA	CHARG_D	Allow NULL?
16	PLPLA	Distribution of Differences	nvarchar	10	0	CHAR		Yes		PLPLA	Allow NULL?
17	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	T148	SOBKZ	Allow NULL?
18	BDTER	Requirement Date for the Component	nvarchar	8	0	DATS	(N'00000000')	Yes		BDTER	Allow NULL?
19	BDMNG	Requirement Quantity	decimal	13	3	QUAN	((0))	Yes		BDMNG
20	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
21	SHKZG	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
22	FMENG	Quantity is Fixed	char	1	0	CHAR	(N' ')	Yes		FMENG	Allow NULL?
23	ENMNG	Quantity Withdrawn	decimal	13	3	QUAN	((0))	Yes		ENMNG
24	ENWRT	Value Withdrawn	decimal	13	2	CURR		Yes		ENWRT
25	WAERS	Currency Key	nvarchar	5	0	CUKY		Yes	TCURC	WAERS	Allow NULL?
26	ERFMG	Quantity in Unit of Entry	decimal	13	3	QUAN	((0))	Yes		ERFMG
27	ERFME	Unit of Entry	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ERFME	Allow NULL?
28	PLNUM	Planned order number	nvarchar	10	0	CHAR	(N' ')	Yes	PLAF	PLNUM	Allow NULL?
29	BANFN	Purchase Requisition Number	nvarchar	10	0	CHAR	(N' ')	Yes		BANFN	Allow NULL?
30	BNFPO	Item Number of Purchase Requisition	nvarchar	5	0	NUMC	(N'00000')	Yes	EBAN	BNFPO	Allow NULL?
31	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
32	BAUGR	Material number of higher-level assembly	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	BAUGR	Allow NULL?
33	SERNR	BOM explosion number	nvarchar	8	0	CHAR	(N' ')	Yes	SNUM	SERNR	Allow NULL?
34	KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	KDAUF	Allow NULL?
35	KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	Yes		KDPOS	Allow NULL?
36	KDEIN	Delivery Schedule for Sales Order	nvarchar	4	0	NUMC	(N'0000')	Yes		KDEIN	Allow NULL?
37	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	CHAR		Yes		PROJN	Allow NULL?
38	BWART	Movement Type (Inventory Management)	nvarchar	3	0	CHAR		Yes	T156	BWART	Allow NULL?
39	SAKNR	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	SAKNR	Allow NULL?
40	GSBER	Business Area	nvarchar	4	0	CHAR		Yes	TGSB	GSBER	Allow NULL?
41	UMWRK	Receiving/Issuing Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	UMWRK	Allow NULL?
42	UMLGO	Receiving/Issuing Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	UMLGO	Allow NULL?
43	NAFKZ	Indicator: follow-up material active/not active	char	1	0	CHAR	(N' ')	Yes		NAFKZ	Allow NULL?
44	NOMAT	Follow-Up/Original Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	NOMAT	Allow NULL?
45	NOMNG	Required quantity	decimal	13	3	QUAN	((0))	Yes		NOMNG
46	POSTP	Item Category (Bill of Material)	char	1	0	CHAR	(N' ')	Yes	T418	POSTP	Allow NULL?
47	POSNR	BOM item number	nvarchar	4	0	CHAR	(N' ')	Yes		APOSN	Allow NULL?
48	ROMS1	Size 1	decimal	13	3	QUAN	((0))	Yes		ROMS1
49	ROMS2	Size 2	decimal	13	3	QUAN	((0))	Yes		ROMS2
50	ROMS3	Size 3	decimal	13	3	QUAN	((0))	Yes		ROMS3
51	ROMEI	Unit of measure for sizes 1 to 3	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ROMEI	Allow NULL?
52	ROMEN	Quantity of variable-size item	decimal	13	3	QUAN	((0))	Yes		ROMEN
53	SGTXT	Item Text	nvarchar	50	0	CHAR		Yes		SGTXT	Allow NULL?
54	LMENG	Required quantity for mat.management in stockkeeping units	decimal	13	3	QUAN		Yes		LMENG
55	ROHPS	Variable-sized item indicator	char	1	0	CHAR	(N' ')	Yes		ROHPS	Allow NULL?
56	RFORM	Formula key	nvarchar	2	0	CHAR	(N' ')	Yes	T418F	RFORM	Allow NULL?
57	ROANZ	Number of variable-size items	decimal	13	3	QUAN	((0))	Yes		ROANZ
58	FLMNG	Shortfall quantity of the component in the order	decimal	13	3	QUAN		Yes		FLMNG
59	STLTY	BOM category	char	1	0	CHAR	(N' ')	Yes		STLTY	Allow NULL?
60	STLNR	Bill of material	nvarchar	8	0	CHAR	(N' ')	Yes		STNUM	Allow NULL?
61	STLKN	BOM item node number	nvarchar	8	0	NUMC	(N'00000000')	Yes		STLKN	Allow NULL?
62	STPOZ	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
63	LTXSP	Language: The long text was stored in this language	char	1	0	LANG	(N' ')	Yes	T002	LTXSP	Allow NULL?
64	POTX1	BOM Item Text (Line 1)	nvarchar	40	0	CHAR	(N' ')	Yes		POTX1	Allow NULL?
65	POTX2	BOM item text (line 2)	nvarchar	40	0	CHAR	(N' ')	Yes		POTX2	Allow NULL?
66	SANKA	Indicator for Relevancy to Costing	char	1	0	CHAR	(N' ')	Yes	TCK08	CK_SELKZ	Allow NULL?
67	ALPOS	Alternative item indicator	char	1	0	CHAR	(N' ')	Yes		ALTPS	Allow NULL?
68	EWAHR	Usage probability in % (alternative item)	decimal	3	0	DEC	((0))	Yes		EWAHR
69	AUSCH	Component scrap in percent	decimal	5	2	DEC	((0))	Yes		KAUSF
70	AVOAU	Operation scrap	decimal	5	2	DEC	((0))	Yes		AVOAU
71	NETAU	Indicator: Net scrap	char	1	0	CHAR	(N' ')	Yes		NETAU	Allow NULL?
72	NLFZT	Lead-time offset	decimal	3	0	DEC	((0))	Yes		NLFZT
73	AENNR	Change Number	nvarchar	12	0	CHAR	(N' ')	Yes	AENR	AENNR	Allow NULL?
74	UMREZ	Numerator for Conversion to Base Units of Measure	decimal	5	0	DEC	((0))	Yes		UMREZ
75	UMREN	Denominator for conversion to base units of measure	decimal	5	0	DEC	((0))	Yes		UMREN
76	SORTF	Sort String	nvarchar	10	0	CHAR	(N' ')	Yes		SORTP	Allow NULL?
77	SBTER	Latest requirements date	nvarchar	8	0	DATS	(N'00000000')	Yes		SBTER	Allow NULL?
78	VERTI	MRP Distribution Key	nvarchar	4	0	CHAR	(N' ')	Yes	T437V	SA_VERTL	Allow NULL?
79	SCHGT	Indicator: Bulk Material	char	1	0	CHAR	(N' ')	Yes		SCHGT	Allow NULL?
80	UPSKZ	Indicator: sub-items exist	char	1	0	CHAR	(N' ')	Yes		UPSKZ	Allow NULL?
81	DBSKZ	Direct procurement indicator	char	1	0	CHAR	(N' ')	Yes		DBSKZ	Allow NULL?
82	TXTPS	Item text indicator	char	1	0	CHAR	(N' ')	Yes		TXTPS	Allow NULL?
83	DUMPS	Phantom item indicator	char	1	0	CHAR	(N' ')	Yes		DUMPS	Allow NULL?
84	BEIKZ	Material Provision Indicator	char	1	0	CHAR	(N' ')	Yes	T417	BEIKZ	Allow NULL?
85	ERSKZ	Indicator: spare part	char	1	0	CHAR	(N' ')	Yes	T413	ERSKZ	Allow NULL?
86	AUFST	Order level	nvarchar	2	0	NUMC	(N'00')	Yes		AUFST	Allow NULL?
87	AUFWG	Order path	nvarchar	2	0	NUMC	(N'00')	Yes		AUFWG	Allow NULL?
88	BAUST	Assembly order level	nvarchar	2	0	NUMC	(N'00')	Yes		BAUST	Allow NULL?
89	BAUWG	Assembly order path	nvarchar	2	0	NUMC	(N'00')	Yes		BAUWG	Allow NULL?
90	AUFPS	Order item number	nvarchar	2	0	CHAR		Yes		AUFPS	Allow NULL?
91	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	EBELN	Allow NULL?
92	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	EBELP	Allow NULL?
93	EBELE	Delivery Schedule Line Counter	nvarchar	4	0	NUMC	(N'0000')	Yes	EKET	EETEN	Allow NULL?
94	KNTTP	Account Assignment Category	char	1	0	CHAR	(N' ')	Yes	T163K	KNTTP	Allow NULL?
95	KZVBR	Consumption Posting	char	1	0	CHAR	(N' ')	Yes		KZVBR	Allow NULL?
96	PSPEL	WBS Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PS_POSNR	Allow NULL?
97	AUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC		Yes		CO_AUFPL	Allow NULL?
98	PLNFL	Sequence	nvarchar	6	0	CHAR		Yes		PLNFOLGE	Allow NULL?
99	VORNR	Operation/Activity Number	nvarchar	4	0	CHAR		Yes		VORNR	Allow NULL?
100	APLZL	Internal counter	nvarchar	8	0	NUMC		Yes		CIM_COUNT	Allow NULL?
101	OBJNR	Object number	nvarchar	22	0	CHAR		Yes	ONR00	J_OBJNR	Allow NULL?
102	FLGAT	Sequence category	char	1	0	CHAR		Yes	TCA07	FOLGENART	Allow NULL?
103	GPREIS	Price in component currency	decimal	15	2	CURR		Yes		PPCOMP
104	FPREIS	Fixed Price in Foreign Currency	decimal	15	2	CURR		Yes		OPREIFX
105	PEINH	Price Unit	decimal	5	0	DEC		Yes		PEINH
106	RGEKZ	Indicator: Backflush	char	1	0	CHAR	(N' ')	Yes		RGEKZ	Allow NULL?
107	EKGRP	Purchasing Group	nvarchar	3	0	CHAR		Yes	T024	EKGRP	Allow NULL?
108	ROKME	Unit of measure for variable-size component	nvarchar	3	0	UNIT		Yes	T006	ROKME	Allow NULL?
109	ZUMEI	Unit for cutting measures	nvarchar	3	0	UNIT		Yes	T006	DZUMEI	Allow NULL?
110	ZUMS1	Cutting measure 1	decimal	13	3	QUAN		Yes		DZUMS1
111	ZUMS2	Cutting measure 2	decimal	13	3	QUAN		Yes		DZUMS2
112	ZUMS3	Cutting measure 3	decimal	13	3	QUAN		Yes		DZUMS3
113	ZUDIV	Integral divisor for cutting measures	nvarchar	5	0	NUMC		Yes		DZUDIV	Allow NULL?
114	VMENG	Confirmed quantity for availability check in SKU	decimal	15	3	QUAN	((0))	Yes		VMENG
115	PRREG	Checking Rule for Availability Check	nvarchar	2	0	CHAR		Yes	T441R	PRREG	Allow NULL?
116	LIFZT	Delivery time in days	decimal	3	0	DEC		Yes		LIFZT
117	CUOBJ	Configuration (internal object number)	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ	Allow NULL?
118	KFPOS	Indicator: "configurable item"	char	1	0	CHAR	(N' ')	Yes		KFPOS	Allow NULL?
119	REVLV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		REVLV	Allow NULL?
120	BERKZ	Material Staging Indicator for Production Supply	char	1	0	CHAR		Yes		BERKZ	Allow NULL?
121	LGNUM	Warehouse Number / Warehouse Complex	nvarchar	3	0	CHAR	(N' ')	Yes	T300	LGNUM	Allow NULL?
122	LGTYP	Storage Type	nvarchar	3	0	CHAR	(N' ')	Yes	T301	LGTYP	Allow NULL?
123	LGPLA	Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes	LAGP	LGPLA	Allow NULL?
124	TBMNG	Transfer requirement quantity already requested	decimal	13	3	QUAN		Yes		TBMNG
125	NPTXTKY	Internal text number (12-character)	nvarchar	12	0	CHAR		Yes		TXTKY	Allow NULL?
126	KBNKZ	Kanban Indicator	char	1	0	CHAR	(N' ')	Yes		KBNKZ	Allow NULL?
127	KZKUP	Indicator: co-product	char	1	0	CHAR	(N' ')	Yes		KZKUP	Allow NULL?
128	AFPOS	Order Item Number	nvarchar	4	0	NUMC		Yes		CO_POSNR	Allow NULL?
129	NO_DISP	Effective for Materials Planning	char	1	0	CHAR	(N' ')	Yes		NO_DISP_PLUS	Allow NULL?
130	BDZTP	Time that reservation quantity required	nvarchar	6	0	TIMS	(N'000000')	Yes		BDZTP	Allow NULL?
131	ESMNG	Usage quantity per order unit of measure	float	15	16	FLTP	((0))	Yes		ESMNG
132	ALPGR	Alternative item: group	nvarchar	2	0	CHAR		Yes		CS_ALPGR	Allow NULL?
133	ALPRF	Alternative item: ranking order	nvarchar	2	0	NUMC		Yes		CS_ALPRF	Allow NULL?
134	ALPST	Alternative item: strategy	char	1	0	CHAR	(N' ')	Yes		CS_ALPST	Allow NULL?
135	KZAUS	Discontinuation type	char	1	0	CHAR	(N' ')	Yes		AUSLF	Allow NULL?
136	NFEAG	Discontinuation group	nvarchar	2	0	CHAR	(N' ')	Yes		CS_NFEAG	Allow NULL?
137	NFPKZ	Indicator: Follow-Up Item	char	1	0	CHAR	(N' ')	Yes		CS_KZNFP	Allow NULL?
138	NFGRP	Follow-up group	nvarchar	2	0	CHAR	(N' ')	Yes		CS_NFGRP	Allow NULL?
139	NFUML	NOT USED: Quantity transfer factor for follow-up material	decimal	5	4	DEC	((0))	Yes		NFUML
140	ADRNR	Addresses: Address Number	nvarchar	10	0	CHAR		Yes	*	CADNR	Allow NULL?
141	CHOBJ	Internal object number of the batch classification	nvarchar	18	0	NUMC		Yes		CUOBJ_CH	Allow NULL?
142	SPLKZ	Batch key	char	1	0	CHAR		Yes		CHSPLIT	Allow NULL?
143	SPLRV	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	NUMC		Yes		RSPOS	Allow NULL?
144	KNUMH	Number of condition record from batch determination	nvarchar	10	0	CHAR		Yes		KNUMH_CH	Allow NULL?
145	WEMPF	Goods Recipient/Ship-To Party	nvarchar	12	0	CHAR		Yes		WEMPF	Allow NULL?
146	ABLAD	Unloading Point	nvarchar	25	0	CHAR		Yes		ABLAD	Allow NULL?
147	HKMAT	Material-related origin	char	1	0	CHAR		Yes		HKMAT	Allow NULL?
148	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	CHAR		Yes	*	HRKFT	Allow NULL?
149	VORAB	Ind: Preliminary order	char	1	0	CHAR		Yes		VORABKZ	Allow NULL?
150	MATKL	Material Group	nvarchar	9	0	CHAR		Yes	T023	MATKL	Allow NULL?
151	FRUNV	Indicator: External procurement data incomplete	char	1	0	CHAR		Yes		FRUNV	Allow NULL?
152	CLAKZ	Indicator: classification exists	char	1	0	CHAR	(N' ')	Yes		CLAKZ	Allow NULL?
153	INPOS	Indicator: intra material	char	1	0	CHAR	(N' ')	Yes		INPOS	Allow NULL?
154	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0	DEC		Yes		WEBAZ
155	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	CHAR		Yes	LFA1	LIFNR	Allow NULL?
156	FLGEX	Indicator: External procurement	char	1	0	CHAR		Yes		FLGEX	Allow NULL?
157	FUNCT	Distribution function	nvarchar	3	0	CHAR		Yes	TC29V	CY_FUNCT	Allow NULL?
158	GPREIS_2	Total Price in Local Currency	decimal	15	2	CURR		Yes		PPGXXX
159	FPREIS_2	Fixed Price in Local Currency	decimal	15	2	CURR		Yes		PPFXXX
160	PEINH_2	Price Unit	decimal	5	0	DEC		Yes		PEINH
161	INFNR	Number of Purchasing Info Record	nvarchar	10	0	CHAR		Yes	EINA	INFNR	Allow NULL?
162	KZECH	Determination of batch entry in the production/process order	char	1	0	CHAR		Yes		KZECH	Allow NULL?
163	KZMPF	Manual Maintenance of Requirement Date	char	1	0	CHAR	(N' ')	Yes		KZMPF	Allow NULL?
164	STLAL	Alternative BOM	nvarchar	2	0	CHAR	(N' ')	Yes		STALT	Allow NULL?
165	PBDNR	Requirements Plan Number	nvarchar	10	0	CHAR	(N' ')	Yes		PBDNR	Allow NULL?
166	STVKN	Inherited node number of BOM item	nvarchar	8	0	NUMC	(N'00000000')	Yes		STVKN	Allow NULL?
167	KTOMA	Acct entered manually	char	1	0	CHAR	(N' ')	Yes		KTOMA	Allow NULL?
168	VRPLA	Indicator: planning without final assembly	char	1	0	CHAR	(N' ')	Yes		VRPLA	Allow NULL?
169	KZBWS	Valuation of Special Stock	char	1	0	CHAR	(N' ')	Yes		KZBWS	Allow NULL?
170	NLFZV	Lead-time offset for operation	decimal	3	0	DEC	((0))	Yes		CS_NLFZV
171	NLFMV	Unit for lead-time offset for operation	nvarchar	3	0	UNIT	(N' ')	Yes	T006	CS_NLFMV	Allow NULL?
172	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	CHAR	(N' ')	Yes		TECHS	Allow NULL?
173	OBJTYPE	Change indicator	char	1	0	CHAR	(N' ')	Yes		OCM_OBJ_TYPE	Allow NULL?
174	CH_PROC	Process that has lead to the change of an object	char	1	0	CHAR	(N' ')	Yes		OCM_CH_PROC	Allow NULL?
175	FXPRU	Fixed-Price Co-Product	char	1	0	CHAR	(N' ')	Yes		CK_FIXPRKU	Allow NULL?
176	UMSOK	Special Stock Indicator for Physical Stock Transfer	char	1	0	CHAR	(N' ')	Yes	*	UMSOK	Allow NULL?
177	VORAB_SM	Advance Shipment Indicator	char	1	0	CHAR	(N' ')	Yes		VORAB_SM	Allow NULL?
178	FIPOS	Commitment Item	nvarchar	14	0	CHAR	(N' ')	Yes	*	FIPOS	Allow NULL?
179	FIPEX	Commitment Item	nvarchar	24	0	CHAR	(N' ')	Yes	*	FM_FIPEX	Allow NULL?
180	FISTL	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
181	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
182	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
183	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
184	PRIO_URG	Requirement Urgency	nvarchar	2	0	NUMC	(N'00')	Yes	PURG	PRIO_URG	Allow NULL?
185	PRIO_REQ	Requirement Priority	nvarchar	3	0	NUMC	(N'000')	Yes	PREQ	PRIO_REQ	Allow NULL?
186	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	CHAR	(N' ')	Yes	*	KBLNR	Allow NULL?
187	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	NUMC	(N'000')	Yes	*	KBLPOS	Allow NULL?
188	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
189	SC_OBJECT_ID	Object ID - Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		/SRMERP/OBJECT_ID	Allow NULL?
190	SC_ITM_NO	Internal Shopping Cart Item Number	int	10	0	INT4	((0))	Yes		/SRMERP/SC_ITM_NO	Allow NULL?
191	SGT_SCAT	Stock Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_SCAT	Allow NULL?
192	SGT_RCAT	Requirement Segment	nvarchar	16	0	CHAR	(N' ')	Yes		SGT_RCAT	Allow NULL?
193	FMFGUS_KEY	United States Federal Government Fields	nvarchar	22	0	CHAR	(N' ')	Yes		FMFG_US_KEY	Allow NULL?
194	ADVCODE	Advice Code	nvarchar	2	0	CHAR	(N' ')	Yes	/ISDFPS/ADVCODE1	/ISDFPS/ADVCODE	Allow NULL?
195	WTY_IND	Warranty indicator	char	1	0	CHAR	(N' ')	Yes		WTYSC_WTY_INDICATOR	Allow NULL?
196	R_PART_INDICATOR	Return Part Indicator	char	1	0	CHAR	(N' ')	Yes		WTYSC_RETURN_PART_INDICATOR	Allow NULL?
197	WTYSC_CLMITEM	Claim item number	nvarchar	16	0	CHAR	(N' ')	Yes		WTYSC_CLMITEM	Allow NULL?

TOP ERP 6.0 | RESB INDEXES

Name	Primary	Unique	Type	Columns
RESB~0	Yes	Yes	CLUSTERED	RSART, RSPOS, RSNUM, MANDT
RESB~M	No	No	NONCLUSTERED	BDTER, KZEAR, XLOEK, WERKS, MATNR, 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

197 COLUMNS | 2 INDEXES | ERP 6.0 | RESB TABLE

TOP ERP 6.0 | RESB COLUMNS

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

197 COLUMNS | 2 INDEXES | ERP 6.0 | RESB TABLE

TOPERP 6.0 | RESB COLUMNS

TOPERP 6.0 | RESB INDEXES

TOP ERP 6.0 | RESB COLUMNS

TOP ERP 6.0 | RESB INDEXES