C_TicketHeadTP

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_TicketHeadTP.
-- 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: CTICKETHEADTP

CREATE VIEW C_TicketHeadTP AS
SELECT
  NominationTicketKey,
  NominationTicketVersion,
  NominationTicketPurpose,
  TicketExternalNumber,
  TicketStatusColorCode,
  NominationTicketStatus,
  NominationTicketStatusCode,
  NominationTicketType,
  NominationDoc,
  TransportSystem,
  TransportationPlanningPoint,
  NominationExtNumber,
  TicketCreationDate,
  TicketCreatedByUser,
  TicketChangedDate,
  TicketChangedByUser,
  TicketApprovalStatus,
  NominationCarrier,
  ConsigneePartner,
  NominationInspector,
  NominationShipper,
  TicketSupplier,
  Trader,
  TicketActualizeMode,
  TicketCorrectionMode,
  TicketReverseMode,
  TicketCorruptMode,
  TicketActionMode,
  NominationDocIsBlocked,
  NominationTicketIsBlocked
FROM I_TicketHeadTP AS _TicketHeadTP
LEFT OUTER JOIN C_TicketItemTP AS _TicketItemTP ON NominationTicketKey = _TicketItemTP.NominationTicketKey AND NominationTicketVersion = _TicketItemTP.NominationTicketVersion  -- association [0..*]
LEFT OUTER JOIN C_TicketKeyVH AS _TicketKeyVH ON NominationTicketKey = _TicketKeyVH.NominationTicketKey  -- association [1..*]
LEFT OUTER JOIN C_TicketKeyVH AS _TicketExternalNumberVH ON TicketExternalNumber = _TicketExternalNumberVH.TicketExternalNumber  -- association [1..*]
LEFT OUTER JOIN C_TicketPurposeVH AS _TicketPurposeVH ON NominationTicketPurpose = _TicketPurposeVH.NominationTicketPurpose  -- association [1..1]
LEFT OUTER JOIN C_TicketTypeVH AS _TicketTypeVH ON NominationTicketType = _TicketTypeVH.NominationTicketType  -- association [0..1]
LEFT OUTER JOIN C_TicketStatusVH AS _TicketStatusVH ON NominationTicketStatus = _TicketStatusVH.NominationTicketStatus  -- association [0..1]
LEFT OUTER JOIN C_TicketTranspPlanPtVH AS _TicketTranspPlanPtVH ON TransportationPlanningPoint = _TicketTranspPlanPtVH.TransportationPlanningPoint  -- association [0..1]
LEFT OUTER JOIN C_NominationTransptSystVH AS _NominationTransptSystVH ON TransportSystem = _NominationTransptSystVH.TransportSystem  -- association [0..1]
LEFT OUTER JOIN C_NominationKeyVH AS _NominationKeyVH ON NominationDoc = _NominationKeyVH.NominationDoc  -- association [0..*]
LEFT OUTER JOIN C_NominationKeyVH AS _NominationExtNumberVH ON NominationExtNumber = _NominationExtNumberVH.NominationExtNumber  -- association [0..*]
LEFT OUTER JOIN C_TicketCreatedByVH AS _TicketCreatedByVH ON TicketCreatedByUser = _TicketCreatedByVH.UserID  -- association [0..1]
LEFT OUTER JOIN C_TicketChangedByVH AS _TicketChangedByVH ON TicketChangedByUser = _TicketChangedByVH.UserID  -- association [0..1]
LEFT OUTER JOIN C_TicketApprovalStatusVH AS _TicketApprovalStatusVH ON TicketApprovalStatus = _TicketApprovalStatusVH.TicketApprovalStatus  -- association [0..1]
LEFT OUTER JOIN C_TicketCarrierVH AS _TicketCarrierVH ON NominationCarrier = _TicketCarrierVH.NominationCarrier  -- association [0..1]
LEFT OUTER JOIN C_TicketShipperVH AS _TicketShipperVH ON NominationShipper = _TicketShipperVH.NominationShipper  -- association [0..1]
LEFT OUTER JOIN C_TicketSupplierVH AS _TicketSupplierVH ON TicketSupplier = _TicketSupplierVH.TicketSupplier  -- association [0..1]
LEFT OUTER JOIN C_TicketConsigneeVH AS _TicketConsigneeVH ON ConsigneePartner = _TicketConsigneeVH.ConsigneePartner  -- association [0..*]
LEFT OUTER JOIN C_TicketInspectorVH AS _TicketInspectorVH ON NominationInspector = _TicketInspectorVH.NominationInspector  -- association [0..*]
LEFT OUTER JOIN C_TicketTraderVH AS _TicketTraderVH ON Trader = _TicketTraderVH.Trader  -- association [0..*]
LEFT OUTER JOIN E_NominationTicketHead AS _TicketHeaderExtension ON NominationTicketKey = _TicketHeaderExtension.NominationTicketKey AND NominationTicketVersion = _TicketHeaderExtension.NominationTicketVersion AND NominationTicketPurpose = _TicketHeaderExtension.NominationTicketPurpose  -- association [1..1]
;