SAP table J_3GLEIART (Activity Types)

SAP table J_3GLEIART has 2 primary key fields being MANDT,J_3GLVART.

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_3GLVART Activity Type CHAR 4 0 J_3GLVART
J_3GBLERF Document Entry CHAR 1 0 J_3GBLERF
J_3GVERRE Settlement Type CHAR 1 0 J_3GVERRE
J_3GLEIERB Indicator for Service Provider CHAR 1 0 J_3GLEIERB
No provider of service
1 Equipment
3 Material
J_3GLEIFLU Indicator: Settlement View CHAR 1 0 J_3GLEIFLU
Internal and external settlement
3 Internal settlement
4 Lease settlement
J_3GUEBSTA Copy Indicator for Location Settl. Type for Settl. Calendar CHAR 1 0 J_3GUEBSTA
Not taken into account in settlement calendar
1 Settlement calendar has priority over doc. settlement type
2 Doc. settlement type has priority over settlement calendar
3 Execute new pricing
J_3GLRELE Relevancy to Wages CHAR 1 0 J_3GLRELE
J_3GZARTHR Attendance or Absence Type CHAR 4 0 T554S AWART
J_3GZARTPP Time Type with Reference to PP CHAR 3 0 T421 J_3GZARTPP
COLOR Calendar: Color flag NUMC 1 0 CAL_COLOR
J_3GFUEART Filler Type for PBE Documents CHAR 1 0 J_3GFUEART
Do not create/complete
1 Missing PBE documents are created
2 Existing PBE documents are completed
J_3GABRK Indicator for Settlement Calendar Dominance CHAR 1 0 J_3GABRK
/SAPCEM/INVREL Indicator: Relevant to Inventory CHAR 1 0 /SAPCEM/INVENTUR_RELEVANT
/SAPCEM/SUMREL Indicator for Totalling in the PBE Filler Calendar CHAR 1 0 /SAPCEM/SUMREL
/SAPCEM/AUSLPR Indicator: Utilization of Capacity as a Percentage CHAR 1 0 /SAPCEM/AUSLPR
/SAPCEM/DISPF Indicator: Available for Planning CHAR 1 0 /SAPCEM/DISPO_FREI

J_3GLEIART foreign key relationships

Table Field Check Table Check Field
0 J_3GLEIART J_3GZARTHR T554S Attendance and Absence Types MANDT
0 J_3GLEIART J_3GZARTHR T554S Attendance and Absence Types MOABW
0 J_3GLEIART J_3GZARTHR T554S Attendance and Absence Types SUBTY
0 J_3GLEIART J_3GZARTHR T554S Attendance and Absence Types ENDDA
1 J_3GLEIART J_3GZARTPP T421 Wage groups MANDT
0 J_3GLEIART MANDT T000 Clients MANDT