I_StudentRegistrationCube

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_StudentRegistrationCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISTUDENTREGISC
-- Parameters: P_KeyDate : sydate, P_Language : sylangu

CREATE VIEW I_StudentRegistrationCube AS
SELECT
  org.ActivePlanVersion AS ActivePlanVersion,
  org.OrganizationalUnit AS OrganizationalUnit,
  org.OrganizationalUnitShortName AS OrganizationalUnitShortName,
  org.OrganizationalUnitName AS OrganizationalUnitName,
  org.ProgramOfStudy AS ProgramOfStudy,
  org.ProgramOfStudyShortName AS ProgramOfStudyShortName,
  org.ProgramOfStudyName AS ProgramOfStudyName,
  org.ProgramOfStudyType AS ProgramOfStudyType,
  org.ProgramOfStudyTypeName AS ProgramOfStudyTypeName,
  study.StudyObject AS StudyObject,
  study.StudentObjectId AS StudentObjectId,
  study.StudentName AS StudentName,
  study.StudentNumber AS StudentNumber,
  _AcademicYear.AcademicYear AS AcademicYear,
  _AcademicYear._AcademicYearText[1:Language = $parameters.P_Language].AcademicYearName AS AcademicYearName,
  _AcademicSession.AcademicSession AS AcademicSession,
  _AcademicSession._AcademicSessionText[1:Language = $parameters.P_Language].AcademicSessionName AS AcademicSessionName,
  1 AS NumberOfStudents
INNER JOIN PiqCds_ProgramStudy ON /* join condition not captured in parsed metadata */
INNER JOIN PiqCds_StudyStudentRegn ON /* join condition not captured in parsed metadata */
INNER JOIN hrp1771 AS reg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PiqCdsAcademicYear AS _AcademicYear ON _AcademicYear.AcademicYear = reg.ayear  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcademicSession AS _AcademicSession ON _AcademicSession.AcademicSession = reg.perid  -- association [0..*]
;