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
  _TransportationOrder.TransportationOrderUUID AS TransportationOrderUUID,
  _TransportationOrder.TransportationOrder AS TransportationOrder,
  _TransportationOrder.TransportationOrderType AS TransportationOrderType,
  _TransportationOrder.TransportationOrderCategory AS TransportationOrderCategory,
  _TransportationOrder.TransportationShippingType AS TransportationShippingType,
  _TransportationOrder.MovementType AS MovementType,
  _TransportationOrder.TransportationMode AS TransportationMode,
  _TransportationOrder.TransportationModeCategory AS TransportationModeCategory,
  _TransportationOrder.CarrierUUID AS CarrierUUID,
  _TransportationOrder.Carrier AS Carrier,
  _TransportationOrder.CarrierAddressID AS CarrierAddressID,
  _TransportationOrder.StandardCarrierAlphaCode AS StandardCarrierAlphaCode,
  _TransportationOrder.TranspOrdExecutingCarrierUUID AS TranspOrdExecutingCarrierUUID,
  _TransportationOrder.TranspOrdExecutingCarrier AS TranspOrdExecutingCarrier,
  _TransportationOrder.ExecutingCarrierAddressID AS ExecutingCarrierAddressID,
  _TransportationOrder.ShipperUUID AS ShipperUUID,
  _TransportationOrder.Shipper AS Shipper,
  _TransportationOrder.ShipperAddressID AS ShipperAddressID,
  _TransportationOrder.ConsigneeUUID AS ConsigneeUUID,
  _TransportationOrder.Consignee AS Consignee,
  _TransportationOrder.ConsigneeAddressID AS ConsigneeAddressID,
  cast( '00000000' as /scmtms/purch_org_id preserving type ) AS TranspPurgOrg,
  cast( '00000000' as /scmtms/purch_grp_id preserving type ) AS TranspPurgGroup,
  cast( _TransportationOrder.TranspPurgOrg as /scmtms/vdm_pur_org_ext_id) AS TranspPurgOrgExtID,
  cast( _TransportationOrder.TranspPurgGroup as /scmtms/vdm_pur_grp_ext_id) AS TranspPurgGroupExtID,
  _TransportationOrder.PurgOrgCompanyCode AS PurgOrgCompanyCode,
  _TransportationOrder.CarrierAccountNumber AS CarrierAccountNumber,
  _TransportationOrder.TranspMeansOfTransport AS TranspMeansOfTransport,
  _TransportationOrder.TranspOrdPartnerReference AS TranspOrdPartnerReference,
  _TransportationOrder.MasterBillOfLading AS MasterBillOfLading,
  _TransportationOrder.TranspOrdResponsiblePerson AS TranspOrdResponsiblePerson,
  _TransportationOrder.TranspOrdHasMltplExectgPties AS TranspOrdHasMltplExectgPties,
  _TransportationOrder.TranspOrdInvoicingCarrierLevel AS TranspOrdInvoicingCarrierLevel,
  _TransportationOrder.TranspOrdOrderDateTime AS TranspOrdOrderDateTime,
  _TransportationOrder.TranspOrdLifeCycleStatus AS TranspOrdLifeCycleStatus,
  _TransportationOrder.TranspOrderSubcontrgSts AS TranspOrderSubcontrgSts,
  _TransportationOrder.TransportationOrderConfSts AS TransportationOrderConfSts,
  _TransportationOrder.TransportationOrderExecSts AS TransportationOrderExecSts,
  _TransportationOrder.TranspOrdGoodsMovementStatus AS TranspOrdGoodsMovementStatus,
  _TransportationOrder.TranspOrdWhseProcessingStatus AS TranspOrdWhseProcessingStatus,
  _TransportationOrder.TranspOrderDngrsGdsSts AS TranspOrderDngrsGdsSts,
  _TransportationOrder.TranspOrdPlanningBlock AS TranspOrdPlanningBlock,
  _TransportationOrder.TranspOrdExecutionIsBlocked AS TranspOrdExecutionIsBlocked,
  _TransportationOrder.TranspOrdPlanningStatus AS TranspOrdPlanningStatus,
  _TransportationOrder.TransportationOrderCrtnType AS TransportationOrderCrtnType,
  _TransportationOrder.CreatedByUser AS CreatedByUser,
  _TransportationOrder.CreationDateTime AS CreationDateTime,
  _TransportationOrder.LastChangedByUser AS LastChangedByUser,
  _TransportationOrder.ChangedDateTime AS ChangedDateTime,
  _TransportationOrder._Carrier AS _Carrier,
  _TransportationOrder._Consignee AS _Consignee,
  _TransportationOrder._CreatedBy AS _CreatedBy,
  _TransportationOrder._LastChangedBy AS _LastChangedBy,
  _TransportationOrder._MeansOfTransport AS _MeansOfTransport,
  _TransportationOrder._MovementType AS _MovementType,
  _TransportationOrder._PurchasingCompanyCode AS _PurchasingCompanyCode,
  _TransportationOrder._Shipper AS _Shipper,
  _TransportationOrder._TranspOrdConfirmationStatus AS _TranspOrdConfirmationStatus,
  _TransportationOrder._TranspOrdExecutionIsBlocked AS _TranspOrdExecutionIsBlocked,
  _TransportationOrder._TranspOrdLifeCycleStatus AS _TranspOrdLifeCycleStatus,
  _TransportationOrder._TranspOrdPlanningBlock AS _TranspOrdPlanningBlock,
  _TransportationOrder._TranspOrdPlanningStatus AS _TranspOrdPlanningStatus,
  _TransportationOrder._TranspOrdResponsiblePerson AS _TranspOrdResponsiblePerson,
  _TransportationOrder._TranspOrdShippingType AS _TranspOrdShippingType,
  _TransportationOrder._TranspOrdSubcontractingSts AS _TranspOrdSubcontractingSts,
  _TransportationOrder._TransportationMode AS _TransportationMode,
  _TransportationOrder._TransportationModeCategory AS _TransportationModeCategory,
  _TransportationOrder._TransportationOrderCategory AS _TransportationOrderCategory,
  _TransportationOrder._TransportationOrderExecSts AS _TransportationOrderExecSts,
  _TransportationOrder._TransportationOrderType AS _TransportationOrderType,
  _TransportationOrder._TranspSCACCode AS _TranspSCACCode,
  _TransportationOrder._TranspOrdDngrsGdsStatus AS _TranspOrdDngrsGdsStatus
FROM I_TransportationOrder_2 AS _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 R_TransportationOrderStopTP AS _SourceStop ON TransportationOrderUUID = _SourceStop.TransportationOrderUUID AND _SourceStop.TranspOrdStopSequencePosition = 'F'  -- association [0..1]
LEFT OUTER JOIN R_TransportationOrderStopTP AS _DestinationStop ON TransportationOrderUUID = _DestinationStop.TransportationOrderUUID AND _DestinationStop.TranspOrdStopSequencePosition = 'L'  -- association [0..1]
LEFT OUTER JOIN R_TransportationOrderItemTP AS _TransportationOrderMainItem ON TransportationOrderUUID = _TransportationOrderMainItem.TransportationOrderUUID AND _TransportationOrderMainItem.TranspOrdItemParentItemUUID = abap.raw'00000000000000000000000000000000'  -- 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..*]
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]
;