I_AcademicEventBooking

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_AcademicEventBooking.
-- 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: IACADEVENTBKNG
-- Parameters: P_KeyDate : sydate, P_Language : sylangu

CREATE VIEW I_AcademicEventBooking AS
SELECT
  event1.short AS StudentNumber,
  event1.stext AS StudentName,
  ModOffers.ModuleBookingID AS ModuleBookingID,
  event2.AcademicEventName AS AcademicEventName,
  event2.AcademicEventShortName AS AcademicEventShortName,
  event2.AcademicEventInstructor AS AcademicEventInstructor,
  event2.AcademicEventInstructorName AS AcademicEventInstructorName,
  event2.AcademicEventInstructorType AS AcademicEventInstructorType,
  event2.AcdmcEventInstructorTypeName AS AcdmcEventInstructorTypeName,
  event2.AcademicEventTypeCategory AS AcademicEventTypeCategory,
  event2.AcademicEventTypeCategoryName AS AcademicEventTypeCategoryName,
  event2.StudyModule AS StudyModule,
  event2.StudyModuleName AS StudyModuleName,
  event2.StudyModuleShortName AS StudyModuleShortName,
  1 AS NumberOfStudents
INNER JOIN hrp1000 AS event1 ON /* join condition not captured in parsed metadata */
INNER JOIN PiqCds_AcademicEventData ON /* join condition not captured in parsed metadata */
INNER JOIN PiqCds_ModuleBkgOffers AS ModOffers ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AcademicEvent AS _InstructorFullName ON AcademicEventInstructor = _InstructorFullName.AcademicEventInstructor  -- association [0..1]
;