PiqCds_ModuleBookingData

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

CREATE VIEW PiqCds_ModuleBookingData AS
SELECT
  OREL.begda AS ModuleBeginDate,
  OREL.endda AS ModuleEndDate,
  OREL.uname AS UserBooked,
  OREL.priox AS StudyModuleBkgWaitListPriority,
  OSM.objid AS StudyModuleObject,
  OSM.mc_short AS StudyModuleShortName,
  OSM.stext AS StudyModuleName,
  OREL.sobid AS StudentObjectID,
  OST.short AS StudentNumber,
  OST.stext AS StudentName,
  OT.smstatus AS StudyModuleBkgStatus,
  OT.storreason AS ModuleCancellationReason,
  OT.stordate AS StudyModuleBkgCanclnDate,
  OT.cpattemp AS StudyModuleAttemptedCredits,
  OT.cpgained AS StudyModuleEarnedCredits,
  OT.cpunit AS StudyModuleCreditsInUnit,
  OT.norm_val AS ScaleStandardValue,
  OT.bookdate AS StudyModuleBookingDate,
  OT.booktime AS StudyModuleBookingTime,
  OT.smrating AS StudyModuleAltvAssmtMethod,
  OT.chargefree AS StudyModuleIsFreeofCharge,
  OT.transferflag AS StudyModuleIsTransferred,
  OT.packnumber AS AcademicEventPackage,
  OT.varid AS SessionVariant,
  OT.perid AS AcademicSession,
  OT.peryr AS AcademicYear,
  OT.alt_scaleid AS AcademicScale,
  OT.alt_scaleid AS AlternateAcademicScale,
  OT.id AS ModuleBookingID,
  OT.bookreason AS StudyModuleBookingReason,
  OT.annulment AS StudyModuleBookingExclusionTyp,
  OT.lockflag AS StudyModuleChangeIsLocked,
  OT.cobok AS StudyModuleBkgIsConditional,
  _BookReason._ModuleBookingReasonText[1:Language = $parameters.p_lang ].StudyModuleBookingReasonName AS StudyModuleBookingReasonName,
  _AcademicYear._AcademicYearText[1:Language = $parameters.p_lang ].AcademicYearName AS AcademicYearName,
  _AcademicSession._AcademicSessionText[1:Language = $parameters.p_lang ].AcademicSessionName AS AcademicSessionName,
  _AcademicScale._AcademicScaleText[1:Language = $parameters.p_lang ].AcademicScaleName AS AcademicScaleName,
  _AltAsessMet._Altasessmethodtxt[1:Language = $parameters.p_lang ].StudyModuleAltvAssmtMethodName AS StudyModuleAltvAssmtMethodName,
  _Bookingcanc._CancRsnText[1:Language = $parameters.p_lang ].StudyModuleBkgCanclnReasonText AS StudyModuleBkgCanclnReasonText,
  _SessionVariant._SessionVarientText[1:Language = $parameters.p_lang ].AcademicSessionVariantName AS AcademicSessionVariantName,
  _Status._Bookingstatustxt[1:Language = $parameters.p_lang ].ModuleBookingStatusName AS ModuleBookingStatusName
LEFT OUTER JOIN hrp1000 AS OSM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1000 AS OST ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrpad506 AS OT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PiqCdsModuleBookingReason AS _BookReason ON _BookReason.BOOKREASON = OT.bookreason  -- association [0..*]
LEFT OUTER JOIN PiqCdAcademicScale AS _AcademicScale ON _AcademicScale.AcademicScale = OT.alt_scaleid  -- association [0..*]
LEFT OUTER JOIN PiqCdsSessionVariant AS _SessionVariant ON _SessionVariant.AcademicSessionVariant = OT.varid  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcademicYear AS _AcademicYear ON _AcademicYear.AcademicYear = OT.peryr  -- association [0..*]
LEFT OUTER JOIN PiqCdsAcademicSession AS _AcademicSession ON _AcademicSession.AcademicSession = OT.perid  -- association [0..*]
LEFT OUTER JOIN PiqCdsAltAssMethod AS _AltAsessMet ON _AltAsessMet.SMRATING = OT.smrating  -- association [0..*]
LEFT OUTER JOIN PiqCdsBookingCancRsn AS _Bookingcanc ON _Bookingcanc.STORREASON = OT.storreason  -- association [0..*]
LEFT OUTER JOIN PiqCdsBookingStatus AS _Status ON _Status.SMSTATUS = OT.smstatus  -- association [0..*]
;