P_CollabnApplFrtOrdInvoice

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_CollabnApplFrtOrdInvoice.
-- 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: PCOLLFRTORDINVC

CREATE VIEW P_CollabnApplFrtOrdInvoice AS
SELECT
  TransportationOrder.TransportationOrderUUID AS TransportationOrderUUID,
  TransportationOrder.TransportationOrder AS FreightOrder,
  TransportationOrder.TransportationOrderCategory AS TransportationOrderCategory,
  TransportationOrder.TransportationOrderType AS TransportationOrderType,
  TransportationOrder.PurchasingOrgExternalID AS PurchasingOrgExternalID,
  TransportationOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingOrganization._OrganizationalUnitText[1:Language = $session.system_language].OrganizationalUnitName AS PurchasingOrganizationName,
  _SourceStop.LocationId AS SourceLocation,
  _DestinationStop.LocationId AS DestinationLocation,
  _SourceStop._Locationdescr.LocationDescription AS SourceLocationDescription,
  _DestinationStop._Locationdescr.LocationDescription AS DestinationLocationDescription,
  _SourceStop.TranspOrdStopPlanTranspDteTme AS TranspOrdDepartureDateTime,
  _DestinationStop.TranspOrdStopPlanTranspDteTme AS TranspOrdArrivalDateTime,
  TransportationOrder.MeansOfTransport AS MeansOfTransport,
  TranspChargeObject.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency,
  TransportationOrder.TranspOrdGrossWeightUnit AS TranspOrdGrossWeightUnit,
  TransportationOrder.TranspOrdGrossWeight AS TranspOrdGrossWeight,
  TransportationOrder.TranspOrdGrossVolumeUnit AS TranspOrdGrossVolumeUnit,
  TransportationOrder.TranspOrdGrossVolume AS TranspOrdGrossVolume,
  TransportationOrder.TranspOrdDistanceUnit AS TranspOrdDistanceUnit,
  TransportationOrder.TranspOrdDistance AS TranspOrdDistance,
  CollabnApplAddlAgrmtPty.BusinessPartnerUUID AS BusinessPartnerUUID,
  CollabnApplAddlAgrmtPty.Coll_Carrier AS Coll_Carrier
FROM I_TransportationOrder AS TransportationOrder
INNER JOIN P_CollabnApplFrtOrdParty AS CollabnApplAddlAgrmtPty 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_TranspOrganizationalUnit AS TranspOrganizationalUnit ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartnerPurgOrg AS EvaluatedSettlement ON /* join condition not captured in parsed metadata */
INNER JOIN I_TranspChargeObject AS TranspChargeObject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TransportationOrderStop AS _SourceStop ON TransportationOrderUUID = _SourceStop.TransportationOrderUUID AND _SourceStop.TranspOrdStopSequencePosition = 'F'  -- association [0..1]
LEFT OUTER JOIN I_TransportationOrderStop AS _DestinationStop ON TransportationOrderUUID = _DestinationStop.TransportationOrderUUID AND _DestinationStop.TranspOrdStopSequencePosition = 'L'  -- association [0..1]
LEFT OUTER JOIN I_MeansOfTransport AS _MeansOfTransport ON MeansOfTransport = _MeansOfTransport.MeansOfTransport  -- association [0..1]
LEFT OUTER JOIN I_TranspOrganizationalUnit AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN I_CarrierInvoicingStatus AS _CarrierInvoicingStatus ON CarrierInvoicingStatus = _CarrierInvoicingStatus.CarrierInvoicingStatus  -- association [0..1]
;