T7HK2B

Contribution plan attributes | #other | Component: Hong Kong

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

Column Name	Description
MANDT FK	Client
CONTP FK	Contribution plan
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
PRVER	Indicator: Include Credit YOS for Previous Employment	Show values
PRECB	Indicator: Use Pre-prorated Calculation Base.	Show values
CMTHD	Indicator to use calculation method B	Show values
VCAMA	Contribute Alternative Voluntary MPF after Retirement	Show values

Column Name	Description	Domain name
PLANO	Provider's plan reference number	CHAR20
PREWT	Calculation basis for contribution plan	LGART

Master Data Relations	Join Conditions
Contribution plan	`T7HK2B.MANDT == T7HK2.MANDT` `T7HK2B.CONTP == T7HK2.CONTP`
Cumulation Type	`T7HK2B.MANDT == T54C2.MANDT` `T7HK2B.CUMTY == T54C2.CUMTY`
Employee mandatory contribution wage type ? ? Client Employee mandatory contribution wage type	`T7HK2B.[column in domain "MOLGA"] == T512W.MOLGA` `T7HK2B.[column in domain "ENDDA"] == T512W.ENDDA` `T7HK2B.MANDT == T512W.MANDT` `T7HK2B.EEMWT == T512W.LGART`
Employee non-mandatory contribution wage type ? ? Client Employee non-mandatory contribution wage type	`T7HK2B.[column in domain "MOLGA"] == T512W.MOLGA` `T7HK2B.[column in domain "ENDDA"] == T512W.ENDDA` `T7HK2B.MANDT == T512W.MANDT` `T7HK2B.EENWT == T512W.LGART`
Employer mandatory contribution wage type ? ? Client Employer mandatory contribution wage type	`T7HK2B.[column in domain "MOLGA"] == T512W.MOLGA` `T7HK2B.[column in domain "ENDDA"] == T512W.ENDDA` `T7HK2B.MANDT == T512W.MANDT` `T7HK2B.ERMWT == T512W.LGART`
Employer non-mandatory contribution wage type ? ? Client Employer non-mandatory contribution wage type	`T7HK2B.[column in domain "MOLGA"] == T512W.MOLGA` `T7HK2B.[column in domain "ENDDA"] == T512W.ENDDA` `T7HK2B.MANDT == T512W.MANDT` `T7HK2B.ERNWT == T512W.LGART`
client	`T7HK2B.MANDT == T000.MANDT`
Contribution plan status	`T7HK2B.MANDT == T7HK23.MANDT` `T7HK2B.PLSTA == T7HK23.PLSTA`
Provider	`T7HK2B.MANDT == T7HK2H.MANDT` `T7HK2B.PROVR == T7HK2H.PROVR`
Calculation basis for contribution plan ? ? Client Calculation basis for contribution plan	`T7HK2B.[column in domain "MOLGA"] == T512W.MOLGA` `T7HK2B.[column in domain "ENDDA"] == T512W.ENDDA` `T7HK2B.MANDT == T512W.MANDT` `T7HK2B.SALWT == T512W.LGART`
Years of service output format Years of service output format Client	`T7HK2B.SCALC == T7HK2P.SCALC` `T7HK2B.MANDT == T7HK2P.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Nature of contribution/entitlement plan	`T7HK2B.MANDT == T7HK2G.MANDT` `T7HK2B.FTYPE == T7HK2G.FTYPE`