PiqCds_AcdmcEventBookingData

DDL: PIQCDS_ACDMCEVENTBOOKINGDATA SQL: PIQCDSACDMCEVTBK Type: view
51 Fields 3 Data Sources

Academic Event Booking Data

PiqCds_AcdmcEventBookingData is a CDS View that provides data about "Academic Event Booking Data" in SAP S/4HANA. It reads from 3 data sources (hrp1000, PiqCds_ModuleBkgOffers, PiqCds_AcademicEventData) and exposes 51 fields.

Data Sources (3)

SourceAliasJoin Type
hrp1000 event1 inner
PiqCds_ModuleBkgOffers ModOffers inner
PiqCds_AcademicEventData PiqCds_AcademicEventData inner

Parameters (2)

NameTypeDefault
p_date abap.dats
p_lang abap.lang

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PIQCDSACDMCEVTBK view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Academic Event Booking Data view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view

Fields (51)

KeyFieldSource TableSource FieldDescription
AcademicEvent event ObjectID Object Value
StudentObjectID hrp1000 objid Work Center
StudentNumber hrp1000 short Shortened form
StudentName hrp1000 stext Text
ModuleBookingID PiqCds_ModuleBkgOffers ModuleBookingID WorklistID
AcademicEventName event2 AcademicEventName Text
AcademicEventShortName event2 AcademicEventShortName Shortened form
AcademicEventInstructor event2 AcademicEventInstructor Instructor (ID)
AcademicEventInstructorName event2 AcademicEventInstructorName
AcademicEventInstructorType event2 AcademicEventInstructorType Instructor Type
AcdmcEventInstructorTypeName event2 AcdmcEventInstructorTypeName Object type
AcademicEventIsDeleted event2 AcademicEventIsDeleted Scheduling
AcademicEventIsExternal event2 AcademicEventIsExternal External event
AcademicEventIsLocked event2 AcademicEventIsLocked Lock flag
AcademicEventLanguage event2 AcademicEventLanguage Primary lang.
AcademicEventLocation event2 AcademicEventLocation
AcademicEventLocationName event2 AcademicEventLocationName
AcademicEventLocationShortName event2 AcademicEventLocationShortName
AcademicEventPackage event2 AcademicEventPackage Event Package
AcademicEventPackageName event2 AcademicEventPackageName
AcademicEventPackageShortName event2 AcademicEventPackageShortName
AcademicEventRoom event2 AcademicEventRoom Room
AcademicEventRoomName event2 AcademicEventRoomName Text
AcademicEventRoomShortName event2 AcademicEventRoomShortName Shortened form
AcademicEventStartDate event2 AcademicEventStartDate Valid From
AcademicEventStartTime event2 AcademicEventStartTime Start time
AcademucEventEndDate event2 AcademucEventEndDate Valid To
AcadelicEventEndTime event2 AcadelicEventEndTime End time
AcademicEventType event2 AcademicEventType
AcademicEventTypeName event2 AcademicEventTypeName Text
AcademicEventTypeShortName event2 AcademicEventTypeShortName Shortened form
AcademicEventTypeCategory event2 AcademicEventTypeCategory
AcademicEventTypeCategoryName event2 AcademicEventTypeCategoryName
AcademicSession event2 AcademicSession Period ID
AcademicSessionName event2 AcademicSessionName
AcademicYear event2 AcademicYear Acad. Year
AcademicYearName event2 AcademicYearName
AcdmcEventTypeDeliveryMode event2 AcdmcEventTypeDeliveryMode
AcdmcEventTypeDeliveryModeName event2 AcdmcEventTypeDeliveryModeName
AcdmcEvtCancellationReason event2 AcdmcEvtCancellationReason Reason canceled
AcdmcEvtCancellationReasonName event2 AcdmcEvtCancellationReasonName Reason canceled
AcdmcEvtTypeAppraisalType event2 AcdmcEvtTypeAppraisalType
AcdmcEvtTypeAppraisalTypeName event2 AcdmcEvtTypeAppraisalTypeName
AcdmcEvtTypeTeachingMethod event2 AcdmcEvtTypeTeachingMethod
AcdmcEvtTypeTeachingMethodName event2 AcdmcEvtTypeTeachingMethodName
IsEvTypeAttendanceCompulsory event2 IsEvTypeAttendanceCompulsory Att. Compulsory
NumberOfTotalBookings event2 NumberOfTotalBookings Normal bookings
StudyModule event2 StudyModule Object Value
StudyModuleName event2 StudyModuleName
StudyModuleShortName event2 StudyModuleShortName
RelationshipSubtype event RelationshipSubtype

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

