SAP table J_3GT370S (Structure Indicator for Catalog)
SAP table J_3GT370S has 2 primary key fields being MANDT,J_3GTPLKZ.
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
MANDT
Client
CLNT
3
0
T000
MANDT
J_3GTPLKZ
Catalog Code
CHAR
5
0
J_3GTPLKZ
J_3GAUSGJ
Edition Year
CHAR
4
0
J_3GAUSGJ
J_3GHERST
Publisher of Catalog
CHAR
30
0
J_3GHERST
J_3GDATAB
Valid-From Date
DATS
8
0
DATAB
J_3GEDITM
Template for Number in Catalog
CHAR
30
0
J_3GEDITM
J_3GSTUFM
Hierarchy Levels of Catalog
CHAR
30
0
J_3GHIERA
J_3GKLASSE
Class number
CHAR
18
0
/SAPCEM/V_CLAS
KLASSE_D
J_3GKENNZ
Technical Statistics
CHAR
1
0
J_3GKENNZ
J_3GKLART
Class Type
CHAR
3
0
TCLA
KLASSENART
J_3GINDEXR
Index series for replacement values
CHAR
5
0
T094A
WBIND
J_3GINTGRZ
Percentage - Limits
DEC
4
2
J_3GINTGRZ
J_3GHIEKG1
Hierarchy Level of Catalog Group 1
CHAR
1
0
J_3GHIEKG1
J_3GHIEKG2
Hierarchy Level of Catalog Group 2
CHAR
1
0
J_3GHIEKG2
J_3GNURKAT
Only Catalog Values Allowed
CHAR
1
0
J_3GNURKAT
J_3GKATPFL
No Catalog Maintenance Using BOM
CHAR
1
0
J_3GKATPFL
J_3GLOGSYS
Logical system
CHAR
10
0
TBDLS
LOGSYS
J_3GSTLMAT
Determine Use of Catalog for BOMs or Material
CHAR
1
0
J_3GSTLMAT
Possible values
M
Materials
S
Bills of material
J_3GT370S foreign key relationships
Table
Field
Check Table
Check Field
0 J_3GT370S
J_3GKLART
TCLA
Class Types
MANDT
1 J_3GT370S
J_3GLOGSYS
TBDLS
Logical system
LOGSYS
0 J_3GT370S
MANDT
T000
Clients
MANDT