I_BR_CTeVehicle

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_CTeVehicle.
-- 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: IBRCTEVEHICLE

CREATE VIEW I_BR_CTeVehicle AS
SELECT
  CTeVehicle.docnum AS BR_CTe,
  CTeVehicle.counter AS BR_CTeVehicleSequenceNmbr,
  CTeVehicle.renavam AS BR_CTeVehicleRENAVAM,
  cast(CTeVehicle.plate as logbr_plate_cte preserving type) AS BR_CTeVehicleLicensePlate,
  CTeVehicle.tare_kg AS BR_CTeVehicleTareWeight,
  cast(CTeVehicle.capa_kg as logbr_capa_kg_cte) AS BR_CTeVehicleCapacityWeight,
  CTeVehicle.capa_m AS BR_CTeVehicleCapacityLength,
  CTeVehicle.owner_tp AS VehicleOwnershipType,
  CTeVehicle.res_type AS VehicleType,
  CTeVehicle.rodado_tp AS BR_CTeVehicleAxlesType,
  CTeVehicle.car_tp AS BR_CTeVehicleTrailerType,
  cast(CTeVehicle.state as logbr_vehicle_region preserving type) AS BR_CTeVehicleRegion,
  cast(CTeVehicle.seal_nr as logbr_seal_cte preserving type) AS BR_CTeVehicleSeal
FROM j_1bcte_d_res AS CTeVehicle
LEFT OUTER JOIN I_BR_VehicleOwnershipType AS _BR_VehicleOwnershipType ON _BR_VehicleOwnershipType.VehicleOwnershipType = VehicleOwnershipType  -- association [0..1]
LEFT OUTER JOIN I_BR_CTeVehicleType AS _BR_CTeVehicleType ON _BR_CTeVehicleType.VehicleType = VehicleType  -- association [0..1]
LEFT OUTER JOIN I_BR_VehicleAxlesType AS _BR_VehicleAxlesType ON _BR_VehicleAxlesType.BR_CTeVehicleAxlesType = BR_CTeVehicleAxlesType  -- association [0..1]
LEFT OUTER JOIN I_BR_TrailerType AS _BR_TrailerType ON _BR_TrailerType.BR_CTeVehicleTrailerType = BR_CTeVehicleTrailerType  -- association [0..1]
;