SAP Table T5W1N
Social insurance schemes
T5W1N (Social insurance schemes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5W1N to other SAP tables.
T5W1N table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
| SVSPA | Social Insurance Type (1=MA, 2=PF, 3=UIF) | SYSPA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| KVSCH | Social Insurance Company | P16_KXSCH | T5W1M | CHAR | 8 | 0 | ||||||||||||||||||
| KVGES | Social Insurance Scheme | P16_KYGST | CHAR | 6 | 0 | |||||||||||||||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||||||||||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||||||||||||
| SVSCH | Percentage or Amount Indicator | SVSCX | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| DEPER | Employee's Percentage (Portion) | DEPER | DEC | 7 | 4 | |||||||||||||||||||
| COMAX | Employer Maximum Contribution | COMAY | T511P | CHAR | 5 | 0 | ||||||||||||||||||
| KONST | Gap Insurance Constant | KONSX | T511P | CHAR | 5 | 0 | ||||||||||||||||||
| LGART | Wage Type | LGART | T512W | CHAR | 4 | 0 | ||||||||||||||||||
| MODEL | Payment Model | MODE1 | T549W | CHAR | 4 | 0 | ||||||||||||||||||
| SPECO | Minimum Value for Personal Accounts | SPECO | DEC | 5 | 2 | |||||||||||||||||||
| CLEAR | Clearance Number for Pension Fund | P16_CLEAR | NUMC | 11 | 0 | |||||||||||||||||||
| ZEINH | Payroll frequency. Used for medical aid tables | P16_PFREQ | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||
| MAIND | MA Capped Amount Option Indicator | P16_MAIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
T5W1N foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5W1N | COMAX | T5W1N | MANDT | T511P | International Payroll Constants | MANDT |
| T5W1N | COMAX | '16' | T511P | International Payroll Constants | MOLGA | |
| T5W1N | COMAX | T5W1N | COMAX | T511P | International Payroll Constants | KONST |
| T5W1N | COMAX | * | T511P | International Payroll Constants | ENDDA | |
| T5W1N | KONST | T5W1N | MANDT | T511P | International Payroll Constants | MANDT |
| T5W1N | KONST | '16' | T511P | International Payroll Constants | MOLGA | |
| T5W1N | KONST | T5W1N | KONST | T511P | International Payroll Constants | KONST |
| T5W1N | KONST | * | T511P | International Payroll Constants | ENDDA | |
| T5W1N | KVSCH | T5W1N | SVSPA | T5W1M | Social insurance companies | SVSPA |
| T5W1N | KVSCH | T5W1N | KVSCH | T5W1M | Social insurance companies | KVSCH |
| T5W1N | KVSCH | T5W1N | MANDT | T5W1M | Social insurance companies | MANDT |
| T5W1N | LGART | '16' | T512W | Wage Type Valuation | MOLGA | |
| T5W1N | LGART | T5W1N | LGART | T512W | Wage Type Valuation | LGART |
| T5W1N | LGART | * | T512W | Wage Type Valuation | ENDDA | |
| T5W1N | LGART | T5W1N | MANDT | T512W | Wage Type Valuation | MANDT |
| T5W1N | MANDT | T5W1N | MANDT | T000 | Clients | MANDT |
| T5W1N | MODEL | T5W1N | MANDT | T549W | Recurr. Pymts/Deducs: Payment Models | MANDT |
| T5W1N | MODEL | T5W1N | MODEL | T549W | Recurr. Pymts/Deducs: Payment Models | MODEL |
