	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

201 COLUMNS | 3 INDEXES | ERP 6.0 | VSRESB_CN TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Project System :: Simulation
1	ERP EHP7	6.0	VSRESB_CN	201	3	Version: Reservation/Dependent requirements	Simulation

SQL: selectupdate insert create

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

SELECT MANDT, VSNMR, 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, ORGRSNUM, ORGRSPOS, ORGRSART, FXPRU, UMSOK, VORAB_SM, FIPOS, FIPEX, FISTL, GEBER, EXTRSNUM, EXTRSPOS, EXTRSART, GRANT_NBR, FKBER, PRIO_URG, PRIO_REQ, BUDGET_PD, KBLNR, KBLPOS, ADVCODE, SC_OBJECT_ID, SC_ITM_NO, WTY_IND, R_PART_INDICATOR, WTYSC_CLMITEM FROM VSRESB_CN

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

TOP ERP 6.0 | VSRESB_CN INDEXES

Name	Primary	Unique	Type	Columns
VSRESB_CN~0	Yes	Yes	CLUSTERED	MANDT, VSNMR, RSNUM, RSPOS, RSART
VSRESB_CN~A	No	No	NONCLUSTERED	MANDT, OBJNR
VSRESB_CN~B	No	No	NONCLUSTERED	RSNUM, RSPOS, RSART, 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

201 COLUMNS | 3 INDEXES | ERP 6.0 | VSRESB_CN TABLE

TOP ERP 6.0 | VSRESB_CN COLUMNS

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

201 COLUMNS | 3 INDEXES | ERP 6.0 | VSRESB_CN TABLE

TOPERP 6.0 | VSRESB_CN COLUMNS

TOPERP 6.0 | VSRESB_CN INDEXES

TOP ERP 6.0 | VSRESB_CN COLUMNS

TOP ERP 6.0 | VSRESB_CN INDEXES