C_CollabnApplFreightOrdForConf

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_CollabnApplFreightOrdForConf.
-- 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.
-- SQL view name: CCOLLFRTORDCONF

CREATE VIEW C_CollabnApplFreightOrdForConf AS
SELECT
  TransportationOrderUUID,
  FreightRequestForQuotationUUID,
  FreightOrder,
  TransportationOrderCategory,
  TransportationOrderType,
  PurchasingOrgExternalID,
  PurchasingOrganizationName,
  SourceLocation,
  DestinationLocation,
  SourceLocationDescription,
  DestinationLocationDescription,
  SourceLocationAddressDesc,
  DestinationLocationAddressDesc,
  FreightOrderConfirmationStatus,
  _CollabnApplFrtOrdConfStatus._Text[1: Language = $session.system_language ].FreightOrderConfStatusDesc AS FreightOrderConfStatusDesc,
  Carrier,
  TranspOrdResponsiblePerson,
  _FrtOrderResponsiblePerson.PersonFullName AS PersonFullName,
  MeansOfTransport AS TranspMeansOfTransport,
  MeansOfTransportDesc,
  TranspOrdDistance,
  TranspOrdDistanceUnit,
  TranspOrdArrivalDateTime,
  TranspOrdDepartureDateTime,
  TranspOrdGrossWeightUnit,
  TranspOrdGrossWeight,
  TranspOrdGrossVolumeUnit,
  TranspOrdGrossVolume,
  TranspOrdQuantityUnit,
  TranspOrdQuantity,
  TranspOrderDngrsGdsSts,
  TranspOrderDngrsGdsStsDesc,
  TransportationOrderStopUUID,
  _FrtOrdActiveVehicleResource.TranspOrdActvVehRscePltNmbr AS TranspOrdActvVehRscePltNmbr,
  _FrtOrdActiveVehicleResource.TranspOrdItmRegnCtryReg AS TranspOrdItmRegnCtryReg,
  cast( _FrtOrdDriverDetails.TranspOrdItemDesc as /scmtms/driver_name ) AS TranspOrdDriverName,
  TenderingPreferredCurrency,
  TndrgRspSubmdAmtCrcy,
  TenderingSubmdPriceVisibility,
  TenderingStopDateVisibility,
  TenderingPriceLimitVisibility,
  TenderingLowestPriceVisibility,
  TenderingSubmdPrCrcyVisibility,
  TndrgReqAbsolutePriceLimitAmt
FROM P_CollabnApplFreightOrdForConf
LEFT OUTER JOIN C_CollabnApplTranspOrderStop AS _CollabnApplTranspOrderStop ON TransportationOrderUUID = _CollabnApplTranspOrderStop.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN C_CollabnApplFrtOrdForConfNote AS _CollabnApplFrtOrdForConfNote ON TransportationOrderUUID = _CollabnApplFrtOrdForConfNote.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_CollabnApplFrtOrdConfStatus AS _CollabnApplFrtOrdConfStatus ON FreightOrderConfirmationStatus = _CollabnApplFrtOrdConfStatus.FreightOrderConfirmationStatus  -- association [0..1]
LEFT OUTER JOIN C_CollabnApplFrtOrdRespPersn AS _FrtOrderResponsiblePerson ON TranspOrdResponsiblePerson = _FrtOrderResponsiblePerson.TranspOrdResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderItem AS _FrtOrdActiveVehicleResource ON TransportationOrderUUID = _FrtOrdActiveVehicleResource.TransportationOrderUUID AND _FrtOrdActiveVehicleResource.TranspOrdItemCategory = 'AVR'  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderItem AS _FrtOrdDriverDetails ON TransportationOrderUUID = _FrtOrdDriverDetails.TransportationOrderUUID AND _FrtOrdDriverDetails.TranspOrdItemCategory = 'DRI' AND TransportationOrderStopUUID = _FrtOrdDriverDetails.SourceStopUUID  -- association [0..1]
;