SAP ABAP Table HRP1714 (DB Table for Infotype 1714)
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQ (Package) Campus Management
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQ (Package) Campus Management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | HRP1714 | Table Relationship Diagram |
Short Description | DB Table for Infotype 1714 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Extended Key Definition of PD Infotypes | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
4 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
5 | OBJID | HROBJID | HROBJID | NUMC | 8 | 0 | Object ID | PLOGI | |
6 | SUBTY | SUBTYP | SUBTYP | CHAR | 4 | 0 | Subtype | * | |
7 | ISTAT | ISTAT_D | ISTAT | CHAR | 1 | 0 | Planning Status | T778S | |
8 | BEGDA | BEGDATUM | DATUM | DATS | 8 | 0 | Start Date | ||
9 | ENDDA | ENDDATUM | DATUM | DATS | 8 | 0 | End Date | ||
10 | VARYF | VARYF | CHAR10 | CHAR | 10 | 0 | Variation Field for File PLOG | ||
11 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
12 | INFTY | INFOTYP | INFOTYP | CHAR | 4 | 0 | Infotype | T778T | |
13 | OTJID | OTJID | CHAR10 | CHAR | 10 | 0 | Concatenation of Object Type and Object ID | ||
14 | .INCLUDE | 0 | 0 | Infotype Administration Data | |||||
15 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
16 | UNAME | USRNAME | CHAR12 | CHAR | 12 | 0 | User Name | ||
17 | REASN | REASN | CHAR2 | CHAR | 2 | 0 | Reason | ||
18 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
19 | ITXNR | ITXNR | NUM08 | NUMC | 8 | 0 | Text Module for Infotype | ||
20 | .INCLUDE | 0 | 0 | Visiting Studies | |||||
21 | INST_OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
22 | INST_OBJID | HROBJID | HROBJID | NUMC | 8 | 0 | Object ID | * | |
23 | PROG_OBJID | PIQEXCSX_OBJID | HROBJID | NUMC | 8 | 0 | Exchange Program ID | * | |
24 | FROM_YEAR | PIQEXC_YEARFROM | PIQTRSESSIONYEAR | NUMC | 4 | 0 | External Academic Year in Which Visiting Studies Started | ||
25 | TO_YEAR | PIQEXC_YEARTO | PIQTRSESSIONYEAR | NUMC | 4 | 0 | External Academic Year in Which Visiting Studies Ended | ||
26 | FROM_SESSION | PIQEXC_SESSIONFROM | PIQTRSESSIONID | CHAR | 4 | 0 | External Academic Session in Which Visiting Studies Started | T7PIQTREXTSES | |
27 | TO_SESSION | PIQEXC_SESSIONTO | PIQTRSESSIONID | CHAR | 4 | 0 | External Academic Session for End of Visiting Studies | T7PIQTREXTSES | |
28 | CONTACT_OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
29 | CONTACT_OBJID | PIQEXCCONT_OBJID | CHAR45 | CHAR | 45 | 0 | University Contact Person (Business Partner Object ID) | ||
30 | APPROVE_DATE | PIQEXCAPPRDATE | DATUM | DATS | 8 | 0 | Approval Date for Visiting Studies | ||
31 | ENDOFSTAY | PIQEXCENDSTAY | DATUM | DATS | 8 | 0 | Last Day of Visiting Studies | ||
32 | DISCIPLINE | PIQSMDISZIP | PIQSMDISZIP | CHAR | 16 | 0 | Discipline | T7PIQSMDISZIP | |
33 | EXCH_STATUS | PIQEXCSTATUS | PIQEXCSTATUS | CHAR | 4 | 0 | External Admission Status | T7PIQEXCSTATUS | |
34 | EXCH_CHOICE | PIQEXCCHOICE | NUMC2 | NUMC | 2 | 0 | Visiting Studies Choice | T7PIQEXCCHOICE | |
35 | HOMEDEGRTYPE | PIQEXCHOMEDEGRTPE | PIQQUAL_LEVEL | CHAR | 4 | 0 | Degree Type of Home University | T7PIQQUAL_LEVEL | |
36 | STUDCATEGORY | PIQEXCSTCAT | PIQEXCSTCAT | CHAR | 4 | 0 | Visiting Student Category | T7PIQEXCSTCAT | |
37 | ADDINFO | PIQEXC_INFO | TEXT40 | CHAR | 40 | 0 | Additional Information |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HRP1714 | DISCIPLINE | T7PIQSMDISZIP | DISZIP | REF | 1 | CN |
2 | HRP1714 | EXCH_CHOICE | T7PIQEXCCHOICE | CHOICE | REF | 1 | CN |
3 | HRP1714 | EXCH_STATUS | T7PIQEXCSTATUS | EXCSTATUS | REF | 1 | CN |
4 | HRP1714 | FROM_SESSION | T7PIQTREXTSES | SESSIONID | REF | 1 | CN |
5 | HRP1714 | HOMEDEGRTYPE | T7PIQQUAL_LEVEL | QUAL_LEVEL | REF | 1 | CN |
6 | HRP1714 | INFTY | T778T | INFTY | KEY | 1 | CN |
7 | HRP1714 | ISTAT | T778S | ISTAT | KEY | 1 | CN |
8 | HRP1714 | MANDT | T000 | MANDT | KEY | 1 | CN |
9 | HRP1714 | OBJID | PLOGI | OBJID | KEY | 1 | CN |
10 | HRP1714 | OTYPE | T778O | OTYPE | KEY | 1 | CN |
11 | HRP1714 | PLVAR | T778P | PLVAR | KEY | 1 | CN |
12 | HRP1714 | STUDCATEGORY | T7PIQEXCSTCAT | CATEGORY | REF | 1 | CN |
13 | HRP1714 | TO_SESSION | T7PIQTREXTSES | SESSIONID | REF | 1 | CN |
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in | 600 |