PiqCds_ProgressionData

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 PiqCds_ProgressionData.
-- 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: PIQCDSPRGRSSN
-- Parameters: p_date : abap.dats, p_lang : abap.lang

CREATE VIEW PiqCds_ProgressionData AS
SELECT
  prog1.plvar AS ActivePlanVersion,
  prog1.objid AS StudentObjectId,
  hrp.stext AS StudentName,
  hrp.short AS StudentNumber,
  _ProgramType.ProgramOfStudyType AS ProgramOfStudyType,
  _ProgramType._ProgramTypeText[1:Language = $parameters.p_lang].ProgramOfStudyTypeName AS ProgramOfStudyTypeName,
  prog1.prog_type AS AcdmcPrgrssnCategory,
  text.ddtext AS AcdmcPrgrssnCategoryName,
  prog2.tabnr AS AcdmcProgression,
  prog2.tabseqnr AS AcdmcProgressionSequence,
  prog2.valid_from AS AcdmcPrgrssnValidFrom,
  prog2.mc_valid_to AS AcdmcPrgrssnValidTo,
  prog2.check_from AS AcdmcPrgrssnStartDate,
  prog2.check_to AS AcdmcPrgrssnEndDate,
  _AcademicPrgrssnStanding.AcdmcPrgrssnStanding AS AcdmcPrgrssnStanding,
  _AcademicPrgrssnStanding._PrgrssnStandingText[1:Language = $parameters.p_lang].AcdmcPrgrssnStandingName AS AcdmcPrgrssnStandingName,
  _AcademicPrgrssnStandingFin.AcdmcPrgrssnStandingFinAid AS AcdmcPrgrssnStandingFinAid,
  _AcademicPrgrssnStandingFin._PrgrssnStandingFinText[1:Language = $parameters.p_lang].AcdmcPrgrssnStandingFinAidName AS AcdmcPrgrssnStandingFinAidName,
  _AcademicHonors.AcademicHonors AS AcademicHonors,
  _AcademicHonors._AcademicHonorsText[1: Language = $parameters.p_lang].AcademicHonorsName AS AcademicHonorsName,
  _ProgressClassification.AcdmcPrgrsClassification AS AcdmcPrgrsClassification,
  _ProgressClassification._ProgressClassificationText[1:Language = $parameters.p_lang].AcdmcPrgrsClassificationName AS AcdmcPrgrsClassificationName,
  _ProgressClassification1.AcdmcPrgrsClassification AS AcdmcPrgrsClassfctnFinAid,
  _ProgressClassification1._ProgressClassificationText[1:Language = $parameters.p_lang].AcdmcPrgrsClassificationName AS AcdmcPrgrsClassfctnFinAidName,
  prog2.result_status AS AcdmcPrgrssnResultStatus,
  text1.ddtext AS AcdmcPrgrssnResultStatusName,
  _AcademicYear.AcademicYear AS AcademicYear,
  _AcademicYear._AcademicYearText[1:Language = $parameters.p_lang].AcademicYearName AS AcademicYearName,
  _AcademicSession.AcademicSession AS AcademicSession,
  _AcademicSession._AcademicSessionText[1:Language = $parameters.p_lang].AcademicSessionName AS AcademicSessionName
FROM hrp1737 AS prog1
INNER JOIN hrt1737 AS prog2 ON /* join condition not captured in parsed metadata */
INNER JOIN hrp1000 AS hrp ON /* join condition not captured in parsed metadata */
INNER JOIN dd07t AS text ON /* join condition not captured in parsed metadata */
INNER JOIN dd07t AS text1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PiqCdsProgramType AS _ProgramType ON _ProgramType.ProgramOfStudyType = prog1.progc_var  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcdmcPrgrsClassification AS _ProgressClassification ON _ProgressClassification.AcdmcPrgrsClassification = prog2.prcl  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcdmcPrgrsClassification AS _ProgressClassification1 ON _ProgressClassification1.AcdmcPrgrsClassification = prog2.prclfa  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcademicYear AS _AcademicYear ON _AcademicYear.AcademicYear = prog2.peryr  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcademicSession AS _AcademicSession ON _AcademicSession.AcademicSession = prog2.perid  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcdmcPrgrssnStanding AS _AcademicPrgrssnStanding ON _AcademicPrgrssnStanding.AcdmcPrgrssnStanding = prog2.acst AND _AcademicPrgrssnStanding.ProgramType = prog1.progc_var  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcdmcPrgrssnStndgFin AS _AcademicPrgrssnStandingFin ON _AcademicPrgrssnStandingFin.AcdmcPrgrssnStandingFinAid = prog2.acstfa AND _AcademicPrgrssnStandingFin.ProgramType = prog1.progc_var  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcademicHonors AS _AcademicHonors ON _AcademicHonors.AcademicHonors = prog2.award AND _AcademicHonors.ProgramType = prog1.progc_var  -- association [0..*]
;