CREATE VIEW PiqCds_AcdmcEventBookingData AS
SELECT
  event.ObjectID AS AcademicEvent,
  event1.objid AS StudentObjectID,
  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.AcademicEventIsDeleted AS AcademicEventIsDeleted,
  event2.AcademicEventIsExternal AS AcademicEventIsExternal,
  event2.AcademicEventIsLocked AS AcademicEventIsLocked,
  event2.AcademicEventLanguage AS AcademicEventLanguage,
  event2.AcademicEventLocation AS AcademicEventLocation,
  event2.AcademicEventLocationName AS AcademicEventLocationName,
  event2.AcademicEventLocationShortName AS AcademicEventLocationShortName,
  event2.AcademicEventPackage AS AcademicEventPackage,
  event2.AcademicEventPackageName AS AcademicEventPackageName,
  event2.AcademicEventPackageShortName AS AcademicEventPackageShortName,
  event2.AcademicEventRoom AS AcademicEventRoom,
  event2.AcademicEventRoomName AS AcademicEventRoomName,
  event2.AcademicEventRoomShortName AS AcademicEventRoomShortName,
  event2.AcademicEventStartDate AS AcademicEventStartDate,
  event2.AcademicEventStartTime AS AcademicEventStartTime,
  event2.AcademucEventEndDate AS AcademucEventEndDate,
  event2.AcadelicEventEndTime AS AcadelicEventEndTime,
  event2.AcademicEventType AS AcademicEventType,
  event2.AcademicEventTypeName AS AcademicEventTypeName,
  event2.AcademicEventTypeShortName AS AcademicEventTypeShortName,
  event2.AcademicEventTypeCategory AS AcademicEventTypeCategory,
  event2.AcademicEventTypeCategoryName AS AcademicEventTypeCategoryName,
  event2.AcademicSession AS AcademicSession,
  event2.AcademicSessionName AS AcademicSessionName,
  event2.AcademicYear AS AcademicYear,
  event2.AcademicYearName AS AcademicYearName,
  event2.AcdmcEventTypeDeliveryMode AS AcdmcEventTypeDeliveryMode,
  event2.AcdmcEventTypeDeliveryModeName AS AcdmcEventTypeDeliveryModeName,
  event2.AcdmcEvtCancellationReason AS AcdmcEvtCancellationReason,
  event2.AcdmcEvtCancellationReasonName AS AcdmcEvtCancellationReasonName,
  event2.AcdmcEvtTypeAppraisalType AS AcdmcEvtTypeAppraisalType,
  event2.AcdmcEvtTypeAppraisalTypeName AS AcdmcEvtTypeAppraisalTypeName,
  event2.AcdmcEvtTypeTeachingMethod AS AcdmcEvtTypeTeachingMethod,
  event2.AcdmcEvtTypeTeachingMethodName AS AcdmcEvtTypeTeachingMethodName,
  event2.IsEvTypeAttendanceCompulsory AS IsEvTypeAttendanceCompulsory,
  event2.NumberOfTotalBookings AS NumberOfTotalBookings,
  event2.StudyModule AS StudyModule,
  event2.StudyModuleName AS StudyModuleName,
  event2.StudyModuleShortName AS StudyModuleShortName,
  event.RelationshipSubtype AS RelationshipSubtype
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 */
;

Learn More