PiqCds_AcademicHoldData

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

CREATE VIEW PiqCds_AcademicHoldData AS
SELECT
  h1728.plvar AS ActivePlanVersion,
  h1728.otype AS AcademicHoldObjectType,
  h1728.objid AS AcademicHoldObject,
  h1728.subty AS AcademicHoldType,
  t777u.sutxt AS AcademicHoldTypeName,
  h1728.istat AS AcademicHoldPlanningStatus,
  t777s.stext AS AcademicHoldPlanningStatusName,
  h1728.begda AS AcademicHoldStartDate,
  h1728.endda AS AcademicHoldEndDate,
  h1728.hs_state AS AcademicHoldState,
  domtab1.ddtext AS AcademicHoldStateName,
  _AcademicActivity.AcademicActivity AS AcademicHoldActivity,
  _AcademicActivity._AcademicActivityText[1: Language = $parameters.p_lang].AcademicActivityName AS AcademicHoldActivityName,
  h1728.process_tp AS AcademicHoldCallupTimePoint,
  h1728.process_date AS AcademicHoldProcessDate,
  h1728.process_time AS AcademicHoldProcessTime,
  case h1728.otype when 'ST' then h1728.objid when 'CS' then sc_cs_st.StudentObjectId end as StudentObjectId AS StudentObjectIdendasStudentObjectId,
  case h1728.otype when 'ST' then p1000.short when 'CS' then sc_cs_st.StudentNumber end as StudentNumber AS StudentNumberendasStudentNumber,
  case h1728.otype when 'ST' then p1000.stext when 'CS' then sc_cs_st.StudentName end as StudentName AS StudentNameendasStudentName,
  case h1728.otype when 'CS' then cs_sc.ProgramOfStudy end as ProgramOfStudy AS ProgramOfStudyendasProgramOfStudy,
  _AcademicSession.AcademicSession AS AcademicSession,
  _AcademicSession._AcademicSessionText[1: Language = $parameters.p_lang].AcademicSessionName AS AcademicSessionName,
  _AcademicYear.AcademicYear AS AcademicYear,
  _AcademicYear._AcademicYearText[1: Language = $parameters.p_lang].AcademicYearName AS AcademicYearName,
  t1728.tline AS AcademicHoldReasonText,
  t7status.hs_category AS AcademicHoldStatusCategory,
  domtab2.ddtext AS AcademicHoldStatusCategoryName,
  t7groupt.hs_group AS AcademicHoldStatusGroup,
  t7groupt.hs_groupt AS AcademicHoldStatusGroupName,
  h1728.seqnr AS AcademicHoldSequenceNumber
FROM hrp1728 AS h1728
INNER JOIN hrt1728 AS t1728 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t777u ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t777s ON /* join condition not captured in parsed metadata */
INNER JOIN dd07t AS domtab1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PiqCds_StudyStudentRegn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PiqCds_StudyProgram ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1000 AS p1000 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t7piqhsstatus AS t7status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t7piqhsgroupt AS t7groupt ON /* join condition not captured in parsed metadata */
INNER JOIN dd07t AS domtab2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PiqCdsAcademicActivity AS _AcademicActivity ON _AcademicActivity.AcademicActivity = h1728.process  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcademicSession AS _AcademicSession ON _AcademicSession.AcademicSession = h1728.hs_perid  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcademicYear AS _AcademicYear ON _AcademicYear.AcademicYear = h1728.hs_peryr  -- association [0..*]
;