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_FrtOrdManagement.
-- 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_FrtOrdManagement AS
SELECT
cast(TransportationOrderUUID as /scmtms/vdm_tor_db_key preserving type ) AS TransportationOrderUUID,
TransportationOrder AS FreightOrder,
TransportationOrderType,
_TransportationOrderType._Text[1:Language = $session.system_language ].TransportationOrderTypeDesc AS TransportationOrderTypeDesc,
TranspOrdPartnerReference,
_AvrItem.TranspOrdActvVehRscePltNmbr AS TranspOrdActvVehRscePltNmbr,
PurchasingOrgExternalID,
_PurchasingOrganization._OrganizationalUnitText[1:Language = $session.system_language].OrganizationalUnitName AS PurchasingOrganizationName,
PurchasingGroupExternalID,
_PurchasingGroup._OrganizationalUnitText[1:Language = $session.system_language].OrganizationalUnitName AS PurchasingGroupName,
cast(_PlngAndExecOrganization.OrganizationalUnitExternalID as /scmtms/exec_org_ext_id preserving type ) AS PlngAndExecOrgExternalID,
cast(_PlngAndExecGroup.OrganizationalUnitExternalID as /scmtms/exec_grp_ext_id preserving type ) AS PlngAndExecGroupExternalID,
PurgOrgCompanyCode,
_PurchasingCompanyCode.CompanyCodeName AS PurgOrgCompanyCodeName,
TranspOrdResponsiblePerson,
TransportationMode,
_TransportationMode._Text[1:Language = $session.system_language].TransportationModeDesc AS TransportationModeDesc,
TransportationOrderCrtnType,
TransportationOrderCategory,
cast(TranspOrdGrossWeight as /scmtms/quantity_13_3 ) AS TranspOrdGrossWeight,
TranspOrdGrossWeightUnit,
cast(TranspOrdGrossVolume as /scmtms/quantity_13_3 ) AS TranspOrdGrossVolume,
TranspOrdGrossVolumeUnit,
cast(TranspOrdQuantity as /scmtms/quantity_13_3 ) AS TranspOrdQuantity,
TranspOrdQuantityUnit,
cast(TranspOrdPalletSpacesQty as /scmtms/quantity_13_3 ) AS TranspOrdPalletSpacesQty,
TranspOrdPalletSpacesUnit,
cast(TranspOrdLoadMetersQty as /scmtms/quantity_13_3 ) AS TranspOrdLoadMetersQty,
TranspOrdLoadMetersUnit,
TranspOrdMaxUtilznRatio,
Carrier,
_Carrier.BusinessPartnerFullName AS CarrierName,
StandardCarrierAlphaCode,
Shipper,
Consignee,
TranspOrdLifeCycleStatus,
_TranspOrdLifeCycleStatus._Text[1:Language = $session.system_language ].TranspOrdLifeCycleStatusDesc AS TranspOrdLifeCycleStatusDesc,
TranspOrdPlanningStatus,
_TranspOrdPlanningStatus._Text[1:Language = $session.system_language ].TranspOrdPlanningStatusDesc AS TranspOrdPlanningStatusDesc,
TransportationOrderExecSts,
_TransportationOrderExecSts._Text[1:Language = $session.system_language ].TransportationOrderExecStsDesc AS TransportationOrderExecStsDesc,
TranspOrderDngrsGdsSts,
_TranspOrdDngrsGdsStatus._Text[1:Language = $session.system_language ].TranspOrderDngrsGdsStsDesc AS TranspOrderDngrsGdsStsDesc,
TranspOrderSubcontrgSts,
_TranspOrdSubcontractingSts._Text[1:Language = $session.system_language ].TranspOrderSubcontrgStsDesc AS TranspOrderSubcontrgStsDesc,
TransportationOrderConfSts,
_TranspOrdConfirmationStatus._Text[1:Language = $session.system_language ].TransportationOrderConfStsDesc AS TransportationOrderConfStsDesc,
_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,
TranspOrdOrderDateTime,
tstmp_to_dats( TranspOrdOrderDateTime, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdOrderDate AS clientNULLasTranspOrdOrderDate,
tstmp_to_tims( TranspOrdOrderDateTime, abap_user_timezone( $session.user,$session.client,'NULL' ) , $session.client, 'NULL' ) as TranspOrdOrderTime AS clientNULLasTranspOrdOrderTime,
TranspOrdDistanceUnit AS DisplayLengthUnit,
cast(TranspOrdDistance as /scmtms/quantity_13_3 ) AS TranspOrdDistanceInDspUnit,
_TranspChargeObject.TransportationChargesObjUUID AS TransportationChargesObjUUID,
_TranspChargeObject.TranspChargeCalcStatus AS TranspChargeCalcStatus,
_TranspChargeObject.TranspChargeCalcStatusDesc AS TranspChargeCalcStatusDesc,
_TranspChargeObject.TranspChrgTotalAmtInDocCrcy AS TranspChrgTotalAmtInDocCrcy,
_TranspChargeObject.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency,
_FrtCostDistrRoot.FrtCostDistrRootUUID AS FrtCostDistrRootUUID,
_FrtCostDistrRoot.FrtCostDistrStatus AS FrtCostDistrStatus,
_FrtCostDistrRoot.FrtCostDistrStatusTxt AS FrtCostDistrStatusTxt,
_TranspOrdSummary.TranspOrdGoodsValueAmount AS TranspOrdGoodsValueAmount,
_TranspOrdSummary.TranspOrdGoodsValueCrcy AS TranspOrdGoodsValueCrcy,
TranspOrdExecutionIsBlocked,
_TranspOrdExecutionIsBlocked._Text[1:Language = $session.system_language ].TranspOrdExecutionBlockDesc AS TranspOrdExecutionBlockDesc,
_TranspChargeObject._TranspChargeCalcStatus AS _TranspChargeCalcStatus,
_FrtCostDistrRoot._DistrStatus AS _DistrStatus
FROM I_TransportationOrder
LEFT OUTER JOIN E_TransportationOrder AS _Extension ON TransportationOrderUUID = _Extension.TransportationOrderUUID -- association [0..1]
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_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_TransportationOrderItem AS _AvrItem ON TransportationOrderUUID = _AvrItem.TransportationOrderUUID AND _AvrItem.TranspOrdItemCategory = 'AVR' -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DisplayLengthUnit ON _DisplayLengthUnit.UnitOfMeasureDimension = 'LENGTH' AND DisplayLengthUnit = _DisplayLengthUnit.UnitOfMeasure -- association [1..1]
LEFT OUTER JOIN C_TranspChargeObject AS _TranspChargeObject ON TransportationOrderUUID = _TranspChargeObject.TranspChargeHostDocumentUUID -- association [0..1]
LEFT OUTER JOIN C_FrtCostDistrRoot AS _FrtCostDistrRoot ON TransportationOrderUUID = _FrtCostDistrRoot.TransportationOrderUUID -- association [0..1]
;