C_NominationMultiTickets

DDL: C_NOMINATIONMULTITICKETS SQL: CNOMMULTITKTS Type: view CONSUMPTION
19 Fields 3 Data Sources 3 Associations

List of Tickets for Nomination

C_NominationMultiTickets is a Consumption CDS View that provides data about "List of Tickets for Nomination" in SAP S/4HANA. It reads from 3 data sources (I_NominationTicketDetail, I_NominationMultiTickets, I_TicketHeaderFld) and exposes 19 fields with key fields NominationDoc, NominationDocItem, NominationTicketKey, NominationTicketItem, NominationTicketVersion. It has 3 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_NominationTicketDetail _NominationTicketDetail inner
I_NominationMultiTickets NominationMultiTickets from
I_TicketHeaderFld TicketHeader left_outer

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_NominationTicketAddlQuantity _NominationTicketAddlQuantity $projection.NominationDoc = _NominationTicketAddlQuantity.NominationDoc and $projection.NominationDocItem = _NominationTicketAddlQuantity.NominationDocItem and $projection.NominationTicketKey = _NominationTicketAddlQuantity.NominationTicketKey and $projection.NominationTicketItem = _NominationTicketAddlQuantity.NominationTicketItem and $projection.NominationTicketVersion = _NominationTicketAddlQuantity.NominationTicketVersion
[0..*] C_NominationTicketParameter _NominationTicketParameter $projection.NominationDoc = _NominationTicketParameter.NominationDoc and $projection.NominationDocItem = _NominationTicketParameter.NominationDocItem and $projection.NominationTicketKey = _NominationTicketParameter.NominationTicketKey and $projection.NominationTicketItem = _NominationTicketParameter.NominationTicketItem and $projection.NominationTicketVersion = _NominationTicketParameter.NominationTicketVersion
[0..*] C_NominationTicketEvent _NominationTicketEvent $projection.NominationDoc = _NominationTicketEvent.NominationDoc and $projection.NominationDocItem = _NominationTicketEvent.NominationDocItem and $projection.NominationTicketKey = _NominationTicketEvent.NominationTicketKey and $projection.NominationTicketVersion = _NominationTicketEvent.NominationTicketVersion

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CNOMMULTITKTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label List of Tickets for Nomination view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc I_NominationMultiTickets NominationDoc Nomination key
KEY NominationDocItem I_NominationMultiTickets NominationDocItem Nom. key item
KEY NominationTicketKey I_NominationMultiTickets NominationTicketKey Ticket key
KEY NominationTicketItem I_NominationMultiTickets NominationTicketItem
KEY NominationTicketVersion I_NominationMultiTickets NominationTicketVersion Ticket version
NominationTicketPurpose I_NominationMultiTickets NominationTicketPurpose Ticket Purpose
TicketExternalNumber TicketExternalNumber Ticket ext. no.
NominationTicketStatus I_NominationMultiTickets NominationTicketStatus Return code
NominationTicketActualQuantity I_NominationMultiTickets NominationTicketActualQuantity Scheduled Qty
NominationTicketActualQtyUoM I_NominationMultiTickets NominationTicketActualQtyUoM Unit of Measure
NominationIsClosed I_NominationMultiTickets NominationIsClosed
NominationTicketLoadStrtDteTme I_NominationMultiTickets NominationTicketLoadStrtDteTme
NominationTicketLoadEndDteTme I_NominationMultiTickets NominationTicketLoadEndDteTme
NominationTicketActlQtyUoMDesc I_NominationMultiTickets NominationTicketActlQtyUoMDesc
NominationDocIsBlocked I_NominationTicketDetail NominationDocIsBlocked
_NominationTicketAddlQuantity _NominationTicketAddlQuantity
_NominationTicketParameter _NominationTicketParameter
_NominationTicketEvent _NominationTicketEvent
_NominationTicketDetail I_NominationMultiTickets _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_NominationMultiTickets.
-- 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: CNOMMULTITKTS

CREATE VIEW C_NominationMultiTickets AS
SELECT
  NominationMultiTickets.NominationDoc AS NominationDoc,
  NominationMultiTickets.NominationDocItem AS NominationDocItem,
  NominationMultiTickets.NominationTicketKey AS NominationTicketKey,
  NominationMultiTickets.NominationTicketItem AS NominationTicketItem,
  NominationMultiTickets.NominationTicketVersion AS NominationTicketVersion,
  NominationMultiTickets.NominationTicketPurpose AS NominationTicketPurpose,
  TicketExternalNumber,
  NominationMultiTickets.NominationTicketStatus AS NominationTicketStatus,
  NominationMultiTickets.NominationTicketActualQuantity AS NominationTicketActualQuantity,
  NominationMultiTickets.NominationTicketActualQtyUoM AS NominationTicketActualQtyUoM,
  NominationMultiTickets.NominationIsClosed AS NominationIsClosed,
  NominationMultiTickets.NominationTicketLoadStrtDteTme AS NominationTicketLoadStrtDteTme,
  NominationMultiTickets.NominationTicketLoadEndDteTme AS NominationTicketLoadEndDteTme,
  NominationMultiTickets.NominationTicketActlQtyUoMDesc AS NominationTicketActlQtyUoMDesc,
  _NominationTicketDetail.NominationDocIsBlocked AS NominationDocIsBlocked,
  NominationMultiTickets._NominationTicketDetail AS _NominationTicketDetail
FROM I_NominationMultiTickets AS NominationMultiTickets
INNER JOIN I_NominationTicketDetail AS _NominationTicketDetail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TicketHeaderFld AS TicketHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_NominationTicketAddlQuantity AS _NominationTicketAddlQuantity ON NominationDoc = _NominationTicketAddlQuantity.NominationDoc AND NominationDocItem = _NominationTicketAddlQuantity.NominationDocItem AND NominationTicketKey = _NominationTicketAddlQuantity.NominationTicketKey AND NominationTicketItem = _NominationTicketAddlQuantity.NominationTicketItem AND NominationTicketVersion = _NominationTicketAddlQuantity.NominationTicketVersion  -- association [0..*]
LEFT OUTER JOIN C_NominationTicketParameter AS _NominationTicketParameter ON NominationDoc = _NominationTicketParameter.NominationDoc AND NominationDocItem = _NominationTicketParameter.NominationDocItem AND NominationTicketKey = _NominationTicketParameter.NominationTicketKey AND NominationTicketItem = _NominationTicketParameter.NominationTicketItem AND NominationTicketVersion = _NominationTicketParameter.NominationTicketVersion  -- association [0..*]
LEFT OUTER JOIN C_NominationTicketEvent AS _NominationTicketEvent ON NominationDoc = _NominationTicketEvent.NominationDoc AND NominationDocItem = _NominationTicketEvent.NominationDocItem AND NominationTicketKey = _NominationTicketEvent.NominationTicketKey AND NominationTicketVersion = _NominationTicketEvent.NominationTicketVersion  -- association [0..*]
;

Learn More