I_BR_NFTransport_C

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 I_BR_NFTransport_C.
-- 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: IBRNFTRANSPORTC

CREATE VIEW I_BR_NFTransport_C AS
SELECT
  NFTransport.BR_NotaFiscal AS BR_NotaFiscal,
  NFTransport.MeansOfTransport AS MeansOfTransport,
  NFTransport.MeansOfTransportType AS MeansOfTransportType,
  NFTransport.IncotermsClassification AS IncotermsClassification,
  NFTransport.IncotermsTransferLocation AS IncotermsTransferLocation,
  cast(concat_with_space(NFTransport.IncotermsClassification, NFTransport.IncotermsTransferLocation, 1) as logbr_nfincotermsfrmtd) AS Incoterms,
  NFTransport.BR_NFArrivalOrDepartureDate AS BR_NFArrivalOrDepartureDate,
  NFTransport.BR_NFArrivalOrDepartureTime AS BR_NFArrivalOrDepartureTime,
  NFTransport.ShippingPoint AS ShippingPoint,
  NFTransport.BR_NFShippingUnitBrand AS BR_NFShippingUnitBrand,
  NFTransport.BR_NFShippingUnitNumber AS BR_NFShippingUnitNumber,
  NFTransport.BR_NFNumberOfPackages AS BR_NFNumberOfPackages,
  NFTransport.BR_NFShippingUnit AS BR_NFShippingUnitConverted,
  NFTransport.HeaderWeightUnit AS HeaderWeightUnit,
  NFTransport.HeaderNetWeight AS HeaderNetWeight,
  NFTransport.HeaderGrossWeight AS HeaderGrossWeight,
  NFTransport.BR_WhldgICMSForTranspCity AS BR_WhldgICMSForTranspCity,
  NFTransport.WagonID AS WagonID,
  NFTransport.FerryBoatID AS FerryBoatID,
  NFTransport.BR_NFExportShipmentPlace AS BR_NFExportShipmentPlace,
  NFTransport.BR_NFExportShipmentRegion AS BR_NFExportShipmentRegion,
  NFTransport.BR_NFExportDispatchLocation AS BR_NFExportDispatchLocation
FROM I_BR_NFDocument AS NFTransport
LEFT OUTER JOIN I_BR_NFTransportedVolume AS _BR_NFTransportedVolume ON _BR_NFTransportedVolume.BR_NotaFiscal = BR_NotaFiscal  -- association [0..*]
LEFT OUTER JOIN I_BR_NFTrailer_C AS _BR_NFTrailer ON _BR_NFTrailer.BR_NotaFiscal = BR_NotaFiscal  -- association [0..*]
;