I_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 I_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: ITICKETHEADTP

CREATE VIEW I_TicketHeadTP AS
SELECT
  TicketHeaderFld.NominationTicketKey AS NominationTicketKey,
  TicketHeaderFld.NominationTicketVersion AS NominationTicketVersion,
  TicketHeaderFld.NominationTicketPurpose AS NominationTicketPurpose,
  TicketHeaderFld.TicketExternalNumber AS TicketExternalNumber,
  TicketHeaderFld.NominationTicketType AS NominationTicketType,
  TicketHeaderFld.TransportSystem AS TransportSystem,
  TicketHeaderFld.NominationTicketStatus AS NominationTicketStatusCode,
  TicketHeaderFld.TransportationPlanningPoint AS TransportationPlanningPoint,
  NominationDoc,
  NominationExtNumber,
  TicketHeaderFld.TicketCreationDate AS TicketCreationDate,
  TicketHeaderFld.TicketCreatedByUser AS TicketCreatedByUser,
  TicketHeaderFld.TicketChangedDate AS TicketChangedDate,
  TicketHeaderFld.TicketChangedByUser AS TicketChangedByUser,
  TicketHeaderFld.TicketApprovalStatus AS TicketApprovalStatus,
  NominationCarrier,
  ConsigneePartner,
  NominationInspector,
  NominationShipper,
  TicketHeaderFld.TicketSupplier AS TicketSupplier,
  TicketHeaderFld.Trader AS Trader,
  cast('' as boolean preserving type ) AS TicketActualizeMode,
  cast('' as boolean preserving type ) AS TicketCorrectionMode,
  cast('' as boolean preserving type ) AS TicketReverseMode,
  cast('' as boolean preserving type ) AS TicketCorruptMode,
  cast('' as char1 preserving type ) AS TicketActionMode,
  TicketNomination.NominationDocIsBlocked AS NominationDocIsBlocked,
  TicketHeaderFld.NominationTicketIsBlocked AS NominationTicketIsBlocked
FROM I_TicketHeaderFld AS TicketHeaderFld
LEFT OUTER JOIN I_TicketNomination AS TicketNomination ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TicketErrorLogCheck AS TicketErrorLogCheck ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TicketItemTP AS _TicketItemTP ON NominationTicketKey = _TicketItemTP.NominationTicketKey AND NominationTicketVersion = _TicketItemTP.NominationTicketVersion  -- association [0..*]
LEFT OUTER JOIN I_TicketKeyVH AS _TicketKeyVH ON NominationTicketKey = _TicketKeyVH.NominationTicketKey  -- association [1..*]
LEFT OUTER JOIN I_TicketKeyVH AS _TicketExternalNumberVH ON TicketExternalNumber = _TicketExternalNumberVH.TicketExternalNumber  -- association [1..*]
LEFT OUTER JOIN I_TicketPurposeVH AS _TicketPurposeVH ON NominationTicketPurpose = _TicketPurposeVH.NominationTicketPurpose  -- association [1..1]
LEFT OUTER JOIN I_TicketTypeVH AS _TicketTypeVH ON NominationTicketType = _TicketTypeVH.NominationTicketType  -- association [0..1]
LEFT OUTER JOIN I_TicketStatusVH AS _TicketStatusVH ON NominationTicketStatus = _TicketStatusVH.NominationTicketStatus  -- association [0..1]
LEFT OUTER JOIN I_TicketTranspPlanPtVH AS _TicketTranspPlanPtVH ON TransportationPlanningPoint = _TicketTranspPlanPtVH.TransportationPlanningPoint  -- association [0..1]
LEFT OUTER JOIN I_NominationTransptSystVH AS _NominationTransptSystVH ON TransportSystem = _NominationTransptSystVH.TransportSystem  -- association [0..1]
LEFT OUTER JOIN I_NominationKeyVH AS _NominationKeyVH ON NominationDoc = _NominationKeyVH.NominationDoc  -- association [0..*]
LEFT OUTER JOIN I_NominationKeyVH AS _NominationExtNumberVH ON NominationExtNumber = _NominationExtNumberVH.NominationExtNumber  -- association [0..*]
LEFT OUTER JOIN I_TicketCreatedByVH AS _TicketCreatedByVH ON TicketCreatedByUser = _TicketCreatedByVH.UserID  -- association [0..1]
LEFT OUTER JOIN I_TicketChangedByVH AS _TicketChangedByVH ON TicketChangedByUser = _TicketChangedByVH.UserID  -- association [0..1]
LEFT OUTER JOIN I_TicketApprovalStatusVH AS _TicketApprovalStatusVH ON TicketApprovalStatus = _TicketApprovalStatusVH.TicketApprovalStatus  -- association [0..1]
LEFT OUTER JOIN I_TicketCarrierVH AS _TicketCarrierVH ON NominationCarrier = _TicketCarrierVH.NominationCarrier  -- association [0..1]
LEFT OUTER JOIN I_TicketShipperVH AS _TicketShipperVH ON NominationShipper = _TicketShipperVH.NominationShipper  -- association [0..1]
LEFT OUTER JOIN I_TicketSupplierVH AS _TicketSupplierVH ON TicketSupplier = _TicketSupplierVH.TicketSupplier  -- association [0..1]
LEFT OUTER JOIN I_TicketConsigneeVH AS _TicketConsigneeVH ON ConsigneePartner = _TicketConsigneeVH.ConsigneePartner  -- association [0..*]
LEFT OUTER JOIN I_TicketInspectorVH AS _TicketInspectorVH ON NominationInspector = _TicketInspectorVH.NominationInspector  -- association [0..*]
LEFT OUTER JOIN I_TicketTraderVH AS _TicketTraderVH ON Trader = _TicketTraderVH.Trader  -- association [0..*]
LEFT OUTER JOIN I_NominationTicketStatusT AS _NominationTicketStatusT ON NominationTicketStatus = _NominationTicketStatusT.NominationTicketStatus  -- association [0..*]
LEFT OUTER JOIN E_NominationTicketHead AS _TicketHeaderExtension ON TicketHeaderFld.NominationTicketKey = _TicketHeaderExtension.NominationTicketKey AND TicketHeaderFld.NominationTicketVersion = _TicketHeaderExtension.NominationTicketVersion AND TicketHeaderFld.NominationTicketPurpose = _TicketHeaderExtension.NominationTicketPurpose  -- association [1..1]
;