SAP table T512W (Wage Type Valuation)
SAP table T512W has 4 primary key fields being MANDT,MOLGA,LGART,ENDDA.
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 | |
| MOLGA | HCM Localization | CHAR | 2 | 0 | T500L | MOLGA | |
| LGART | Wage Type | CHAR | 4 | 0 | LGART | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| GVBLA | Valuation basis | CHAR | 2 | 0 | GVBLA | ||
| GVALA | Statement wage type | CHAR | 4 | 0 | T512W | GVALA | |
| GVPRO | Percentage | DEC | 7 | 2 | GVPRO | ||
| PZBLA | Valuation basis | CHAR | 2 | 0 | GVBLA | ||
| PZALA | Statement wage type | CHAR | 4 | 0 | T512W | GVALA | |
| PZPRO | Percentage | DEC | 7 | 2 | GVPRO | ||
| FZBLA | Valuation basis | CHAR | 2 | 0 | GVBLA | ||
| FZALA | Statement wage type | CHAR | 4 | 0 | T512W | GVALA | |
| FZPRO | Percentage | DEC | 7 | 2 | GVPRO | ||
| VKLAS | Processing classes | CHAR | 100 | 0 | VKLAS | ||
| KUMUL | Cumulation of gross amounts | RAW | 12 | 0 | KUMUL | ||
| D1AUS | RTE/NUM/AMT selection for average basis | RAW | 1 | 0 | DSAUS | ||
| D1KUM | Cumulations for average bases | RAW | 4 | 0 | DSKUM | ||
| D1PRO | Percentage for average bases | DEC | 7 | 2 | DSPRO | ||
| D2AUS | RTE/NUM/AMT selection for average basis | RAW | 1 | 0 | DSAUS | ||
| D2KUM | Cumulations for average bases | RAW | 4 | 0 | DSKUM | ||
| D2PRO | Percentage for average bases | DEC | 7 | 2 | DSPRO | ||
| D3AUS | RTE/NUM/AMT selection for average basis | RAW | 1 | 0 | DSAUS | ||
| D3KUM | Cumulations for average bases | RAW | 4 | 0 | DSKUM | ||
| D3PRO | Percentage for average bases | DEC | 7 | 2 | DSPRO | ||
| D4AUS | RTE/NUM/AMT selection for average basis | RAW | 1 | 0 | DSAUS | ||
| D4KUM | Cumulations for average bases | RAW | 4 | 0 | DSKUM | ||
| D4PRO | Percentage for average bases | DEC | 7 | 2 | DSPRO | ||
| D5AUS | RTE/NUM/AMT selection for average basis | RAW | 1 | 0 | DSAUS | ||
| D5KUM | Cumulations for average bases | RAW | 4 | 0 | DSKUM | ||
| D5PRO | Percentage for average bases | DEC | 7 | 2 | DSPRO | ||
| AKLAS | Evaluation classes | CHAR | 40 | 0 | ASKLA |
T512W foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T512W | FZALA | T512W | Wage Type Valuation | MANDT |
| 0 T512W | FZALA | T512W | Wage Type Valuation | MOLGA |
| 0 T512W | FZALA | T512W | Wage Type Valuation | ENDDA |
| 1 T512W | GVALA | T512W | Wage Type Valuation | MANDT |
| 1 T512W | GVALA | T512W | Wage Type Valuation | MOLGA |
| 1 T512W | GVALA | T512W | Wage Type Valuation | ENDDA |
| 0 T512W | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| 1 T512W | PZALA | T512W | Wage Type Valuation | MANDT |
| 1 T512W | PZALA | T512W | Wage Type Valuation | MOLGA |
| 1 T512W | PZALA | T512W | Wage Type Valuation | ENDDA |