SAP Table
J_3GLEIART Activity Types
SAP table J_3GLEIART has 2 primary key fields being MANDT,J_3GLVART.
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_3GLEIART columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyJ_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 | ||||||||||
|
|||||||||||||||
| J_3GLEIFLU | Indicator: Settlement View | CHAR | 1 | 0 | J_3GLEIFLU | ||||||||||
|
|||||||||||||||
| J_3GUEBSTA | Copy Indicator for Location Settl. Type for Settl. Calendar | CHAR | 1 | 0 | J_3GUEBSTA | ||||||||||
|
|||||||||||||||
| 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 | ||||||||||
|
|||||||||||||||
| 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 | ||||||||||
/ Relationships
J_3GLEIART foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| J_3GLEIART | J_3GZARTHR | T554S | Attendance and Absence Types | MANDT |
| J_3GLEIART | J_3GZARTHR | T554S | Attendance and Absence Types | MOABW |
| J_3GLEIART | J_3GZARTHR | T554S | Attendance and Absence Types | SUBTY |
| J_3GLEIART | J_3GZARTHR | T554S | Attendance and Absence Types | ENDDA |
| J_3GLEIART | J_3GZARTPP | T421 | Wage groups | MANDT |
| J_3GLEIART | MANDT | T000 | Clients | MANDT |