SAP ABAP Table J_3GMATRIX_ALT (Structure for Entry Matrix, Operator's Report)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	J_3GMATRIX_ALT	Table Relationship Diagram
Short Description	Structure for Entry Matrix, Operator's Report

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	J_3GBLART	☐	J_3GBLART	J_3GBLART	CHAR	4	0	Document Type	*
2	J_3GBLTYP	☐	J_3GBLTYP	J_3GBLTYP	CHAR	1	0	CEM Document Category
3	.INCLUDE	☐				0	0	Document Data - Item Data
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	J_3GBELNRI	☐	J_3GBELNRI	J_3GBELNR	CHAR	10	0	Document Number	J_3GBELK
6	J_3GPOSNRI	☐	J_3GBELPOS	J_3GPOSNR	NUMC	5	0	Document Item	*
7	J_3GUPOSNR	☐	J_3GUPOSNR	NUMC2	NUMC	2	0	Sub-Item Number
8	.INCLUDE	☐				0	0	Administrative Data for CEM Documents
9	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
11	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
14	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
15	J_3GABSEND	☐	J_3GABSEND	KUNNR	CHAR	10	0	Sender	KNA1
16	J_3GABSREF	☐	J_3GABSREF	J_3GREFTYP	CHAR	2	0	Reference Type Sender
17	J_3GABSPSP	☐	J_3GABSPSP	PS_POSNR	NUMC	8	0	WBS Element Sender	PRPS
18	J_3GABSPRO	☐	J_3GABSPRO	PS_PSPNR	NUMC	8	0	Project Number Sender	PROJ
19	J_3GABSKOS	☐	J_3GABSKOS	KOSTL	CHAR	10	0	Cost Center Sender	CSKS
20	J_3GABSKOK	☐	J_3GABSKOK	CACCD	CHAR	4	0	Controlling Area Sender	TKA01
21	J_3GABSACO	☐	J_3GABSACO	AUFNR	CHAR	12	0	Sender of CO Order	AUFK
22	J_3GABSAPM	☐	J_3GABSAPM	AUFNR	CHAR	12	0	Sender of PM Order	AUFK
23	J_3GABSWRK	☐	J_3GABSWRK	WERKS	CHAR	4	0	Plant Sender	T001W
24	J_3GABSLAG	☐	J_3GABSLAG	LGORT	CHAR	4	0	Storage Location/Warehouse Sender	T001L
25	J_3GABSEXT	☐	J_3GABSEXT	KUNNR	CHAR	10	0	External Ship-to Party - Sender	KNA1
26	J_3GABSDEB	☐	J_3GABSDEB	KUNNR	CHAR	10	0	Debtor of Sender	KNA1
27	J_3GEMPFAE	☐	J_3GEMPFAE	KUNNR	CHAR	10	0	Recipient	KNA1
28	.INCLUDE	☐				0	0	General Data Fields for Document Header and Items
29	J_3GEMPREF	☐	J_3GEMPREF	J_3GREFTYP	CHAR	2	0	Receiving Reference Type
30	J_3GEMPPSP	☐	J_3GEMPPSP	PS_POSNR	NUMC	8	0	Receiving WBS Element	PRPS
31	J_3GEMPPRO	☐	J_3GEMPPRO	PS_PSPNR	NUMC	8	0	Receiving Project Number	PROJ
32	J_3GEMPKOS	☐	J_3GEMPKOS	KOSTL	CHAR	10	0	Receiving Cost Center	CSKS
33	J_3GEMPKOK	☐	J_3GEMPKOK	CACCD	CHAR	4	0	Receiving Controlling Area	TKA01
34	J_3GEMPACO	☐	J_3GEMPACO	AUFNR	CHAR	12	0	CO Order Recipient	AUFK
35	J_3GEMPAPM	☐	J_3GEMPAPM	AUFNR	CHAR	12	0	PM Order Recipient	AUFK
36	J_3GEMPWRK	☐	J_3GEMPWRK	WERKS	CHAR	4	0	Receiving Plant	T001W
37	J_3GEMPLAG	☐	J_3GEMPLAG	LGORT	CHAR	4	0	Receiving Storage Location	T001L
38	J_3GEMPEXT	☐	J_3GEMPEXT	KUNNR	CHAR	10	0	External Ship-To Party - Recipient	KNA1
39	J_3GEMPDEB	☐	J_3GEMPDEB	KUNNR	CHAR	10	0	Debtor of Recipient	KNA1
40	J_3GMITTLE	☐	J_3GMITTLE	KUNNR	CHAR	10	0	Intermediate Recipient	*
41	J_3GMITREF	☐	J_3GMITREF	J_3GREFTYP	CHAR	2	0	Reference Type - Intermediate Recipient
42	J_3GMITPSP	☐	J_3GMITPSP	PS_POSNR	NUMC	8	0	WBS Element - Intermediate Recipient	PRPS
43	J_3GMITPRO	☐	J_3GMITPRO	PS_PSPNR	NUMC	8	0	Project Number - Intermediate Recipient	PROJ
44	J_3GMITKOS	☐	J_3GMITKOS	KOSTL	CHAR	10	0	Cost Center - Intermediate Recipient	CSKS
45	J_3GMITKOK	☐	J_3GMITKOK	CACCD	CHAR	4	0	Controlling Area - Intermediate Recipient	TKA01
46	J_3GMITACO	☐	J_3GMITACO	AUFNR	CHAR	12	0	CO Order - Intermediate Recipient	AUFK
47	J_3GMITAPM	☐	J_3GMITAPM	AUFNR	CHAR	12	0	PM Order Recipient	AUFK
48	J_3GMITWRK	☐	J_3GMITWRK	WERKS	CHAR	4	0	Plant - Intermediate Recipient	T001W
49	J_3GMITLAG	☐	J_3GMITLAG	LGORT	CHAR	4	0	Storage Location - Intermediate Recipient	T001L
50	J_3GFREMDP	☐	J_3GFREMDP	X	CHAR	1	0	Indicator for External Employees
51	PERNR	☐	J_3GPERNR	J_3GPERNR	NUMC	8	0	Personal Number
52	NACHN	☐	NACHN	NACHN	CHAR	25	0	Last Name
53	J_3GEMPPER	☐	J_3GEMPPER	KUNNR	CHAR	10	0	Receiving Cost Center for Personnel	KNA1
54	J_3GBELSTA	☐	J_3GBELSTA	J_3GBELSTA	CHAR	1	0	Internal Document Status
55	J_3GPIABS	☐	J_3GPIABS	J_3GPAUSCH	CHAR	1	0	Document Flat Rate Indicator (Internal) - Sender
56	J_3GPEABS	☐	J_3GPEABS	J_3GPAUSCH	CHAR	1	0	Document Flat Rate Indicator (External) - Sender
57	J_3GPIEMPF	☐	J_3GPIEMPS	J_3GPAUSCH	CHAR	1	0	Document Flat Rate Indicator (Internal) - Recipient
58	J_3GPEEMPS	☐	J_3GPEEMPS	J_3GPAUSCH	CHAR	1	0	Document Flat Rate Indicator (External) - Recipient
59	J_3GBETR1	☐	J_3GBETR1	WERTV8	CURR	15	2	Internal Flat Rate - Sender
60	J_3GBETR2	☐	J_3GBETR2	WERTV8	CURR	15	2	External Flat Rate - Sender
61	J_3GBETR3	☐	J_3GBETR3	WERTV8	CURR	15	2	Internal Flat Rate - Recipient
62	J_3GBETR4	☐	J_3GBETR4	WERTV8	CURR	15	2	External Flat Rate - Recipient
63	J_3GWAERS1	☐	J_3GWAERS1	WAERS	CUKY	5	0	Currency Flat Rate Amount (Internal) - Sender	TCURC
64	J_3GWAERS2	☐	J_3GWAERS2	WAERS	CUKY	5	0	Currency Flat Rate Amount (External) - Sender	TCURC
65	J_3GWAERS3	☐	J_3GWAERS3	WAERS	CUKY	5	0	Currency Flat Rate Amount (Internal) - Recipient	TCURC
66	J_3GWAERS4	☐	J_3GWAERS4	WAERS	CUKY	5	0	Currency Flat Rate Amount (External) - Recipient	TCURC
67	J_3GFAKTAB	☐	J_3GFAKTAB	J_3GFAKTKZ	CHAR	1	0	Billing Indicator - Sender
68	J_3GFAKTEM	☐	J_3GFAKTEM	J_3GFAKTKZ	CHAR	1	0	Billing Indicator - Recipient
69	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
70	J_3GTPLKZ	☐	J_3GTPLKZ	J_3GTPLKZ	CHAR	5	0	Catalog Code	J_3GT370S
71	J_3GKATNRC	☐	J_3GKATNRC	J_3GKATNRC	CHAR	30	0	Number in Catalog	J_3GKATAL
72	LFDNR	☐	J_3GLFDNR4	NUMC4	NUMC	4	0	Sequence Number
73	J_3GDOMLMB	☐	J_3GDOMLMB	J_3GDOMLMB	CHAR	1	0	Pricing Dominancy (Provider/Intermediate Recipient/Debtor)
74	J_3GDOMMB	☐	J_3GDOMMB	J_3GDOMLMB	CHAR	1	0	Pricing Dominancy (Intermediate Recipient/Debtor)
75	J_3GBELNR	☐	J_3GBELNR	J_3GBELNR	CHAR	10	0	External Document Number
76	J_3GPOSNR	☐	J_3GBELPOS	J_3GPOSNR	NUMC	5	0	Document Item	*
77	J_3GGRUND	☐	J_3GBEWEG	J_3GBEWEG	CHAR	1	0	Internal Indicator for Transaction Type	J_3GZUABGR
78	J_3GLFDNR	☐	J_3GLFDNR2	NUMC2	NUMC	2	0	Sequence Number	J_3GZUABGR
79	J_3GLVART	☐	J_3GLVART	J_3GLVART	CHAR	4	0	Activity Type	J_3GLEIART
80	J_3GMENGE	☐	J_3GMENGE	MENG13	QUAN	13	3	Quantity
81	J_3GMEINS	☐	MEINA	MEINS	UNIT	3	0	Unit of measure	T006
82	J_3GMENGE2	☐	J_3GMENGE	MENG13	QUAN	13	3	Quantity
83	J_3GMEINS2	☐	MEINA	MEINS	UNIT	3	0	Unit of measure	T006
84	J_3GKZLATR	☐	J_3GKZLATR	J_3GKZLATR	CHAR	1	0	Activity Type Separation
85	J_3GVBELNE	☐	J_3GVBELNE	VBELN	CHAR	10	0	Number of External Billing Document	VBUK
86	EQUNR2	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
87	J_3GKZMENG	☐	J_3GKZMENG	J_3GKZMENG	CHAR	1	0	Item/Multipart Indicator
88	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
89	J_3GGENSTA	☐	J_3GGENSTA	J_3GGENSTA	CHAR	1	0	Generation Status
90	J_3GKZFRIS	☐	J_3GKZFRIS	J_3GKZFRIS	CHAR	1	0	Usage Period Indicator
91	J_3GEINEND	☐	J_3GEINEND	DATUM	DATS	8	0	End of Usage Period
92	J_3GDATLAB	☐	J_3GDATLAB	DATUM	DATS	8	0	Date of Activity Output
93	J_3GKZLADI	☐	J_3GKZLADI	J_3GKZLAD	CHAR	1	0	Indicator: Internal Loading Costs
94	J_3GKZLADE	☐	J_3GKZLADE	J_3GKZLAD	CHAR	1	0	Indicator: External (Un)Loading Costs
95	J_3GKZBERG	☐	J_3GKZBERG	J_3GKZBERG	CHAR	1	0	Indicator for Provision Fees
96	J_3GBESTEM	☐	J_3GBESTEM	KUNNR	CHAR	10	0	Inventory Management - Recipient	KNA1
97	J_3GKZSPIL	☐	J_3GKZSPIL	J_3GKZSOPR	CHAR	1	0	Indicator: Special Price for Internal Provider of Service
98	J_3GKZSPEL	☐	J_3GKZSPEL	J_3GKZSOPR	CHAR	1	0	Indicator: Special Price for External Provider of Service
99	J_3GKZSPIB	☐	J_3GKZSPIB	J_3GKZSOPR	CHAR	1	0	Indicator: Special Price for Internal Recipient of Service
100	J_3GKZSPEB	☐	J_3GKZSPEB	J_3GKZSOPR	CHAR	1	0	Indicator: Special Price for External Recipient of Service
101	J_3GKZLVOI	☐	J_3GKZLVOI	X	CHAR	1	0	Indicator: Calculate Internal PBE as TBE
102	J_3GKZLVOE	☐	J_3GKZLVOE	X	CHAR	1	0	Indicator: Calculate external PBE as TBE
103	J_3GUMVERI	☐	J_3GUMVERI	J_3GLVART	CHAR	4	0	Redirection Settlement Type - Internal	J_3GLEIART
104	J_3GUMVERE	☐	J_3GUMVERE	J_3GLVART	CHAR	4	0	Redirection Settlement Type - External	J_3GLEIART
105	.INCLUDE	☐				0	0	Measuring Points Document Entry (Structure)
106	J_3GIMPT1	☐	J_3GIMPT1	IMRC_POINT	CHAR	12	0	Actual Value of Measuring Point	*
107	J_3GIMPT2	☐	J_3GIMPT2	IMRC_POINT	CHAR	12	0	Calculated Value of Measuring Point	*
108	J_3GMPOBJ	☐	IMRC_MPOBJ	J_OBJNR	CHAR	22	0	Object Number for the Measuring Point Object	*
109	J_3GMPBEG1	☐	J_3GMPBEG1	NUM10	NUMC	10	0	Actual Start of Measuring Point
110	J_3GMPEND1	☐	J_3GMPEND1	NUMC10	NUMC	10	0	Actual End of Measuring Point
111	J_3GCDIFF	☐	J_3GCDIFF	NUMC10	NUMC	10	0	Counter Reading Difference
112	J_3GMDOCM1	☐	IMRC_MDOCM	IMRC_MDOCM	CHAR	20	0	Measurement Document	*
113	J_3GMDOCM2	☐	IMRC_MDOCM	IMRC_MDOCM	CHAR	20	0	Measurement Document	*
114	J_3GIDATE	☐	IMRC_IDATE	DATUM	DATS	8	0	Date of the Measurement
115	J_3GITIME	☐	IMRC_ITIME	UZEIT	TIMS	6	0	Time of Measurement
116	J_3GBELSTE	☐	J_3GBELSTE	J_3GBELSTA	CHAR	1	0	External Document Status
117	J_3GKZPERK	☐	J_3GKZPERK	X	CHAR	1	0	Indicator: Personnel Created in Header
118	J_3GKZEMPK	☐	J_3GKZEMPK	X	CHAR	1	0	Indicator: Recipient Created in Header
119	J_3GKZEQUK	☐	J_3GKZEQUK	X	CHAR	1	0	Indicator: Equipment Created in Header
120	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
121	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
122	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
123	WOCHE	☐	INDX_SRTFD	SYCHAR22	CHAR	22	0	User-defined key in table INDX
124	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_3GMATRIX_ALT	EQUNR	EQUI	EQUNR
2	J_3GMATRIX_ALT	EQUNR2	EQUI	EQUNR
3	J_3GMATRIX_ALT	J_3GABSACO	AUFK	AUFNR
4	J_3GMATRIX_ALT	J_3GABSAPM	AUFK	AUFNR
5	J_3GMATRIX_ALT	J_3GABSDEB	KNA1	KUNNR
6	J_3GMATRIX_ALT	J_3GABSEND	KNA1	KUNNR
7	J_3GMATRIX_ALT	J_3GABSEXT	KNA1	KUNNR
8	J_3GMATRIX_ALT	J_3GABSKOK	TKA01	KOKRS
9	J_3GMATRIX_ALT	J_3GABSKOS	CSKS	KOSTL
10	J_3GMATRIX_ALT	J_3GABSLAG	T001L	LGORT
11	J_3GMATRIX_ALT	J_3GABSPRO	PROJ	PSPNR
12	J_3GMATRIX_ALT	J_3GABSPSP	PRPS	PSPNR
13	J_3GMATRIX_ALT	J_3GABSWRK	T001W	WERKS
14	J_3GMATRIX_ALT	J_3GBELNRI	J_3GBELK	J_3GBELNRI	KEY
15	J_3GMATRIX_ALT	J_3GBESTEM	KNA1	KUNNR
16	J_3GMATRIX_ALT	J_3GEMPACO	AUFK	AUFNR
17	J_3GMATRIX_ALT	J_3GEMPAPM	AUFK	AUFNR
18	J_3GMATRIX_ALT	J_3GEMPDEB	KNA1	KUNNR
19	J_3GMATRIX_ALT	J_3GEMPEXT	KNA1	KUNNR
20	J_3GMATRIX_ALT	J_3GEMPFAE	KNA1	KUNNR
21	J_3GMATRIX_ALT	J_3GEMPKOK	TKA01	KOKRS
22	J_3GMATRIX_ALT	J_3GEMPKOS	CSKS	KOSTL
23	J_3GMATRIX_ALT	J_3GEMPLAG	T001L	LGORT
24	J_3GMATRIX_ALT	J_3GEMPPER	KNA1	KUNNR
25	J_3GMATRIX_ALT	J_3GEMPPRO	PROJ	PSPNR
26	J_3GMATRIX_ALT	J_3GEMPPSP	PRPS	PSPNR
27	J_3GMATRIX_ALT	J_3GEMPWRK	T001W	WERKS
28	J_3GMATRIX_ALT	J_3GGRUND	J_3GZUABGR	J_3GGRUND
29	J_3GMATRIX_ALT	J_3GKATNRC	J_3GKATAL	J_3GKATNRC
30	J_3GMATRIX_ALT	J_3GLFDNR	J_3GZUABGR	J_3GLFDNR
31	J_3GMATRIX_ALT	J_3GLVART	J_3GLEIART	J_3GLVART
32	J_3GMATRIX_ALT	J_3GMEINS	T006	MSEHI	REF	C	CN
33	J_3GMATRIX_ALT	J_3GMEINS2	T006	MSEHI	REF	C	CN
34	J_3GMATRIX_ALT	J_3GMITACO	AUFK	AUFNR
35	J_3GMATRIX_ALT	J_3GMITAPM	AUFK	AUFNR
36	J_3GMATRIX_ALT	J_3GMITKOK	TKA01	KOKRS
37	J_3GMATRIX_ALT	J_3GMITKOS	CSKS	KOSTL
38	J_3GMATRIX_ALT	J_3GMITLAG	T001L	LGORT
39	J_3GMATRIX_ALT	J_3GMITPRO	PROJ	PSPNR
40	J_3GMATRIX_ALT	J_3GMITPSP	PRPS	PSPNR
41	J_3GMATRIX_ALT	J_3GMITWRK	T001W	WERKS
42	J_3GMATRIX_ALT	J_3GTPLKZ	J_3GT370S	J_3GTPLKZ
43	J_3GMATRIX_ALT	J_3GUMVERE	J_3GLEIART	J_3GLVART
44	J_3GMATRIX_ALT	J_3GUMVERI	J_3GLEIART	J_3GLVART
45	J_3GMATRIX_ALT	J_3GVBELNE	VBUK	VBELN
46	J_3GMATRIX_ALT	J_3GWAERS1	TCURC	WAERS
47	J_3GMATRIX_ALT	J_3GWAERS2	TCURC	WAERS
48	J_3GMATRIX_ALT	J_3GWAERS3	TCURC	WAERS
49	J_3GMATRIX_ALT	J_3GWAERS4	TCURC	WAERS
50	J_3GMATRIX_ALT	MANDT	T000	MANDT	KEY	1	CN
51	J_3GMATRIX_ALT	MATNR	MARA	MATNR	REF	C	CN

History

Last changed by/on	SAP	20050301
SAP Release Created in