T5ITS7

Insurance pay scale jumps - class change | #other | Component: Italy

🔑 Keys (9)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical
Other (2)
🔗 Relations (8)

Column Name	Description
MANDT FK	Client
TRFAR FK	Pay scale type
TRFGB FK	Pay Scale Area
TRFKZ	ES grouping for collective agreement provision
TRFGR FK	Pay Scale Group
TRFST FK	Pay Scale Level
TPVAL FK	Valuation type
CDCAA	Current service category
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
RISCA	Number of months in the future class	NUM3
CDCAF	Future service category	NUMC2

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T5ITS7.MANDT == T000.MANDT`
Valuation type Valuation type ?	`T5ITS7.MANDT == T5ITSV.MANDT` `T5ITS7.TPVAL == T5ITSV.TPVAL` `T5ITS7.[column in domain "ENDDA"] == T5ITSV.ENDDA`

Other Relations \| to Master Data Relations ↑	Join Conditions
Pay Scale Group ? Pay scale type Pay Scale Group Pay Scale Level ? ES grouping for collective agreement provision Client Pay Scale Area ?	`T5ITS7.[column in domain "MOLGA"] == T510.MOLGA` `T5ITS7.TRFAR == T510.TRFAR` `T5ITS7.CATSU == T510.TRFGR` `T5ITS7.SLSUC == T510.TRFST` `T5ITS7.[column in domain "LGART"] == T510.LGART` `T5ITS7.TRFKZ == T510.TRFKZ` `T5ITS7.MANDT == T510.MANDT` `T5ITS7.TRFGB == T510.TRFGB` `T5ITS7.[column in domain "ENDDA"] == T510.ENDDA`
Pay Scale Level ? Pay scale type Pay Scale Group Pay Scale Level ? ES grouping for collective agreement provision Client Pay Scale Area ?	`T5ITS7.[column in domain "MOLGA"] == T510.MOLGA` `T5ITS7.TRFAR == T510.TRFAR` `T5ITS7.TRFGR == T510.TRFGR` `T5ITS7.SLSUC == T510.TRFST` `T5ITS7.[column in domain "LGART"] == T510.LGART` `T5ITS7.TRFKZ == T510.TRFKZ` `T5ITS7.MANDT == T510.MANDT` `T5ITS7.TRFGB == T510.TRFGB` `T5ITS7.[column in domain "ENDDA"] == T510.ENDDA`
trfar ? Pay scale type	`T5ITS7.MANDT == T510A.MANDT` `T5ITS7.[column in domain "MOLGA"] == T510A.MOLGA` `T5ITS7.TRFAR == T510A.TRFAR`
trfgb ? Client Pay Scale Area	`T5ITS7.[column in domain "MOLGA"] == T510G.MOLGA` `T5ITS7.MANDT == T510G.MANDT` `T5ITS7.TRFGB == T510G.TRFGB`
Pay Scale Group ? Pay scale type Pay Scale Group Pay Scale Level ? ES grouping for collective agreement provision Client Pay Scale Area ?	`T5ITS7.[column in domain "MOLGA"] == T510.MOLGA` `T5ITS7.TRFAR == T510.TRFAR` `T5ITS7.TRFGR == T510.TRFGR` `T5ITS7.TRFST == T510.TRFST` `T5ITS7.[column in domain "LGART"] == T510.LGART` `T5ITS7.TRFKZ == T510.TRFKZ` `T5ITS7.MANDT == T510.MANDT` `T5ITS7.TRFGB == T510.TRFGB` `T5ITS7.[column in domain "ENDDA"] == T510.ENDDA`
Pay Scale Level ? Pay scale type Pay Scale Group Pay Scale Level ? ES grouping for collective agreement provision Client Pay Scale Area ?	`T5ITS7.[column in domain "MOLGA"] == T510.MOLGA` `T5ITS7.TRFAR == T510.TRFAR` `T5ITS7.TRFGR == T510.TRFGR` `T5ITS7.TRFST == T510.TRFST` `T5ITS7.[column in domain "LGART"] == T510.LGART` `T5ITS7.TRFKZ == T510.TRFKZ` `T5ITS7.MANDT == T510.MANDT` `T5ITS7.TRFGB == T510.TRFGB` `T5ITS7.[column in domain "ENDDA"] == T510.ENDDA`