SAP ABAP Table J_3GBELP_ALT (Document Data - Item Data)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-EC-CEM (Application Component) Construction Equipment Management
     ⤷ J3GP (Package) CEM Module Pools

Basic Data

Table Category	INTTAB	Structure
Structure	J_3GBELP_ALT	Table Relationship Diagram
Short Description	Document Data - Item Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20050301
SAP Release Created in