SAP table T5DB1 (Trainee Remuneration)

SAP table T5DB1 has 7 primary key fields being MANDT,MOLGA,ZVKAS,TRFGG,BAUTY,BSATT,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
ZVKAS Social Fund CHAR 2 0 T5DBA P01B_ZVKAS
TRFGG Pay Scale Area Group CHAR 2 0 T5D0T TRFGG
BAUTY Employee Subgroup Grouping for Construction Pay CHAR 1 0 P01B_BAUTY
Without Grouping
1 Technical/Commercial Employees
2 Technical/Commercial Trainees
3 Foremen
4 Industrial Workers
5 Industrial Trainees
6 Executive Employees
7 Industrial Placement Students
A Other
BSATT Training Year for Reimbursement CHAR 2 0 T5DBH P01B_AUSJA
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
AVERG Trainee Remuneration CURR 6 2 P01B_AVERG
LGART Wage Type CHAR 4 0 T512W LGART
PSATZ Percentage DEC 5 2 P01B_PSATZ

T5DB1 foreign key relationships

Table Field Check Table Check Field
0 T5DB1 BSATT T5DBH Construction Attributes MANDT
0 T5DB1 BSATT T5DBH Construction Attributes BSATY
0 T5DB1 BSATT T5DBH Construction Attributes BSATT
0 T5DB1 BSATT T5DBH Construction Attributes ENDDA
1 T5DB1 LGART T512W Wage Type Valuation MANDT
1 T5DB1 LGART T512W Wage Type Valuation MOLGA
1 T5DB1 LGART T512W Wage Type Valuation ENDDA
0 T5DB1 MOLGA T500L Personnel Country Grouping MOLGA
1 T5DB1 TRFGG T5D0T Pay Scale Area Groupings MANDT
1 T5DB1 TRFGG T5D0T Pay Scale Area Groupings MOLGA
1 T5DB1 TRFGG T5D0T Pay Scale Area Groupings TGGTY
1 T5DB1 TRFGG T5D0T Pay Scale Area Groupings TRFGG
0 T5DB1 ZVKAS T5DBA Social Funds in the Building Sector MANDT
0 T5DB1 ZVKAS T5DBA Social Funds in the Building Sector ZVKAS
0 T5DB1 ZVKAS T5DBA Social Funds in the Building Sector ENDDA