SAP table T5VSA (Cumulation category of wage types for annual tax reporting)

SAP table T5VSA has 3 primary key fields being MANDT,MOLGA,LGART.

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 T512W LGART
ATCAT Cumulation category for wagetypes CHAR 2 0 P20_ATCAT
01 Basic
02 Basic with payroll period
03 Loans
04 Company car
05 Basis for holiday allowance
06 Travel expenses
12 Basic with WPBP handling within payroll period
ATSVB Sign where wage type was earned CHAR 1 0 P20_ATSVB
Wagetype follows employee
C Correction wagetype
M Mainland wagetype
S Svalbard wagetype
KSJOM Seaman tax CHAR 1 0 P20_TABTY
ATSGC Change sign of wage type amount for cumulation CHAR 1 0 P20_ATSGC

T5VSA foreign key relationships

Table Field Check Table Check Field
0 T5VSA LGART T512W Wage Type Valuation MANDT
0 T5VSA LGART T512W Wage Type Valuation MOLGA
0 T5VSA LGART T512W Wage Type Valuation ENDDA
1 T5VSA MOLGA T500L Personnel Country Grouping MOLGA