	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

156 COLUMNS | 3 INDEXES | ERP 6.0 | J_3GBELK TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Engineering Construction :: Construction Equipment Management
1	ERP EHP7	6.0	J_3GBELK	156	3	Document File - Header Data	Construction Equipment Management

SQL: selectupdate insert create

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

SELECT MANDT, J_3GBELNRI, ERNAM, ERZET, ERDAT, UNAME, AEZET, AEDTM, J_3GABSEND, J_3GABSREF, J_3GABSPSP, J_3GABSPRO, J_3GABSKOS, J_3GABSKOK, J_3GABSACO, J_3GABSAPM, J_3GABSWRK, J_3GABSLAG, J_3GABSEXT, J_3GABSDEB, J_3GEMPFAE, J_3GEMPREF, J_3GEMPPSP, J_3GEMPPRO, J_3GEMPKOS, J_3GEMPKOK, J_3GEMPACO, J_3GEMPAPM, J_3GEMPWRK, J_3GEMPLAG, J_3GEMPEXT, J_3GEMPDEB, J_3GMITTLE, J_3GMITREF, J_3GMITPSP, J_3GMITPRO, J_3GMITKOS, J_3GMITKOK, J_3GMITACO, J_3GMITAPM, J_3GMITWRK, J_3GMITLAG, J_3GFREMDP, PERNR, NACHN, J_3GEMPPER, J_3GBELSTA, J_3GPIABS, J_3GPEABS, J_3GPIEMPF, J_3GPEEMPS, J_3GBETR1, J_3GBETR2, J_3GBETR3, J_3GBETR4, J_3GWAERS1, J_3GWAERS2, J_3GWAERS3, J_3GWAERS4, J_3GFAKTAB, J_3GFAKTEM, EQUNR, J_3GTPLKZ, J_3GKATNRC, LFDNR, J_3GDOMLMB, J_3GDOMMB, J_3GBELNR, J_3GBLART, J_3GBLTYP, J_3GBELDAT, VKORG, VTWEG, SPART, INCO1, J_3GBEWEG, J_3GBELSTE, SLWID, USR00, USR01, USR02, USR03, USR04, USE04, USR05, USE05, USR06, USE06, USR07, USE07, USR08, USR09, USR10, USR11, VNAME, RECID, ETYPE, JV_OTYPE, JV_JIBCL, JV_JIBSA, JV_OCO, DUMMY_CI_AFVU, SPARAMETER1, SPARAMETER2, SPARAMETER3, /MRSS/ID_PROFILE, /MRSS/PROF_KEY, /MRSS/PROF_GUID, /MRSS/ACT_TYPE, /MRSS/ORDER_PROB, /MRSS/INIT_DONE, /MRSS/DATACHANGE, /MRSS/DEM_COUNT, /MRSS/SUPERV_CNT, /MRSS/RULE_ID, /MRSS/SALES_ORG, /MRSS/REFF_RCNT, /MRSS/REFF_E_BEG, /MRSS/REFF_E_END, /MRSS/REFF_L_BEG, /MRSS/REFF_L_END, /MRSS/RELEVANT, /MRSS/TEAM_PLAN, /MRSS/SINGL_RES, /MRSS/TO_BEGDAT, /MRSS/TO_BEGTIM, /MRSS/TO_ENDDAT, /MRSS/TO_ENDTIM, /MRSS/TO_DURAT, /MRSS/TO_DUNIT, /MRSS/TO_DISTAN, /MRSS/TO_MANUAL, /MRSS/FR_BEGDAT, /MRSS/FR_BEGTIM, /MRSS/FR_ENDDAT, /MRSS/FR_ENDTIM, /MRSS/FR_DURAT, /MRSS/FR_DUNIT, /MRSS/FR_DISTAN, /MRSS/FR_MANUAL, ILART_OP, FERC_IND, J_3GVVCOM1, J_3GVVCOM2, GSGEW, GEWEI, J_3GABS_BUKRS, J_3GABS_GSBER, MBLNR, MJAHR, J_3GEMP_BUKRS, J_3GEMP_GSBER, J_3GABSNPLNR, J_3GABSVORNR, J_3GEMPNPLNR, J_3GEMPVORNR FROM J_3GBELK

