	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

205 COLUMNS | 2 INDEXES | ERP 6.0 | J_3GBELP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Engineering Construction :: Construction Equipment Management
1	ERP EHP7	6.0	J_3GBELP	205	2	Document Data - Item 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, J_3GPOSNRI, J_3GUPOSNR, 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_3GPOSNR, J_3GGRUND, J_3GLFDNR, J_3GLVART, J_3GMENGE, J_3GMEINS, J_3GMENGE2, J_3GMEINS2, J_3GKZLATR, J_3GVBELNE, EQUNR2, J_3GKZMENG, MATNR, J_3GGENSTA, J_3GKZFRIS, J_3GEINEND, J_3GDATLAB, J_3GKZLADI, J_3GKZLADE, J_3GKZBERG, J_3GBESTEM, J_3GKZSPIL, J_3GKZSPEL, J_3GKZSPIB, J_3GKZSPEB, J_3GKZLVOI, J_3GKZLVOE, J_3GUMVERI, J_3GUMVERE, J_3GIMPT1, J_3GIMPT2, J_3GMPOBJ, J_3GMPBEG1, J_3GMPEND1, J_3GCDIFF, J_3GMDOCM1, J_3GMDOCM2, J_3GIDATE, J_3GITIME, 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, J_3GGEWICHT, J_3GGEWEI, J_3GPAKKENN, CHARGE, J_3GPKOKRS, J_3GPKOSTL, J_3GRESTYP, J_3GLVART_WL, J_3GBFART, /SAPCEM/BDNUM, /SAPCEM/BDPOS, /SAPCEM/FRISTDAT, J_3GEMP_CHARGE, RSNUM, RSPOS, J_3GABSNPLNR, J_3GABSVORNR, J_3GEMPNPLNR, J_3GEMPVORNR, RUECK, RMZHL, /SAPCEM/BDENDU, BEDID, BEDZL, CANUM, /SAPCEM/AUFNR, /SAPCEM/VORNR, /SAPCEM/UVORN FROM J_3GBELP

