T5ITC3

Lowest rate management | #other | Component: Italy

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical
Other
🔗 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
TPASS FK	Taxation type	Show values
CDCON FK	Contribution indicator
GRCAL FK	Calculation group
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

Master Data Relations \| to Other Relations ↓	Join Conditions
Contribution indicator ? Client Contribution indicator Pay scale type Pay Scale Area Taxation type	`T5ITC3.[column in domain "ENDDA"] == T5ITCS.ENDDA` `T5ITC3.MANDT == T5ITCS.MANDT` `T5ITC3.CDCON == T5ITCS.CDCON` `T5ITC3.TRFAR == T5ITCS.TRFAR` `T5ITC3.TRFGB == T5ITCS.TRFGB` `T5ITC3.TPASS == T5ITCS.TPASS`
Client	`T5ITC3.MANDT == T000.MANDT`
Taxation type ? Pay scale type Pay Scale Area Taxation type	`T5ITC3.MANDT == T5ITCT.MANDT` `T5ITC3.[column in domain "ENDDA"] == T5ITCT.ENDDA` `T5ITC3.TRFAR == T5ITCT.TRFAR` `T5ITC3.TRFGB == T5ITCT.TRFGB` `T5ITC3.TPASS == T5ITCT.TPASS`
Wage type: lowest rate integration ? ? Client Wage type: lowest rate integration	`T5ITC3.[column in domain "MOLGA"] == T512W.MOLGA` `T5ITC3.[column in domain "ENDDA"] == T512W.ENDDA` `T5ITC3.MANDT == T512W.MANDT` `T5ITC3.WTIMI == T512W.LGART`

Other Relations \| to Master Data Relations ↑	Join Conditions
Calculation group Pay scale type Pay Scale Area ES grouping for collective agreement provision Client Calculation group ? Taxation type ? ?	`T5ITC3.TRFAR == T5ITC1.TRFAR` `T5ITC3.TRFGB == T5ITC1.TRFGB` `T5ITC3.TRFKZ == T5ITC1.TRFKZ` `T5ITC3.MANDT == T5ITC1.MANDT` `T5ITC3.GRCAL == T5ITC1.GRCAL` `T5ITC3.[column in domain "P15_PROGR"] == T5ITC1.PROGR` `T5ITC3.TPASS == T5ITC1.TPASS` `T5ITC3.[column in domain "P15_CDCON"] == T5ITC1.CDCON` `T5ITC3.[column in domain "ENDDA"] == T5ITC1.ENDDA`
Lowest rate type of value Pay Scale Area Lowest rate type of value Pay scale type ES grouping for collective agreement provision ? ? ?	`T5ITC3.MANDT == T5ITC4.MANDT` `T5ITC3.TRFGB == T5ITC4.TRFGB` `T5ITC3.TPVMI == T5ITC4.TPVMI` `T5ITC3.TRFAR == T5ITC4.TRFAR` `T5ITC3.TRFKZ == T5ITC4.TRFKZ` `T5ITC3.[column in domain "TRFGR"] == T5ITC4.TRFGR` `T5ITC3.[column in domain "TRFST"] == T5ITC4.TRFST` `T5ITC3.[column in domain "ENDDA"] == T5ITC4.ENDDA`
Pay scale type ? Pay scale type	`T5ITC3.MANDT == T510A.MANDT` `T5ITC3.[column in domain "MOLGA"] == T510A.MOLGA` `T5ITC3.TRFAR == T510A.TRFAR`
Pay Scale Area ? Client Pay Scale Area	`T5ITC3.[column in domain "MOLGA"] == T510G.MOLGA` `T5ITC3.MANDT == T510G.MANDT` `T5ITC3.TRFGB == T510G.TRFGB`