T5W1N

Social insurance schemes | #masterdata | Component: South Africa

🔑 Keys (5)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (5)
Other (4)
🔗 Relations (6)

Column Name	Description
MANDT FK	Client
SVSPA	Social Insurance Type (1=MA, 2=PF, 3=UIF)	Show values
KVSCH FK	Social Insurance Company
KVGES	Social Insurance Scheme
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
SVSPA	Social Insurance Type (1=MA, 2=PF, 3=UIF)	Show values
SVSCH	Percentage or Amount Indicator	Show values
ZEINH	Payroll frequency. Used for medical aid tables	Show values
MAIND	MA Capped Amount Option Indicator	Show values
FNDOP	Fund Options	Show values

Column Name	Description	Domain name
DEPER	Employee's Percentage (Portion)	DEC3_4
SPECO	Minimum Value for Personal Accounts	DEC3_2
CLEAR	Clearance Number for Pension Fund	NUM11
CATFC	Fund Member Category Factor	P16_CATFC

Master Data Relations	Join Conditions
Employer Maximum Contribution Employer Maximum Contribution ? ? Client	`T5W1N.COMAX == T511P.KONST` `T5W1N.[column in domain "MOLGA"] == T511P.MOLGA` `T5W1N.[column in domain "ENDDA"] == T511P.ENDDA` `T5W1N.MANDT == T511P.MANDT`
Gap Insurance Constant Gap Insurance Constant ? ? Client	`T5W1N.KONST == T511P.KONST` `T5W1N.[column in domain "MOLGA"] == T511P.MOLGA` `T5W1N.[column in domain "ENDDA"] == T511P.ENDDA` `T5W1N.MANDT == T511P.MANDT`
Wage Type ? ? Client Wage Type	`T5W1N.[column in domain "MOLGA"] == T512W.MOLGA` `T5W1N.[column in domain "ENDDA"] == T512W.ENDDA` `T5W1N.MANDT == T512W.MANDT` `T5W1N.LGART == T512W.LGART`
Client	`T5W1N.MANDT == T000.MANDT`
Payment Model	`T5W1N.MANDT == T549W.MANDT` `T5W1N.MODEL == T549W.MODEL`

Other Relations \| to Master Data Relations ↑	Join Conditions
Socila insurance company Social Insurance Type (1=MA, 2=PF, 3=UIF) Social Insurance Company Client	`T5W1N.SVSPA == T5W1M.SVSPA` `T5W1N.KVSCH == T5W1M.KVSCH` `T5W1N.MANDT == T5W1M.MANDT`