SAP table T5QTP (Payroll Tax and Workers Compensation)

SAP table T5QTP has 5 primary key fields being MANDT,STATE,TXTYP,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
STATE State / Territory CHAR 3 0 T5QTK P13Q_STATE
TXTYP Tax Type CHAR 2 0 P13Q_TXTYP
PT Payroll Tax
WC Workers Compensation
LGART Wage Type CHAR 4 0 T512W LGART
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA

T5QTP foreign key relationships

Table Field Check Table Check Field
0 T5QTP LGART T512W Wage Type Valuation MANDT
0 T5QTP LGART T512W Wage Type Valuation MOLGA
0 T5QTP LGART T512W Wage Type Valuation ENDDA
1 T5QTP STATE T5QTK State/Territory Code Australia MANDT
1 T5QTP STATE T5QTK State/Territory Code Australia STATE