SAP ABAP Table HRI1714 (Visiting Studies)
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 | INTTAB | Structure |
Structure | HRI1714 | Table Relationship Diagram |
Short Description | Visiting Studies |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | INST_OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
2 | INST_OBJID | HROBJID | HROBJID | NUMC | 8 | 0 | Object ID | * | |
3 | PROG_OBJID | PIQEXCSX_OBJID | HROBJID | NUMC | 8 | 0 | Exchange Program ID | * | |
4 | FROM_YEAR | PIQEXC_YEARFROM | PIQTRSESSIONYEAR | NUMC | 4 | 0 | External Academic Year in Which Visiting Studies Started | ||
5 | TO_YEAR | PIQEXC_YEARTO | PIQTRSESSIONYEAR | NUMC | 4 | 0 | External Academic Year in Which Visiting Studies Ended | ||
6 | FROM_SESSION | PIQEXC_SESSIONFROM | PIQTRSESSIONID | CHAR | 4 | 0 | External Academic Session in Which Visiting Studies Started | T7PIQTREXTSES | |
7 | TO_SESSION | PIQEXC_SESSIONTO | PIQTRSESSIONID | CHAR | 4 | 0 | External Academic Session for End of Visiting Studies | T7PIQTREXTSES | |
8 | CONTACT_OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
9 | CONTACT_OBJID | PIQEXCCONT_OBJID | CHAR45 | CHAR | 45 | 0 | University Contact Person (Business Partner Object ID) | ||
10 | APPROVE_DATE | PIQEXCAPPRDATE | DATUM | DATS | 8 | 0 | Approval Date for Visiting Studies | ||
11 | ENDOFSTAY | PIQEXCENDSTAY | DATUM | DATS | 8 | 0 | Last Day of Visiting Studies | ||
12 | DISCIPLINE | PIQSMDISZIP | PIQSMDISZIP | CHAR | 16 | 0 | Discipline | T7PIQSMDISZIP | |
13 | EXCH_STATUS | PIQEXCSTATUS | PIQEXCSTATUS | CHAR | 4 | 0 | External Admission Status | T7PIQEXCSTATUS | |
14 | EXCH_CHOICE | PIQEXCCHOICE | NUMC2 | NUMC | 2 | 0 | Visiting Studies Choice | T7PIQEXCCHOICE | |
15 | HOMEDEGRTYPE | PIQEXCHOMEDEGRTPE | PIQQUAL_LEVEL | CHAR | 4 | 0 | Degree Type of Home University | T7PIQQUAL_LEVEL | |
16 | STUDCATEGORY | PIQEXCSTCAT | PIQEXCSTCAT | CHAR | 4 | 0 | Visiting Student Category | T7PIQEXCSTCAT | |
17 | 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 | HRI1714 | DISCIPLINE | T7PIQSMDISZIP | DISZIP | REF | 1 | CN |
2 | HRI1714 | EXCH_CHOICE | T7PIQEXCCHOICE | CHOICE | REF | 1 | CN |
3 | HRI1714 | EXCH_STATUS | T7PIQEXCSTATUS | EXCSTATUS | REF | 1 | CN |
4 | HRI1714 | FROM_SESSION | T7PIQTREXTSES | SESSIONID | REF | 1 | CN |
5 | HRI1714 | HOMEDEGRTYPE | T7PIQQUAL_LEVEL | QUAL_LEVEL | REF | 1 | CN |
6 | HRI1714 | STUDCATEGORY | T7PIQEXCSTCAT | CATEGORY | REF | 1 | CN |
7 | HRI1714 | TO_SESSION | T7PIQTREXTSES | SESSIONID | REF | 1 | CN |
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in | 600 |