SAP table J_3GKATAL (Catalog)

SAP table J_3GKATAL has 3 primary key fields being MANDT,J_3GTPLKZ,J_3GKATNRC.

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 * MANDT
J_3GTPLKZ Catalog Code CHAR 5 0 J_3GT370S J_3GTPLKZ
J_3GKATNRC Number in Catalog CHAR 30 0 J_3GKATNRC
J_3GERSDA Created On DATS 8 0 ERSDA
J_3GERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
J_3GLAEDA Date of Last Change DATS 8 0 LAEDA
J_3GAENAM Name of Person Who Changed Object CHAR 12 0 AENAM
J_3GINTERP Catalog Value Cannot be Interpolated CHAR 1 0 J_3GINTERP
Catalog value can be interpolated
X Catalog value cannot be interpolated
J_3GLVORM Deletion Indicator CHAR 1 0 LVORM

J_3GKATAL foreign key relationships

Table Field Check Table Check Field
0 J_3GKATAL J_3GTPLKZ J_3GT370S Structure Indicator for Catalog J_3GTPLKZ