- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
PIQDB_DE_SXSTATD
Student and Exam Statistics Detail Table
|
#transactional
|
Component: Campus Management
- 🔑 Keys (3)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates
- ☰ Categorical (10)
- Other (62)
- 🔗 Relations (1)
| Column Name | Description | |
|---|---|---|
| MANDT | Client | |
| RUNID | Run Identifier | |
| ST_OBJID | Object ID of Student |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| REP_PERID | Statistical Reporting Period | Show values |
| REGISTRATION_TYPE | Registration Type | Show values |
| FIRST_PERID | Statistical Reporting Period | Show values |
| GDRSEM_STUDTYP | Study Type | Show values |
| PREPSEM | Number of Semesters at a Preparatory College | Show values |
| PREVSEM1_HEI_IND | Higher Education Institution in Previous Semester | Show values |
| PREVSEM1_PRG_IND | Program of Study in Previous Semester | Show values |
| WORK_QUAL | Work Experience with Qualification | Show values |
| WORK_STUDY | Work Experience with Qualification for Current Study | Show values |
| ERROR | Error Occurred | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| STUDENT | Student Number | PIQSTUDENT12 | |
| CS_OBJID_RD1 | Study Object for Registered or Deregistered Student | HROBJID | |
| CS_OBJID_RD2 | Study Object for Registered or Deregistered Student | HROBJID | |
| CS_OBJID_G1 | Study Object for Graduation | HROBJID | |
| CS_OBJID_G2 | Study Object for Graduation | HROBJID | |
| REP_REGIO | Region | CHAR2 | |
| REP_YEAR | Statistical Reporting Year | PIQ_DE_PERYR | |
| HEI | Higher Education Institution | PIQ_DE_HEI | |
| RECNUM | Record Number | ||
| STUDENTNO | Student Number | PIQSTUDENT12 | |
| BIRTH_MONTH | Month | NUMC2 | |
| BIRTH_YEAR | Year | NUMC4 | |
| NATIONALITY | DUEVO: Nationality | DUSTA | |
| STUDY_REGIO | Region | CHAR2 | |
| STUDY_COUNTY | County Code | COUNC | |
| STUDY_COUNTRY | DUEVO: Nationality | DUSTA | |
| HOME_REGIO | Region | CHAR2 | |
| HOME_COUNTY | County Code | COUNC | |
| HOME_COUNTRY | DUEVO: Nationality | DUSTA | |
| SUMMER_SEM_IND | Summer Semester | CHAR2 | |
| STALA_14 | Available for State Statistical Agency Use | CHAR2 | |
| STALA_15 | Available for State Statistical Agency Use | CHAR2 | |
| FIRST_HEI | First Higher Education Institute | PIQ_DE_HEI | |
| FIRST_YEAR | First Academic Year | PIQPERYR | |
| UNIVERSITY_SEM | Number of Semesters at German Universities | NUMC2 | |
| LEAVEOFABSSEM | Semesters with Leaves of Absence at German Universities | NUMC2 | |
| INTERNSHIPSEM | Number of Internship Semesters at Higher Education Institute | NUMC2 | |
| GDRSEM | Number of Study Semesters in German Democratic Republic | NUMC2 | |
| INTERRUPTSEM | Interrupted Study Semesters | NUMC2 | |
| STALA_65U2 | Available for State Statistical Agency Use | CHAR2 | |
| FRGN1_COUNTRY | DUEVO: Nationality | DUSTA | |
| FRGN1_CNT_MONTHS | Number of Months | NUMC2 | |
| BLANK_84 | Blank | CHAR1 | |
| FRGN2_COUNTRY | DUEVO: Nationality | DUSTA | |
| FRGN2_CNT_MONTHS | Number of Months | NUMC2 | |
| BLANK_87 | Blank | CHAR1 | |
| BLANK_88 | Blank | CHAR3 | |
| BLANK_89 | Blank | CHAR2 | |
| BLANK_90 | Blank | CHAR1 | |
| UEQ_YEAR | Academic Year | PIQPERYR | |
| UEQ_TYPE | University Entrance Qualification | PIQ_DE_UEQ | |
| UEQ_REGIO | Region | CHAR2 | |
| UEQ_COUNTY | County Code | COUNC | |
| UEQ_COUNTRY | DUEVO: Nationality | DUSTA | |
| BLANK_114 | Blank | CHAR1 | |
| BLANK_115 | Blank | CHAR1 | |
| BLANK_116 | Blank | CHAR2 | |
| BLANK_117 | Blank | CHAR2 | |
| BLANK_118 | Blank | CHAR1 | |
| BLANK_119 | Blank | CHAR1 | |
| BIRTH_DAY | Day | NUMC2 | |
| STUDENT_NAME | First Name of Student | TEXT4 | |
| NATIONALITY_SECOND | DUEVO: Nationality | DUSTA | |
| STALA_16 | Available for State Statistical Agency Use | CHAR2 | |
| FIRST_HEI_COUNTRY | Country/Region Code | ||
| INTERRUPT_TYPE | Type of Study Interruption | PIQ_DE_INTERRUPT_TYPE | |
| STALA_27 | Available for State Statistical Agency Use | CHAR3 | |
| STALA_120 | Available for State Statistical Agency Use | CHAR3 | |
| STALA_121 | Available for State Statistical Agency Use | CHAR2 | |
| STALA_124 | Available for State Statistical Agency Use | CHAR3 | |
| STALA_125 | Available for State Statistical Agency Use | CHAR3 | |
| CORR_RUN_TMSTP | Correction Run Timestamp | TZNTSTMPS |
| Master Data Relations | Join Conditions |
|---|---|
| Gender key | PIQDB_DE_SXSTATD.GENDER_KEY == TSAD15.GENDER |