TOP ERP 6.0 | J_3GBELK 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	J_3GBELNRI	Document Number	nvarchar	10	0	CHAR	(N' ')	No		J_3GBELNRI	Allow NULL?
3	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
4	ERZET	Entry time	nvarchar	6	0	TIMS	(N'000000')	Yes		ERZET	Allow NULL?
5	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
6	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
7	AEZET	Time last change was made	nvarchar	6	0	TIMS	(N'000000')	Yes		AEZET	Allow NULL?
8	AEDTM	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
9	J_3GABSEND	Sender	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GABSEND	Allow NULL?
10	J_3GABSREF	Reference Type Sender	nvarchar	2	0	CHAR	(N' ')	Yes		J_3GABSREF	Allow NULL?
11	J_3GABSPSP	WBS Element Sender	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	J_3GABSPSP	Allow NULL?
12	J_3GABSPRO	Project Number Sender	nvarchar	8	0	NUMC	(N'00000000')	Yes	PROJ	J_3GABSPRO	Allow NULL?
13	J_3GABSKOS	Cost Center Sender	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	J_3GABSKOS	Allow NULL?
14	J_3GABSKOK	Controlling Area Sender	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	J_3GABSKOK	Allow NULL?
15	J_3GABSACO	Sender of CO Order	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GABSACO	Allow NULL?
16	J_3GABSAPM	Sender of PM Order	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GABSAPM	Allow NULL?
17	J_3GABSWRK	Plant Sender	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	J_3GABSWRK	Allow NULL?
18	J_3GABSLAG	Storage Location/Warehouse Sender	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	J_3GABSLAG	Allow NULL?
19	J_3GABSEXT	External Ship-to Party - Sender	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GABSEXT	Allow NULL?
20	J_3GABSDEB	Debtor of Sender	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GABSDEB	Allow NULL?
21	J_3GEMPFAE	Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GEMPFAE	Allow NULL?
22	J_3GEMPREF	Receiving Reference Type	nvarchar	2	0	CHAR	(N' ')	Yes		J_3GEMPREF	Allow NULL?
23	J_3GEMPPSP	Receiving WBS Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	J_3GEMPPSP	Allow NULL?
24	J_3GEMPPRO	Receiving Project Number	nvarchar	8	0	NUMC	(N'00000000')	Yes	PROJ	J_3GEMPPRO	Allow NULL?
25	J_3GEMPKOS	Receiving Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	J_3GEMPKOS	Allow NULL?
26	J_3GEMPKOK	Receiving Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	J_3GEMPKOK	Allow NULL?
27	J_3GEMPACO	CO Order Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GEMPACO	Allow NULL?
28	J_3GEMPAPM	PM Order Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GEMPAPM	Allow NULL?
29	J_3GEMPWRK	Receiving Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	J_3GEMPWRK	Allow NULL?
30	J_3GEMPLAG	Receiving Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	J_3GEMPLAG	Allow NULL?
31	J_3GEMPEXT	External Ship-To Party - Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GEMPEXT	Allow NULL?
32	J_3GEMPDEB	Debtor of Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GEMPDEB	Allow NULL?
33	J_3GMITTLE	Intermediate Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GMITTLE	Allow NULL?
34	J_3GMITREF	Reference Type - Intermediate Recipient	nvarchar	2	0	CHAR	(N' ')	Yes		J_3GMITREF	Allow NULL?
35	J_3GMITPSP	WBS Element - Intermediate Recipient	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	J_3GMITPSP	Allow NULL?
36	J_3GMITPRO	Project Number - Intermediate Recipient	nvarchar	8	0	NUMC	(N'00000000')	Yes	PROJ	J_3GMITPRO	Allow NULL?
37	J_3GMITKOS	Cost Center - Intermediate Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	J_3GMITKOS	Allow NULL?
38	J_3GMITKOK	Controlling Area - Intermediate Recipient	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	J_3GMITKOK	Allow NULL?
39	J_3GMITACO	CO Order - Intermediate Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GMITACO	Allow NULL?
40	J_3GMITAPM	PM Order Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GMITAPM	Allow NULL?
41	J_3GMITWRK	Plant - Intermediate Recipient	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	J_3GMITWRK	Allow NULL?
42	J_3GMITLAG	Storage Location - Intermediate Recipient	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	J_3GMITLAG	Allow NULL?
43	J_3GFREMDP	Indicator for External Employees	char	1	0	CHAR	(N' ')	Yes		J_3GFREMDP	Allow NULL?
44	PERNR	Personal Number	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	J_3GPERNR	Allow NULL?
45	NACHN	Last Name	nvarchar	25	0	CHAR	(N' ')	Yes		NACHN	Allow NULL?
46	J_3GEMPPER	Receiving Cost Center for Personnel	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GEMPPER	Allow NULL?
47	J_3GBELSTA	Internal Document Status	char	1	0	CHAR	(N' ')	Yes		J_3GBELSTA	Allow NULL?
48	J_3GPIABS	Document Flat Rate Indicator (Internal) - Sender	char	1	0	CHAR	(N' ')	Yes		J_3GPIABS	Allow NULL?
49	J_3GPEABS	Document Flat Rate Indicator (External) - Sender	char	1	0	CHAR	(N' ')	Yes		J_3GPEABS	Allow NULL?
50	J_3GPIEMPF	Document Flat Rate Indicator (Internal) - Recipient	char	1	0	CHAR	(N' ')	Yes		J_3GPIEMPS	Allow NULL?
51	J_3GPEEMPS	Document Flat Rate Indicator (External) - Recipient	char	1	0	CHAR	(N' ')	Yes		J_3GPEEMPS	Allow NULL?
52	J_3GBETR1	Internal Flat Rate - Sender	decimal	15	2	CURR	((0))	Yes		J_3GBETR1
53	J_3GBETR2	External Flat Rate - Sender	decimal	15	2	CURR	((0))	Yes		J_3GBETR2
54	J_3GBETR3	Internal Flat Rate - Recipient	decimal	15	2	CURR	((0))	Yes		J_3GBETR3
55	J_3GBETR4	External Flat Rate - Recipient	decimal	15	2	CURR	((0))	Yes		J_3GBETR4
56	J_3GWAERS1	Currency Flat Rate Amount (Internal) - Sender	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	J_3GWAERS1	Allow NULL?
57	J_3GWAERS2	Currency Flat Rate Amount (External) - Sender	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	J_3GWAERS2	Allow NULL?
58	J_3GWAERS3	Currency Flat Rate Amount (Internal) - Recipient	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	J_3GWAERS3	Allow NULL?
59	J_3GWAERS4	Currency Flat Rate Amount (External) - Recipient	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	J_3GWAERS4	Allow NULL?
60	J_3GFAKTAB	Billing Indicator - Sender	char	1	0	CHAR	(N' ')	Yes		J_3GFAKTAB	Allow NULL?
61	J_3GFAKTEM	Billing Indicator - Recipient	char	1	0	CHAR	(N' ')	Yes		J_3GFAKTEM	Allow NULL?
62	EQUNR	Equipment Number	nvarchar	18	0	CHAR	(N' ')	Yes	EQUI	EQUNR	Allow NULL?
63	J_3GTPLKZ	Catalog Code	nvarchar	5	0	CHAR	(N' ')	Yes	J_3GT370S	J_3GTPLKZ	Allow NULL?
64	J_3GKATNRC	Number in Catalog	nvarchar	30	0	CHAR	(N' ')	Yes	J_3GKATAL	J_3GKATNRC	Allow NULL?
65	LFDNR	Sequence Number	nvarchar	4	0	NUMC	(N'0000')	Yes		J_3GLFDNR4	Allow NULL?
66	J_3GDOMLMB	Pricing Dominancy (Provider/Intermediate Recipient/Debtor)	char	1	0	CHAR	(N' ')	Yes		J_3GDOMLMB	Allow NULL?
67	J_3GDOMMB	Pricing Dominancy (Intermediate Recipient/Debtor)	char	1	0	CHAR	(N' ')	Yes		J_3GDOMMB	Allow NULL?
68	J_3GBELNR	External Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		J_3GBELNR	Allow NULL?
69	J_3GBLART	Document Type	nvarchar	4	0	CHAR	(N' ')	Yes	J_3GBELART	J_3GBLART	Allow NULL?
70	J_3GBLTYP	CEM Document Category	char	1	0	CHAR	(N' ')	Yes		J_3GBLTYP	Allow NULL?
71	J_3GBELDAT	CEM Document Date	nvarchar	8	0	DATS	(N'00000000')	Yes		J_3GBELDAT	Allow NULL?
72	VKORG	Sales Organization, but Obsolete	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	/SAPCEM/VKORG	Allow NULL?
73	VTWEG	Distribution Channel, but Obsolete	nvarchar	2	0	CHAR	(N' ')	Yes	TVTW	/SAPCEM/VTWEG	Allow NULL?
74	SPART	Division, but Obsolete	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	/SAPCEM/SPART	Allow NULL?
75	INCO1	Incoterms (Part 1)	nvarchar	3	0	CHAR	(N' ')	Yes	TINC	INCO1	Allow NULL?
76	J_3GBEWEG	Internal Indicator for Transaction Type	char	1	0	CHAR	(N' ')	Yes		J_3GBEWEG	Allow NULL?
77	J_3GBELSTE	External Document Status	char	1	0	CHAR	(N' ')	Yes		J_3GBELSTE	Allow NULL?
78	SLWID	Key word ID for user-defined fields	nvarchar	7	0	CHAR	(N' ')	Yes	TCN00	SLWID	Allow NULL?
79	USR00	User field with 20 characters	nvarchar	20	0	CHAR	(N' ')	Yes		USRCHAR20	Allow NULL?
80	USR01	User field with 20 characters	nvarchar	20	0	CHAR	(N' ')	Yes		USRCHAR20	Allow NULL?
81	USR02	User field with 10 characters	nvarchar	10	0	CHAR	(N' ')	Yes		USRCHAR10	Allow NULL?
82	USR03	User field with 10 characters	nvarchar	10	0	CHAR	(N' ')	Yes		USRCHAR10	Allow NULL?
83	USR04	User field for quantity (length 10.3)	decimal	13	3	QUAN	((0))	Yes		USRQUAN13
84	USE04	User field: Unit for quantity fields	nvarchar	3	0	UNIT	(N' ')	Yes	T006	USRUNIT	Allow NULL?
85	USR05	User field for quantity (length 10.3)	decimal	13	3	QUAN	((0))	Yes		USRQUAN13
86	USE05	User field: Unit for quantity fields	nvarchar	3	0	UNIT	(N' ')	Yes	T006	USRUNIT	Allow NULL?
87	USR06	User-defined field for values (length 10,3)	decimal	13	3	CURR	((0))	Yes		USRCURR13
88	USE06	User field: Unit for value fields	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	USRCUKY	Allow NULL?
89	USR07	User-defined field for values (length 10,3)	decimal	13	3	CURR	((0))	Yes		USRCURR13
90	USE07	User field: Unit for value fields	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	USRCUKY	Allow NULL?
91	USR08	User field for date	nvarchar	8	0	DATS	(N'00000000')	Yes		USRDATE	Allow NULL?
92	USR09	User field for date	nvarchar	8	0	DATS	(N'00000000')	Yes		USRDATE	Allow NULL?
93	USR10	User-defined field: Indicator for reports	char	1	0	CHAR	(N' ')	Yes		USRFLAG	Allow NULL?
94	USR11	User-defined field: Indicator for reports	char	1	0	CHAR	(N' ')	Yes		USRFLAG	Allow NULL?
95	VNAME	Joint Venture	nvarchar	6	0	CHAR	(N' ')	Yes	T8JV	JV_NAME	Allow NULL?
96	RECID	Recovery Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	T8JJ	JV_RECIND	Allow NULL?
97	ETYPE	Equity type	nvarchar	3	0	CHAR	(N' ')	Yes	T8JG	JV_ETYPE	Allow NULL?
98	JV_OTYPE	Joint Venture Object Type	nvarchar	4	0	CHAR	(N' ')	Yes		JV_OTYPE	Allow NULL?
99	JV_JIBCL	JIB/JIBE Class	nvarchar	3	0	CHAR	(N' ')	Yes	T8J6A	JV_JIBCL	Allow NULL?
100	JV_JIBSA	JIB/JIBE Subclass A	nvarchar	5	0	CHAR	(N' ')	Yes	T8J6C	JV_JIBSA	Allow NULL?
101	JV_OCO	JV original cost object	char	1	0	CHAR	(N' ')	Yes		JV_OR_CO	Allow NULL?
102	DUMMY_CI_AFVU	Single-Character Indicator	char	1	0	CHAR	(N' ')	Yes		CHAR1	Allow NULL?
103	SPARAMETER1	Scheduling Parameters for External Scheduling	nvarchar	4	0	CHAR	(N' ')	Yes		SPARAMETER	Allow NULL?
104	SPARAMETER2	Scheduling Parameters for External Scheduling	nvarchar	4	0	CHAR	(N' ')	Yes		SPARAMETER	Allow NULL?
105	SPARAMETER3	Scheduling Parameters for External Scheduling	nvarchar	4	0	CHAR	(N' ')	Yes		SPARAMETER	Allow NULL?
106	/MRSS/ID_PROFILE	Requirements Profile Was Changed Manually	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_REQU_UPD	Allow NULL?
107	/MRSS/PROF_KEY	Profile Key	nvarchar	10	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_REQUID	Allow NULL?
108	/MRSS/PROF_GUID	Character field, length 32	nvarchar	32	0	CHAR	(N' ')	Yes		CHAR32	Allow NULL?
109	/MRSS/ACT_TYPE	Process variant	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_ACTIVITY_TYPE	Allow NULL?
110	/MRSS/ORDER_PROB	Order probability in percent	nvarchar	3	0	CHAR	(N' ')	Yes		/MRSS/T_ORDER_PROB	Allow NULL?
111	/MRSS/INIT_DONE	Internal initialization carried out once	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_INIT_DONE	Allow NULL?
112	/MRSS/DATACHANGE	Data was changed in the controls on the user screen	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_USCREENCTL_DATACHANGED	Allow NULL?
113	/MRSS/DEM_COUNT	Counter for Demands in Operation	nvarchar	4	0	NUMC	(N'0000')	Yes		/MRSS/T_DEM_COUNT	Allow NULL?
114	/MRSS/SUPERV_CNT	Number of Site Supervisors	nvarchar	2	0	CHAR	(N' ')	Yes		/MRSS/T_RAP_SUPERVISOR_COUNT	Allow NULL?
115	/MRSS/RULE_ID	Time Rule Id	nvarchar	25	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_TIME_RULE_ID	Allow NULL?
116	/MRSS/SALES_ORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
117	/MRSS/REFF_RCNT	Determination of Remaining Demand: No. of Resources	nvarchar	3	0	NUMC	(N'000')	Yes		/MRSS/T_REM_EFFORT_RES_COUNT	Allow NULL?
118	/MRSS/REFF_E_BEG	Time stamp: start	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		/MRSS/T_TIMESTAMP_BEGIN	Allow NULL?
119	/MRSS/REFF_E_END	Time stamp: end	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		/MRSS/T_TIMESTAMP_END	Allow NULL?
120	/MRSS/REFF_L_BEG	Time stamp: start	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		/MRSS/T_TIMESTAMP_BEGIN	Allow NULL?
121	/MRSS/REFF_L_END	Time stamp: end	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		/MRSS/T_TIMESTAMP_END	Allow NULL?
122	/MRSS/RELEVANT	Operation Set as MRS-Relevant	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RELEVANT_FOR_MRS	Allow NULL?
123	/MRSS/TEAM_PLAN	Team Planning flag for Demand	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_TEAM_PLANNING	Allow NULL?
124	/MRSS/SINGL_RES	Combine Operations and Assign Same Resource	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_FORCE_SINGLE_RES	Allow NULL?
125	/MRSS/TO_BEGDAT	Field of type DATS	nvarchar	8	0	DATS	(N'00000000')	Yes		DATS	Allow NULL?
126	/MRSS/TO_BEGTIM	Field of type TIMS	nvarchar	6	0	TIMS	(N'000000')	Yes		TIMS	Allow NULL?
127	/MRSS/TO_ENDDAT	Field of type DATS	nvarchar	8	0	DATS	(N'00000000')	Yes		DATS	Allow NULL?
128	/MRSS/TO_ENDTIM	Field of type TIMS	nvarchar	6	0	TIMS	(N'000000')	Yes		TIMS	Allow NULL?
129	/MRSS/TO_DURAT	Character Field Length = 10	nvarchar	10	0	CHAR	(N' ')	Yes		CHAR10	Allow NULL?
130	/MRSS/TO_DUNIT	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
131	/MRSS/TO_DISTAN	19 Characters	nvarchar	19	0	CHAR	(N' ')	Yes		CHAR19	Allow NULL?
132	/MRSS/TO_MANUAL	Boolean Variable	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_BOOLEAN	Allow NULL?
133	/MRSS/FR_BEGDAT	Field of type DATS	nvarchar	8	0	DATS	(N'00000000')	Yes		DATS	Allow NULL?
134	/MRSS/FR_BEGTIM	Field of type TIMS	nvarchar	6	0	TIMS	(N'000000')	Yes		TIMS	Allow NULL?
135	/MRSS/FR_ENDDAT	Field of type DATS	nvarchar	8	0	DATS	(N'00000000')	Yes		DATS	Allow NULL?
136	/MRSS/FR_ENDTIM	Field of type TIMS	nvarchar	6	0	TIMS	(N'000000')	Yes		TIMS	Allow NULL?
137	/MRSS/FR_DURAT	Character Field Length = 10	nvarchar	10	0	CHAR	(N' ')	Yes		CHAR10	Allow NULL?
138	/MRSS/FR_DUNIT	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
139	/MRSS/FR_DISTAN	19 Characters	nvarchar	19	0	CHAR	(N' ')	Yes		CHAR19	Allow NULL?
140	/MRSS/FR_MANUAL	Boolean Variable	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_BOOLEAN	Allow NULL?
141	ILART_OP	Maintenance activity type	nvarchar	3	0	CHAR	(N' ')	Yes	*	ILA	Allow NULL?
142	FERC_IND	Regulatory indicator	nvarchar	4	0	CHAR	(N' ')	Yes	FERC_C7	FE_IND	Allow NULL?
143	J_3GVVCOM1	Comment	nvarchar	40	0	CHAR	(N' ')	Yes		J_3GVVCOM	Allow NULL?
144	J_3GVVCOM2	Comment	nvarchar	40	0	CHAR	(N' ')	Yes		J_3GVVCOM	Allow NULL?
145	GSGEW	Total Weight	decimal	15	3	QUAN	((0))	Yes		GSGEW
146	GEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	GEWEI	Allow NULL?
147	J_3GABS_BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
148	J_3GABS_GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
149	MBLNR	Number of Material Document	nvarchar	10	0	CHAR	(N' ')	Yes		MBLNR	Allow NULL?
150	MJAHR	Material Document Year	nvarchar	4	0	NUMC	(N'0000')	Yes		MJAHR	Allow NULL?
151	J_3GEMP_BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
152	J_3GEMP_GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
153	J_3GABSNPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	*	NPLNR	Allow NULL?
154	J_3GABSVORNR	Operation/Activity Number	nvarchar	4	0	CHAR	(N' ')	Yes		VORNR	Allow NULL?
155	J_3GEMPNPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	*	NPLNR	Allow NULL?
156	J_3GEMPVORNR	Operation/Activity Number	nvarchar	4	0	CHAR	(N' ')	Yes		VORNR	Allow NULL?

TOP ERP 6.0 | J_3GBELK INDEXES

Name	Primary	Unique	Type	Columns
J_3GBELK~0	Yes	Yes	CLUSTERED	J_3GBELNRI, MANDT
J_3GBELK~001	No	No	NONCLUSTERED	J_3GBELNR, MANDT
J_3GBELK~002	No	No	NONCLUSTERED	J_3GBELDAT, 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

156 COLUMNS | 3 INDEXES | ERP 6.0 | J_3GBELK TABLE

TOP ERP 6.0 | J_3GBELK COLUMNS

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

156 COLUMNS | 3 INDEXES | ERP 6.0 | J_3GBELK TABLE

TOPERP 6.0 | J_3GBELK COLUMNS

TOPERP 6.0 | J_3GBELK INDEXES

TOP ERP 6.0 | J_3GBELK COLUMNS

TOP ERP 6.0 | J_3GBELK INDEXES