HRP1789 - DB Table for Infotype 1789
DB Table for Infotype 1789 information is stored in SAP table HRP1789.
It is part of development package PMIQ_DE_STAT_REPORTING in software component IS-HER-CM. This development package consists of objects that can be grouped under "Statistical Reporting".
It is part of development package PMIQ_DE_STAT_REPORTING in software component IS-HER-CM. This development package consists of objects that can be grouped under "Statistical Reporting".
Fields for table HRP1789
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | HRIKEY | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| PLVAR | Plan Version | X | PLVAR | CHAR | 4 | T778P |
| OTYPE | Object Type | X | OTYPE | CHAR | 4 | T778O |
| OBJID | Object ID | X | HROBJID | NUMC | 16 | PLOGI |
| SUBTY | Subtype | X | SUBTYP | CHAR | 8 | * |
| ISTAT | Planning Status | X | ISTAT_D | CHAR | 2 | T778S |
| BEGDA | Start Date | X | BEGDATUM | DATS | 16 | |
| ENDDA | End Date | X | ENDDATUM | DATS | 16 | |
| VARYF | Variation Field for File PLOG | X | VARYF | CHAR | 20 | |
| SEQNR | Number of Infotype Record With Same Key | X | SEQNR | NUMC | 6 | |
| INFTY | Infotype | INFOTYP | CHAR | 8 | T778T | |
| OTJID | Concatenation of Object Type and Object ID | OTJID | CHAR | 20 | ||
| .INCLUDE | HRIADMIN | 0 | ||||
| AEDTM | Changed on | AEDTM | DATS | 16 | ||
| UNAME | User Name | USRNAME | CHAR | 24 | ||
| REASN | Reason | REASN | CHAR | 4 | ||
| HISTO | Historical Record Flag | HISTO | CHAR | 2 | ||
| ITXNR | Text Module for Infotype | ITXNR | NUMC | 16 | ||
| .INCLUDE | HRI1789 | 0 | ||||
| PERYR | Academic Year | PIQPERYR | NUMC | 8 | * | |
| PERID | Academic Session | PIQPERID | NUMC | 6 | * | |
| PERYR_FIRST | Statistical Reporting Year | PIQ_DE_PERYR | NUMC | 8 | ||
| PERID_FIRST | Statistical Reporting Period | PIQ_DE_PERID | NUMC | 2 | ||
| HEI | First Higher Education Institute | PIQ_DE_HEI_FIRST | CHAR | 8 | T7PIQ_DE_HEI | |
| GDRSEM | Number of Semesters in German Democratic Republic | PIQ_DE_SESSCNT_GDR | DEC | 3 | ||
| GDRSEM_STUDTYP | Study Type | PIQ_DE_STUDYTYP | NUMC | 2 | ||
| PREPSEM | Number of Semesters at Preparatory College | PIQ_DE_SESSCNT_PRPC | DEC | 3 | ||
| UNIVERSITYSEM | Number of Semesters at German Universities | PIQ_DE_SESSCNT_UNIV | DEC | 3 | ||
| LEAVEOFABSSEM | Semesters with Leaves of Absence at German Universities | PIQ_DE_SESSCNT_LOA | DEC | 3 | ||
| INTERNSHIPSEM | Number of Internship Semesters at Higher Education Institute | PIQ_DE_SESSCNT_INTERN | DEC | 3 | ||
| CLINICSEM | Clinical Semesters | PIQ_DE_SESSCNT_CLINIC | DEC | 3 | ||
| WORK_QUAL | Work Experience with Qualification | PIQ_DE_WORK_EXP_QUAL | CHAR | 2 | ||
| WORK_STUDY | Work Experience with Qualification for Current Study | PIQ_DE_WORK_EXP_STUDY | CHAR | 2 | ||
| INTERRUPTSEM_PREV | Interrupted Semesters | PIQ_DE_SESSCNT_INTRUPT | DEC | 3 | ||
| HEI_COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | T005 | |
| INTERRUPT_PROGRAM | Program ID | PIQSCOBJID | NUMC | 16 | * | |
| INTERRUPT_TYPE | Type of Study Interruption | PIQ_DE_INTERRUPT_TYPE | CHAR | 4 | T7PIQ_DE_ITRTYP | |
| REF_OTYPE | Object Type | OTYPE | CHAR | 4 | * | |
| REF_REALO | ID of Related Object | SOBID | CHAR | 90 | ||
| ADM_DATE | Admission Approved Date | PIQ_DE_ADM_DATE | DATS | 16 | ||
| COHORT_SEM | Cohorts Semesters | PIQ_DE_SESSCNT_COHSEM | DEC | 3 | ||
| CLINIC_COHSEM | Clinical Cohort Semesters | PIQ_DE_SESSCNT_CLINICCOHSEM | DEC | 3 | ||
| CLINIC_SUBSEM | Clinical Subject Semesters | PIQ_DE_SUB_SEM | DEC | 3 | ||
| .INCLUDE | CI_P1789 | 0 | ||||
| TABNR | Reference Number to Table Part | HRTABNR | CHAR | 64 | HRITABNR |