C_CollabnApplMngFrtOrderCharge

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_CollabnApplMngFrtOrderCharge.
-- 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_CollabnApplMngFrtOrderCharge AS
SELECT
  TransportationOrderUUID,
  FreightOrder,
  TransportationOrderCategory,
  TransportationOrderType,
  TranspOrdShippingType,
  FreightOrderDisputeCaseStatus,
  _CollabnApplFrtOrdDsputStatus._Text[1: Language = $session.system_language].FrtOrdDisputeCaseStatusDesc AS FrtOrdDisputeCaseStatusDesc,
  TranspOrdResponsiblePerson,
  _CollabnApplFrtOrdRespPersn.PersonFullName AS PersonFullName,
  PurchasingOrgExternalID,
  PurchasingOrganizationName,
  SourceLocation,
  DestinationLocation,
  SourceLocationDescription,
  DestinationLocationDescription,
  SourceLocationAddressDesc,
  DestinationLocationAddressDesc,
  Carrier,
  BusinessPartnerCompany,
  MeansOfTransport AS TranspMeansOfTransport,
  MeansOfTransportDesc,
  TranspOrdDistance,
  TranspOrdDistanceUnit,
  TranspOrdArrivalDateTime,
  TranspOrdDepartureDateTime,
  TranspOrdGrossWeightUnit,
  TranspOrdGrossWeight,
  TranspOrdGrossVolumeUnit,
  TranspOrdGrossVolume,
  TranspOrdQuantityUnit,
  TranspOrdQuantity,
  TransportationOrderStopUUID,
  TransportationOrderTypeDesc,
  TranspChargeDocumentCurrency,
  TranspChrgNetAmtInDocCrcy,
  TranspChrgPrpsdNetAmtInDocCrcy,
  SuplrFrtInvcReqUUID,
  FreightOrderDisputeStatus
FROM P_CollabnApplMngFrtOrderCharge
LEFT OUTER JOIN C_CollabnApplMngFrtOrdChrgStge AS _CollabnApplMngFrtOrdChrgStge ON TransportationOrderUUID = _CollabnApplMngFrtOrdChrgStge.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN C_CollabnApplMngFrtOrdChrgItem AS _CollabnApplMngFrtOrdChrgItem ON TransportationOrderUUID = _CollabnApplMngFrtOrdChrgItem.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN C_CollabnApplFrtOrdRespPersn AS _CollabnApplFrtOrdRespPersn ON TranspOrdResponsiblePerson = _CollabnApplFrtOrdRespPersn.TranspOrdResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN C_CollabnMngFrtOrdChargeItemVH AS _CollabnMngFrtOrdChargeItemVH ON TransportationOrderUUID = _CollabnMngFrtOrdChargeItemVH.TranspChargeHostDocumentUUID  -- association [0..*]
LEFT OUTER JOIN C_CollabnMngFrtOrdChargeTypeVH AS _CollabnMngFrtOrdChargeTypeVH ON (TranspOrdShippingType = _CollabnMngFrtOrdChargeTypeVH.TransportationShippingType OR (TranspOrdShippingType is initial ) )  -- association [0..*]
LEFT OUTER JOIN C_CollabnApplMngFrtOrdChrgNote AS _CollabnApplMngFrtOrdChrgNote ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_CollabnMngFrtOrdChrgElement AS _CollabnMngFrtOrdChrgElement ON /* condition not available in parsed metadata */  -- association [0..*]
;