/SCMTMS/CV_EquipmentRoot

DDL: /SCMTMS/CV_EQUIPMENTROOT SQL: /SCMTMS/CV_EQROT Type: view
111 Fields 3 Data Sources

Equipment Root

/SCMTMS/CV_EquipmentRoot is a CDS View that provides data about "Equipment Root" in SAP S/4HANA. It reads from 3 data sources (I_EquipmentGroupClassification, I_EquipmentType, I_MeansOfTransport) and exposes 111 fields with key fields EquipmentGroup, EquipmentType.

Data Sources (3)

SourceAliasJoin Type
I_EquipmentGroupClassification _EquipmentGroup from
I_EquipmentType _EquipmentType inner
I_MeansOfTransport _MeansOfTransport left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName /SCMTMS/CV_EQROT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Equipment Root view

Fields (111)

KeyFieldSource TableSource FieldDescription
KEY EquipmentGroup I_EquipmentGroupClassification EquipmentGroup Equipment Group
KEY EquipmentType I_EquipmentType EquipmentType Equipment Type
ResourceAdditionalUUID I_EquipmentType ResourceAdditionalUUID UUID
EquipTypeIsTranspPlngNotRlvt I_EquipmentType EquipTypeIsTranspPlngNotRlvt Restricted Use
TranspMeansOfTransport I_EquipmentType TranspMeansOfTransport Transact. Type
ResourceMaximumLoadWeight I_EquipmentType ResourceMaximumLoadWeight Payload Weight
ResourceMaximumLoadWeightUnit I_EquipmentType ResourceMaximumLoadWeightUnit PaylWghtUoM
ResourceCubicCapacity I_EquipmentType ResourceCubicCapacity Cubic Capacity
ResourceCubicCapacityUnit I_EquipmentType ResourceCubicCapacityUnit Cub. Capa. UoM
ResourceInteriorLength I_EquipmentType ResourceInteriorLength Interior Length
ResourceInteriorWidth I_EquipmentType ResourceInteriorWidth Interior Width
ResourceInteriorHeight I_EquipmentType ResourceInteriorHeight Interior Height
ResourceInteriorLengthUnit I_EquipmentType ResourceInteriorLengthUnit
RsceAddlCapNmbrOfUnits I_EquipmentType RsceAddlCapNmbrOfUnits Number of Units
RsceAddlCapNmbrOfUnitsUnit I_EquipmentType RsceAddlCapNmbrOfUnitsUnit
RsceAddlCapAltvNmbrOfUnits I_EquipmentType RsceAddlCapAltvNmbrOfUnits Alt. Number of Units
RsceAddlCapAltvNmbrOfUnitsUnit I_EquipmentType RsceAddlCapAltvNmbrOfUnitsUnit
ResourceMaximumGrossWeight I_EquipmentType ResourceMaximumGrossWeight Max. Gross Weight
ResourceMaximumGrossWeightUnit I_EquipmentType ResourceMaximumGrossWeightUnit Gross Weight UoM
ResourceTareWeight I_EquipmentType ResourceTareWeight Tare Weight
ResourceTareWeightUnit I_EquipmentType ResourceTareWeightUnit Tare Weight UoM
ResourceTareVolume I_EquipmentType ResourceTareVolume Tare Volume
ResourceTareVolumeUnit I_EquipmentType ResourceTareVolumeUnit Tare Volume UoM
TwentyFootEquivUnitCapacity I_EquipmentType TwentyFootEquivUnitCapacity TEU Capacity
ResourceIsTemperatureCtrld I_EquipmentType ResourceIsTemperatureCtrld Temp.Ctrld.
ResourceMinCtrlTemperature I_EquipmentType ResourceMinCtrlTemperature Min. Temp.
ResourceMaxCtrlTemperature I_EquipmentType ResourceMaxCtrlTemperature Max. Temp.
ResourceCtrlTemperatureUnit I_EquipmentType ResourceCtrlTemperatureUnit Temp. UoM
ResourceIsVentilated I_EquipmentType ResourceIsVentilated Ventilation
ResourceULDClassification I_EquipmentType ResourceULDClassification Classification
ResourceIsIATACompliant I_EquipmentType ResourceIsIATACompliant IATA-Compl.
RsceULDNumberIsToBeChecked I_EquipmentType RsceULDNumberIsToBeChecked Validate ULD Number
RsceULDLoadingInstruction I_EquipmentType RsceULDLoadingInstruction ULD Loading Instr.
ResourceMaximumLength I_EquipmentType ResourceMaximumLength Maximal Length
ResourceMaximumWidth I_EquipmentType ResourceMaximumWidth Width
ResourceMaximumHeight I_EquipmentType ResourceMaximumHeight Max. Height
ResourceMaximumLengthUnit I_EquipmentType ResourceMaximumLengthUnit Unit of Meas.
ResourcePlatformHeight I_EquipmentType ResourcePlatformHeight Platform Height
ResourcePlatformHeightUnit I_EquipmentType ResourcePlatformHeightUnit Platform Height UoM
ResourceTopDeckHeight I_EquipmentType ResourceTopDeckHeight Top Deck Height
ResourceTopDeckHeightUnit I_EquipmentType ResourceTopDeckHeightUnit Top Deck Height UoM
ResourceWheelDiameter I_EquipmentType ResourceWheelDiameter Wheel Diameter
ResourceWheelDiameterUnit I_EquipmentType ResourceWheelDiameterUnit Wheel Diameter UoM
ResourceDoorWidth I_EquipmentType ResourceDoorWidth Door Width
ResourceDoorHeight I_EquipmentType ResourceDoorHeight Door Height
ResourceDoorLengthUnit I_EquipmentType ResourceDoorLengthUnit Door Dim. UoM
RsceLoadOpeningLength I_EquipmentType RsceLoadOpeningLength Load. Opening Length
RsceLoadOpeningWidth I_EquipmentType RsceLoadOpeningWidth Load. Opening Width
RsceLoadOpeningLengthUnit I_EquipmentType RsceLoadOpeningLengthUnit Load. Opening UoM
NumberOfAxles I_EquipmentType NumberOfAxles Number of Axles
ResourceAxleSpaceDistance I_EquipmentType ResourceAxleSpaceDistance Dist. Between Axles
ResourceAxleSpaceDistanceUnit I_EquipmentType ResourceAxleSpaceDistanceUnit Dist Betw Axles UoM
ResourceMaxAxleWeight I_EquipmentType ResourceMaxAxleWeight Max. Axle Weight
ResourceMaxAxleWeightUnit I_EquipmentType ResourceMaxAxleWeightUnit Max. Axle Weight UoM
ResourceCouplerStyle I_EquipmentType ResourceCouplerStyle Coupler Style
ResourceWheelBearingType I_EquipmentType ResourceWheelBearingType Wheel Bearing Type
ResourceDraftGearType I_EquipmentType ResourceDraftGearType Draft Gear Type
ResourceCargoBodyDistance I_EquipmentType ResourceCargoBodyDistance Cargo Body Distance
ResourceConnectorDistance I_EquipmentType ResourceConnectorDistance Connector Distance
ResourceConnectorMaxWeight I_EquipmentType ResourceConnectorMaxWeight Max. Weight Connect.
ResourceKingpinDistance I_EquipmentType ResourceKingpinDistance King Pin Distance
ResourceKingpinMaxWeight I_EquipmentType ResourceKingpinMaxWeight Max. Weight King Pin
ResourceSplitDeckDistance I_EquipmentType ResourceSplitDeckDistance Split Deck Position
ResourceSplitDeckMaxWeight I_EquipmentType ResourceSplitDeckMaxWeight Max. Weight Sp. Deck
ResourceTechnicalDistanceUnit I_EquipmentType ResourceTechnicalDistanceUnit Distance UoM
ResourceLoadWeightUnit I_EquipmentType ResourceLoadWeightUnit Weight-Loading UoM
RsceMaxTrailingLoadWeight I_EquipmentType RsceMaxTrailingLoadWeight Max. Trailing Load
RsceMaxTrailingLoadWeightUnit I_EquipmentType RsceMaxTrailingLoadWeightUnit Trailing Load UoM
ResourceIsUsableForFood I_EquipmentType ResourceIsUsableForFood Food-Grade Resource
VehicleLoadingProfile I_EquipmentType VehicleLoadingProfile Veh. Load. Profile
AttachedEquipmentProfile I_EquipmentType AttachedEquipmentProfile Att. Equip. Profile
ResourceAxleGroup1Type I_EquipmentType ResourceAxleGroup1Type Axle Type
RsceAxleGroup1SpaceDistance I_EquipmentType RsceAxleGroup1SpaceDistance Dist. Between Axles
RsceAxleGroup1Distance I_EquipmentType RsceAxleGroup1Distance Axle Group Distance
ResourceAxleGroup1DistanceUnit I_EquipmentType ResourceAxleGroup1DistanceUnit Distance UoM
RsceAxleGroup1MaximumWeight I_EquipmentType RsceAxleGroup1MaximumWeight Max. Weight on Group
RsceAxleGroup1EmptyWeight I_EquipmentType RsceAxleGroup1EmptyWeight Emp. Weight on Group
RsceAxleGroup1WeightUnit I_EquipmentType RsceAxleGroup1WeightUnit Weights UoM
RsceAxleGroup1IsDrivingAxle I_EquipmentType RsceAxleGroup1IsDrivingAxle Drive Axle
RsceAxleGroup1IsSteeringAxle I_EquipmentType RsceAxleGroup1IsSteeringAxle Steering Axle
ResourceAxleGroup2Type I_EquipmentType ResourceAxleGroup2Type Axle Type
RsceAxleGroup2SpaceDistance I_EquipmentType RsceAxleGroup2SpaceDistance Dist. Between Axles
RsceAxleGroup2Distance I_EquipmentType RsceAxleGroup2Distance Axle Group Distance
ResourceAxleGroup2DistanceUnit I_EquipmentType ResourceAxleGroup2DistanceUnit Distance UoM
RsceAxleGroup2MaximumWeight I_EquipmentType RsceAxleGroup2MaximumWeight Max. Weight on Group
RsceAxleGroup2EmptyWeight I_EquipmentType RsceAxleGroup2EmptyWeight Emp. Weight on Group
RsceAxleGroup2WeightUnit I_EquipmentType RsceAxleGroup2WeightUnit Weights UoM
RsceAxleGroup2IsDrivingAxle I_EquipmentType RsceAxleGroup2IsDrivingAxle Drive Axle
RsceAxleGroup2IsSteeringAxle I_EquipmentType RsceAxleGroup2IsSteeringAxle Steering Axle
ResourceAxleGroup3Type I_EquipmentType ResourceAxleGroup3Type Axle Type
RsceAxleGroup3SpaceDistance I_EquipmentType RsceAxleGroup3SpaceDistance Dist. Between Axles
RsceAxleGroup3Distance I_EquipmentType RsceAxleGroup3Distance Axle Group Distance
ResourceAxleGroup3DistanceUnit I_EquipmentType ResourceAxleGroup3DistanceUnit Distance UoM
RsceAxleGroup3MaximumWeight I_EquipmentType RsceAxleGroup3MaximumWeight Max. Weight on Group
RsceAxleGroup3EmptyWeight I_EquipmentType RsceAxleGroup3EmptyWeight Emp. Weight on Group
RsceAxleGroup3WeightUnit I_EquipmentType RsceAxleGroup3WeightUnit Weights UoM
RsceAxleGroup3IsDrivingAxle I_EquipmentType RsceAxleGroup3IsDrivingAxle Drive Axle
RsceAxleGroup3IsSteeringAxle I_EquipmentType RsceAxleGroup3IsSteeringAxle Steering Axle
ResourceTypeClassification I_EquipmentType ResourceTypeClassification Type Classification
PackagingMaterialName I_EquipmentType PackagingMaterialName Packaging Matl
ResourcePictureURL I_EquipmentType ResourcePictureURL Equi. Type URL
ResourceCompartmentProfile I_EquipmentType ResourceCompartmentProfile Comp. Profile
ResourceIsCombinationResource I_EquipmentType ResourceIsCombinationResource Comb. Resource
EquipmentTypeIsDeleted I_EquipmentType EquipmentTypeIsDeleted Mark for Deletion
TransportationMode I_MeansOfTransport TransportationMode Mode of Transp.
MeansOfTransportIsPassive I_MeansOfTransport MeansOfTransportIsPassive Passive
ResourceClass I_EquipmentGroupClassification ResourceClass
ResourceType
EquipmentTypeDesc
_EquipmentGroupText I_EquipmentGroupClassification _EquipmentGroupText
_TransportationMode I_MeansOfTransport _TransportationMode

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 /SCMTMS/CV_EquipmentRoot.
-- 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: /SCMTMS/CV_EQROT

