T5RPBSG1

Salary Conversions for GNP | #other | Component: Public Sector

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

Column Name	Description
MANDT FK	Client
MOLGA FK	HCM Localization
GNPCD FK	GNP Code
OPSTP FK	Old PayScale Type
OPSLA FK	Old PayScale Area
OESGR FK	Old ESG for CAP
OPSGR FK	Old PayScale Group
OPSLV FK	Old PayScale Level

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
GRPID	Group Id	CHAR2

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T5RPBSG1.MANDT == T000.MANDT`
HCM Localization	`T5RPBSG1.MOLGA == T500L.MOLGA`

Other Relations \| to Master Data Relations ↑	Join Conditions
Fr Key for GNPCD	`T5RPBSG1.MANDT == T5RPBSG0.MANDT` `T5RPBSG1.GNPCD == T5RPBSG0.GNPCD`
New ESG for CAP HCM Localization New PayScale Type ? ? ? New ESG for CAP Client New PayScale Area ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.NPSTP == T510.TRFAR` `T5RPBSG1.[column in domain "TRFGR"] == T510.TRFGR` `T5RPBSG1.[column in domain "TRFST"] == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.NESGR == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.NPSLA == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`
New PayScale Group HCM Localization New PayScale Type New PayScale Group ? ? New ESG for CAP Client New PayScale Area ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.NPSTP == T510.TRFAR` `T5RPBSG1.NPSGR == T510.TRFGR` `T5RPBSG1.[column in domain "TRFST"] == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.NESGR == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.NPSLA == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`
New PayScale Area HCM Localization New PayScale Type ? ? ? ? Client New PayScale Area ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.NPSTP == T510.TRFAR` `T5RPBSG1.[column in domain "TRFGR"] == T510.TRFGR` `T5RPBSG1.[column in domain "TRFST"] == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.[column in domain "TRFKZ"] == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.NPSLA == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`
New Pay Scale level HCM Localization New PayScale Type New PayScale Group New Pay Scale level ? New ESG for CAP Client New PayScale Area ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.NPSTP == T510.TRFAR` `T5RPBSG1.NPSGR == T510.TRFGR` `T5RPBSG1.NPSLV == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.NESGR == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.NPSLA == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`
New PayScale Type HCM Localization New PayScale Type ? ? ? ? Client ? ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.NPSTP == T510.TRFAR` `T5RPBSG1.[column in domain "TRFGR"] == T510.TRFGR` `T5RPBSG1.[column in domain "TRFST"] == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.[column in domain "TRFKZ"] == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.[column in domain "TRFGB"] == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`
Old ESG for CAP HCM Localization Old PayScale Type ? ? ? Old ESG for CAP Client Old PayScale Area ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.OPSTP == T510.TRFAR` `T5RPBSG1.[column in domain "TRFGR"] == T510.TRFGR` `T5RPBSG1.[column in domain "TRFST"] == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.OESGR == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.OPSLA == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`
Old PayScale Group HCM Localization Old PayScale Type Old PayScale Group ? ? Old ESG for CAP Client Old PayScale Area ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.OPSTP == T510.TRFAR` `T5RPBSG1.OPSGR == T510.TRFGR` `T5RPBSG1.[column in domain "TRFST"] == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.OESGR == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.OPSLA == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`
Old PayScale Area HCM Localization Old PayScale Type ? ? ? ? Client Old PayScale Area ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.OPSTP == T510.TRFAR` `T5RPBSG1.[column in domain "TRFGR"] == T510.TRFGR` `T5RPBSG1.[column in domain "TRFST"] == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.[column in domain "TRFKZ"] == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.OPSLA == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`
Old PayScale Level HCM Localization Old PayScale Type Old PayScale Group Old PayScale Level ? Old ESG for CAP Client Old PayScale Area ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.OPSTP == T510.TRFAR` `T5RPBSG1.OPSGR == T510.TRFGR` `T5RPBSG1.OPSLV == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.OESGR == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.OPSLA == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`
Old PayScale Type HCM Localization Old PayScale Type ? ? ? ? Client ? ?	`T5RPBSG1.MOLGA == T510.MOLGA` `T5RPBSG1.OPSTP == T510.TRFAR` `T5RPBSG1.[column in domain "TRFGR"] == T510.TRFGR` `T5RPBSG1.[column in domain "TRFST"] == T510.TRFST` `T5RPBSG1.[column in domain "LGART"] == T510.LGART` `T5RPBSG1.[column in domain "TRFKZ"] == T510.TRFKZ` `T5RPBSG1.MANDT == T510.MANDT` `T5RPBSG1.[column in domain "TRFGB"] == T510.TRFGB` `T5RPBSG1.[column in domain "ENDDA"] == T510.ENDDA`