SAP table T5LSP (Employer reference for SOCSO (Malaysia))
SAP table T5LSP has 4 primary key fields being MANDT,MODPS,MODES,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 | |
| MODPS | Personnel subarea grouping for SOCSO (Malaysia) | NUMC | 2 | 0 | T5LMS | P14_MODPS | |
| MODES | Employee subgroup grouping for SOCSO (Malaysia) | NUMC | 2 | 0 | T5LGS | P14_MODES | |
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| ERRNS | Employer SOCSO reference number for Malaysia | CHAR | 20 | 0 | P14_ERRNS | ||
| EMFSL | Payee key for bank transfers | CHAR | 8 | 0 | T521B | EMFSL_521B | |
| ACCNO | Company account number | CHAR | 17 | 0 | P14_ACCNO |
T5LSP foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5LSP | EMFSL | T521B | Payee Keys | MANDT |
| 0 T5LSP | EMFSL | T521B | Payee Keys | EMFSL |
| 0 T5LSP | EMFSL | T521B | Payee Keys | ENDDA |
| 1 T5LSP | MODES | T5LGS | Employee subgroup grouping SOCSO Malaysia | MANDT |
| 1 T5LSP | MODES | T5LGS | Employee subgroup grouping SOCSO Malaysia | MODES |
| 0 T5LSP | MODPS | T5LMS | Personnel Area grouping for SOCSO (Malaysia) | MANDT |
| 0 T5LSP | MODPS | T5LMS | Personnel Area grouping for SOCSO (Malaysia) | MODPS |