HRP1789

DB Table for Infotype 1789 | #masterdata | Component: Campus Management
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
ADM_DATE Admission Approved Date
Column Name Description
PERID_FIRST Statistical Reporting Period Show values
GDRSEM_STUDTYP Study Type Show values
WORK_QUAL Work Experience with Qualification Show values
WORK_STUDY Work Experience with Qualification for Current Study 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
PERYR Academic Year PIQPERYR
PERID Academic Session PIQPERID
PERYR_FIRST Statistical Reporting Year PIQ_DE_PERYR
GDRSEM Number of Semesters in German Democratic Republic PIQ_DE_SESSCNT
PREPSEM Number of Semesters at Preparatory College PIQ_DE_SESSCNT
UNIVERSITYSEM Number of Semesters at German Universities PIQ_DE_SESSCNT
LEAVEOFABSSEM Semesters with Leaves of Absence at German Universities PIQ_DE_SESSCNT
INTERNSHIPSEM Number of Internship Semesters at Higher Education Institute PIQ_DE_SESSCNT
CLINICSEM Clinical Semesters PIQ_DE_SESSCNT
INTERRUPTSEM_PREV Interrupted Semesters PIQ_DE_SESSCNT
INTERRUPT_PROGRAM Program ID HROBJID
REF_OTYPE Object Type OTYPE
REF_REALO ID of Related Object CHAR45
COHORT_SEM Cohorts Semesters PIQ_DE_SESSCNT
CLINIC_COHSEM Clinical Cohort Semesters PIQ_DE_SESSCNT
CLINIC_SUBSEM Clinical Subject Semesters PIQ_DE_SESSCNT
Master Data Relations Join Conditions
First Higher Education Institute
  • ?
  • ?
  • First Higher Education Institute
Country/Region Key
  • Country/Region Key
  • Client
  • HRP1789.HEI_COUNTRY == T005.LAND1
  • HRP1789.MANDT == T005.MANDT
Foreign Key: Infotype
  • HRP1789.MANDT == T778T.MANDT
  • HRP1789.INFTY == T778T.INFTY
Type of Study Interruption
  • ?
  • Type of Study Interruption
Foreign Key: Status
  • HRP1789.MANDT == T778S.MANDT
  • HRP1789.ISTAT == T778S.ISTAT
Foreign Key: Client HRP1789.MANDT == T000.MANDT
Foreign Key: Object ID
  • Object Type
  • Plan Version
  • Client
  • Object ID
  • HRP1789.OTYPE == PLOGI.OTYPE
  • HRP1789.PLVAR == PLOGI.PLVAR
  • HRP1789.MANDT == PLOGI.MANDT
  • HRP1789.OBJID == PLOGI.OBJID
Foreign Key: Object Type
  • HRP1789.MANDT == T778O.MANDT
  • HRP1789.OTYPE == T778O.OTYPE
Foreign Key: Plan Version
  • HRP1789.MANDT == T778P.MANDT
  • HRP1789.PLVAR == T778P.PLVAR
Reference Number to Table Part