CREATE VIEW /SCMTMS/CV_EquipmentRoot AS
SELECT
  _EquipmentGroup.EquipmentGroup AS EquipmentGroup,
  _EquipmentType.EquipmentType AS EquipmentType,
  _EquipmentType.ResourceAdditionalUUID AS ResourceAdditionalUUID,
  _EquipmentType.EquipTypeIsTranspPlngNotRlvt AS EquipTypeIsTranspPlngNotRlvt,
  _EquipmentType.TranspMeansOfTransport AS TranspMeansOfTransport,
  _EquipmentType.ResourceMaximumLoadWeight AS ResourceMaximumLoadWeight,
  _EquipmentType.ResourceMaximumLoadWeightUnit AS ResourceMaximumLoadWeightUnit,
  _EquipmentType.ResourceCubicCapacity AS ResourceCubicCapacity,
  _EquipmentType.ResourceCubicCapacityUnit AS ResourceCubicCapacityUnit,
  _EquipmentType.ResourceInteriorLength AS ResourceInteriorLength,
  _EquipmentType.ResourceInteriorWidth AS ResourceInteriorWidth,
  _EquipmentType.ResourceInteriorHeight AS ResourceInteriorHeight,
  _EquipmentType.ResourceInteriorLengthUnit AS ResourceInteriorLengthUnit,
  _EquipmentType.RsceAddlCapNmbrOfUnits AS RsceAddlCapNmbrOfUnits,
  _EquipmentType.RsceAddlCapNmbrOfUnitsUnit AS RsceAddlCapNmbrOfUnitsUnit,
  _EquipmentType.RsceAddlCapAltvNmbrOfUnits AS RsceAddlCapAltvNmbrOfUnits,
  _EquipmentType.RsceAddlCapAltvNmbrOfUnitsUnit AS RsceAddlCapAltvNmbrOfUnitsUnit,
  _EquipmentType.ResourceMaximumGrossWeight AS ResourceMaximumGrossWeight,
  _EquipmentType.ResourceMaximumGrossWeightUnit AS ResourceMaximumGrossWeightUnit,
  _EquipmentType.ResourceTareWeight AS ResourceTareWeight,
  _EquipmentType.ResourceTareWeightUnit AS ResourceTareWeightUnit,
  _EquipmentType.ResourceTareVolume AS ResourceTareVolume,
  _EquipmentType.ResourceTareVolumeUnit AS ResourceTareVolumeUnit,
  _EquipmentType.TwentyFootEquivUnitCapacity AS TwentyFootEquivUnitCapacity,
  _EquipmentType.ResourceIsTemperatureCtrld AS ResourceIsTemperatureCtrld,
  _EquipmentType.ResourceMinCtrlTemperature AS ResourceMinCtrlTemperature,
  _EquipmentType.ResourceMaxCtrlTemperature AS ResourceMaxCtrlTemperature,
  _EquipmentType.ResourceCtrlTemperatureUnit AS ResourceCtrlTemperatureUnit,
  _EquipmentType.ResourceIsVentilated AS ResourceIsVentilated,
  _EquipmentType.ResourceULDClassification AS ResourceULDClassification,
  _EquipmentType.ResourceIsIATACompliant AS ResourceIsIATACompliant,
  _EquipmentType.RsceULDNumberIsToBeChecked AS RsceULDNumberIsToBeChecked,
  _EquipmentType.RsceULDLoadingInstruction AS RsceULDLoadingInstruction,
  _EquipmentType.ResourceMaximumLength AS ResourceMaximumLength,
  _EquipmentType.ResourceMaximumWidth AS ResourceMaximumWidth,
  _EquipmentType.ResourceMaximumHeight AS ResourceMaximumHeight,
  _EquipmentType.ResourceMaximumLengthUnit AS ResourceMaximumLengthUnit,
  _EquipmentType.ResourcePlatformHeight AS ResourcePlatformHeight,
  _EquipmentType.ResourcePlatformHeightUnit AS ResourcePlatformHeightUnit,
  _EquipmentType.ResourceTopDeckHeight AS ResourceTopDeckHeight,
  _EquipmentType.ResourceTopDeckHeightUnit AS ResourceTopDeckHeightUnit,
  _EquipmentType.ResourceWheelDiameter AS ResourceWheelDiameter,
  _EquipmentType.ResourceWheelDiameterUnit AS ResourceWheelDiameterUnit,
  _EquipmentType.ResourceDoorWidth AS ResourceDoorWidth,
  _EquipmentType.ResourceDoorHeight AS ResourceDoorHeight,
  _EquipmentType.ResourceDoorLengthUnit AS ResourceDoorLengthUnit,
  _EquipmentType.RsceLoadOpeningLength AS RsceLoadOpeningLength,
  _EquipmentType.RsceLoadOpeningWidth AS RsceLoadOpeningWidth,
  _EquipmentType.RsceLoadOpeningLengthUnit AS RsceLoadOpeningLengthUnit,
  _EquipmentType.NumberOfAxles AS NumberOfAxles,
  _EquipmentType.ResourceAxleSpaceDistance AS ResourceAxleSpaceDistance,
  _EquipmentType.ResourceAxleSpaceDistanceUnit AS ResourceAxleSpaceDistanceUnit,
  _EquipmentType.ResourceMaxAxleWeight AS ResourceMaxAxleWeight,
  _EquipmentType.ResourceMaxAxleWeightUnit AS ResourceMaxAxleWeightUnit,
  _EquipmentType.ResourceCouplerStyle AS ResourceCouplerStyle,
  _EquipmentType.ResourceWheelBearingType AS ResourceWheelBearingType,
  _EquipmentType.ResourceDraftGearType AS ResourceDraftGearType,
  _EquipmentType.ResourceCargoBodyDistance AS ResourceCargoBodyDistance,
  _EquipmentType.ResourceConnectorDistance AS ResourceConnectorDistance,
  _EquipmentType.ResourceConnectorMaxWeight AS ResourceConnectorMaxWeight,
  _EquipmentType.ResourceKingpinDistance AS ResourceKingpinDistance,
  _EquipmentType.ResourceKingpinMaxWeight AS ResourceKingpinMaxWeight,
  _EquipmentType.ResourceSplitDeckDistance AS ResourceSplitDeckDistance,
  _EquipmentType.ResourceSplitDeckMaxWeight AS ResourceSplitDeckMaxWeight,
  _EquipmentType.ResourceTechnicalDistanceUnit AS ResourceTechnicalDistanceUnit,
  _EquipmentType.ResourceLoadWeightUnit AS ResourceLoadWeightUnit,
  _EquipmentType.RsceMaxTrailingLoadWeight AS RsceMaxTrailingLoadWeight,
  _EquipmentType.RsceMaxTrailingLoadWeightUnit AS RsceMaxTrailingLoadWeightUnit,
  _EquipmentType.ResourceIsUsableForFood AS ResourceIsUsableForFood,
  _EquipmentType.VehicleLoadingProfile AS VehicleLoadingProfile,
  _EquipmentType.AttachedEquipmentProfile AS AttachedEquipmentProfile,
  _EquipmentType.ResourceAxleGroup1Type AS ResourceAxleGroup1Type,
  _EquipmentType.RsceAxleGroup1SpaceDistance AS RsceAxleGroup1SpaceDistance,
  _EquipmentType.RsceAxleGroup1Distance AS RsceAxleGroup1Distance,
  _EquipmentType.ResourceAxleGroup1DistanceUnit AS ResourceAxleGroup1DistanceUnit,
  _EquipmentType.RsceAxleGroup1MaximumWeight AS RsceAxleGroup1MaximumWeight,
  _EquipmentType.RsceAxleGroup1EmptyWeight AS RsceAxleGroup1EmptyWeight,
  _EquipmentType.RsceAxleGroup1WeightUnit AS RsceAxleGroup1WeightUnit,
  _EquipmentType.RsceAxleGroup1IsDrivingAxle AS RsceAxleGroup1IsDrivingAxle,
  _EquipmentType.RsceAxleGroup1IsSteeringAxle AS RsceAxleGroup1IsSteeringAxle,
  _EquipmentType.ResourceAxleGroup2Type AS ResourceAxleGroup2Type,
  _EquipmentType.RsceAxleGroup2SpaceDistance AS RsceAxleGroup2SpaceDistance,
  _EquipmentType.RsceAxleGroup2Distance AS RsceAxleGroup2Distance,
  _EquipmentType.ResourceAxleGroup2DistanceUnit AS ResourceAxleGroup2DistanceUnit,
  _EquipmentType.RsceAxleGroup2MaximumWeight AS RsceAxleGroup2MaximumWeight,
  _EquipmentType.RsceAxleGroup2EmptyWeight AS RsceAxleGroup2EmptyWeight,
  _EquipmentType.RsceAxleGroup2WeightUnit AS RsceAxleGroup2WeightUnit,
  _EquipmentType.RsceAxleGroup2IsDrivingAxle AS RsceAxleGroup2IsDrivingAxle,
  _EquipmentType.RsceAxleGroup2IsSteeringAxle AS RsceAxleGroup2IsSteeringAxle,
  _EquipmentType.ResourceAxleGroup3Type AS ResourceAxleGroup3Type,
  _EquipmentType.RsceAxleGroup3SpaceDistance AS RsceAxleGroup3SpaceDistance,
  _EquipmentType.RsceAxleGroup3Distance AS RsceAxleGroup3Distance,
  _EquipmentType.ResourceAxleGroup3DistanceUnit AS ResourceAxleGroup3DistanceUnit,
  _EquipmentType.RsceAxleGroup3MaximumWeight AS RsceAxleGroup3MaximumWeight,
  _EquipmentType.RsceAxleGroup3EmptyWeight AS RsceAxleGroup3EmptyWeight,
  _EquipmentType.RsceAxleGroup3WeightUnit AS RsceAxleGroup3WeightUnit,
  _EquipmentType.RsceAxleGroup3IsDrivingAxle AS RsceAxleGroup3IsDrivingAxle,
  _EquipmentType.RsceAxleGroup3IsSteeringAxle AS RsceAxleGroup3IsSteeringAxle,
  _EquipmentType.ResourceTypeClassification AS ResourceTypeClassification,
  _EquipmentType.PackagingMaterialName AS PackagingMaterialName,
  _EquipmentType.ResourcePictureURL AS ResourcePictureURL,
  _EquipmentType.ResourceCompartmentProfile AS ResourceCompartmentProfile,
  _EquipmentType.ResourceIsCombinationResource AS ResourceIsCombinationResource,
  _EquipmentType.EquipmentTypeIsDeleted AS EquipmentTypeIsDeleted,
  _MeansOfTransport.TransportationMode AS TransportationMode,
  _MeansOfTransport.MeansOfTransportIsPassive AS MeansOfTransportIsPassive,
  _EquipmentGroup.ResourceClass AS ResourceClass,
  _EquipmentGroup._ResourceClass.ResourceType AS ResourceType,
  _EquipmentType._EquipmentTypeText[1: Language = $session.system_language ].EquipmentTypeDesc AS EquipmentTypeDesc,
  _EquipmentGroup._EquipmentGroupText AS _EquipmentGroupText,
  _MeansOfTransport._TransportationMode AS _TransportationMode
FROM I_EquipmentGroupClassification AS _EquipmentGroup
INNER JOIN I_EquipmentType AS _EquipmentType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MeansOfTransport AS _MeansOfTransport ON /* join condition not captured in parsed metadata */
;

Learn More