SAP Campus Management Tables
Are you looking for the right table related to SAP Campus Management Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Campus Management (IS-HER-CM) module.
Top 10 tables in Campus Management
| Table | Description |
|---|---|
| T7PIQADH_CATEG | Decision: Decision Category |
| GFDDBINDX | Cluster Table for Generic Form Designer |
| T7PIQ_DE_SUBGRPT | Text Table for Subject Grouping |
| T7PIQAD_S0TYPET | Course Offering Type Description |
| T7PIQAD_QTA_B | Assign Decision Basis Type to Quota |
| PIQDBPPFAD | Decision IDs and Persistant GUID |
| T7PIQAD_H_C_REL | Decision: Decision Component Assignment |
| PIQDBAD_RPD | Admission: Ranking Position Document Header |
| PIQDBATEVENTSST | Class Attendance Maintenance Status |
| PIQAUD_AW_CNGVAL | Setting input table for allowed academic work used in Audit |
List of tables in Campus Management
| Table | Description |
|---|---|
| T7PIQADH_CATEG | Decision: Decision Category |
| GFDDBINDX | Cluster Table for Generic Form Designer |
| T7PIQ_DE_SUBGRPT | Text Table for Subject Grouping |
| T7PIQAD_S0TYPET | Course Offering Type Description |
| T7PIQAD_QTA_B | Assign Decision Basis Type to Quota |
| PIQDBPPFAD | Decision IDs and Persistant GUID |
| T7PIQAD_H_C_REL | Decision: Decision Component Assignment |
| PIQDBAD_RPD | Admission: Ranking Position Document Header |
| PIQDBATEVENTSST | Class Attendance Maintenance Status |
| PIQAUD_AW_CNGVAL | Setting input table for allowed academic work used in Audit |
| T7PIQADP_TYPE | Admission Procedure Type |
| GFDDBCUSTCONT_RT | OBSOLETE:store runtime result of questionaire custom field |
| PIQPROC_AD_STAT | Admission Activity Docs: Status Log |
| HRP5230 | DB Table for Infotype 5230 |
| PIQDB_DE_OTHGRD | Graduation from other programs of study |
| T7PIQAD_QTAT | Quota Text Table |
| PIQMOD_MP_SM_VAR | Mass Module Booking Module Variant Table |
| GFDDB_SRV_VAL | Value Table for service property name |
| T7PIQADI_TYPE | Decision: Decision Item Type |
| T7PIQAD_SCHEM | Allocation Scheme |
| T7PIQAD_SPGRPT | Study Package Group Text |
| PIQ_ACTIONS_VAL | Check table for actions in admission portal |
| PIQPROC_ADM_DT | Activity Document: Admission Detailed Data |
| PIQDBADM_SWITCH | Switch table for admission configuration |
| GFD_DBCONFIG_TXT | Text Table for GFDDBCONFIGRATON |
| PIQ_STU_UNIV_URL | Table to maintain the University URL for My Personal Details |
| PIQMOD_MP_ST_VAR | Module Booking Mass Process Student variant Table |
| PIQDB_DE_TRD | Target Degree for Transcripts |
| PIQDBADM_REUSE_D | Table to store the reusable form details in the applications |
| GFD_FILE_MAP | OBSOLETE:File mapping b/w form &customer file system |
| HRPAD552 | Additional Data for PAD500 |
| T7PIQADMCODECHG | Admission Code and Status Mapping |
| T7PIQISHCAT1 | Internships Category 1 |
| T7PIQATABSRSN | CM: Absence Reasons |
| HRP1789 | DB Table for Infotype 1789 |
| T7PIQCA_ACCESS | Access Types for Business Abstraction Layer |
| PIQ_ACTI_VAL_TXT | Text table for action description |
| T7PIQHS_PROGSET | Set Holds and Cust. Status in Program Type Progression |
| PIQDBADM_CONFIG | Admission portal details like logo, terms & conditions |
| PIQDBATPREEX | Pre Excused Absences |
| PIQSUBGROUP_MAP | Mapping of Subgroup Type to the Grouping Object |
| HRP1729 | DB Table for Infotype 1729 |
| T7PIQCORRFEE | Define Behaviour of Student Correspondence Requests |
| T7PIQCA_ACCESST | Access Types for Business Abstraction Layer |
| T7PIQBW_DELTA | BW Extraction: Map Infotype <-> BW Data Source |
| T7PIQADH_SUBCATT | Decision: Text table for Decision Category Type |
| PIQDB_DE_OTHREG | Registration at other universities and in previous semester |
| T7PIQCA_BAL_DES | Destination for Business Abstraction Layer |
| GFD_DOM_CONFIG | Domain configuration |
| T7PIQCA_BAL_CONT | Destination for Business Abstraction Layer |
| HRP1723 | DB Table for Infotype 1723 |
| T7PIQ_DE_DRGRSN | Value Table for De-registration |
| T7PIQ_DE_MTDEGRE | Target Degree |
| T7PIQATCALCRULET | Calculation Rule Text |
| T7PIQ_DE_DRGRSNT | Text Table for De-registration |
| T7PIQ_DE_EXPTYPT | Type of Professional Experience Outside Germany |
| PIQDB_DE_SXSTATD | Student and Exam Statistics Detail Table |
| PIQDBAD_C | Admission: Decision Component |
| PIQDB_DE_STATHDR | Header Table for Statistical Reporting Germany |
| PIQDBATATT | CM: Class Attendance |
| T7PIQ_DE_ITRTYP | Type of Study Interruptions |
| PIQDBAD_PROC | Admission Procedure |
| T7PIQAGR_MC_PROT | Appraisal Mass Change Processing Type Description |
| T7PIQCONFPAR | Parameters per Configuration |
| T7PIQADH_SUBCAT | Decision: Decision Sub Category |
| T7PIQAD_SCHEMQTA | Map Quota to Allocation Scheme |
| T7PIQ_DE_MOBPRGT | Mobility Program |
| HRT1768 | Table Part Infotype 1768 |
| T7PIQCA_BADICONF | BAL Access Type for BAdI |
| T7PIQ_DE_FULLPAT | Full Time/Part Time/Dual Study Text Table |
| T7PIQADHTYPE_ISR | Map an ISR Scenario to a Decision Type |
| T7PIQYEAR_FORTX | Define academic years used by transactions |
| PIQDBAGR_ADDATTR | Appraisal - Add Attributes |
| PIQDBAD_H | Admission: Decision Header |
| T7PIQCA_BADI_CUS | BAL Acess Type for BAdI |
| T7PIQ_DE_GLSUBD | Value Table for Guest Listeners Subject Direction Fachricht. |
| PIQDBAD_LINK | Admission: Object Linkage (obsolete. do not use) |
| T7PIQADMCODE | Maintaining Admission Codes |
| T7PIQHICONT | Branch Office & Contact Data For Studends HI |
| GFDDB_CONFIG_MAP | GFD Configuration Mapping |
| T7PIQ_DE_GSUBCDT | Text Table for Subject Code (Government Level) |
| T7PIQBW_DATASOUR | BW Extraction: Map DataSource with FM for Delta Queue |
| T7PIQCORRSENDCON | Table for sendcontrol |
| GFDDB_FORM_MD | Table to store form metadata for generic form builder |
| T7PIQAGR_MC_PROC | Mass Adjustment of Grades: Processing Type |
| T7PIQHI | Health Insurance Companies for Students |
| T7PIQ_DE_MOBPRG | Mobility Program |
| T7PIQAD_SPGRP | Study Package Group |
| PIQ_ACTVITY_LIST | Activities (Text Table) |
| HRP5901 | DB Table for Infotype 5901 |
| T7PIQ_DE_MTCNTPC | Mapping Table County to Postal Code |
| PIQ_HLD_OTYP_TAB | Hold Otype Table |
| PIQDB_DE_REPREG | Registration in the reporting semester |
| GFDDB_INT_CONF | DB table to maintain the configuration for Intermediate page |
| T7PIQ_DE_EXPTYP | Type of Professional Experience Outside Germany |
| T7PIQ_DE_GLSUBDT | Text Table for Guest Listeners Subject Direction Fachrichtun |
| T7PIQ_REQTAB_VAL | Check table for association names for tabs in request app |
| T7PIQAD_H_B_REL | Decision: Decision Basis Type Assignment |
| PIQ_HEALTH_TAB | Table to set health insurance tab |
| T7PIQHI_FUNDTYP | Health Insurance Fund Type |
| T7PIQCA_BADI_DES | Logical Destination for Business Abstraction Layer |
| HRT1727 | Table Part Infotype 1727 |
| T7PIQ_DE_MTGRAD | Mapping table for Graduation Exam Results |
| PIQDB_DE_REPGRD | Graduation in the reporting semester |
| T7PIQADH_CAT_SUB | Decision: Assign sub category to decision category |
| T7PIQADB_TYPET | Admission: Decision Basis Element |
| T7PIQ_DE_SUBAR | Subject Area |
| T7PIQ_DE_PHDTYPT | Post Graduate Doctoral Study Type |
| T7PIQADH_TYPET | Decision: Text table for Decision Header Type |
| T7PIQAGR_BLGRD_R | Blind Grade Number Range Validity |
| T7PIQHI_FUNDTYPT | Health Insurance Fund Type |
| T7PIQ_DE_GSUBCD | Subject Code (Government Level) |
| T7PIQCONF_VALUE | Configuration Type Activation |
| PIQDB_DE_AGR_CP | earned credits for exams accomplished since last stat report |
| T7PIQ_DE_HEI | Higher Education Institutions |
| PIQDB_STBOOK | Module Booking Details of Student |
| PIQSUBGROUP_CAP | Module and Event Package Subgroup Capacity Declaration |
| PIQDBAD_RL_H | Admission: Ranking List Header |
| T7PIQCONF | Configuration Types |
| T7PIQ_REQ | Configuration for different context id and requests |
| T7PIQWDDIALOGT | Text Table for Student Dialog Settings |
| T7PIQDEGSUBT | Text Table for Subject Areas of Degree Programs |
| T7PIQATABSRSNT | Absence Reason Text Table |
| GFDDB_CONTENT | GFD Content Table |
| PIQDB_DE_GLSTATD | Guest Listener Statistics Detail Table |
| PIQILM_STBLOCK | SLCM : Table for Blocked Data Lookup |
| T7PIQADC_TYPE | Decision: Decision Component Type |
| T7PIQADH_CATEGT | Decision: Text table for Decision Category Type |
| T7PIQAPPEXT | Applications |
| T7PIQ_DE_DEGREE | Degree |
| T7PIQAPP | Student Self Service Adobe Applications |
| T7PIQISHCAT4 | Internships Category 4 |
| T7PIQ_DE_THESIST | Doctoral Thesis |
| T7PIQ_REQ_TXT | Text table for applications name for request app |
| T7PIQCA_BAL_CONF | Destination for Business Abstraction Layer |
| T7PIQOIFVIEWT | OIF View Description |
| PIQDBAD_I | Admission: Decision Item |
| T7PIQRQPRFVWASSN | Assignment of Requirement Profile View to Req. Element |
| PIQ_ACVTY_TIME | Duration to find the list of activities |
| T7PIQ_DE_UEQ | Value Table for UEQ |
| T7PIQ_DE_SUB2SUB | Mapping Subject State Level to Subject Government Level |
| PIQDBCOREQ_COND | Table for Corequisite booking check conditions |
| T7PIQ_DE_GSUBART | Subject Area |
| T7PIQ_DE_HEIT | Higher Education Institutions Text |
| PIQDB_DE_TRS | Specialization for Trnascripts |
| T7PIQADH_TYPE | Decision: Decision Header Type (System Table) |
| T7PIQ_DE_MTEXPER | Mapping table for Academic Periods |
| PIQ_ACTVTY_LIST | Activities (Text Table) |
| T7PIQPROCPOST | Text Table for Process Types |
| T7PIQISHCAT1T | Internships Category 1 Texts |
| T7PIQCONFT | Configuration Type texts |
| PIQDB_DE_QRSTATD | Quick Report Detail Table |
| T7PIQISHCAT2 | Internships Category 2 |
| PIQDBAD_RPD_DTL | Admission: Ranking Position Document Details |
| PIQDB_DE_DRSTATD | Doctoral Student Statistics Detail Table |
| PIQDB_STACAD | Student Acad Work : Program Admission and Registration |
| T7PIQ_DE_UEQT | Text Table for UEQ |
| T7PIQISHCAT2T | Internships Category 2 Texts |
| T7PIQAD_H_I_REL | Decision: Decision Item Type Assignment |
| T7PIQ_DE_AR2SGRP | Mapping Subject Area to Subject Grouping |
| T7PIQMODGRPSPEC | Assignm. of External Module Group Categories to Internal |
| T7PIQ_DE_PRTTYPT | Part Time Study Type |
| T7PIQAD_H_PROC | Decision: Allowed Activities per Decision Type |
| T7PIQNOTETYPEADV | Advisory notes |
| T7PIQDEGSUB | Degrees for Programs |
| PIQDBAD_B | Decision: Decision Basis |
| T7PIQADC_TYPET | Decision: Text table for Decision Component Type |
| T7PIQ_DE_COUNTY | Value Table for Counties |
| T7PIQAD_OTYPE | Admission Object Type |
| T7PIQ_DE_EXPDURT | Duration of Professional Experience outside Germany |
| T7PIQDEGREET | Text Table for Degree Types for Programs |
| PIQDBAD_SP_H | Admission: Study Package Header |
| PIQDBAD_TEXT | Admission Processing General Text |
| PIQAUD_AW_CHANGE | Setting for Allowed changes of Academic Work used in Audits |
| T7PIQAD_SCHEMT | Allocation Scheme text |
| PIQ_SET_HLTH_TAB | Table to set health tab |
| T7PIQ_DE_MTDREG | Mapping Table for De-registration |
| T7PIQ_DE_MTPERID | Mapping table for Academic Periods |
| PIQSUBGROUP_DEF | Booking Sub-Group Definition |
| T7PIQ_DE_SUB2AR | Mapping Subject Government Level to Subject Area |
| T7PIQMGREGISTR | Define Positions of Registrars |
| HRP1797 | DB Table for Infotype 1797 |
| PIQDBAD_I_DTL | Admission: Decision Item Details |
| T7PIQSINGLEFEEST | Define Attributes for Single Fees (Text) |
| T7PIQDEGREESUB | Degree Type/Subject Area Assignments |
| PIQDBSUBREQ_GRP | Audits: Sub Requirement and Group Information |
| T7PIQREQPRFVIEW | T7PIQREQPRFVIEW |
| T7PIQAD_S0TYPE | Course Offering Type |
| T7PIQISHCAT3 | Internships Category 3 |
| T7PIQAD_OTYPET | Admission: Object Type Text |
| T7PIQAD_ISR_UPD | Activities for manual update of ISR |
| T7PIQ_DE_PARTRSN | Part Time Study Reason |
| T7PIQISHCAT5 | Internships Category 5 |
| T7PIQ_DE_THESIS | Doctoral Thesis |
| T7PIQ_DE_HI | Health Insurance Type |
| T7PIQOPTS | Definition of Database Optimizations |
| PIQ_ACVTY_DATES | Table for Activity dates |
| T7PIQPROCPOS | Process Types |
| T7PIQREQPRFVIEWT | T7PIQREQPRFVIEWT |
| T7PIQOPTC | Activation of Database Optimizations |
| T7PIQ_TAB_NOTES | Notes for different tabs |
| T7PIQ_DE_SUBCD | Subject Code (State/HEI Level) |
| T7PIQISHSTATUST | Texttbale for Statuses for internship registration |
| T7PIQWDDIALOG | Web Dynpro Dialog |
| T7PIQ_REQ_TABS | Tabs to be shown for each context |
| T7PIQ_DE_SUBGRP | Subject Grouping |
| PIQDBADM_MIN_SUB | To have a link between mini subm id & form subm id |
| T7PIQ_DE_COUNTYT | Text Table for Counties |
| T7PIQADP_TYPET | Admission Procedure Type Text Table |
| PIQ_STATUS_VAL | Check table for status in admission portal |
| T7PIQISHCAT4T | Internships Category 4 Texts |
| T7PIQ_DE_LOARSNT | Text Table for Leave of Absence |
| T7PIQOIFIBLOCKT | IBlock Description |
| PIQPROC_AD_REF | Admission Activity Docs: Reference Object |
| T7PIQAD_QTA | Quota |
| T7PIQ_DE_ITRTYPT | Type of Study Interuption Description |
| T7PIQOIFIBLOCK | iBlock(Information Block) for OIF |
| T7PIQDEGREE | No Longer Used: Degree Types for Programs |
| PIQDBADM_ALWD_AC | To maintain the allowed actions for given status & contextID |
| PIQDBAD_D | Decision: Decision Dates |
| T7PIQADI_TYPET | Decision: Text table for Decision Item Type |
| T7PIQATCALCRULE | Calculation Rule |
| T7PIQISHCAT3T | Internships Category 3 Texts |
| T7PIQISHSTATUS | Statuses for internship registrations |
| T7PIQ_DE_PRTTYP | Part Time Study Percentage |
| T7PIQ_DE_EXPDUR | Duration of Professional Experience outside Germany |
| T7PIQADH_TYPE_C | Decision: Decision Header Type (customizing table) |
| PIQDBAD_RL_I | Admission: Ranking List Item |
| PIQDB_DE_TRH | Transcript Header |
| T7PIQ_DE_PHDTYP | Post Graduate Doctoral Study Type |
| T7PIQ_DE_FULLPAR | Full Time/Part Time/Dual Study |
| T7PIQMGALRTGRP | Alert Group Definition |
| T7PIQMGALRTCAT | CM: Define Alert Group Categories for Alert Groups |
| T7PIQADHTYPE_CAT | Valid Decision Category for Decision Type |
| T7PIQSINGLEFEES | Define Attributes for Individual Fees |
| T7PIQ_DE_SUBCDT | Text Table for Subject Code (State/HEI Level) |
| T7PIQ_DE_MTENR | Mapping table for Student Registration Category |
| T7PIQSTBPIDSYN | BP Student Identification number synchronization |
| PIQ_STAT_VAL_TXT | Text Table for Status |
| PIQDBATNOTE | Attendance Note |
| T7PIQ_DE_MTLOA | Mapping Table for Leave of Absence |
| GFDDB_SRV_VL_TXT | Text table for GFDDB_SRV_VAL |
| T7PIQAD_PPF_ICON | Icons for PPF Actions |
| GFDDBDOCUCONT_RT | OBSOLETE:store runtime result of questionaire document field |
| HRP1768 | DB Table for Infotype 1768 |
| T7PIQADB_TYPE | Decision Framework: Decision Basis Type |
| PIQDBADM_CONFIGT | Text table for PIQDBADM_CONFIG |
| T7PIQWDDIAL_VIEW | Assigned OIF Views to WebDypro Dialog |
| T7PIQOIFVIEW | OIF View |
| T7PIQAD_H_D_REL | Decision: Decision Date Type Assignment |
| T7PIQWDDIALOG_C | Web Dynpro Dialog Subject to Privacy Rules |
| PIQDBAD_RL_I_DTL | Admission: Ranking List Item Details |
| HRP1727 | DB Table for Infotype 1727 |
| PIQDBAD_SP_I | Admission: Study Package Item |
| T7PIQ_DE_SUBART | Text Table for Subject Area |
| T7PIQVIEW_IBLOCK | Assigned iBlocks to OIF View |
| T7PIQOPTST | Text Table for Database Optimizations |
| T7PIQ_DE_DEGREET | Degree Text |
| PIQDBCORRREQUEST | Transcript Requests |
| PIQDBATEVENTST | CM: Attendance Maintenance Status |
| HRP1798 | DB Table for Infotype 1798 |
| T7PIQ_DE_LOARSN | Value Table for Leave of Absence |
| GFDDB_INT_CONF_T | Text Table for Intermediate page |
| GFDDBCONFIGRATON | Configuration Generic Form Designer |
| T7PIQ_DE_MTEMPL | Employment in the University |
| GFDDB_LANGUAGE | GFDDB_LANGUAGE |
| HRT1789 | Table Part Infotype 1789 |
| T7PIQ_REQTAB_TXT | Text table for T7PIQ_REQ_TABS |
| T7PIQMGALRTGRPT | CM: Alert Group Text Definition |
| GFDBDMS_CONTENT | Temporary table to store documents of DMS |
| PIQDBADM_ALW_TXT | Text Table for PIQDBADM_ALWD_AC |
| T7PIQISHCAT5T | Internships Category 5 Texts |
| PIQDBCOPIEDOBJ | Copied Objects of Report Program RHIQ_COPY_ROLL_FORWARD |