C_TicketDocFlow

DDL: C_TICKETDOCFLOW SQL: CTKTDOCFLW Type: view CONSUMPTION
16 Fields 2 Data Sources

Ticket Document Flow

C_TicketDocFlow is a Consumption CDS View that provides data about "Ticket Document Flow" in SAP S/4HANA. It reads from 2 data sources (I_TicketDocFlow, I_TicketItemTP) and exposes 16 fields with key fields NominationTicketKey, NominationTicketItem, NominationTicketVersion, NominationTicketPurpose, TicketSequenceNumber.

Data Sources (2)

SourceAliasJoin Type
I_TicketDocFlow _DocumentFlowRelationshipType from
I_TicketItemTP _NumberOfAllItems left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CTKTDOCFLW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Ticket Document Flow view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY NominationTicketKey I_TicketDocFlow NominationTicketKey Ticket key
KEY NominationTicketItem I_TicketDocFlow NominationTicketItem Single-Character Flag
KEY NominationTicketVersion I_TicketDocFlow NominationTicketVersion Ticket version
KEY NominationTicketPurpose I_TicketDocFlow NominationTicketPurpose Ticket Purpose
KEY TicketSequenceNumber TicketSequenceNumber Sequence
NominationDoc I_TicketItemTP NominationDoc Nomination key
NominationDocItem I_TicketItemTP NominationDocItem Nom. key item
MaterialMovementType MaterialMovementType Movement Scenario
NominationReferenceDocument NominationReferenceDocument Reference Document Number
DocumentCategoryText DocumentCategoryText DocFlow Document Text
TicketDocumentStatus TicketDocumentStatus DocFlow Document Text
SDDocumentCategoryName SDDocumentCategoryName TSW Det.Doc typ
NominationDocIsBlocked I_TicketDocFlow NominationDocIsBlocked
NominationTicketIsBlocked I_TicketDocFlow NominationTicketIsBlocked Flag to Select Tkt
NominationTicketType I_TicketDocFlow NominationTicketType Ticket type
MaterialDocumentYear MaterialDocumentYear Material Document Year

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_TicketDocFlow.
-- 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: CTKTDOCFLW

CREATE VIEW C_TicketDocFlow AS
SELECT
  _DocumentFlowRelationshipType.NominationTicketKey AS NominationTicketKey,
  _DocumentFlowRelationshipType.NominationTicketItem AS NominationTicketItem,
  _DocumentFlowRelationshipType.NominationTicketVersion AS NominationTicketVersion,
  _DocumentFlowRelationshipType.NominationTicketPurpose AS NominationTicketPurpose,
  TicketSequenceNumber,
  _NumberOfAllItems.NominationDoc AS NominationDoc,
  _NumberOfAllItems.NominationDocItem AS NominationDocItem,
  MaterialMovementType,
  NominationReferenceDocument,
  DocumentCategoryText,
  TicketDocumentStatus,
  SDDocumentCategoryName,
  _DocumentFlowRelationshipType.NominationDocIsBlocked AS NominationDocIsBlocked,
  _DocumentFlowRelationshipType.NominationTicketIsBlocked AS NominationTicketIsBlocked,
  _DocumentFlowRelationshipType.NominationTicketType AS NominationTicketType,
  MaterialDocumentYear
FROM I_TicketDocFlow AS _DocumentFlowRelationshipType
LEFT OUTER JOIN I_TicketItemTP AS _NumberOfAllItems ON /* join condition not captured in parsed metadata */
;

Learn More