P_CollabnApplFreightQuotation

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_CollabnApplFreightQuotation.
-- 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: PCOLLABFRTQUOT

CREATE VIEW P_CollabnApplFreightQuotation AS
SELECT
  TenderingResponse.TenderingResponseUUID AS FreightQuotationUUID,
  TenderingResponse.TenderingRequestUUID AS FreightRequestForQuotationUUID,
  TenderingResponse.TransportationOrderUUID AS TransportationOrderUUID,
  TenderingStep.TenderingUUID AS TenderingUUID,
  cast ( TenderingRequest.TenderingRequest as /scmtms/vdm_freight_rfq) AS FreightRequestForQuotation,
  Tendering.RefTransportationOrderUUID AS RefTransportationOrderUUID,
  Tendering.TenderingManager AS TenderingManager,
  TenderingRequest.TenderingRequestedCarrier AS TenderingRequestedCarrier,
  TenderingResponse.TenderingResponseSqncNumber AS TenderingResponseSqncNumber,
  TenderingResponse.TenderingAwardStatus AS TenderingAwardStatus,
  TenderingResponse.TenderingResponseCode AS TenderingResponseCode,
  TenderingResponse.TenderingRejectionReason AS TenderingRejectionReason,
  TenderingResponse.TenderingSubmissionDateTime AS TenderingSubmissionDateTime,
  TenderingResponse.TndrgRspSubmdAmtCrcy AS TndrgRspSubmdAmtCrcy,
  TenderingResponse.TndrgRspSubmdAmt AS TndrgRspSubmdAmt,
  TenderingRequest.TenderingVisibilitySettings AS TenderingVisibilitySettings
FROM I_TenderingResponse AS TenderingResponse
INNER JOIN I_TenderingRequest AS TenderingRequest ON /* join condition not captured in parsed metadata */
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 */
LEFT OUTER JOIN I_TransportationOrder AS _RefTransportationOrder ON RefTransportationOrderUUID = _RefTransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TenderingRejectionReason AS _TenderingRejectionReason ON TenderingRejectionReason = _TenderingRejectionReason.TenderingRejectionReason  -- association [0..1]
LEFT OUTER JOIN I_TenderingResponseCode AS _TenderingResponseCode ON TenderingResponseCode = _TenderingResponseCode.TenderingResponseCode  -- association [0..1]
LEFT OUTER JOIN I_TenderingAwardStatus AS _TenderingAwardStatus ON TenderingAwardStatus = _TenderingAwardStatus.TenderingAwardStatus  -- association [0..1]
LEFT OUTER JOIN I_TenderingVisibilitySettings AS _TenderingVisibilitySettings ON TenderingVisibilitySettings = _TenderingVisibilitySettings.TenderingVisibilitySettings  -- association [1..1]
LEFT OUTER JOIN C_CollabnApplTenderingManager AS _TenderingManager ON TenderingManager = _TenderingManager.TenderingManager  -- association [0..1]
;