P_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 P_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: PCOLLFRTORDCONF

CREATE VIEW P_CollabnApplFreightOrdForConf AS
SELECT
  TransportationOrder.TransportationOrderUUID AS TransportationOrderUUID,
  hextobin('00000000000000000000000000000000') AS FreightRequestForQuotationUUID,
  TransportationOrder.TransportationOrder AS FreightOrder,
  TransportationOrder.TransportationOrderCategory AS TransportationOrderCategory,
  TransportationOrder.TransportationOrderType AS TransportationOrderType,
  TransportationOrder.PurchasingOrgExternalID AS PurchasingOrgExternalID,
  TransportationOrder._PurchasingOrganization._OrganizationalUnitText[1:Language = $session.system_language].OrganizationalUnitName AS PurchasingOrganizationName,
  TransportationOrder._SourceStop.TransportationOrderStopUUID AS TransportationOrderStopUUID,
  TransportationOrder._SourceStop.LocationId AS SourceLocation,
  TransportationOrder._DestinationStop.LocationId AS DestinationLocation,
  TransportationOrder._SourceStop._Locationdescr.LocationDescription AS SourceLocationDescription,
  TransportationOrder._DestinationStop._Locationdescr.LocationDescription AS DestinationLocationDescription,
  TransportationOrder._SourceStop._Locationdescr.AddressObjectDescription AS SourceLocationAddressDesc,
  TransportationOrder._DestinationStop._Locationdescr.AddressObjectDescription AS DestinationLocationAddressDesc,
  TransportationOrder.Carrier AS Carrier,
  TransportationOrder.TranspOrdResponsiblePerson AS TranspOrdResponsiblePerson,
  TransportationOrder.MeansOfTransport AS MeansOfTransport,
  TransportationOrder._MeansOfTransport._Text[1: Language = $session.system_language].MeansOfTransportDesc AS MeansOfTransportDesc,
  TransportationOrder.TranspOrdDistance AS TranspOrdDistance,
  TransportationOrder.TranspOrdDistanceUnit AS TranspOrdDistanceUnit,
  TransportationOrder._SourceStop.TranspOrdStopPlanTranspDteTme AS TranspOrdDepartureDateTime,
  TransportationOrder._DestinationStop.TranspOrdStopPlanTranspDteTme AS TranspOrdArrivalDateTime,
  TransportationOrder.TranspOrdGrossWeightUnit AS TranspOrdGrossWeightUnit,
  TransportationOrder.TranspOrdGrossWeight AS TranspOrdGrossWeight,
  TransportationOrder.TranspOrdGrossVolumeUnit AS TranspOrdGrossVolumeUnit,
  TransportationOrder.TranspOrdGrossVolume AS TranspOrdGrossVolume,
  TransportationOrder.TranspOrdQuantityUnit AS TranspOrdQuantityUnit,
  TransportationOrder.TranspOrdQuantity AS TranspOrdQuantity,
  TransportationOrder.TranspOrderDngrsGdsSts AS TranspOrderDngrsGdsSts,
  TransportationOrder._TranspOrdDngrsGdsStatus._Text[1: Language = $session.system_language].TranspOrderDngrsGdsStsDesc AS TranspOrderDngrsGdsStsDesc,
  cast ( '' as abap.cuky( 05 )) AS TenderingPreferredCurrency,
  cast ( '' as abap.cuky( 05 )) AS TndrgRspSubmdAmtCrcy,
  cast( '' as abap.char( 02 )) AS TenderingSubmdPriceVisibility,
  cast( '' as abap.char( 02 )) AS TenderingSubmdPrCrcyVisibility,
  cast('' as abap.char( 02 )) AS TenderingStopDateVisibility,
  cast( '' as abap.char( 02 )) AS TenderingPriceLimitVisibility,
  cast( '' as abap.char( 02 )) AS TenderingLowestPriceVisibility
FROM I_TransportationOrder AS TransportationOrder
INNER JOIN P_CollabnApplCarrierUser AS CollabnApplCarrierUser ON /* join condition not captured in parsed metadata */
INNER JOIN I_TenderingStep AS TenderingStep ON /* join condition not captured in parsed metadata */
INNER JOIN I_Tendering AS Tendering ON /* join condition not captured in parsed metadata */
INNER JOIN I_TransportationOrder AS TransportationOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_TransportationOrder AS RefTransportationOrder ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_TenderingRequest
;