HRP1009

Infotype 1009 DB table | #masterdata | Component: Staffing

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

Column Name	Description
MANDT FK	Client
PLVAR FK	Plan Version
OTYPE FK	Object Type
OBJID FK	Object ID
SUBTY	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

Column Name	Description

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

Column Name	Description

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

Master Data Relations	Join Conditions
Infotype	`HRP1009.MANDT == T778T.MANDT` `HRP1009.INFTY == T778T.INFTY`
Planning Status	`HRP1009.MANDT == T778S.MANDT` `HRP1009.ISTAT == T778S.ISTAT`
Client	`HRP1009.MANDT == T000.MANDT`
Object ID Object Type Plan Version Client Object ID	`HRP1009.OTYPE == PLOGI.OTYPE` `HRP1009.PLVAR == PLOGI.PLVAR` `HRP1009.MANDT == PLOGI.MANDT` `HRP1009.OBJID == PLOGI.OBJID`
Object Type	`HRP1009.MANDT == T778O.MANDT` `HRP1009.OTYPE == T778O.OTYPE`
Plan Version	`HRP1009.MANDT == T778P.MANDT` `HRP1009.PLVAR == T778P.PLVAR`
Examination Type Examination Type Subtype Client	`HRP1009.UNART == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART001 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART002 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART003 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART004 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART005 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART006 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART007 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART008 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART009 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART010 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART011 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART012 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART013 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART014 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART015 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART016 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART017 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART018 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART019 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART020 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART021 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART022 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART023 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART024 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART025 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART026 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART027 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART028 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART029 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART030 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART031 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART032 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART033 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART034 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART035 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART036 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART037 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART038 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART039 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART040 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART041 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART042 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART043 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART044 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART045 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART046 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART047 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART048 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART049 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART050 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART051 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART052 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART053 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART054 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART055 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART056 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART057 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART058 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART059 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART060 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`
Examination Type Examination Type Subtype Client	`HRP1009.UNART061 == T778G.UNART` `HRP1009.SUBTY == T778G.SUBTY` `HRP1009.MANDT == T778G.MANDT`