SAP table V_T710 (Generated Table for View)
SAP table V_T710 has 7 primary key fields being MANDT,MOLGA,SLTYP,SLREG,SLGRP,SLLVL,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 | |
| SLTYP | Pay Grade Type | CHAR | 2 | 0 | T510A | P_SLTYP | |
| SLREG | Pay Grade Area | CHAR | 2 | 0 | T510G | P_SLREG | |
| SLGRP | Pay grade | CHAR | 8 | 0 | T710A | P_SLGRP | |
| SLLVL | Pay Grade Level | CHAR | 2 | 0 | P_SLLVL | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| SLMIN | Lower limit of pay grade level | CURR | 13 | 2 | P_SLMIN | ||
| SLMAX | Upper limit of pay grade level | CURR | 13 | 2 | P_SLMAX | ||
| SLREF | Reference salary of grade level | CURR | 13 | 2 | CMP_SLREF | ||
| CTAMT | Reference Salary of Pay Grade | CURR | 13 | 2 | P_CTAMT | ||
| WAERS | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |
| FQTXT | Text (20 Characters) | CHAR | 20 | 0 | TEXT20 | ||
| ENDDA_A | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA_A | Start Date | DATS | 8 | 0 | BEGDA | ||
| LTEXT | Name of HR Country Grouping | CHAR | 25 | 0 | MLGTX | ||
| TARTX | Name of pay scale type (Basic Pay infotype) | CHAR | 20 | 0 | TARTX | ||
| TGBTX | Name of pay scale area (Basic Pay infotype) | CHAR | 20 | 0 | TGBTX | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA |
V_T710 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 V_T710 | MANDT | T000 | Clients | MANDT |
| 1 V_T710 | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| 0 V_T710 | SLGRP | T710A | Pay Grade | MANDT |
| 0 V_T710 | SLGRP | T710A | Pay Grade | MOLGA |
| 0 V_T710 | SLGRP | T710A | Pay Grade | SLGRP |
| 0 V_T710 | SLGRP | T710A | Pay Grade | ENDDA |
| 1 V_T710 | SLREG | T510G | Pay Scale Areas | MOLGA |
| 1 V_T710 | SLREG | T510G | Pay Scale Areas | TRFGB |
| 0 V_T710 | SLTYP | T510A | Pay Scale Types | MANDT |
| 0 V_T710 | SLTYP | T510A | Pay Scale Types | MOLGA |
| 0 V_T710 | SLTYP | T510A | Pay Scale Types | TRFAR |
| 1 V_T710 | WAERS | TCURC | Currency Codes | MANDT |
| 1 V_T710 | WAERS | TCURC | Currency Codes | WAERS |