SAP table T710S (Survey Data)
SAP table T710S has 4 primary key fields being MANDT,SCODE,JCODE,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 | |
| SCODE | Salary Survey | CHAR | 4 | 0 | T778U | P_SCODE | |
| JCODE | Job from survey | CHAR | 8 | 0 | P_JCODE | ||
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| MABAS | Average Survey Salary | CURR | 13 | 2 | P_MABAS | ||
| MABAM | Average bonus payment (absolute) | CURR | 13 | 2 | P_MABAM | ||
| MABPC | Average Bonus Payment (Percentage) | DEC | 5 | 2 | P_MABPC | ||
| CURCY | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |
| PERIO | Unit of Time for Compensation | CHAR | 1 | 0 | T710F | CMP_FREQU |
T710S foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T710S | CURCY | TCURC | Currency Codes | MANDT |
| 0 T710S | CURCY | TCURC | Currency Codes | WAERS |
| 1 T710S | PERIO | T710F | Units of Time | FREQU |
| 0 T710S | SCODE | T778U | Subtypes | MANDT |
| 0 T710S | SCODE | T778U | Subtypes | INFTY |
| 0 T710S | SCODE | T778U | Subtypes | SUBTY |