SAP ABAP Table /SAPCEM/VBADATA (Structure Log Data CEM SD Settlement Run)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPCEM/VBADATA	Table Relationship Diagram
Short Description	Structure Log Data CEM SD Settlement Run

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	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
2	J_3GKBAUL	☐	J_3GKBAUL	J_3GKBAUL	CHAR	1	0	ETM-Relevant Indicator
3	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
4	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
5	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
6	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
7	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
8	J_3GABSEND	☐	J_3GABSEND	KUNNR	CHAR	10	0	Sender	*
9	J_3GEMPFAE	☐	J_3GEMPFAE	KUNNR	CHAR	10	0	Recipient	*
10	J_3GEMPDEB	☐	J_3GEMPDEB	KUNNR	CHAR	10	0	Debtor of Recipient	*
11	J_3GEMPEXT	☐	J_3GEMPEXT	KUNNR	CHAR	10	0	External Ship-To Party - Recipient	*
12	J_3GRESTYP	☐	J_3GRESTYP	J_3GRESTYP	CHAR	2	0	Resource Indicator
13	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
14	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
15	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	*
16	J_3GLVART	☐	J_3GLVART	J_3GLVART	CHAR	4	0	Activity Type	*
17	J_3GDATVO	☐	J_3GDATVO	DATUM	DATS	8	0	From Date
18	J_3GDATBI	☐	J_3GDATBI	DATUM	DATS	8	0	To Date
19	J_3GBELNRI	☐	J_3GBELNRI	J_3GBELNR	CHAR	10	0	Document Number
20	J_3GPOSNRI	☐	J_3GPOSNRI	NUMC4	NUMC	4	0	Internal Item Number
21	FAKSP	☐	FAKSP	FAKSP	CHAR	2	0	Lock	*
22	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
23	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
24	.INCLUDE	☐				0	0	Include Structure SD Order Item Additional Data CEM-Specific
25	J_3GKZMENG	☐	J_3GKZMENG	J_3GKZMENG	CHAR	1	0	Item/Multipart Indicator
26	J_3GKZLADG	☐	J_3GKZLADG	CHAR1	CHAR	1	0	Indicator: Relevancy to Loading Costs	J_3GLADEKE
27	J_3GKZLAD	☐	J_3GKZLAD	J_3GKZLAD	CHAR	1	0	Indicator: Loading/Unloading Costs Apply
28	J_3GKZBERG	☐	J_3GKZBERG	J_3GKZBERG	CHAR	1	0	Indicator for Provision Fees
29	J_3GPMAUFE	☐	J_3GPMAUFE	AUFNR	CHAR	12	0	PM Order Number (Owner)	AUFK
30	J_3GPMAUFV	☐	J_3GPMAUFV	AUFNR	CHAR	12	0	PM Order Number (Administrator)	AUFK
31	J_3GEIGNER	☐	J_3GEIGNER	J_3GEIGVER	CHAR	12	0	Owner	J_3GEIVERS
32	J_3GVERWAL	☐	J_3GVERWAL	J_3GEIGVER	CHAR	12	0	Administrator	J_3GEIVERS
33	J_3GEIFR	☐	J_3GEIFR	J_3GEIFR	CHAR	1	0	Indicator for Own/External Equipment
34	J_3GEQART	☐	J_3GEQART	J_3GEQART	CHAR	10	0	Procurement Type for External Equipment	J_3GFEQUI
35	J_3GBLTYP	☐	J_3GBLTYP	J_3GBLTYP	CHAR	1	0	CEM Document Category
36	J_3GPRGRPE	☐	J_3GPRGRPE	KONDA	CHAR	2	0	Price Group for Equipment	T188
37	J_3GTPLKZ	☐	J_3GTPLKZ	J_3GTPLKZ	CHAR	5	0	Catalog Code	J_3GT370S
38	J_3GKATNRC	☐	J_3GKATNRC	J_3GKATNRC	CHAR	30	0	Number in Catalog	J_3GKATAL
39	J_3GKATGR1	☐	J_3GKATGR1	J_3GKATGR1	CHAR	5	0	Catalog Group 1
40	J_3GKATGR2	☐	J_3GKATGR2	J_3GKATGR2	CHAR	15	0	Catalog Group 2
41	J_3GPACHT	☐	J_3GPACHT	J_3GKZPACH	CHAR	1	0	Leasing Type
42	J_3GETYPA	☐	J_3GETYPA	J_3GETYP	CHAR	2	0	Sending Recipient Type	J_3GZUETYP
43	J_3GETYPE	☐	J_3GETYPE	J_3GETYP	CHAR	2	0	Receiving Recipient Type	J_3GZUETYP
44	J_3GREFTAB	☐	J_3GREFTAB	J_3GREFTYP	CHAR	2	0	Reference Type Partner Function - Sender
45	J_3GREFTWE	☐	J_3GREFTWE	J_3GREFTYP	CHAR	2	0	Reference Type Partner Function Ship-To Int./Sold-To Ext.
46	J_3GCOOBJA	☐	J_3GCOOBJA	TEXT14	CHAR	14	0	CO Object - Sender
47	J_3GCOOBJE	☐	J_3GCOOBJE	TEXT14	CHAR	14	0	CO Object - Recipient
48	J_3GPEMPST	☐	J_3GPEMPST	KUNNR	CHAR	10	0	Price Determiner	KNA1
49	J_3GSEMPST	☐	J_3GSEMPST	KUNNR	CHAR	10	0	Standard Recipient	KNA1
50	J_3GDEMPST	☐	J_3GDEMPST	KUNNR	CHAR	10	0	Dummy Recipient	KNA1
51	J_3GLGSBER	☐	J_3GLGSBER	GSBER	CHAR	4	0	Providing Business Area	TGSB
52	J_3GLBUKRS	☐	J_3GLBUKRS	BUKRS	CHAR	4	0	Providing Company Code	T001
53	J_3GLWERKS	☐	J_3GLWERKS	WERKS	CHAR	4	0	Providing Plant	T001W
54	J_3GBGSBER	☐	J_3GEGSBER	GSBER	CHAR	4	0	Debited Business Area	TGSB
55	J_3GBBUKRS	☐	J_3GEBUKRS	BUKRS	CHAR	4	0	Debited company code	T001
56	J_3GBWERKS	☐	J_3GEWERKS	WERKS	CHAR	4	0	Debited Plant	T001W
57	J_3GLKOKRS	☐	J_3GLKOKRS	CACCD	CHAR	4	0	Providing Controlling Area	TKA01
58	J_3GBKOKRS	☐	J_3GBKOKRS	CACCD	CHAR	4	0	Debited Controlling Area	TKA01
59	J_3GLPRC01	☐	J_3GLPRC01	PRCTR	CHAR	10	0	Providing Profit Center 01	CEPC
60	J_3GBPRC01	☐	J_3GEPRC01	PRCTR	CHAR	10	0	Debited Profit Center 01	CEPC
61	J_3GLPCGR1	☐	J_3GLPCGR1	SETNAM_INT	CHAR	12	0	Providing Profit Center - Group 1	*
62	J_3GBPCGR1	☐	J_3GBPCGR1	SETNAM_INT	CHAR	12	0	Debited Profit Center - Group 1	*
63	J_3GBEWEG	☐	J_3GBEWEG	J_3GBEWEG	CHAR	1	0	Internal Indicator for Transaction Type
64	J_3GABRART	☐	J_3GABRART	J_3GABRART	CHAR	1	0	Settlement Type
65	J_3GTAGMON	☐	J_3GTAGMON	DEC3_2	DEC	5	2	Number of Days/Month
66	J_3GCALID	☐	J_3GCALID	WFCID	CHAR	2	0	Calendar ID	TFACD
67	J_3GVMONAT	☐	J_3GVMONAT	J_3GVMONAT	NUMC	1	0	Indicator for Complete Month
68	J_3GABTAGM	☐	J_3GABTAGM	CHAR1	CHAR	1	0	Indicator - Retirement Date Counts in Settlement
69	J_3GORGUEB	☐	J_3GORGUEB	CHAR1	CHAR	1	0	Indicator: Across All Organizational Structures
70	J_3GSTDTAG	☐	J_3GSTDTAG	DEC03_2	DEC	5	2	Hours per Day
71	J_3GSTDMON	☐	J_3GSTDMON	DEC03_2	DEC	5	2	Hours per Month
72	J_3GKINP	☐	J_3GKINP	XFELD	CHAR	1	0	Indicator: Item Created in Input
73	J_3GASTLNR	☐	J_3GASTLNR	NUMC4	NUMC	4	0	Number of Active BOM for Equipment (Internal No. Assignment)
74	J_3GPAKET	☐	J_3GPAKET	J_3GPAKET	CHAR	18	0	Package	J_3GPAKK
75	J_3GZUFRIS	☐	J_3GZUFRIS	J_3GZUFRIS	CHAR	1	0	Surcharge from Relevancy to Deadlines
76	J_3GEQMATNR	☐	J_3GEQMATNR	MATNR	CHAR	18	0	Equipment Material Number	MARA
77	J_3GEQSERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
78	J_3GABSNPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
79	J_3GABSVORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
80	J_3GEMPNPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
81	J_3GEMPVORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
82	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
83	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
84	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
85	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPCEM/VBADATA	J_3GABSNPLNR	AUFK	AUFNR	REF
2	/SAPCEM/VBADATA	J_3GBBUKRS	T001	BUKRS
3	/SAPCEM/VBADATA	J_3GBGSBER	TGSB	GSBER
4	/SAPCEM/VBADATA	J_3GBKOKRS	TKA01	KOKRS
5	/SAPCEM/VBADATA	J_3GBPRC01	CEPC	PRCTR
6	/SAPCEM/VBADATA	J_3GBWERKS	T001W	WERKS
7	/SAPCEM/VBADATA	J_3GCALID	TFACD	IDENT
8	/SAPCEM/VBADATA	J_3GDEMPST	KNA1	KUNNR
9	/SAPCEM/VBADATA	J_3GEIGNER	J_3GEIVERS	J_3GEIGVER
10	/SAPCEM/VBADATA	J_3GEMPNPLNR	AUFK	AUFNR	REF
11	/SAPCEM/VBADATA	J_3GEQART	J_3GFEQUI	J_3GEQART
12	/SAPCEM/VBADATA	J_3GEQMATNR	MARA	MATNR	REF	1	CN
13	/SAPCEM/VBADATA	J_3GETYPA	J_3GZUETYP	J_3GETYP
14	/SAPCEM/VBADATA	J_3GETYPE	J_3GZUETYP	J_3GETYP
15	/SAPCEM/VBADATA	J_3GKATNRC	J_3GKATAL	J_3GKATNRC
16	/SAPCEM/VBADATA	J_3GKZLADG	J_3GLADEKE	J_3GKZLADG
17	/SAPCEM/VBADATA	J_3GLBUKRS	T001	BUKRS
18	/SAPCEM/VBADATA	J_3GLGSBER	TGSB	GSBER
19	/SAPCEM/VBADATA	J_3GLKOKRS	TKA01	KOKRS
20	/SAPCEM/VBADATA	J_3GLPRC01	CEPC	PRCTR
21	/SAPCEM/VBADATA	J_3GLWERKS	T001W	WERKS
22	/SAPCEM/VBADATA	J_3GPAKET	J_3GPAKK	J_3GPAKET	REF	1	CN
23	/SAPCEM/VBADATA	J_3GPEMPST	KNA1	KUNNR
24	/SAPCEM/VBADATA	J_3GPMAUFE	AUFK	AUFNR
25	/SAPCEM/VBADATA	J_3GPMAUFV	AUFK	AUFNR
26	/SAPCEM/VBADATA	J_3GPRGRPE	T188	KONDA
27	/SAPCEM/VBADATA	J_3GSEMPST	KNA1	KUNNR
28	/SAPCEM/VBADATA	J_3GTPLKZ	J_3GT370S	J_3GTPLKZ
29	/SAPCEM/VBADATA	J_3GVERWAL	J_3GEIVERS	J_3GEIGVER
30	/SAPCEM/VBADATA	WAERK	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C2