HRP1714 - DB Table for Infotype 1714
DB Table for Infotype 1714 information is stored in SAP table HRP1714.
It is part of development package PMIQ in software component IS-HER-CM-AD. This development package consists of objects that can be grouped under "Campus Management".
It is part of development package PMIQ in software component IS-HER-CM-AD. This development package consists of objects that can be grouped under "Campus Management".
Fields for table HRP1714
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | HRIKEY | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| PLVAR | Plan Version | X | PLVAR | CHAR | 2 | T778P |
| OTYPE | Object Type | X | OTYPE | CHAR | 2 | T778O |
| OBJID | Object ID | X | HROBJID | NUMC | 8 | PLOGI |
| SUBTY | Subtype | X | SUBTYP | CHAR | 4 | * |
| ISTAT | Planning Status | X | ISTAT_D | CHAR | 1 | T778S |
| BEGDA | Start Date | X | BEGDATUM | DATS | 8 | |
| ENDDA | End Date | X | ENDDATUM | DATS | 8 | |
| VARYF | Variation Field for File PLOG | X | VARYF | CHAR | 10 | |
| SEQNR | Number of Infotype Record With Same Key | X | SEQNR | NUMC | 3 | |
| INFTY | Infotype | INFOTYP | CHAR | 4 | T778T | |
| OTJID | Concatenation of Object Type and Object ID | OTJID | CHAR | 10 | ||
| .INCLUDE | HRIADMIN | 0 | ||||
| AEDTM | Changed on | AEDTM | DATS | 8 | ||
| UNAME | User Name | USRNAME | CHAR | 12 | ||
| REASN | Reason | REASN | CHAR | 2 | ||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | ||
| ITXNR | Text Module for Infotype | ITXNR | NUMC | 8 | ||
| .INCLUDE | HRI1714 | 0 | ||||
| INST_OTYPE | Object Type | OTYPE | CHAR | 2 | * | |
| INST_OBJID | Object ID | HROBJID | NUMC | 8 | * | |
| PROG_OBJID | Exchange Program ID | PIQEXCSX_OBJID | NUMC | 8 | * | |
| FROM_YEAR | External Academic Year in Which Visiting Studies Started | PIQEXC_YEARFROM | NUMC | 4 | ||
| TO_YEAR | External Academic Year in Which Visiting Studies Ended | PIQEXC_YEARTO | NUMC | 4 | ||
| FROM_SESSION | External Academic Session in Which Visiting Studies Started | PIQEXC_SESSIONFROM | CHAR | 4 | T7PIQTREXTSES | |
| TO_SESSION | External Academic Session for End of Visiting Studies | PIQEXC_SESSIONTO | CHAR | 4 | T7PIQTREXTSES | |
| CONTACT_OTYPE | Object Type | OTYPE | CHAR | 2 | * | |
| CONTACT_OBJID | University Contact Person (Business Partner Object ID) | PIQEXCCONT_OBJID | CHAR | 45 | ||
| APPROVE_DATE | Approval Date for Visiting Studies | PIQEXCAPPRDATE | DATS | 8 | ||
| ENDOFSTAY | Last Day of Visiting Studies | PIQEXCENDSTAY | DATS | 8 | ||
| DISCIPLINE | Discipline | PIQSMDISZIP | CHAR | 16 | T7PIQSMDISZIP | |
| EXCH_STATUS | External Admission Status | PIQEXCSTATUS | CHAR | 4 | T7PIQEXCSTATUS | |
| EXCH_CHOICE | Visiting Studies Choice | PIQEXCCHOICE | NUMC | 2 | T7PIQEXCCHOICE | |
| HOMEDEGRTYPE | Degree Type of Home University | PIQEXCHOMEDEGRTPE | CHAR | 4 | T7PIQQUAL_LEVEL | |
| STUDCATEGORY | Visiting Student Category | PIQEXCSTCAT | CHAR | 4 | T7PIQEXCSTCAT | |
| ADDINFO | Additional Information | PIQEXC_INFO | CHAR | 40 |