SAP ABAP Table J_3GVBRPZ (Include Structure Billing Item Additional Data (CEM))

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_3GVBRPZ	Table Relationship Diagram
Short Description	Include Structure Billing Item Additional Data (CEM)

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	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
2	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
3	J_3GLVART	☐	J_3GLVART	J_3GLVART	CHAR	4	0	Activity Type	J_3GLEIART
4	J_3GDATVO	☐	J_3GDATVO	DATUM	DATS	8	0	From Date
5	J_3GDATBI	☐	J_3GDATBI	DATUM	DATS	8	0	To Date
6	J_3GPOSNRI	☐	J_3GBELPOS	J_3GPOSNR	NUMC	5	0	Document Item	*
7	J_3GKZMENG	☐	J_3GKZMENG	J_3GKZMENG	CHAR	1	0	Item/Multipart Indicator
8	J_3GKZLADG	☐	J_3GKZLADG	CHAR1	CHAR	1	0	Indicator: Relevancy to Loading Costs	J_3GLADEKE
9	J_3GKZLAD	☐	J_3GKZLAD	J_3GKZLAD	CHAR	1	0	Indicator: Loading/Unloading Costs Apply
10	J_3GKZBERG	☐	J_3GKZBERG	J_3GKZBERG	CHAR	1	0	Indicator for Provision Fees
11	J_3GEIGNER	☐	J_3GEIGNER	J_3GEIGVER	CHAR	12	0	Owner	J_3GEIVERS
12	J_3GVERWAL	☐	J_3GVERWAL	J_3GEIGVER	CHAR	12	0	Administrator	J_3GEIVERS
13	J_3GEIFR	☐	J_3GEIFR	J_3GEIFR	CHAR	1	0	Indicator for Own/External Equipment
14	J_3GEQART	☐	J_3GEQART	J_3GEQART	CHAR	10	0	Procurement Type for External Equipment	J_3GFEQUI
15	J_3GBLTYP	☐	J_3GBLTYP	J_3GBLTYP	CHAR	1	0	CEM Document Category
16	J_3GPRGRPE	☐	J_3GPRGRPE	KONDA	CHAR	2	0	Price Group for Equipment	T188
17	J_3GTPLKZ	☐	J_3GTPLKZ	J_3GTPLKZ	CHAR	5	0	Catalog Code	J_3GT370S
18	J_3GKATNRC	☐	J_3GKATNRC	J_3GKATNRC	CHAR	30	0	Number in Catalog	J_3GKATAL
19	J_3GKATGR1	☐	J_3GKATGR1	J_3GKATGR1	CHAR	5	0	Catalog Group 1
20	J_3GKATGR2	☐	J_3GKATGR2	J_3GKATGR2	CHAR	15	0	Catalog Group 2
21	J_3GPACHT	☐	J_3GPACHT	J_3GKZPACH	CHAR	1	0	Leasing Type
22	J_3GREFTAB	☐	J_3GREFTAB	J_3GREFTYP	CHAR	2	0	Reference Type Partner Function - Sender
23	J_3GREFTWE	☐	J_3GREFTWE	J_3GREFTYP	CHAR	2	0	Reference Type Partner Function Ship-To Int./Sold-To Ext.
24	J_3GCOOBJA	☐	J_3GCOOBJA	TEXT14	CHAR	14	0	CO Object - Sender
25	J_3GCOOBJE	☐	J_3GCOOBJE	TEXT14	CHAR	14	0	CO Object - Recipient
26	J_3GPEMPST	☐	J_3GPEMPST	KUNNR	CHAR	10	0	Price Determiner	KNA1
27	J_3GSEMPST	☐	J_3GSEMPST	KUNNR	CHAR	10	0	Standard Recipient	KNA1
28	J_3GDEMPST	☐	J_3GDEMPST	KUNNR	CHAR	10	0	Dummy Recipient	KNA1
29	J_3GLGSBER	☐	J_3GLGSBER	GSBER	CHAR	4	0	Providing Business Area	TGSB
30	J_3GLBUKRS	☐	J_3GLBUKRS	BUKRS	CHAR	4	0	Providing Company Code	T001
31	J_3GLWERKS	☐	J_3GLWERKS	WERKS	CHAR	4	0	Providing Plant	T001W
32	J_3GBGSBER	☐	J_3GEGSBER	GSBER	CHAR	4	0	Debited Business Area	TGSB
33	J_3GBBUKRS	☐	J_3GEBUKRS	BUKRS	CHAR	4	0	Debited company code	T001
34	J_3GBWERKS	☐	J_3GEWERKS	WERKS	CHAR	4	0	Debited Plant	T001W
35	J_3GLKOKRS	☐	J_3GLKOKRS	CACCD	CHAR	4	0	Providing Controlling Area	TKA01
36	J_3GBKOKRS	☐	J_3GBKOKRS	CACCD	CHAR	4	0	Debited Controlling Area	TKA01
37	J_3GLPRC01	☐	J_3GLPRC01	PRCTR	CHAR	10	0	Providing Profit Center 01	CEPC
38	J_3GBPRC01	☐	J_3GEPRC01	PRCTR	CHAR	10	0	Debited Profit Center 01	CEPC
39	J_3GLPCGR1	☐	J_3GLPCGR1	SETNAM_INT	CHAR	12	0	Providing Profit Center - Group 1	*
40	J_3GLPCGR2	☐	J_3GLPCGR2	SETNAM_INT	CHAR	12	0	Providing Profit Center - Group 2	*
41	J_3GLPCGR3	☐	J_3GLPCGR3	SETNAM_INT	CHAR	12	0	Providing Profit Center - Group 3	*
42	J_3GLPCGR4	☐	J_3GLPCGR4	SETNAM_INT	CHAR	12	0	Providing Profit Center - Group 4	*
43	J_3GBPCGR1	☐	J_3GBPCGR1	SETNAM_INT	CHAR	12	0	Debited Profit Center - Group 1	*
44	J_3GBPCGR2	☐	J_3GEPCGR2	SETNAM_INT	CHAR	12	0	Debited Profit Center - Group 2	*
45	J_3GBPCGR3	☐	J_3GEPCGR3	SETNAM_INT	CHAR	12	0	Debited Profit Center - Group 3	*
46	J_3GBPCGR4	☐	J_3GEPCGR4	SETNAM_INT	CHAR	12	0	Debited Profit Center - Group 4	*
47	J_3GBEWEG	☐	J_3GBEWEG	J_3GBEWEG	CHAR	1	0	Internal Indicator for Transaction Type
48	J_3GABRART	☐	J_3GABRART	J_3GABRART	CHAR	1	0	Settlement Type
49	J_3GTAGMON	☐	J_3GTAGMON	DEC3_2	DEC	5	2	Number of Days/Month
50	J_3GCALID	☐	J_3GCALID	WFCID	CHAR	2	0	Calendar ID	TFACD
51	J_3GVMONAT	☐	J_3GVMONAT	J_3GVMONAT	NUMC	1	0	Indicator for Complete Month
52	J_3GABTAGM	☐	J_3GABTAGM	CHAR1	CHAR	1	0	Indicator - Retirement Date Counts in Settlement
53	J_3GSTDTAG	☐	J_3GSTDTAG	DEC03_2	DEC	5	2	Hours per Day
54	J_3GSTDMON	☐	J_3GSTDMON	DEC03_2	DEC	5	2	Hours per Month
55	J_3GKINP	☐	J_3GKINP	XFELD	CHAR	1	0	Indicator: Item Created in Input
56	J_3GASTLNR	☐	J_3GASTLNR	NUMC4	NUMC	4	0	Number of Active BOM for Equipment (Internal No. Assignment)
57	J_3GPAKET	☐	J_3GPAKET	J_3GPAKET	CHAR	18	0	Package	J_3GPAKK
58	J_3GZUFRIS	☐	J_3GZUFRIS	J_3GZUFRIS	CHAR	1	0	Surcharge from Relevancy to Deadlines
59	J_3GEQMATNR	☐	J_3GEQMATNR	MATNR	CHAR	18	0	Equipment Material Number	MARA
60	J_3GEQSERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
61	J_3GABSNPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
62	J_3GABSVORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
63	J_3GEMPNPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
64	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_3GVBRPZ	EQART	T370K	EQART
2	J_3GVBRPZ	EQUNR	EQUI	EQUNR
3	J_3GVBRPZ	J_3GABSNPLNR	AUFK	AUFNR	REF
4	J_3GVBRPZ	J_3GBBUKRS	T001	BUKRS
5	J_3GVBRPZ	J_3GBGSBER	TGSB	GSBER
6	J_3GVBRPZ	J_3GBKOKRS	TKA01	KOKRS
7	J_3GVBRPZ	J_3GBPRC01	CEPC	PRCTR
8	J_3GVBRPZ	J_3GBWERKS	T001W	WERKS
9	J_3GVBRPZ	J_3GCALID	TFACD	IDENT
10	J_3GVBRPZ	J_3GDEMPST	KNA1	KUNNR
11	J_3GVBRPZ	J_3GEIGNER	J_3GEIVERS	J_3GEIGVER
12	J_3GVBRPZ	J_3GEMPNPLNR	AUFK	AUFNR	REF
13	J_3GVBRPZ	J_3GEQART	J_3GFEQUI	J_3GEQART
14	J_3GVBRPZ	J_3GEQMATNR	MARA	MATNR
15	J_3GVBRPZ	J_3GKATNRC	J_3GKATAL	J_3GKATNRC
16	J_3GVBRPZ	J_3GKZLADG	J_3GLADEKE	J_3GKZLADG
17	J_3GVBRPZ	J_3GLBUKRS	T001	BUKRS
18	J_3GVBRPZ	J_3GLGSBER	TGSB	GSBER
19	J_3GVBRPZ	J_3GLKOKRS	TKA01	KOKRS
20	J_3GVBRPZ	J_3GLPRC01	CEPC	PRCTR
21	J_3GVBRPZ	J_3GLVART	J_3GLEIART	J_3GLVART
22	J_3GVBRPZ	J_3GLWERKS	T001W	WERKS
23	J_3GVBRPZ	J_3GPAKET	J_3GPAKK	J_3GPAKET
24	J_3GVBRPZ	J_3GPEMPST	KNA1	KUNNR
25	J_3GVBRPZ	J_3GPRGRPE	T188	KONDA
26	J_3GVBRPZ	J_3GSEMPST	KNA1	KUNNR
27	J_3GVBRPZ	J_3GTPLKZ	J_3GT370S	J_3GTPLKZ
28	J_3GVBRPZ	J_3GVERWAL	J_3GEIVERS	J_3GEIGVER

History

Last changed by/on	SAP	20130529
SAP Release Created in