R_TransportationOrderTP

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 R_TransportationOrderTP.
-- 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.

CREATE VIEW R_TransportationOrderTP AS
SELECT
  TransportationOrderUUID,
  TransportationOrder,
  TransportationOrderType,
  TransportationOrderCategory,
  TranspOrdShippingType AS TransportationShippingType,
  MovementType,
  TransportationMode,
  TransportationModeCategory,
  CarrierUUID,
  Carrier,
  CarrierAddressID,
  StandardCarrierAlphaCode,
  TranspOrdExecutingCarrierUUID,
  TranspOrdExecutingCarrier,
  ExecutingCarrierAddressID,
  ShipperUUID,
  Shipper,
  ShipperAddressID,
  ConsigneeUUID,
  Consignee,
  ConsigneeAddressID,
  PurchasingOrganization AS TranspPurgOrg,
  PurchasingOrgExternalID AS TranspPurgOrgExtID,
  PurchasingGroup AS TranspPurgGroup,
  PurchasingGroupExternalID AS TranspPurgGroupExtID,
  PurgOrgCompanyCode,
  PlngAndExecOrganization,
  PlngAndExecGroup,
  TransOrdAcctNmbrWthExectgCarr AS CarrierAccountNumber,
  MeansOfTransport AS TranspMeansOfTransport,
  TranspOrdPartnerReference,
  MasterBillOfLading,
  TranspOrdResponsiblePerson,
  TranspOrdHasMltplExectgPties,
  TranspOrdInvoicingCarrierLevel,
  TranspOrdLifeCycleStatus,
  TranspOrderSubcontrgSts,
  TransportationOrderConfSts,
  TransportationOrderExecSts,
  TranspOrdGoodsMovementStatus,
  TranspOrdWhseProcessingStatus,
  TranspOrderDngrsGdsSts,
  TranspOrdPlanningBlock,
  TranspOrdExecutionIsBlocked,
  TransportationOrderCrtnType,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedDateTime
FROM I_TransportationOrder
LEFT OUTER JOIN R_TrOrdMainBPAddrDfltRprstnTP AS _CarrierAddrDfltRprstn ON TransportationOrderUUID = _CarrierAddrDfltRprstn.TransportationOrderUUID AND _CarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U3'  -- association [0..1]
LEFT OUTER JOIN R_TrOrdMainBPAddrDfltRprstnTP AS _ShipperAddrDfltRprstn ON TransportationOrderUUID = _ShipperAddrDfltRprstn.TransportationOrderUUID AND _ShipperAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U6'  -- association [0..1]
LEFT OUTER JOIN R_TrOrdMainBPAddrDfltRprstnTP AS _ConsigneeAddrDfltRprstn ON TransportationOrderUUID = _ConsigneeAddrDfltRprstn.TransportationOrderUUID AND _ConsigneeAddrDfltRprstn.TranspOrdBizPartnerFunction = 'WE'  -- association [0..1]
LEFT OUTER JOIN R_TrOrdMainBPAddrDfltRprstnTP AS _ExectgCarrierAddrDfltRprstn ON TransportationOrderUUID = _ExectgCarrierAddrDfltRprstn.TransportationOrderUUID AND _ExectgCarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'TJ'  -- association [0..1]
LEFT OUTER JOIN E_TransportationOrder AS _Extension ON TransportationOrderUUID = _Extension.TransportationOrderUUID  -- association [1]
LEFT OUTER JOIN R_TransportationOrderBPTP AS _TransportationOrderBP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_TranspOrdDocRefTP AS _TranspOrdDocumentReference ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_TransportationOrderItemTP AS _TransportationOrderItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_TransportationOrderStopTP AS _TransportationOrderStop ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_TransportationOrderEventTP AS _TransportationOrderEvent ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_TrOrdMainBPAddrDfltRprstnTP AS _TrOrdMainBPAddrDfltRprstn ON /* condition not available in parsed metadata */  -- association [0..3]
LEFT OUTER JOIN R_TransportationOrderNoteTP AS _TransportationOrderNote ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_TransportationOrderChargeTP AS _TransportationOrderCharge ON /* condition not available in parsed metadata */  -- association [0..1]
;