I_NominationTicketRecord

DDL: I_NOMINATIONTICKETRECORD SQL: INOMTKTRECD Type: view COMPOSITE
18 Fields 2 Data Sources 5 Associations

Nomination Ticket Items

I_NominationTicketRecord is a Composite CDS View that provides data about "Nomination Ticket Items" in SAP S/4HANA. It reads from 2 data sources (I_TicketItemFld, I_TicketErrorLogCheck) and exposes 18 fields with key fields NominationTicketKey, NominationTicketItem, NominationTicketVersion, NominationTicketPurpose. It has 5 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_TicketItemFld _TicketItemFld from
I_TicketErrorLogCheck TicketErrorLogCheck left_outer

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_TicketHeaderFld _TicketHeaderFld _TicketItemFld.NominationTicketKey = _TicketHeaderFld.NominationTicketKey and _TicketItemFld.NominationTicketVersion = _TicketHeaderFld.NominationTicketVersion and _TicketItemFld.NominationTicketPurpose = _TicketHeaderFld.NominationTicketPurpose
[1..1] I_NominationHeaderFld _NominationHeaderFld $projection.NominationDoc = _NominationHeaderFld.NominationDoc
[0..*] I_NominationTicketItemStsT _NominationTicketItemStsT $projection.NominationItemStatus = _NominationTicketItemStsT.NominationItemStatus
[0..*] I_NominationTicketStatusT _NominationTicketStatusT $projection.LatestTicketStatus = _NominationTicketStatusT.NominationTicketStatus
[0..1] I_TicketPurposeVH _TicketPurposeVH $projection.NominationTicketPurpose = _TicketPurposeVH.NominationTicketPurpose

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName INOMTKTRECD view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Nomination Ticket Items view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY NominationTicketKey I_TicketItemFld NominationTicketKey Ticket key
KEY NominationTicketItem I_TicketItemFld NominationTicketItem Single-Character Flag
KEY NominationTicketVersion I_TicketItemFld NominationTicketVersion Ticket version
KEY NominationTicketPurpose I_TicketItemFld NominationTicketPurpose Ticket Purpose
TicketExternalNumber _TicketHeaderFld TicketExternalNumber
NominationTicketExtNumber NominationTicketExtNumber External pos.
NominationItemStatus NominationItemStatus Workflow Status
TicketCreatedByUser TicketCreatedByUser User Name
TicketCreationDate TicketCreationDate Entered On
NominationDoc NominationDoc Nomination key
NominationDocItem NominationDocItem Nom. key item
NominationTicketIsBlocked _TicketHeaderFld NominationTicketIsBlocked
NominationDocIsBlocked _NominationHeaderFld NominationDocIsBlocked
_NominationHeaderFld _NominationHeaderFld
_TicketHeaderFld _TicketHeaderFld
_NominationTicketItemStsT _NominationTicketItemStsT
_NominationTicketStatusT _NominationTicketStatusT
_TicketPurposeVH _TicketPurposeVH

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_NominationTicketRecord.
-- 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: INOMTKTRECD

CREATE VIEW I_NominationTicketRecord AS
SELECT
  _TicketItemFld.NominationTicketKey AS NominationTicketKey,
  _TicketItemFld.NominationTicketItem AS NominationTicketItem,
  _TicketItemFld.NominationTicketVersion AS NominationTicketVersion,
  _TicketItemFld.NominationTicketPurpose AS NominationTicketPurpose,
  _TicketHeaderFld.TicketExternalNumber AS TicketExternalNumber,
  NominationTicketExtNumber,
  NominationItemStatus,
  TicketCreatedByUser,
  TicketCreationDate,
  NominationDoc,
  NominationDocItem,
  _TicketHeaderFld.NominationTicketIsBlocked AS NominationTicketIsBlocked,
  _NominationHeaderFld.NominationDocIsBlocked AS NominationDocIsBlocked
FROM I_TicketItemFld AS _TicketItemFld
LEFT OUTER JOIN I_TicketErrorLogCheck AS TicketErrorLogCheck ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TicketHeaderFld AS _TicketHeaderFld ON _TicketItemFld.NominationTicketKey = _TicketHeaderFld.NominationTicketKey AND _TicketItemFld.NominationTicketVersion = _TicketHeaderFld.NominationTicketVersion AND _TicketItemFld.NominationTicketPurpose = _TicketHeaderFld.NominationTicketPurpose  -- association [1..1]
LEFT OUTER JOIN I_NominationHeaderFld AS _NominationHeaderFld ON NominationDoc = _NominationHeaderFld.NominationDoc  -- association [1..1]
LEFT OUTER JOIN I_NominationTicketItemStsT AS _NominationTicketItemStsT ON NominationItemStatus = _NominationTicketItemStsT.NominationItemStatus  -- association [0..*]
LEFT OUTER JOIN I_NominationTicketStatusT AS _NominationTicketStatusT ON LatestTicketStatus = _NominationTicketStatusT.NominationTicketStatus  -- association [0..*]
LEFT OUTER JOIN I_TicketPurposeVH AS _TicketPurposeVH ON NominationTicketPurpose = _TicketPurposeVH.NominationTicketPurpose  -- association [0..1]
;

Learn More