PiqCds_Moduledata

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_Moduledata.
-- 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: PIQCDSMODBKNDATA
-- Parameters: p_idate : abap.dats, p_lang : abap.lang

CREATE VIEW PiqCds_Moduledata AS
SELECT
  O.mandt AS mandt,
  O.objid AS StudyModule,
  O.mc_short AS StudyModuleShortName,
  O.stext AS StudyModuleName,
  OT.cpmin AS StudyModuleMinCredits,
  OT.cpmax AS StudyModuleMaxCredits,
  OT.cpopt AS StudyModuleOptimumCredits,
  OP.kapz1 AS StudyModuleMinCapacity,
  OP.kapz2 AS StudyModuleOptimumCapacity,
  OP.kapz3 AS StudyModuleMaxCapacity,
  OQ.offerpattern AS StudyModuleSessionPattern,
  OS.severity AS StudyModuleAcademicLevel,
  OS.category AS StudyModuleCategory,
  OS.modrepeattype AS StudyModuleRepetitionType,
  OS.waitl_level AS StudyModuleWaitingListLevel,
  text.ddtext AS StudyModuleWaitListLevelName,
  OS.waitl_number AS StudyModuleWaitlistInPercent,
  OS.waitl_disabled AS StudyModuleWaitListIsDisabled,
  OS.mult_sec_enabled AS StudyModuleMltplSctnIsEnabled,
  O.begda AS ModuleBeginDate,
  O.endda AS ModuleEndDate,
  _RepetitionType._RepetitionTypeText[1: Language = $parameters.p_lang ].StudyModuleRepetitionTypeName AS StudyModuleRepetitionTypeName,
  _ModuleCategory._ModuleCategoryText[1:Language = $parameters.p_lang ].StudyModuleCategoryName AS StudyModuleCategoryName,
  _AcademicLevel._AcademicLevelText[1:Language = $parameters.p_lang ].StudyModuleAcademicLevelName AS StudyModuleAcademicLevelName,
  _SessionPattern._SessionPatternText[1:Language = $parameters.p_lang ].StudentSessionPatternText AS StudentSessionPatternText
LEFT OUTER JOIN hrp1741 AS OT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1024 AS OP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1746 AS OS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1751 AS OQ ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PiqCdsRepetitionType AS _RepetitionType ON _RepetitionType.MODREPEATTYPE = OS.modrepeattype  -- association [0..*]
LEFT OUTER JOIN PiqCdsModuleCategory AS _ModuleCategory ON _ModuleCategory.CATEGORY = OS.category  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcademicLevl AS _AcademicLevel ON _AcademicLevel.SEVERITY = OS.severity  -- association [0..*]
LEFT OUTER JOIN PiqCdsSessionPattern AS _SessionPattern ON _SessionPattern.offerpattern = OQ.offerpattern  -- association [0..*]
;