SAP table T5VS8 (Assignment of wage types to tax codes)
SAP table T5VS8 has 5 primary key fields being MANDT,MOLGA,LGART,ATGRN,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 | T5VSA | LGART | |
| ATGRN | Tax code granularity | CHAR | 2 | 0 | T5VS2 | P20_ATGRN | |
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| LTKOD | Tax code for Norwegian annual tax statements | CHAR | 4 | 0 | T5VS4 | P20_LTKOD |
T5VS8 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5VS8 | ATGRN | T5VS2 | Tax code granularity - Check table | ATCAT |
| 0 T5VS8 | ATGRN | T5VS2 | Tax code granularity - Check table | ATGRN |
| 1 T5VS8 | LGART | T5VSA | Cumulation category of wage types for annual tax reporting | MOLGA |
| 1 T5VS8 | LGART | T5VSA | Cumulation category of wage types for annual tax reporting | LGART |
| 0 T5VS8 | LTKOD | T5VS4 | Tax codes with direct attributes | ENDDA |
| 1 T5VS8 | MOLGA | T500L | Personnel Country Grouping | MOLGA |