HRP1939 - DB Table for Infotype 1939
DB Table for Infotype 1939 information is stored in SAP table HRP1939.
It is part of development package PMIQ_NL in software component IS-HER-CM-NL. This development package consists of objects that can be grouped under "Student Lifecycle Management - Netherlands".
It is part of development package PMIQ_NL in software component IS-HER-CM-NL. This development package consists of objects that can be grouped under "Student Lifecycle Management - Netherlands".
Fields for table HRP1939
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 | HRI1939 | 0 | ||||
| TRANS_GUID | GUID - Unique ID of External Transcript | PIQTRTRANS_GUID | CHAR | 64 | ||
| DEGREENR | Number of Degree/Qualification | PIQTRDEGREENR | NUMC | 4 | ||
| DEGREEID | Degree/Qualification | PIQTRDEGREEID | NUMC | 16 | * | |
| TYPENAME | Previous Education Type Name | PIQ_NL_TYPENAME | CHAR | 26 | ||
| BRINNUMBER | BRIN Number | PIQ_NL_BRINNUMBER | CHAR | 8 | ||
| RESIDENCENO | Supplying Institute Residence Number | PIQ_NL_RESIDENCENO | NUMC | 4 | ||
| LOCATION | Location | PIQ_NL_LOCATION | CHAR | 48 | ||
| INSTITUTENAME | Institute Name | PIQ_NL_INSTITUTENAME | CHAR | 140 | ||
| PREEDUEXTCODE | Previous Education Code | PIQ_NL_PREEDUCATION | NUMC | 10 | ||
| PREEDUEXTNAME | Previous Education Name | PIQ_NL_PREEDUNAME | CHAR | 200 | ||
| PREEDUEXTCOUN | Country/Region Key | LAND1 | CHAR | 6 | * | |
| VERIFCERTSTATUS | Certifcate Verification Status | PIQ_NL_VERIFCERTSTATUS | CHAR | 4 | * | |
| VERIFICATIONDATE | Verification Date | PIQ_NL_VERIFICATIONDATE | DATS | 16 | ||
| VERIFIEDBRIN | BRIN Number | PIQ_NL_BRINNUMBER | CHAR | 8 | ||
| VERIFIEDINSTIT | Institute Name | PIQ_NL_INSTITUTENAME | CHAR | 140 | ||
| VERIFACCEPT | Accept Verification | PIQ_NL_VERIFACCEPT | CHAR | 2 | ||
| DEGFAILDATE | Degree/Qualification Failed date | PIQNLDEGFAILDATE | DATS | 16 | ||
| DEGFAILEDFLAG | Indicator: Academic qualification failed | PIQNLFAILEDFLAG | CHAR | 2 | ||
| INSTITUTERIOCODE | Educational Institute code (RIO Description) | PIQ_NL_INSTITUTECODERIO | CHAR | 14 | ||
| INSTLOCRIOCODE | Educational Location code (RIO Location) | PIQ_NL_INSTLOCRIOCODE | CHAR | 14 | ||
| TABNR | Reference Number to Table Part | HRTABNR | CHAR | 64 | HRITABNR |