HRP1718

DB Table for Infotype 1718 | #masterdata | Component: Administration

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

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

Column Name	Description

Column Name	Description
BEGDA	Start Date
ENDDA	End Date
AEDTM	Changed on
START_DATE	Internship Begin Date
END_DATE	Internship End Date

Column Name	Description
UNIT	Internship Duration Unit	Show values
FULLPART_IND	UCAS: Full-Time Indicator	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
ARBGB	Name of Employer or Company	TEXT20
ORT01	Location of Employer or Company	TEXT25
TAETEBSCHR	Job (Description)	TEXT120
ISHREG_ID	Internship Registration ID	SYSUUID_C32
TEXT	Internship Registration (Description)	TEXT60
ATTRIBUTE1	Internship Attribute 1	PIQISH_ATTR
ATTRIBUTE2	Internship Attribute 2	PIQISH_ATTR
ATTRIBUTE3	Internship Attribute 3	PIQISH_ATTR
ATTRIBUTE4	Internship Attribute 4	PIQISH_ATTR
ATTRIBUTE5	Internship Attribute 5	PIQISH_ATTR
GUIDTYPE	Unique Identification Type (GUID)	PIQGUIDTYPE
GUID	Unique Key (ID)	SYSUUID_C
SC_OBJID	Program ID	HROBJID
ACLEVEL	Stage	PIQLEVEL
REF_OTYPE	Object Type	OTYPE
REF_OBJID	Object ID	HROBJID
NOTE_GUID	GUID - Unique Note Identifier	SYSUUID_C
DURATION	Internship Duration	PIQISH_DUR

Master Data Relations	Join Conditions
Academic Session	`HRP1718.MANDT == T7PIQPERIOD.MANDT` `HRP1718.ACAD_SESSION == T7PIQPERIOD.PERID`
Academic Year	`HRP1718.MANDT == T7PIQYEAR.MANDT` `HRP1718.ACAD_YEAR == T7PIQYEAR.PERYR`
Work Contract Concluded With Employer	`HRP1718.MANDT == T542C.MANDT` `HRP1718.ANSVX == T542C.ANSVX`
Industry key Industry key Client	`HRP1718.BRANC == T016.BRSCH` `HRP1718.MANDT == T016.MANDT`
Internship Category 1	`HRP1718.MANDT == T7PIQISHCAT1.MANDT` `HRP1718.CATEGORY1 == T7PIQISHCAT1.CATEGORY1`
Internship Category 2	`HRP1718.MANDT == T7PIQISHCAT2.MANDT` `HRP1718.CATEGORY2 == T7PIQISHCAT2.CATEGORY2`
Internship Category 3	`HRP1718.MANDT == T7PIQISHCAT3.MANDT` `HRP1718.CATEGORY3 == T7PIQISHCAT3.CATEGORY3`
Internship Category 4	`HRP1718.MANDT == T7PIQISHCAT4.MANDT` `HRP1718.CATEGORY4 == T7PIQISHCAT4.CATEGORY4`
Internship Category 5 Internship Category 5 Client	`HRP1718.CATEGORY5 == T7PIQISHCAT5.CATEGORY5` `HRP1718.MANDT == T7PIQISHCAT5.MANDT`
Internship Contact Person Internship Contact Person Client	`HRP1718.CONTACT_PARTNER == BUT000.PARTNER` `HRP1718.MANDT == BUT000.CLIENT`
Infotype	`HRP1718.MANDT == T778T.MANDT` `HRP1718.INFTY == T778T.INFTY`
Offering Institution Offering Institution Client	`HRP1718.INST_PARTNER == BUT000.PARTNER` `HRP1718.MANDT == BUT000.CLIENT`
Planning Status	`HRP1718.MANDT == T778S.MANDT` `HRP1718.ISTAT == T778S.ISTAT`
Country/Region Key Country/Region Key Client	`HRP1718.LAND1 == T005.LAND1` `HRP1718.MANDT == T005.MANDT`
Client	`HRP1718.MANDT == T000.MANDT`
Object ID Object Type Plan Version Client Object ID	`HRP1718.OTYPE == PLOGI.OTYPE` `HRP1718.PLVAR == PLOGI.PLVAR` `HRP1718.MANDT == PLOGI.MANDT` `HRP1718.OBJID == PLOGI.OBJID`
Object Type	`HRP1718.MANDT == T778O.MANDT` `HRP1718.OTYPE == T778O.OTYPE`
Plan Version	`HRP1718.MANDT == T778P.MANDT` `HRP1718.PLVAR == T778P.PLVAR`
Internship Registration Status Internship Registration Status Client	`HRP1718.STATUS == T7PIQISHSTATUS.STATUS` `HRP1718.MANDT == T7PIQISHSTATUS.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Present or Previous Job Present or Previous Job ?	`HRP1718.MANDT == T513C.MANDT` `HRP1718.TAETE == T513C.TAETE` `HRP1718.[column in domain "SPRAS"] == T513C.SPRAS`