SAP ABAP Table PIQTRCOURSE (External Subject Data)
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 | PIQTRCOURSE | Table Relationship Diagram |
Short Description | External Subject Data |
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 | COURSEID | PIQTRCOURSEID | HROBJID | NUMC | 8 | 0 | Registered Subject | * | |
2 | EXTGRADE | PIQTREXTGRADE | CHAR | 10 | 0 | Original Grade in External Subject | |||
3 | EXTGRADENORM | PIQTREXTGRADENORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Original Grade per Subject (Standard Value) | ||
4 | EXTGRADESCALE | PIQTREXTGRADESCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for Original Grade | T7PIQSCALE | |
5 | GRADEMANFLAG | PIQTRGRADEMANFLAG | CHAR | 1 | 0 | Overwrite Converted Original Grade of External Subject | |||
6 | INTGRADE | PIQTRINTGRADE | CHAR | 10 | 0 | Original Grade in External Subject on Internal Grading Scale | |||
7 | INTGRADENORM | PIQTRINTGRADENORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Converted Grade per Subject (Standard Value) | ||
8 | INTGRADESCALE | PIQTRINTGRADESCALE | PIQSCALE_ID | CHAR | 4 | 0 | Internal Grading Scale for Converted Grade per Subject | T7PIQSCALE | |
9 | COREPEATFLAG | PIQTRCOREPEATFLAG | CHAR | 1 | 0 | Indicator: Repeated Subject | |||
10 | HONORSINDIC | PIQTRHONORSINDIC | CHAR | 1 | 0 | Indicator: Honors Subject | |||
11 | EXTCOATMCRED | PIQTREXTCOATMCRED | PIQCP | QUAN | 10 | 5 | Attempted Credits in External Subject | ||
12 | EXTCOGRDCRED | PIQTREXTCOGRDCRED | PIQCP | QUAN | 10 | 5 | Graded Credits in External Subject | ||
13 | EXTCOERNCRED | PIQTREXTCOERNCRED | PIQCP | QUAN | 10 | 5 | Earned Credits in External Subject | ||
14 | EXTCOCREDTYPE | PIQTREXTCOCREDTYPE | MEINS | UNIT | 3 | 0 | Original Credit Type of External Subject | T7PIQCP | |
15 | COCREDMANFLAG | PIQTRCOCREDMANFLAG | CHAR | 1 | 0 | Overwrite Converted Credits Per External Subject Manually | |||
16 | INTCOATMCRED | PIQTRINTCOATMCRED | PIQCP | QUAN | 10 | 5 | Attempted Credits in Ext. Subject in Internal Credit Type | ||
17 | INTCOGRDCRED | PIQTRINTCOGRDCRED | PIQCP | QUAN | 10 | 5 | Graded Credits in Ext. Subject in Internal Credit Type | ||
18 | INTCOERNCRED | PIQTRINTCOERNCRED | PIQCP | QUAN | 10 | 5 | Earned Credits in Ext. Subject in Internal Credit Type | ||
19 | INTCOCREDTYPE | PIQTRINTCOCREDTYPE | MEINS | UNIT | 3 | 0 | Internal Credit Type | T7PIQCP | |
20 | BASFORCOCRED | PIQTRBASFORCOCRED | PIQTRBASFORCRED | CHAR | 4 | 0 | Basis for Accomplished Credits | T7PIQTRBASFORCP | |
21 | COREFLAG | PIQTRCOREFLAG | CHAR | 1 | 0 | Indicator for Core Subject | |||
22 | COWITHDRDATE | PIQTRCOWITHDRDATE | DATS | 8 | 0 | Date of Withdrawal | |||
23 | COSESID | PIQTRCOSESID | PIQTRSESSIONID | CHAR | 4 | 0 | Session In Which External Subject Was Taken | T7PIQTREXTSES | |
24 | COSESYEAR | PIQTRCOSESYEAR | PIQTRSESSIONYEAR | NUMC | 4 | 0 | Year In Which Subject Was Taken | ||
25 | COBEGDATE | PIQTRCOBEGDATE | DATS | 8 | 0 | Start Date of Subject | |||
26 | COENDDATE | PIQTRCOENDDATE | DATS | 8 | 0 | End Date of Subject |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PIQTRCOURSE | BASFORCOCRED | T7PIQTRBASFORCP | BASISFORCP | KEY | 1 | CN |
2 | PIQTRCOURSE | COSESID | T7PIQTREXTSES | SESSIONID | KEY | 1 | CN |
3 | PIQTRCOURSE | EXTCOCREDTYPE | T7PIQCP | CPUNIT | KEY | 1 | CN |
4 | PIQTRCOURSE | EXTGRADESCALE | T7PIQSCALE | SCALEID | KEY | 1 | CN |
5 | PIQTRCOURSE | INTCOCREDTYPE | T7PIQCP | CPUNIT | KEY | 1 | CN |
6 | PIQTRCOURSE | INTGRADESCALE | T7PIQSCALE | SCALEID | KEY | 1 | CN |
History
Last changed by/on | SAP | 20050224 |
SAP Release Created in | 463 |