SAP ABAP Table /SAPCEM/VJ_3GBELK (Change Document Structure; Generated by RSSCD000)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-EC-CEM (Application Component) Construction Equipment Management
     ⤷ /SAPCEM/CHANGE_DOCUMENT (Package) Change Documents

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPCEM/VJ_3GBELK	Table Relationship Diagram
Short Description	Change Document Structure; Generated by RSSCD000

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in