C_FrtOrdExecution

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_FrtOrdExecution.
-- 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 C_FrtOrdExecution AS
SELECT
  cast(TransportationOrderUUID as /scmtms/vdm_tor_db_key preserving type ) AS TransportationOrderUUID,
  TransportationOrder AS FreightOrder,
  TransportationOrderCategory,
  TransportationOrderType,
  _TransportationOrderType._Text[1:Language = $session.system_language ].TransportationOrderTypeDesc AS TransportationOrderTypeDesc,
  TranspOrdPartnerReference,
  _AvrItem.TranspOrdActvVehRscePltNmbr AS TranspOrdActvVehRscePltNmbr,
  PurchasingOrgExternalID,
  PurchasingOrganization,
  _PurchasingOrganization._OrganizationalUnitText[1:Language = $session.system_language].OrganizationalUnitName AS PurchasingOrganizationName,
  PurchasingGroupExternalID,
  PurchasingGroup,
  _PurchasingGroup._OrganizationalUnitText[1:Language = $session.system_language].OrganizationalUnitName AS PurchasingGroupName,
  _PlngAndExecOrganization.OrganizationalUnitExternalID AS PlngAndExecOrganization,
  _PlngAndExecGroup.OrganizationalUnitExternalID AS PlngAndExecGroup,
  PurgOrgCompanyCode,
  _PurchasingCompanyCode.CompanyCodeName AS PurgOrgCompanyCodeName,
  TranspOrdResponsiblePerson,
  TransportationMode,
  Carrier,
  _Carrier.BusinessPartnerFullName AS CarrierName,
  StandardCarrierAlphaCode,
  Shipper,
  Consignee,
  _SourceStop.LocationId AS SourceLocation,
  _SourceStop._Locationdescr.AddressObjectDescription AS SourceLocationLabel,
  tstmp_to_dats(_SourceStop.TranspOrdStopPlanTranspDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdDepartureDate AS clientNULLasTranspOrdDepartureDate,
  tstmp_to_tims(_SourceStop.TranspOrdStopPlanTranspDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdDepartureTime AS clientNULLasTranspOrdDepartureTime,
  cast ( _SourceStop.TranspOrdStopPlanTranspDteTme as log_created_on preserving type ) AS TranspOrdDepartureDateTime,
  _DestinationStop.LocationId AS DestinationLocation,
  _DestinationStop._Locationdescr.AddressObjectDescription AS DestinationLocationLabel,
  tstmp_to_dats( _DestinationStop.TranspOrdStopPlanTranspDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdArrivalDate AS clientNULLasTranspOrdArrivalDate,
  tstmp_to_tims(_DestinationStop.TranspOrdStopPlanTranspDteTme, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdArrivalTime AS clientNULLasTranspOrdArrivalTime,
  cast ( _DestinationStop.TranspOrdStopPlanTranspDteTme as log_created_on preserving type ) AS TranspOrdArrivalDateTime,
  TranspOrdLifeCycleStatus,
  _TranspOrdLifeCycleStatus._Text[1:Language = $session.system_language ].TranspOrdLifeCycleStatusDesc AS TranspOrdLifeCycleStatusDesc,
  TransportationOrderExecSts,
  _TransportationOrderExecSts._Text[1:Language = $session.system_language ].TransportationOrderExecStsDesc AS TransportationOrderExecStsDesc,
  _TranspChargeObject.TransportationChargesObjUUID AS TransportationChargesObjUUID,
  _TranspChargeObject.TranspChargeCalcStatus AS TranspChargeCalcStatus,
  _TranspChargeObject._TranspChargeCalcStatus._Text[1:Language = $session.system_language ].TranspChargeCalcStatusDesc AS TranspChargeCalcStatusDesc,
  _TranspChargeObject.InvoicingStatus AS InvoicingStatus,
  _TranspChargeObject._InvoicingStatus._Text[1:Language = $session.system_language ].InvoicingStatusDesc AS InvoicingStatusDesc,
  _TranspChargeObject.TranspChrgTotalAmtInDocCrcy AS TranspChrgTotalAmtInDocCrcy,
  _TranspChargeObject.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency,
  _TranspOrdSummary.TranspOrdGoodsValueAmount AS TranspOrdGoodsValueAmount,
  _TranspOrdSummary.TranspOrdGoodsValueCrcy AS TranspOrdGoodsValueCrcy,
  TranspOrdGrossWeightUnit,
  cast(TranspOrdGrossWeight as /scmtms/quantity_13_3 ) AS TranspOrdGrossWeight,
  TranspOrdGrossVolumeUnit,
  cast(TranspOrdGrossVolume as /scmtms/quantity_13_3 ) AS TranspOrdGrossVolume,
  TranspOrdQuantityUnit,
  cast(TranspOrdQuantity as /scmtms/quantity_13_3 ) AS TranspOrdQuantity,
  TranspOrdDistanceUnit AS DisplayLengthUnit,
  cast(TranspOrdDistance as /scmtms/quantity_13_3 ) AS TranspOrdDistanceInDspUnit,
  _LastReportedEvent.TranspOrdEventCode AS TranspOrdEventCode,
  _LastReportedEvent._TranspOrdEventCode._Text[1:Language = $session.system_language ].TranspOrdEventCodeDesc AS TranspOrdEventCodeDesc,
  concat( concat( cast(_DeliveryRatio.TranspOrderNmbrOfItmWthDeliv as abap.char( 100 )), '/'), cast(_DeliveryRatio.TranspOrderNmbrOfDelivRlvtItm as abap.char( 100 )) ) as TranspOrdDelivCrtnPrgrsRatio AS char100asTranspOrdDelivCrtnPrgrsRatio,
  _LastReportedCheckOutEvent.TransportationOrderEventUUID AS TranspOrdLastCheckOutUUID,
  _LastReportedCheckOutEvent.TranspOrdEvtActualDateTime AS TranspOrdEvtActualDateTime,
  _LastReportedCheckOutEvent._TransportationOrderStop._Locationdescr.AddressObjectDescription AS TranspOrdLastCheckOutLocDesc,
  _FrtCostDistrRoot.FrtCostDistrRootUUID AS FrtCostDistrRootUUID,
  _FrtCostDistrRoot.FrtCostDistrStatus AS FrtCostDistrStatus,
  _FrtCostDistrRoot._DistrStatus._Text[1: Language = $session.system_language].FrtCostDistrStatusTxt AS FrtCostDistrStatusTxt,
  _TranspChargeObject._TranspChargeCalcStatus AS _TranspChargeCalcStatus,
  _TranspChargeObject._InvoicingStatus AS _InvoicingStatus,
  _TranspChargeObject._TranspChargeDocumentCurrency AS _TranspChargeDocumentCurrency,
  _LastReportedEvent._TranspOrdEventCode AS _TranspOrdEventCode,
  _FrtCostDistrRoot._DistrStatus AS _DistrStatus
FROM I_TransportationOrder
LEFT OUTER JOIN I_TranspOrdDeliveryRatio AS _DeliveryRatio ON TransportationOrderUUID = _DeliveryRatio.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _ConsigneeParty ON Consignee = _ConsigneeParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerVH AS _ConsigneePartyVH ON Consignee = _ConsigneePartyVH.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ShipperParty ON Shipper = _ShipperParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerVH AS _ShipperPartyVH ON Shipper = _ShipperPartyVH.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CarrierParty ON Carrier = _CarrierParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerVH AS _CarrierPartyVH ON Carrier = _CarrierPartyVH.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_FreightOrderVH AS _FreightOrderVH ON FreightOrder = _FreightOrderVH.FreightOrder  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdLastRptdEvent AS _LastReportedEvent ON TransportationOrderUUID = _LastReportedEvent.TransportationOrderUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdLastRptdCheckOutEvt AS _LastReportedCheckOutEvent ON TransportationOrderUUID = _LastReportedCheckOutEvent.TransportationOrderUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeObject AS _TranspChargeObject ON TransportationOrderUUID = _TranspChargeObject.TranspChargeHostDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderItem AS _AvrItem ON TransportationOrderUUID = _AvrItem.TransportationOrderUUID AND _AvrItem.TranspOrdItemCategory = 'AVR'  -- association [0..1]
LEFT OUTER JOIN C_FrtCostDistrRoot AS _FrtCostDistrRoot ON TransportationOrderUUID = _FrtCostDistrRoot.TransportationOrderUUID  -- association [0..1]
;