HRP1501

DB Table for Infotype 1501 | #masterdata | Component: Budget Management

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

Column Name	Description
MANDT FK	Client
PLVAR FK	Plan Version
OTYPE FK	Object Type
OBJID FK	Object ID
SUBTY FK	Subtype
ISTAT FK	Planning Status
BEGDA	Start Date
ENDDA	End Date
VARYF	Variation Field for File PLOG
SEQNR	Number of Infotype Record With Same Key

Column Name	Description
BETRG	Amount

Column Name	Description

Column Name	Description
BEGDA	Start Date
ENDDA	End Date
AEDTM	Changed on

Column Name	Description
KGLST	Indicator for special pay scale group	Show values

Column Name	Description	Domain name
OTJID	Concatenation of Object Type and Object ID	CHAR10
UNAME	User Name	CHAR12
REASN	Reason	CHAR2
HISTO	Historical Record Flag	CHAR1
ITXNR	Text Module for Infotype	NUM08
TRFKZ	ES grouping for collective agreement provision	CHAR1
TRFGR	Pay Scale Group	TRFGR
ANLAG	BAT appendix	CHAR4
TTEIL	BAT Part	CHAR4
ABSNT	BAT section/subsection	CHAR6
KINBW	Indicator for indirect valuation	CHAR1
AKTE	Record Number	TEXT15
KOMM	Reason	TEXT40

Master Data Relations \| to Other Relations ↓	Join Conditions
FTE Limit Group FTE Limit Group Client	`HRP1501.AREA == T7PMX.AREA` `HRP1501.MANDT == T7PMX.MANDT`
Case group catalog Case group catalog Client ?	`HRP1501.FALGK == T5D5K.FALGK` `HRP1501.MANDT == T5D5K.MANDT` `HRP1501.[column in domain "ENDDA"] == T5D5K.ENDDA`
Time base	`HRP1501.MANDT == T7PMI.MANDT` `HRP1501.FREQ == T7PMI.FREQUENCY`
Infotype	`HRP1501.MANDT == T778T.MANDT` `HRP1501.INFTY == T778T.INFTY`
Planning Status	`HRP1501.MANDT == T778S.MANDT` `HRP1501.ISTAT == T778S.ISTAT`
Career Group HCM Localization Career Group Pay scale type	`HRP1501.MANDT == T7PMH.MANDT` `HRP1501.MOLGA == T7PMH.MOLGA` `HRP1501.LFBGR == T7PMH.LFBGR` `HRP1501.TRFAR == T7PMH.TRFAR`
Client	`HRP1501.MANDT == T000.MANDT`
HCM Localization	`HRP1501.MOLGA == T500L.MOLGA`
Object ID Object Type Plan Version Client Object ID	`HRP1501.OTYPE == PLOGI.OTYPE` `HRP1501.PLVAR == PLOGI.PLVAR` `HRP1501.MANDT == PLOGI.MANDT` `HRP1501.OBJID == PLOGI.OBJID`
Object Type	`HRP1501.MANDT == T778O.MANDT` `HRP1501.OTYPE == T778O.OTYPE`
Plan Version	`HRP1501.MANDT == T778P.MANDT` `HRP1501.PLVAR == T778P.PLVAR`
Subtype Subtype Client Infotype	`HRP1501.SUBTY == T778U.SUBTY` `HRP1501.MANDT == T778U.MANDT` `HRP1501.INFTY == T778U.INFTY`
Currency Key	`HRP1501.MANDT == TCURC.MANDT` `HRP1501.WAERS == TCURC.WAERS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Case group ? Client Case group catalog Pay Scale Group ? Case group ?	`HRP1501.[column in domain "TRFGR"] == T5D5F.LTRGR` `HRP1501.MANDT == T5D5F.MANDT` `HRP1501.FALGK == T5D5F.FALGK` `HRP1501.TRFGR == T5D5F.TRFGR` `HRP1501.[column in domain "FALGR"] == T5D5F.LFLGR` `HRP1501.FALGR == T5D5F.FALGR` `HRP1501.[column in domain "ENDDA"] == T5D5F.ENDDA`
Pay scale type HCM Localization Pay scale type	`HRP1501.MANDT == T510A.MANDT` `HRP1501.MOLGA == T510A.MOLGA` `HRP1501.TRFAR == T510A.TRFAR`
Pay Scale Area HCM Localization Client Pay Scale Area	`HRP1501.MOLGA == T510G.MOLGA` `HRP1501.MANDT == T510G.MANDT` `HRP1501.TRFGB == T510G.TRFGB`