C_NominationTicketEvent

DDL: C_NOMINATIONTICKETEVENT SQL: CNOMTKTEVENT Type: view CONSUMPTION
16 Fields 2 Data Sources

Nomination Ticket Event

C_NominationTicketEvent is a Consumption CDS View that provides data about "Nomination Ticket Event" in SAP S/4HANA. It reads from 2 data sources (I_NominationTicketDetail, I_NominationTicketEvent) and exposes 16 fields with key fields NominationDoc, NominationDocItem, NominationTicketKey, NominationTicketItem, NominationTicketVersion.

Data Sources (2)

SourceAliasJoin Type
I_NominationTicketDetail _NominationTicketDetail inner
I_NominationTicketEvent NominationTicketEvent from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CNOMTKTEVENT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Nomination Ticket Event view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc I_NominationTicketEvent NominationDoc Nomination key
KEY NominationDocItem I_NominationTicketEvent NominationDocItem Nom. key item
KEY NominationTicketKey I_NominationTicketEvent NominationTicketKey
KEY NominationTicketItem I_NominationTicketEvent NominationTicketItem
KEY NominationTicketVersion I_NominationTicketEvent NominationTicketVersion
KEY NominationTicketEventNumber NominationTicketEventNumber
NominationTicketPurpose I_NominationTicketEvent NominationTicketPurpose
NominationTicketEventType NominationTicketEventType
NominationTicketEventTypeDesc NominationTicketEventTypeDesc
NominationTicketEventSqncNmbr NominationTicketEventSqncNmbr
NominationTicketEvtStrtDteTme NominationTicketEvtStrtDteTme
NominationTicketEvtEndDteTme NominationTicketEvtEndDteTme
NominationTicketEventLongText NominationTicketEventLongText
TicketIsHeaderEvent TicketIsHeaderEvent
NominationDocIsBlocked I_NominationTicketDetail NominationDocIsBlocked
_NominationTicketDetail _NominationTicketDetail

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 C_NominationTicketEvent.
-- 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: CNOMTKTEVENT

CREATE VIEW C_NominationTicketEvent AS
SELECT
  NominationTicketEvent.NominationDoc AS NominationDoc,
  NominationTicketEvent.NominationDocItem AS NominationDocItem,
  NominationTicketEvent.NominationTicketKey AS NominationTicketKey,
  NominationTicketEvent.NominationTicketItem AS NominationTicketItem,
  NominationTicketEvent.NominationTicketVersion AS NominationTicketVersion,
  NominationTicketEventNumber,
  NominationTicketEvent.NominationTicketPurpose AS NominationTicketPurpose,
  NominationTicketEventType,
  NominationTicketEventTypeDesc,
  NominationTicketEventSqncNmbr,
  NominationTicketEvtStrtDteTme,
  NominationTicketEvtEndDteTme,
  NominationTicketEventLongText,
  TicketIsHeaderEvent,
  _NominationTicketDetail.NominationDocIsBlocked AS NominationDocIsBlocked
FROM I_NominationTicketEvent AS NominationTicketEvent
INNER JOIN I_NominationTicketDetail AS _NominationTicketDetail ON /* join condition not captured in parsed metadata */
;

Learn More