SAP table J_3GEIVERS (Owner/Administrator Master Record)
SAP table J_3GEIVERS has 2 primary key fields being MANDT,J_3GEIGVER.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Owner/Administrator Number
CHAR
12
0
J_3GEIGVER
J_3GLOEKZ
Deletion Indicator
CHAR
1
0
J_3GLOEKZ
J_3GERNAM
Name of Person Responsible for Creating the Object
CHAR
12
0
ERNAM
J_3GERSDA
Created On
DATS
8
0
ERSDA
J_3GAENAM
Name of Person Who Changed Object
CHAR
12
0
AENAM
J_3GLAEDA
Date of Last Change
DATS
8
0
LAEDA
J_3GKZEIVE
Indicator for Owner/Administrator
CHAR
1
0
J_3GKZEIVE
Possible values
1
Owner
2
Administrator
3
Owner and administrator
KOKRS
Controlling Area
CHAR
4
0
TKA01
KOKRS
PRCTR
Profit Center
CHAR
10
0
*
PRCTR
GSBER
Business Area
CHAR
4
0
TGSB
GSBER
BUKRS
Company Code
CHAR
4
0
T001
BUKRS
WERK
Plant
CHAR
4
0
T001W
WERKS_D
J_3GVERWTP
Central/Decentral Equipment Management Category
CHAR
1
0
J_3GVERWTP
Possible values
1
Central equipment management
2
Decentral equipment management
J_3GABTYP
Mapping Category, Group Mapping
NUMC
1
0
J_3GABTYP
Possible values
1
Business area/company code/plant
J_3GDATE
Date from
DATS
8
0
DATE_FROM
J_3GNATION
Cluster PC: nation code
CHAR
1
0
J_3GNATION
J_3GADRNR
Addresses: Address Number
CHAR
10
0
SADR
CADNR
J_3GEIVERS foreign key relationships
Table
Field
Check Table
Check Field
0 J_3GEIVERS
BUKRS
T001 Company Codes
BUKRS
1 J_3GEIVERS
GSBER
TGSB Business Areas
MANDT
1 J_3GEIVERS
GSBER
TGSB Business Areas
GSBER
0 J_3GEIVERS
J_3GADRNR
SADR Address Management: Company Data
MANDT
0 J_3GEIVERS
J_3GADRNR
SADR Address Management: Company Data
NATIO
1 J_3GEIVERS
KOKRS
TKA01 Controlling Areas
MANDT
0 J_3GEIVERS
MANDT
T000 Clients
MANDT
1 J_3GEIVERS
WERK
T001W Plants/Branches
WERKS