T5R1E

The rates of levy for foreign worker | #masterdata | Component: Singapore

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

Column Name	Description
MANDT FK	Client
SIGRP FK	Institution of soc. provident funds SG
FUNTY FK	Fund type
FWTYP FK	Types of foreign workers
FWSGR	Subgroup of foreign workers
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description

Column Name	Description	Domain name
MLEVY	Levy per month for foreign worker	DEC4_2
PLEVY	Levy for part-month employment of foreign worker	DEC4_2
LEMAX	Maximum for levy for part-month foreign worker	DEC4_2

Master Data Relations	Join Conditions
Fund type Institution of soc. provident funds SG Fund type ?	`T5R1E.MANDT == T5R1B.MANDT` `T5R1E.SIGRP == T5R1B.SIGRP` `T5R1E.FUNTY == T5R1B.FUNTY` `T5R1E.[column in domain "P25M_FUNCL"] == T5R1B.FUNCL`
Client	`T5R1E.MANDT == T000.MANDT`
Institution of soc. provident funds SG ? Institution of soc. provident funds SG ?	`T5R1E.MANDT == T5R1A.MANDT` `T5R1E.[column in domain "ENDDA"] == T5R1A.ENDDA` `T5R1E.SIGRP == T5R1A.SIGRP` `T5R1E.[column in domain "P25M_SIOFC"] == T5R1A.SIOFC`

Other Relations \| to Master Data Relations ↑	Join Conditions
Types of foreign workers Types of foreign workers Subgroup of foreign workers	`T5R1E.MANDT == T5R1D.MANDT` `T5R1E.FWTYP == T5R1D.FWTYP` `T5R1E.FWSGR == T5R1D.FWSGR`