C_FrtOrdGenDataBasicFacts

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_FrtOrdGenDataBasicFacts.
-- 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_FrtOrdGenDataBasicFacts 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,
  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,
  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,
  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,
  _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,
  concat( concat( cast(_DeliveryRatio.TranspOrderNmbrOfItmWthDeliv as abap.char( 100 )), '/'), cast(_DeliveryRatio.TranspOrderNmbrOfDelivRlvtItm as abap.char( 100 )) ) as TranspOrdDelivCrtnPrgrsRatio AS char100asTranspOrdDelivCrtnPrgrsRatio,
  TranspOrdDistanceUnit AS DisplayLengthUnit,
  cast(TranspOrdDistance as /scmtms/quantity_13_3 ) AS TranspOrdDistanceInDspUnit,
  _TranspChargeObject.TransportationChargesObjUUID AS TransportationChargesObjUUID,
  _TranspChargeObject.TranspChargeCalcStatus AS TranspChargeCalcStatus,
  _TranspChargeObject.TranspChargeCalcStsCriticality AS TranspChargeCalcStsCriticality,
  _TranspChargeObject.TranspChrgTotalAmtInDocCrcy AS TranspChrgTotalAmtInDocCrcy,
  _TranspChargeObject.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency,
  _FrtCostDistrRoot.FrtCostDistrRootUUID AS FrtCostDistrRootUUID,
  _FrtCostDistrRoot.FrtCostDistrStatus AS FrtCostDistrStatus,
  _TranspOrdSummary.TranspOrdGoodsValueAmount AS TranspOrdGoodsValueAmount,
  _TranspOrdSummary.TranspOrdGoodsValueCrcy AS TranspOrdGoodsValueCrcy,
  _TranspChargeObject._TranspChargeCalcStatus AS _TranspChargeCalcStatus,
  _FrtCostDistrRoot._DistrStatus AS _DistrStatus
LEFT OUTER JOIN I_FrtOrderItem AS _Item ON TransportationOrderUUID = _Item.TransportationOrderUUID  -- association [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_TransportationOrderCplBP AS _BusinessPartner ON TransportationOrderUUID = _BusinessPartner.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_FreightOrderVH AS _FreightOrderVH ON FreightOrder = _FreightOrderVH.FreightOrder  -- association [0..1]
LEFT OUTER JOIN I_TransportationLocationVH AS _SourceLocationAddressVH ON SourceLocation is not initial AND SourceLocation = _SourceLocationAddressVH.Location  -- association [0..1]
LEFT OUTER JOIN I_TransportationLocationVH AS _DestinationLocationAddressVH ON DestinationLocation is not initial AND DestinationLocation = _DestinationLocationAddressVH.Location  -- association [0..1]
LEFT OUTER JOIN I_FrtOrderStage AS _Stage ON TransportationOrderUUID = _Stage.TransportationOrderUUID  -- association [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]
LEFT OUTER JOIN I_UnitOfMeasure AS _DisplayLengthUnit ON _DisplayLengthUnit.UnitOfMeasureDimension = 'LENGTH' AND DisplayLengthUnit = _DisplayLengthUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN C_TranspChargeItemElement AS _TranspChargeItemElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_FrtCostDistrItm AS _FrtCostDistrItem ON /* condition not available in parsed metadata */  -- association [0..*]
;