SAP ABAP Table J_3GBELK (Document File - Header Data)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-EC-CEM (Application Component) Construction Equipment Management
     ⤷ J3GD (Package) CEM Dictionary Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_3GBELK	Table Relationship Diagram
Short Description	Document File - Header Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	J_3GBELNRI	☑	J_3GBELNRI	J_3GBELNR	CHAR	10	0	Document Number
3	.INCLUDE	☐				0	0	Administrative Data for CEM Documents
4	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
5	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
9	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	J_3GABSEND	☐	J_3GABSEND	KUNNR	CHAR	10	0	Sender	KNA1
11	J_3GABSREF	☐	J_3GABSREF	J_3GREFTYP	CHAR	2	0	Reference Type Sender
12	J_3GABSPSP	☐	J_3GABSPSP	PS_POSNR	NUMC	8	0	WBS Element Sender	PRPS
13	J_3GABSPRO	☐	J_3GABSPRO	PS_PSPNR	NUMC	8	0	Project Number Sender	PROJ
14	J_3GABSKOS	☐	J_3GABSKOS	KOSTL	CHAR	10	0	Cost Center Sender	CSKS
15	J_3GABSKOK	☐	J_3GABSKOK	CACCD	CHAR	4	0	Controlling Area Sender	TKA01
16	J_3GABSACO	☐	J_3GABSACO	AUFNR	CHAR	12	0	Sender of CO Order	AUFK
17	J_3GABSAPM	☐	J_3GABSAPM	AUFNR	CHAR	12	0	Sender of PM Order	AUFK
18	J_3GABSWRK	☐	J_3GABSWRK	WERKS	CHAR	4	0	Plant Sender	T001W
19	J_3GABSLAG	☐	J_3GABSLAG	LGORT	CHAR	4	0	Storage Location/Warehouse Sender	T001L
20	J_3GABSEXT	☐	J_3GABSEXT	KUNNR	CHAR	10	0	External Ship-to Party - Sender	KNA1
21	J_3GABSDEB	☐	J_3GABSDEB	KUNNR	CHAR	10	0	Debtor of Sender	KNA1
22	J_3GEMPFAE	☐	J_3GEMPFAE	KUNNR	CHAR	10	0	Recipient	KNA1
23	.INCLUDE	☐				0	0	General Data Fields for Document Header and Items
24	J_3GEMPREF	☐	J_3GEMPREF	J_3GREFTYP	CHAR	2	0	Receiving Reference Type
25	J_3GEMPPSP	☐	J_3GEMPPSP	PS_POSNR	NUMC	8	0	Receiving WBS Element	PRPS
26	J_3GEMPPRO	☐	J_3GEMPPRO	PS_PSPNR	NUMC	8	0	Receiving Project Number	PROJ
27	J_3GEMPKOS	☐	J_3GEMPKOS	KOSTL	CHAR	10	0	Receiving Cost Center	CSKS
28	J_3GEMPKOK	☐	J_3GEMPKOK	CACCD	CHAR	4	0	Receiving Controlling Area	TKA01
29	J_3GEMPACO	☐	J_3GEMPACO	AUFNR	CHAR	12	0	CO Order Recipient	AUFK
30	J_3GEMPAPM	☐	J_3GEMPAPM	AUFNR	CHAR	12	0	PM Order Recipient	AUFK
31	J_3GEMPWRK	☐	J_3GEMPWRK	WERKS	CHAR	4	0	Receiving Plant	T001W
32	J_3GEMPLAG	☐	J_3GEMPLAG	LGORT	CHAR	4	0	Receiving Storage Location	T001L
33	J_3GEMPEXT	☐	J_3GEMPEXT	KUNNR	CHAR	10	0	External Ship-To Party - Recipient	KNA1
34	J_3GEMPDEB	☐	J_3GEMPDEB	KUNNR	CHAR	10	0	Debtor of Recipient	KNA1
35	J_3GMITTLE	☐	J_3GMITTLE	KUNNR	CHAR	10	0	Intermediate Recipient	KNA1
36	J_3GMITREF	☐	J_3GMITREF	J_3GREFTYP	CHAR	2	0	Reference Type - Intermediate Recipient
37	J_3GMITPSP	☐	J_3GMITPSP	PS_POSNR	NUMC	8	0	WBS Element - Intermediate Recipient	PRPS
38	J_3GMITPRO	☐	J_3GMITPRO	PS_PSPNR	NUMC	8	0	Project Number - Intermediate Recipient	PROJ
39	J_3GMITKOS	☐	J_3GMITKOS	KOSTL	CHAR	10	0	Cost Center - Intermediate Recipient	CSKS
40	J_3GMITKOK	☐	J_3GMITKOK	CACCD	CHAR	4	0	Controlling Area - Intermediate Recipient	TKA01
41	J_3GMITACO	☐	J_3GMITACO	AUFNR	CHAR	12	0	CO Order - Intermediate Recipient	AUFK
42	J_3GMITAPM	☐	J_3GMITAPM	AUFNR	CHAR	12	0	PM Order Recipient	AUFK
43	J_3GMITWRK	☐	J_3GMITWRK	WERKS	CHAR	4	0	Plant - Intermediate Recipient	T001W
44	J_3GMITLAG	☐	J_3GMITLAG	LGORT	CHAR	4	0	Storage Location - Intermediate Recipient	T001L
45	J_3GFREMDP	☐	J_3GFREMDP	X	CHAR	1	0	Indicator for External Employees
46	PERNR	☐	J_3GPERNR	J_3GPERNR	NUMC	8	0	Personal Number	*
47	NACHN	☐	NACHN	NACHN	CHAR	25	0	Last Name
48	J_3GEMPPER	☐	J_3GEMPPER	KUNNR	CHAR	10	0	Receiving Cost Center for Personnel	KNA1
49	J_3GBELSTA	☐	J_3GBELSTA	J_3GBELSTA	CHAR	1	0	Internal Document Status
50	J_3GPIABS	☐	J_3GPIABS	J_3GPAUSCH	CHAR	1	0	Document Flat Rate Indicator (Internal) - Sender
51	J_3GPEABS	☐	J_3GPEABS	J_3GPAUSCH	CHAR	1	0	Document Flat Rate Indicator (External) - Sender
52	J_3GPIEMPF	☐	J_3GPIEMPS	J_3GPAUSCH	CHAR	1	0	Document Flat Rate Indicator (Internal) - Recipient
53	J_3GPEEMPS	☐	J_3GPEEMPS	J_3GPAUSCH	CHAR	1	0	Document Flat Rate Indicator (External) - Recipient
54	J_3GBETR1	☐	J_3GBETR1	WERTV8	CURR	15	2	Internal Flat Rate - Sender
55	J_3GBETR2	☐	J_3GBETR2	WERTV8	CURR	15	2	External Flat Rate - Sender
56	J_3GBETR3	☐	J_3GBETR3	WERTV8	CURR	15	2	Internal Flat Rate - Recipient
57	J_3GBETR4	☐	J_3GBETR4	WERTV8	CURR	15	2	External Flat Rate - Recipient
58	J_3GWAERS1	☐	J_3GWAERS1	WAERS	CUKY	5	0	Currency Flat Rate Amount (Internal) - Sender	TCURC
59	J_3GWAERS2	☐	J_3GWAERS2	WAERS	CUKY	5	0	Currency Flat Rate Amount (External) - Sender	TCURC
60	J_3GWAERS3	☐	J_3GWAERS3	WAERS	CUKY	5	0	Currency Flat Rate Amount (Internal) - Recipient	TCURC
61	J_3GWAERS4	☐	J_3GWAERS4	WAERS	CUKY	5	0	Currency Flat Rate Amount (External) - Recipient	TCURC
62	J_3GFAKTAB	☐	J_3GFAKTAB	J_3GFAKTKZ	CHAR	1	0	Billing Indicator - Sender
63	J_3GFAKTEM	☐	J_3GFAKTEM	J_3GFAKTKZ	CHAR	1	0	Billing Indicator - Recipient
64	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
65	J_3GTPLKZ	☐	J_3GTPLKZ	J_3GTPLKZ	CHAR	5	0	Catalog Code	J_3GT370S
66	J_3GKATNRC	☐	J_3GKATNRC	J_3GKATNRC	CHAR	30	0	Number in Catalog	J_3GKATAL
67	LFDNR	☐	J_3GLFDNR4	NUMC4	NUMC	4	0	Sequence Number
68	J_3GDOMLMB	☐	J_3GDOMLMB	J_3GDOMLMB	CHAR	1	0	Pricing Dominancy (Provider/Intermediate Recipient/Debtor)
69	J_3GDOMMB	☐	J_3GDOMMB	J_3GDOMLMB	CHAR	1	0	Pricing Dominancy (Intermediate Recipient/Debtor)
70	J_3GBELNR	☐	J_3GBELNR	J_3GBELNR	CHAR	10	0	External Document Number
71	J_3GBLART	☐	J_3GBLART	J_3GBLART	CHAR	4	0	Document Type	J_3GBELART
72	J_3GBLTYP	☐	J_3GBLTYP	J_3GBLTYP	CHAR	1	0	CEM Document Category
73	J_3GBELDAT	☐	J_3GBELDAT	DATUM	DATS	8	0	CEM Document Date
74	VKORG	☐	/SAPCEM/VKORG	VKORG	CHAR	4	0	Sales Organization, but Obsolete	TVKO
75	VTWEG	☐	/SAPCEM/VTWEG	VTWEG	CHAR	2	0	Distribution Channel, but Obsolete	TVTW
76	SPART	☐	/SAPCEM/SPART	SPART	CHAR	2	0	Division, but Obsolete	TSPA
77	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
78	J_3GBEWEG	☐	J_3GBEWEG	J_3GBEWEG	CHAR	1	0	Internal Indicator for Transaction Type
79	J_3GBELSTE	☐	J_3GBELSTE	J_3GBELSTA	CHAR	1	0	External Document Status
80	.INCLUDE	☐				0	0	User-Defined Fields
81	.INCLUDE	☐				0	0	Include structure of the user fields of the operation
82	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
83	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
84	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
85	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
86	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
87	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
88	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
89	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
90	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
91	USR06	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
92	USE06	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
93	USR07	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
94	USE07	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
95	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
96	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
97	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
98	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
99	.INCLUDE	☐				0	0	JV data: (GJV_DATA_2),jv_oco
100	.INCLUDE	☐				0	0	JV data: (vname,recid,etype),jv_otype,jv_jibcl,jv_jibsa
101	.INCLUDE	☐				0	0	General assignments of application objects
102	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
103	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
104	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JG
105	JV_OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
106	JV_JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
107	JV_JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
108	JV_OCO	☐	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
109	.INCLUDE	☐				0	0
110	SPARAMETER1	☐	SPARAMETER		CHAR	4	0	Scheduling Parameters for External Scheduling
111	SPARAMETER2	☐	SPARAMETER		CHAR	4	0	Scheduling Parameters for External Scheduling
112	SPARAMETER3	☐	SPARAMETER		CHAR	4	0	Scheduling Parameters for External Scheduling
113	.INCLU--AP	☐				0	0	AFVUI APPEND for Operation Account Assignment
114	ILART_OP	☐	ILA	ILART	CHAR	3	0	Maintenance activity type	*
115	.INCLU--AP	☐				0	0	Append structure for Regulatory Reporting
116	FERC_IND	☐	FE_IND	FE_IND	CHAR	4	0	Regulatory indicator	FERC_C7
117	J_3GVVCOM1	☐	J_3GVVCOM	CHAR40	CHAR	40	0	Comment
118	J_3GVVCOM2	☐	J_3GVVCOM	CHAR40	CHAR	40	0	Comment
119	GSGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
120	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
121	J_3GABS_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
122	J_3GABS_GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
123	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
124	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
125	J_3GEMP_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
126	J_3GEMP_GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
127	J_3GABSNPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
128	J_3GABSVORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
129	J_3GEMPNPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
130	J_3GEMPVORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3GBELK	EQUNR	EQUI	EQUNR
2	J_3GBELK	ETYPE	T8JG	ETYPE
3	J_3GBELK	FERC_IND	FERC_C7	IND	REF
4	J_3GBELK	INCO1	TINC	INCO1
5	J_3GBELK	JV_JIBCL	T8J6A	CLASS
6	J_3GBELK	JV_JIBSA	T8J6C	SUBCLASS	KEY	1	CN
7	J_3GBELK	J_3GABSACO	AUFK	AUFNR
8	J_3GBELK	J_3GABSAPM	AUFK	AUFNR
9	J_3GBELK	J_3GABSDEB	KNA1	KUNNR
10	J_3GBELK	J_3GABSEND	KNA1	KUNNR
11	J_3GBELK	J_3GABSEXT	KNA1	KUNNR
12	J_3GBELK	J_3GABSKOK	TKA01	KOKRS
13	J_3GBELK	J_3GABSKOS	CSKS	KOSTL
14	J_3GBELK	J_3GABSLAG	T001L	LGORT
15	J_3GBELK	J_3GABSPRO	PROJ	PSPNR
16	J_3GBELK	J_3GABSPSP	PRPS	PSPNR
17	J_3GBELK	J_3GABSWRK	T001W	WERKS
18	J_3GBELK	J_3GBLART	J_3GBELART	J_3GBLART
19	J_3GBELK	J_3GEMPACO	AUFK	AUFNR
20	J_3GBELK	J_3GEMPAPM	AUFK	AUFNR
21	J_3GBELK	J_3GEMPDEB	KNA1	KUNNR
22	J_3GBELK	J_3GEMPEXT	KNA1	KUNNR
23	J_3GBELK	J_3GEMPFAE	KNA1	KUNNR
24	J_3GBELK	J_3GEMPKOK	TKA01	KOKRS
25	J_3GBELK	J_3GEMPKOS	CSKS	KOSTL
26	J_3GBELK	J_3GEMPLAG	T001L	LGORT
27	J_3GBELK	J_3GEMPPER	KNA1	KUNNR
28	J_3GBELK	J_3GEMPPRO	PROJ	PSPNR
29	J_3GBELK	J_3GEMPPSP	PRPS	PSPNR
30	J_3GBELK	J_3GEMPWRK	T001W	WERKS
31	J_3GBELK	J_3GKATNRC	J_3GKATAL	J_3GKATNRC
32	J_3GBELK	J_3GMITACO	AUFK	AUFNR
33	J_3GBELK	J_3GMITAPM	AUFK	AUFNR
34	J_3GBELK	J_3GMITKOK	TKA01	KOKRS
35	J_3GBELK	J_3GMITKOS	CSKS	KOSTL
36	J_3GBELK	J_3GMITLAG	T001L	LGORT
37	J_3GBELK	J_3GMITPRO	PROJ	PSPNR
38	J_3GBELK	J_3GMITPSP	PRPS	PSPNR
39	J_3GBELK	J_3GMITTLE	KNA1	KUNNR
40	J_3GBELK	J_3GMITWRK	T001W	WERKS
41	J_3GBELK	J_3GTPLKZ	J_3GT370S	J_3GTPLKZ
42	J_3GBELK	J_3GWAERS1	TCURC	WAERS
43	J_3GBELK	J_3GWAERS2	TCURC	WAERS
44	J_3GBELK	J_3GWAERS3	TCURC	WAERS
45	J_3GBELK	J_3GWAERS4	TCURC	WAERS
46	J_3GBELK	MANDT	T000	MANDT	KEY	1	CN
47	J_3GBELK	RECID	T8JJ	RECID	REF
48	J_3GBELK	SLWID	TCN00	SLWID
49	J_3GBELK	SPART	TSPA	SPART		1	CN
50	J_3GBELK	USE04	T006	MSEHI
51	J_3GBELK	USE05	T006	MSEHI
52	J_3GBELK	USE06	TCURC	WAERS
53	J_3GBELK	USE07	TCURC	WAERS
54	J_3GBELK	VKORG	TVKO	VKORG	REF	1	CN
55	J_3GBELK	VNAME	T8JV	VNAME
56	J_3GBELK	VTWEG	TVTW	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in