TOP ERP 6.0 | J_3GBELP 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_3GBELK	J_3GBELNRI	Allow NULL?
3	J_3GPOSNRI	Document Item	nvarchar	5	0	NUMC	(N'00000')	No		J_3GBELPOS	Allow NULL?
4	J_3GUPOSNR	Sub-Item Number	nvarchar	2	0	NUMC	(N'00')	No		J_3GUPOSNR	Allow NULL?
5	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
6	ERZET	Entry time	nvarchar	6	0	TIMS	(N'000000')	Yes		ERZET	Allow NULL?
7	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
8	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
9	AEZET	Time last change was made	nvarchar	6	0	TIMS	(N'000000')	Yes		AEZET	Allow NULL?
10	AEDTM	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
11	J_3GABSEND	Sender	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GABSEND	Allow NULL?
12	J_3GABSREF	Reference Type Sender	nvarchar	2	0	CHAR	(N' ')	Yes		J_3GABSREF	Allow NULL?
13	J_3GABSPSP	WBS Element Sender	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	J_3GABSPSP	Allow NULL?
14	J_3GABSPRO	Project Number Sender	nvarchar	8	0	NUMC	(N'00000000')	Yes	PROJ	J_3GABSPRO	Allow NULL?
15	J_3GABSKOS	Cost Center Sender	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	J_3GABSKOS	Allow NULL?
16	J_3GABSKOK	Controlling Area Sender	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	J_3GABSKOK	Allow NULL?
17	J_3GABSACO	Sender of CO Order	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GABSACO	Allow NULL?
18	J_3GABSAPM	Sender of PM Order	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GABSAPM	Allow NULL?
19	J_3GABSWRK	Plant Sender	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	J_3GABSWRK	Allow NULL?
20	J_3GABSLAG	Storage Location/Warehouse Sender	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	J_3GABSLAG	Allow NULL?
21	J_3GABSEXT	External Ship-to Party - Sender	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GABSEXT	Allow NULL?
22	J_3GABSDEB	Debtor of Sender	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GABSDEB	Allow NULL?
23	J_3GEMPFAE	Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GEMPFAE	Allow NULL?
24	J_3GEMPREF	Receiving Reference Type	nvarchar	2	0	CHAR	(N' ')	Yes		J_3GEMPREF	Allow NULL?
25	J_3GEMPPSP	Receiving WBS Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	J_3GEMPPSP	Allow NULL?
26	J_3GEMPPRO	Receiving Project Number	nvarchar	8	0	NUMC	(N'00000000')	Yes	PROJ	J_3GEMPPRO	Allow NULL?
27	J_3GEMPKOS	Receiving Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	J_3GEMPKOS	Allow NULL?
28	J_3GEMPKOK	Receiving Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	J_3GEMPKOK	Allow NULL?
29	J_3GEMPACO	CO Order Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GEMPACO	Allow NULL?
30	J_3GEMPAPM	PM Order Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GEMPAPM	Allow NULL?
31	J_3GEMPWRK	Receiving Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	J_3GEMPWRK	Allow NULL?
32	J_3GEMPLAG	Receiving Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	J_3GEMPLAG	Allow NULL?
33	J_3GEMPEXT	External Ship-To Party - Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GEMPEXT	Allow NULL?
34	J_3GEMPDEB	Debtor of Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GEMPDEB	Allow NULL?
35	J_3GMITTLE	Intermediate Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	*	J_3GMITTLE	Allow NULL?
36	J_3GMITREF	Reference Type - Intermediate Recipient	nvarchar	2	0	CHAR	(N' ')	Yes		J_3GMITREF	Allow NULL?
37	J_3GMITPSP	WBS Element - Intermediate Recipient	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	J_3GMITPSP	Allow NULL?
38	J_3GMITPRO	Project Number - Intermediate Recipient	nvarchar	8	0	NUMC	(N'00000000')	Yes	PROJ	J_3GMITPRO	Allow NULL?
39	J_3GMITKOS	Cost Center - Intermediate Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	J_3GMITKOS	Allow NULL?
40	J_3GMITKOK	Controlling Area - Intermediate Recipient	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	J_3GMITKOK	Allow NULL?
41	J_3GMITACO	CO Order - Intermediate Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GMITACO	Allow NULL?
42	J_3GMITAPM	PM Order Recipient	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	J_3GMITAPM	Allow NULL?
43	J_3GMITWRK	Plant - Intermediate Recipient	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	J_3GMITWRK	Allow NULL?
44	J_3GMITLAG	Storage Location - Intermediate Recipient	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	J_3GMITLAG	Allow NULL?
45	J_3GFREMDP	Indicator for External Employees	char	1	0	CHAR	(N' ')	Yes		J_3GFREMDP	Allow NULL?
46	PERNR	Personal Number	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	J_3GPERNR	Allow NULL?
47	NACHN	Last Name	nvarchar	25	0	CHAR	(N' ')	Yes		NACHN	Allow NULL?
48	J_3GEMPPER	Receiving Cost Center for Personnel	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GEMPPER	Allow NULL?
49	J_3GBELSTA	Internal Document Status	char	1	0	CHAR	(N' ')	Yes		J_3GBELSTA	Allow NULL?
50	J_3GPIABS	Document Flat Rate Indicator (Internal) - Sender	char	1	0	CHAR	(N' ')	Yes		J_3GPIABS	Allow NULL?
51	J_3GPEABS	Document Flat Rate Indicator (External) - Sender	char	1	0	CHAR	(N' ')	Yes		J_3GPEABS	Allow NULL?
52	J_3GPIEMPF	Document Flat Rate Indicator (Internal) - Recipient	char	1	0	CHAR	(N' ')	Yes		J_3GPIEMPS	Allow NULL?
53	J_3GPEEMPS	Document Flat Rate Indicator (External) - Recipient	char	1	0	CHAR	(N' ')	Yes		J_3GPEEMPS	Allow NULL?
54	J_3GBETR1	Internal Flat Rate - Sender	decimal	15	2	CURR	((0))	Yes		J_3GBETR1
55	J_3GBETR2	External Flat Rate - Sender	decimal	15	2	CURR	((0))	Yes		J_3GBETR2
56	J_3GBETR3	Internal Flat Rate - Recipient	decimal	15	2	CURR	((0))	Yes		J_3GBETR3
57	J_3GBETR4	External Flat Rate - Recipient	decimal	15	2	CURR	((0))	Yes		J_3GBETR4
58	J_3GWAERS1	Currency Flat Rate Amount (Internal) - Sender	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	J_3GWAERS1	Allow NULL?
59	J_3GWAERS2	Currency Flat Rate Amount (External) - Sender	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	J_3GWAERS2	Allow NULL?
60	J_3GWAERS3	Currency Flat Rate Amount (Internal) - Recipient	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	J_3GWAERS3	Allow NULL?
61	J_3GWAERS4	Currency Flat Rate Amount (External) - Recipient	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	J_3GWAERS4	Allow NULL?
62	J_3GFAKTAB	Billing Indicator - Sender	char	1	0	CHAR	(N' ')	Yes		J_3GFAKTAB	Allow NULL?
63	J_3GFAKTEM	Billing Indicator - Recipient	char	1	0	CHAR	(N' ')	Yes		J_3GFAKTEM	Allow NULL?
64	EQUNR	Equipment Number	nvarchar	18	0	CHAR	(N' ')	Yes	EQUI	EQUNR	Allow NULL?
65	J_3GTPLKZ	Catalog Code	nvarchar	5	0	CHAR	(N' ')	Yes	J_3GT370S	J_3GTPLKZ	Allow NULL?
66	J_3GKATNRC	Number in Catalog	nvarchar	30	0	CHAR	(N' ')	Yes	J_3GKATAL	J_3GKATNRC	Allow NULL?
67	LFDNR	Sequence Number	nvarchar	4	0	NUMC	(N'0000')	Yes		J_3GLFDNR4	Allow NULL?
68	J_3GDOMLMB	Pricing Dominancy (Provider/Intermediate Recipient/Debtor)	char	1	0	CHAR	(N' ')	Yes		J_3GDOMLMB	Allow NULL?
69	J_3GDOMMB	Pricing Dominancy (Intermediate Recipient/Debtor)	char	1	0	CHAR	(N' ')	Yes		J_3GDOMMB	Allow NULL?
70	J_3GBELNR	External Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		J_3GBELNR	Allow NULL?
71	J_3GPOSNR	Document Item	nvarchar	5	0	NUMC	(N'00000')	Yes	*	J_3GBELPOS	Allow NULL?
72	J_3GGRUND	Internal Indicator for Transaction Type	char	1	0	CHAR	(N' ')	Yes	J_3GZUABGR	J_3GBEWEG	Allow NULL?
73	J_3GLFDNR	Sequence Number	nvarchar	2	0	NUMC	(N'00')	Yes	J_3GZUABGR	J_3GLFDNR2	Allow NULL?
74	J_3GLVART	Activity Type	nvarchar	4	0	CHAR	(N' ')	Yes	J_3GLEIART	J_3GLVART	Allow NULL?
75	J_3GMENGE	Quantity	decimal	13	3	QUAN	((0))	Yes		J_3GMENGE
76	J_3GMEINS	Unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINA	Allow NULL?
77	J_3GMENGE2	Quantity	decimal	13	3	QUAN	((0))	Yes		J_3GMENGE
78	J_3GMEINS2	Unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINA	Allow NULL?
79	J_3GKZLATR	Activity Type Separation	char	1	0	CHAR	(N' ')	Yes		J_3GKZLATR	Allow NULL?
80	J_3GVBELNE	Number of External Billing Document	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	J_3GVBELNE	Allow NULL?
81	EQUNR2	Equipment Number	nvarchar	18	0	CHAR	(N' ')	Yes	EQUI	EQUNR	Allow NULL?
82	J_3GKZMENG	Item/Multipart Indicator	char	1	0	CHAR	(N' ')	Yes		J_3GKZMENG	Allow NULL?
83	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
84	J_3GGENSTA	Generation Status	char	1	0	CHAR	(N' ')	Yes		J_3GGENSTA	Allow NULL?
85	J_3GKZFRIS	Usage Period Indicator	char	1	0	CHAR	(N' ')	Yes		J_3GKZFRIS	Allow NULL?
86	J_3GEINEND	End of Usage Period	nvarchar	8	0	DATS	(N'00000000')	Yes		J_3GEINEND	Allow NULL?
87	J_3GDATLAB	Date of Activity Output	nvarchar	8	0	DATS	(N'00000000')	Yes		J_3GDATLAB	Allow NULL?
88	J_3GKZLADI	Indicator: Internal Loading Costs	char	1	0	CHAR	(N' ')	Yes		J_3GKZLADI	Allow NULL?
89	J_3GKZLADE	Indicator: External (Un)Loading Costs	char	1	0	CHAR	(N' ')	Yes		J_3GKZLADE	Allow NULL?
90	J_3GKZBERG	Indicator for Provision Fees	char	1	0	CHAR	(N' ')	Yes		J_3GKZBERG	Allow NULL?
91	J_3GBESTEM	Inventory Management - Recipient	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	J_3GBESTEM	Allow NULL?
92	J_3GKZSPIL	Indicator: Special Price for Internal Provider of Service	char	1	0	CHAR	(N' ')	Yes		J_3GKZSPIL	Allow NULL?
93	J_3GKZSPEL	Indicator: Special Price for External Provider of Service	char	1	0	CHAR	(N' ')	Yes		J_3GKZSPEL	Allow NULL?
94	J_3GKZSPIB	Indicator: Special Price for Internal Recipient of Service	char	1	0	CHAR	(N' ')	Yes		J_3GKZSPIB	Allow NULL?
95	J_3GKZSPEB	Indicator: Special Price for External Recipient of Service	char	1	0	CHAR	(N' ')	Yes		J_3GKZSPEB	Allow NULL?
96	J_3GKZLVOI	Indicator: Calculate Internal PBE as TBE	char	1	0	CHAR	(N' ')	Yes		J_3GKZLVOI	Allow NULL?
97	J_3GKZLVOE	Indicator: Calculate external PBE as TBE	char	1	0	CHAR	(N' ')	Yes		J_3GKZLVOE	Allow NULL?
98	J_3GUMVERI	Redirection Settlement Type - Internal	nvarchar	4	0	CHAR	(N' ')	Yes	J_3GLEIART	J_3GUMVERI	Allow NULL?
99	J_3GUMVERE	Redirection Settlement Type - External	nvarchar	4	0	CHAR	(N' ')	Yes	J_3GLEIART	J_3GUMVERE	Allow NULL?
100	J_3GIMPT1	Actual Value of Measuring Point	nvarchar	12	0	CHAR	(N' ')	Yes	*	J_3GIMPT1	Allow NULL?
101	J_3GIMPT2	Calculated Value of Measuring Point	nvarchar	12	0	CHAR	(N' ')	Yes	*	J_3GIMPT2	Allow NULL?
102	J_3GMPOBJ	Object Number for the Measuring Point Object	nvarchar	22	0	CHAR	(N' ')	Yes	*	IMRC_MPOBJ	Allow NULL?
103	J_3GMPBEG1	Actual Start of Measuring Point	nvarchar	10	0	NUMC	(N'0000000000')	Yes		J_3GMPBEG1	Allow NULL?
104	J_3GMPEND1	Actual End of Measuring Point	nvarchar	10	0	NUMC	(N'0000000000')	Yes		J_3GMPEND1	Allow NULL?
105	J_3GCDIFF	Counter Reading Difference	nvarchar	10	0	NUMC	(N'0000000000')	Yes		J_3GCDIFF	Allow NULL?
106	J_3GMDOCM1	Measurement Document	nvarchar	20	0	CHAR	(N' ')	Yes	*	IMRC_MDOCM	Allow NULL?
107	J_3GMDOCM2	Measurement Document	nvarchar	20	0	CHAR	(N' ')	Yes	*	IMRC_MDOCM	Allow NULL?
108	J_3GIDATE	Date of the Measurement	nvarchar	8	0	DATS	(N'00000000')	Yes		IMRC_IDATE	Allow NULL?
109	J_3GITIME	Time of Measurement	nvarchar	6	0	TIMS	(N'000000')	Yes		IMRC_ITIME	Allow NULL?
110	J_3GBELSTE	External Document Status	char	1	0	CHAR	(N' ')	Yes		J_3GBELSTE	Allow NULL?
111	SLWID	Key word ID for user-defined fields	nvarchar	7	0	CHAR	(N' ')	Yes	TCN00	SLWID	Allow NULL?
112	USR00	User field with 20 characters	nvarchar	20	0	CHAR	(N' ')	Yes		USRCHAR20	Allow NULL?
113	USR01	User field with 20 characters	nvarchar	20	0	CHAR	(N' ')	Yes		USRCHAR20	Allow NULL?
114	USR02	User field with 10 characters	nvarchar	10	0	CHAR	(N' ')	Yes		USRCHAR10	Allow NULL?
115	USR03	User field with 10 characters	nvarchar	10	0	CHAR	(N' ')	Yes		USRCHAR10	Allow NULL?
116	USR04	User field for quantity (length 10.3)	decimal	13	3	QUAN	((0))	Yes		USRQUAN13
117	USE04	User field: Unit for quantity fields	nvarchar	3	0	UNIT	(N' ')	Yes	T006	USRUNIT	Allow NULL?
118	USR05	User field for quantity (length 10.3)	decimal	13	3	QUAN	((0))	Yes		USRQUAN13
119	USE05	User field: Unit for quantity fields	nvarchar	3	0	UNIT	(N' ')	Yes	T006	USRUNIT	Allow NULL?
120	USR06	User-defined field for values (length 10,3)	decimal	13	3	CURR	((0))	Yes		USRCURR13
121	USE06	User field: Unit for value fields	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	USRCUKY	Allow NULL?
122	USR07	User-defined field for values (length 10,3)	decimal	13	3	CURR	((0))	Yes		USRCURR13
123	USE07	User field: Unit for value fields	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	USRCUKY	Allow NULL?
124	USR08	User field for date	nvarchar	8	0	DATS	(N'00000000')	Yes		USRDATE	Allow NULL?
125	USR09	User field for date	nvarchar	8	0	DATS	(N'00000000')	Yes		USRDATE	Allow NULL?
126	USR10	User-defined field: Indicator for reports	char	1	0	CHAR	(N' ')	Yes		USRFLAG	Allow NULL?
127	USR11	User-defined field: Indicator for reports	char	1	0	CHAR	(N' ')	Yes		USRFLAG	Allow NULL?
128	VNAME	Joint Venture	nvarchar	6	0	CHAR	(N' ')	Yes	T8JV	JV_NAME	Allow NULL?
129	RECID	Recovery Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	T8JJ	JV_RECIND	Allow NULL?
130	ETYPE	Equity type	nvarchar	3	0	CHAR	(N' ')	Yes	T8JG	JV_ETYPE	Allow NULL?
131	JV_OTYPE	Joint Venture Object Type	nvarchar	4	0	CHAR	(N' ')	Yes		JV_OTYPE	Allow NULL?
132	JV_JIBCL	JIB/JIBE Class	nvarchar	3	0	CHAR	(N' ')	Yes	T8J6A	JV_JIBCL	Allow NULL?
133	JV_JIBSA	JIB/JIBE Subclass A	nvarchar	5	0	CHAR	(N' ')	Yes	T8J6C	JV_JIBSA	Allow NULL?
134	JV_OCO	JV original cost object	char	1	0	CHAR	(N' ')	Yes		JV_OR_CO	Allow NULL?
135	DUMMY_CI_AFVU	Single-Character Indicator	char	1	0	CHAR	(N' ')	Yes		CHAR1	Allow NULL?
136	SPARAMETER1	Scheduling Parameters for External Scheduling	nvarchar	4	0	CHAR	(N' ')	Yes		SPARAMETER	Allow NULL?
137	SPARAMETER2	Scheduling Parameters for External Scheduling	nvarchar	4	0	CHAR	(N' ')	Yes		SPARAMETER	Allow NULL?
138	SPARAMETER3	Scheduling Parameters for External Scheduling	nvarchar	4	0	CHAR	(N' ')	Yes		SPARAMETER	Allow NULL?
139	/MRSS/ID_PROFILE	Requirements Profile Was Changed Manually	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_REQU_UPD	Allow NULL?
140	/MRSS/PROF_KEY	Profile Key	nvarchar	10	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_REQUID	Allow NULL?
141	/MRSS/PROF_GUID	Character field, length 32	nvarchar	32	0	CHAR	(N' ')	Yes		CHAR32	Allow NULL?
142	/MRSS/ACT_TYPE	Process variant	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_ACTIVITY_TYPE	Allow NULL?
143	/MRSS/ORDER_PROB	Order probability in percent	nvarchar	3	0	CHAR	(N' ')	Yes		/MRSS/T_ORDER_PROB	Allow NULL?
144	/MRSS/INIT_DONE	Internal initialization carried out once	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_INIT_DONE	Allow NULL?
145	/MRSS/DATACHANGE	Data was changed in the controls on the user screen	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_USCREENCTL_DATACHANGED	Allow NULL?
146	/MRSS/DEM_COUNT	Counter for Demands in Operation	nvarchar	4	0	NUMC	(N'0000')	Yes		/MRSS/T_DEM_COUNT	Allow NULL?
147	/MRSS/SUPERV_CNT	Number of Site Supervisors	nvarchar	2	0	CHAR	(N' ')	Yes		/MRSS/T_RAP_SUPERVISOR_COUNT	Allow NULL?
148	/MRSS/RULE_ID	Time Rule Id	nvarchar	25	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_TIME_RULE_ID	Allow NULL?
149	/MRSS/SALES_ORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	*	VKORG	Allow NULL?
150	/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?
151	/MRSS/REFF_E_BEG	Time stamp: start	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		/MRSS/T_TIMESTAMP_BEGIN	Allow NULL?
152	/MRSS/REFF_E_END	Time stamp: end	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		/MRSS/T_TIMESTAMP_END	Allow NULL?
153	/MRSS/REFF_L_BEG	Time stamp: start	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		/MRSS/T_TIMESTAMP_BEGIN	Allow NULL?
154	/MRSS/REFF_L_END	Time stamp: end	nvarchar	14	0	NUMC	(N'00000000000000')	Yes		/MRSS/T_TIMESTAMP_END	Allow NULL?
155	/MRSS/RELEVANT	Operation Set as MRS-Relevant	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RELEVANT_FOR_MRS	Allow NULL?
156	/MRSS/TEAM_PLAN	Team Planning flag for Demand	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_TEAM_PLANNING	Allow NULL?
157	/MRSS/SINGL_RES	Combine Operations and Assign Same Resource	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_FORCE_SINGLE_RES	Allow NULL?
158	/MRSS/TO_BEGDAT	Field of type DATS	nvarchar	8	0	DATS	(N'00000000')	Yes		DATS	Allow NULL?
159	/MRSS/TO_BEGTIM	Field of type TIMS	nvarchar	6	0	TIMS	(N'000000')	Yes		TIMS	Allow NULL?
160	/MRSS/TO_ENDDAT	Field of type DATS	nvarchar	8	0	DATS	(N'00000000')	Yes		DATS	Allow NULL?
161	/MRSS/TO_ENDTIM	Field of type TIMS	nvarchar	6	0	TIMS	(N'000000')	Yes		TIMS	Allow NULL?
162	/MRSS/TO_DURAT	Character Field Length = 10	nvarchar	10	0	CHAR	(N' ')	Yes		CHAR10	Allow NULL?
163	/MRSS/TO_DUNIT	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
164	/MRSS/TO_DISTAN	19 Characters	nvarchar	19	0	CHAR	(N' ')	Yes		CHAR19	Allow NULL?
165	/MRSS/TO_MANUAL	Boolean Variable	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_BOOLEAN	Allow NULL?
166	/MRSS/FR_BEGDAT	Field of type DATS	nvarchar	8	0	DATS	(N'00000000')	Yes		DATS	Allow NULL?
167	/MRSS/FR_BEGTIM	Field of type TIMS	nvarchar	6	0	TIMS	(N'000000')	Yes		TIMS	Allow NULL?
168	/MRSS/FR_ENDDAT	Field of type DATS	nvarchar	8	0	DATS	(N'00000000')	Yes		DATS	Allow NULL?
169	/MRSS/FR_ENDTIM	Field of type TIMS	nvarchar	6	0	TIMS	(N'000000')	Yes		TIMS	Allow NULL?
170	/MRSS/FR_DURAT	Character Field Length = 10	nvarchar	10	0	CHAR	(N' ')	Yes		CHAR10	Allow NULL?
171	/MRSS/FR_DUNIT	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
172	/MRSS/FR_DISTAN	19 Characters	nvarchar	19	0	CHAR	(N' ')	Yes		CHAR19	Allow NULL?
173	/MRSS/FR_MANUAL	Boolean Variable	char	1	0	CHAR	(N' ')	Yes		/MRSS/T_RSG_BOOLEAN	Allow NULL?
174	ILART_OP	Maintenance activity type	nvarchar	3	0	CHAR	(N' ')	Yes	*	ILA	Allow NULL?
175	FERC_IND	Regulatory indicator	nvarchar	4	0	CHAR	(N' ')	Yes	FERC_C7	FE_IND	Allow NULL?
176	J_3GVVCOM1	Comment	nvarchar	40	0	CHAR	(N' ')	Yes		J_3GVVCOM	Allow NULL?
177	J_3GVVCOM2	Comment	nvarchar	40	0	CHAR	(N' ')	Yes		J_3GVVCOM	Allow NULL?
178	J_3GGEWICHT	Gross Weight of the Item	decimal	15	3	QUAN	((0))	Yes		BRGEW_AP
179	J_3GGEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	GEWEI	Allow NULL?
180	J_3GPAKKENN	Settlement Package Indicator	char	1	0	CHAR	(N' ')	Yes		J_3GPAKKENN	Allow NULL?
181	CHARGE	Batch Number	nvarchar	10	0	CHAR	(N' ')	No	MCH1	CHARG_D	Allow NULL?
182	J_3GPKOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	KOKRS	Allow NULL?
183	J_3GPKOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	KOSTL	Allow NULL?
184	J_3GRESTYP	Resource Indicator	nvarchar	2	0	CHAR	(N' ')	Yes		J_3GRESTYP	Allow NULL?
185	J_3GLVART_WL	Activity Type for Redelivery	nvarchar	4	0	CHAR	(N' ')	Yes	*	J_3GLVART_WL	Allow NULL?
186	J_3GBFART	Inventory Management Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	J_3GBFART	Allow NULL?
187	/SAPCEM/BDNUM	Number of Requisition Note	nvarchar	10	0	CHAR	(N' ')	Yes	/SAPCEM/BDKO	/SAPCEM/BDNUM	Allow NULL?
188	/SAPCEM/BDPOS	Requisition Note Item	nvarchar	5	0	NUMC	(N'00000')	Yes		/SAPCEM/BDPOS	Allow NULL?
189	/SAPCEM/FRISTDAT	End of Deadline	nvarchar	8	0	DATS	(N'00000000')	Yes		/SAPCEM/FRISTDAT	Allow NULL?
190	J_3GEMP_CHARGE	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
191	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	RSNUM	Allow NULL?
192	RSPOS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	NUMC	(N'0000')	Yes		RSPOS	Allow NULL?
193	J_3GABSNPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	NPLNR	Allow NULL?
194	J_3GABSVORNR	Operation/Activity Number	nvarchar	4	0	CHAR	(N' ')	Yes		VORNR	Allow NULL?
195	J_3GEMPNPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	NPLNR	Allow NULL?
196	J_3GEMPVORNR	Operation/Activity Number	nvarchar	4	0	CHAR	(N' ')	Yes		VORNR	Allow NULL?
197	RUECK	Completion confirmation number for the operation	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_RUECK	Allow NULL?
198	RMZHL	Confirmation counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CO_RMZHL	Allow NULL?
199	/SAPCEM/BDENDU	Requirement End: Time	nvarchar	6	0	TIMS	(N'000000')	Yes		/SAPCEM/BDENDU	Allow NULL?
200	BEDID	ID of the capacity requirements record	nvarchar	12	0	NUMC	(N'000000000000')	Yes	*	BEDID	Allow NULL?
201	BEDZL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
202	CANUM	Counters for cap. rqmts. records (various caps. + indiv.caps	nvarchar	4	0	NUMC	(N'0000')	Yes	*	CY_COUNT	Allow NULL?
203	/SAPCEM/AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	AUFNR	Allow NULL?
204	/SAPCEM/VORNR	Operation/Activity Number	nvarchar	4	0	CHAR	(N' ')	Yes		VORNR	Allow NULL?
205	/SAPCEM/UVORN	Suboperation	nvarchar	4	0	CHAR	(N' ')	Yes		UVORN	Allow NULL?

TOP ERP 6.0 | J_3GBELP INDEXES

Name	Primary	Unique	Type	Columns
J_3GBELP~0	Yes	Yes	CLUSTERED	J_3GUPOSNR, J_3GPOSNRI, J_3GBELNRI, MANDT
J_3GBELP~001	No	No	NONCLUSTERED	J_3GBELSTE, J_3GEMPDEB, J_3GBELSTA, J_3GDATLAB, J_3GUPOSNR

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

205 COLUMNS | 2 INDEXES | ERP 6.0 | J_3GBELP TABLE

TOP ERP 6.0 | J_3GBELP COLUMNS

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

205 COLUMNS | 2 INDEXES | ERP 6.0 | J_3GBELP TABLE

TOPERP 6.0 | J_3GBELP COLUMNS

TOPERP 6.0 | J_3GBELP INDEXES

TOP ERP 6.0 | J_3GBELP COLUMNS

TOP ERP 6.0 | J_3GBELP INDEXES