SAP ABAP Table PIQQUALINTERNAL (Work Area for Internal Qualifications)
Hierarchy
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   IS-HER-CM-AD (Application Component) Administration
     PMIQ (Package) Campus Management
Basic Data
Table Category INTTAB    Structure 
Structure PIQQUALINTERNAL   Table Relationship Diagram
Short Description Work Area for Internal Qualifications    
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 .INCLUDE       0   0   Key Structure for Infotype Structures PNNNN  
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 OBJEKTID NUM08 NUMC 8   0   Object ID  
6 INFTY INFOTYP INFOTYP CHAR 4   0   Infotype T778T
7 SUBTY SUBTYP SUBTYP CHAR 4   0   Subtype T778U
8 ISTAT ISTAT_D ISTAT CHAR 1   0   Planning Status T778S
9 PRIOX PRIOX CHAR2 CHAR 2   0   Priority  
10 BEGDA BEGDATUM DATUM DATS 8   0   Start Date  
11 ENDDA ENDDATUM DATUM DATS 8   0   End Date  
12 VARYF VARYF CHAR10 CHAR 10   0   Variation Field for File PLOG  
13 SEQNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
14 .INCLUDE       0   0   Additional Data for Relationship "Fulfills Qualification"  
15 CPGAINED PIQCONFERQ_CPGAINEDOBS PIQCP QUAN 10   5   CM: OBSOLET  
16 CPUNIT PIQCONFERQ_CPUNITOBS MEINS UNIT 3   0   CM: OBSOLET T006
17 NORM_VAL PIQCONFERQ_NORMVALOBS PIQSCALE_NORM_VAL DEC 8   2   CM: OBSOLET  
18 CQRATING PIQCONFERQ_CQRATINGOBS PIQSMRATING CHAR 3   0   CM: OBSOLET T7PIQSMRATING
19 TRANSFERFLAG PIQTRANSFER PIQTRANSFER CHAR 1   0   External Academic Work or Qualification Transferred  
20 SM_OBJID PIQCONFERQ_SMOBS HROBJID NUMC 8   0   CM: OBSOLET *
21 .INCLUDE       0   0    
22 .INCLUDE       0   0   Objects Referenced for Qualification Conferment  
23 REFOBJ_OTYPE OTYPE OTYPE CHAR 2   0   Object Type *
24 REFOBJ_REALO SOBID CHAR45 CHAR 45   0   ID of Related Object  
25 PERIDFORCQ PIQCONFERQ_PERIDFORCQ PIQPERCT NUMC 3   0   Duration of Study Required to Achieve Qualification  
26 PERIDFORCQUNIT PIQCONFERQ_PERIDFORCQUNIT PIQCONFERQ_PERIDFORCQUNIT CHAR 1   0   Unit for Number of Periods  
27 PERID PIQPERID PIQPERID NUMC 3   0   Academic Session *
28 PERYR PIQPERYR PIQPERYR NUMC 4   0   Academic Year *
29 ID PIQAGRID SYSUUID_C CHAR 32   0   Appraisal ID  
30 COBOK PIQPEPE_COBOK PIQPEPE_COBOK CHAR 1   0   Conditional Booking  
31 STAGE PIQLEVEL PIQLEVEL NUMC 2   0   Stage T7PIQLEVEL
32 REFPROC_GUIDTYPE PIQCONFERQ_REFPROC_GUIDTYPE PIQGUIDTYPE CHAR 4   0   Reference to a Process *
33 REFPROC_GUID PIQCONFERQ_REFPROC_GUID SYSUUID_C CHAR 32   0   Process Identification (ID)  
34 ACADHONOR_SYM PIQCONFERQ_ACADHONOR_GRADESYM PIQGRADESYM CHAR 10   0   Academic Honors  
35 ACADHONOR_GRADE PIQCONFERQ_ACADHONOR_GRADE PIQSCALE_NORM_VAL DEC 8   2   Academic Honors: Standard Value  
36 ACADHONOR_SCALE PIQCONFERQ_ACADHONOR_SCALE PIQSCALE_ID CHAR 4   0   Academic Honors Scale T7PIQSCALE
37 NOT_COMPLETED PIQCONFERQ_NOTCOMPL PIQCONFERQ_NOTCOMPL CHAR 1   0   Qualification Was Not Achieved  
38 DIPLOMANAME PIQCONFERQ_DIPLOMANAME TEXT80 CHAR 80   0   Diploma Name  
39 FINALW_ID PIQCONFERQ_FINALW_ID SYSUUID_C CHAR 32   0   Module Booking ID of Individual Work  
40 FINALW_TITLE PIQCONFERQ_FINALWTITLE TEXT100 CHAR 100   0   Title of Qualifying Work  
41 FINALW_LANGU PIQCONFERQ_FINALWLANGU SPRAS LANG 1   0   Original Language T002
42 FINALW_TITLEALT PIQCONFERQ_FINALWTITLEALT TEXT100 CHAR 100   0   Title of Qualifying Work in Other Language  
43 FINALW_LANGUALT PIQCONFERQ_FINALWLANGUALT SPRAS LANG 1   0   Other Language T002
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PIQQUALINTERNAL ACADHONOR_SCALE T7PIQSCALE SCALEID    
2 PIQQUALINTERNAL CPUNIT T006 MSEHI    
3 PIQQUALINTERNAL CQRATING T7PIQSMRATING SMRATING    
4 PIQQUALINTERNAL FINALW_LANGU T002 SPRAS    
5 PIQQUALINTERNAL FINALW_LANGUALT T002 SPRAS    
6 PIQQUALINTERNAL INFTY T778T INFTY    
7 PIQQUALINTERNAL ISTAT T778S ISTAT    
8 PIQQUALINTERNAL MANDT T000 MANDT    
9 PIQQUALINTERNAL OTYPE T778O OTYPE    
10 PIQQUALINTERNAL PLVAR T778P PLVAR    
11 PIQQUALINTERNAL STAGE T7PIQLEVEL ACLEVEL    
12 PIQQUALINTERNAL SUBTY T778U SUBTY    
History
Last changed by/on SAP  20050705 
SAP Release Created in 463