T5D3M

Assignment of a Valuation of Pay Scales for Statistics | #masterdata | Component: Germany

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

Column Name	Description
MANDT FK	Client
MOLGA FK	HCM Localization
SUBTY FK	Statistics area
STAGB FK	Statistics Indicator
TRFAR FK	Pay scale type
TRFGB FK	Pay Scale Area
TRFKZ FK	ES grouping for collective agreement provision
TRFGR FK	Pay Scale Group
TRFST FK	Pay Scale Level
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
Valuation of Pay Scales for Statistics HCM Localization Statistics Indicator Client Statistics area Valuation of Pay Scales for Statistics	`T5D3M.MOLGA == T5D3N.MOLGA` `T5D3M.STAGB == T5D3N.STAGB` `T5D3M.MANDT == T5D3N.MANDT` `T5D3M.SUBTY == T5D3N.SUBTY` `T5D3M.EINST == T5D3N.EINST`
Client	`T5D3M.MANDT == T000.MANDT`
HCM Localization	`T5D3M.MOLGA == T500L.MOLGA`
Statistics Indicator HCM Localization Statistics Indicator Statistics area Client	`T5D3M.MOLGA == T543A.MOLGA` `T5D3M.STAGB == T543A.STAGB` `T5D3M.SUBTY == T543A.SUBTY` `T5D3M.MANDT == T543A.MANDT`
Statistics area ? Statistics area	`T5D3M.MANDT == T591A.MANDT` `T5D3M.[column in domain "INFTY"] == T591A.INFTY` `T5D3M.SUBTY == T591A.SUBTY`

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