SAP Table
J_3GKATAL Catalog
SAP table J_3GKATAL has 3 primary key fields being MANDT,J_3GTPLKZ,J_3GKATNRC.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
J_3GKATAL columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | * | MANDT | |||||
| KeyJ_3GTPLKZ | Catalog Code | CHAR | 5 | 0 | J_3GT370S | J_3GTPLKZ | |||||
| KeyJ_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 | ||||||
|
|||||||||||
| J_3GLVORM | Deletion Indicator | CHAR | 1 | 0 | LVORM | ||||||
/ Relationships
J_3GKATAL foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| J_3GKATAL | J_3GTPLKZ | J_3GT370S | Structure Indicator for Catalog | J_3GTPLKZ |