I_EquipmentType

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_EquipmentType.
-- 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: IEQUIPMENTTYPE

CREATE VIEW I_EquipmentType AS
SELECT
  EquipmentType.equi_type AS EquipmentGroup,
  EquipmentType.equi_code AS EquipmentType,
  equi_type_res_guid AS ResourceAdditionalUUID,
  ttype AS TranspMeansOfTransport,
  reduced_planning_scope AS EquipTypeIsTranspPlngNotRlvt,
  payload_weight AS ResourceMaximumLoadWeight,
  payload_wght_uom AS ResourceMaximumLoadWeightUnit,
  cubic_capacity AS ResourceCubicCapacity,
  cubic_capa_uom AS ResourceCubicCapacityUnit,
  internal_length AS ResourceInteriorLength,
  internal_width AS ResourceInteriorWidth,
  internal_height AS ResourceInteriorHeight,
  cast(internal_lwh_uom as /scmb/splr_base_uom preserving type ) AS ResourceInteriorLengthUnit,
  quan_units AS RsceAddlCapNmbrOfUnits,
  cast(quan_units_uom as /scmb/splr_base_uom preserving type ) AS RsceAddlCapNmbrOfUnitsUnit,
  alt_quan_units AS RsceAddlCapAltvNmbrOfUnits,
  cast(alt_quan_units_uom as /scmb/splr_base_uom preserving type ) AS RsceAddlCapAltvNmbrOfUnitsUnit,
  max_gross_weight AS ResourceMaximumGrossWeight,
  max_gross_weight_uom AS ResourceMaximumGrossWeightUnit,
  tare_weight AS ResourceTareWeight,
  tare_weight_uom AS ResourceTareWeightUnit,
  tare_volume AS ResourceTareVolume,
  tare_volume_uom AS ResourceTareVolumeUnit,
  teu_count AS TwentyFootEquivUnitCapacity,
  temp_control AS ResourceIsTemperatureCtrld,
  temp_ctrl_min AS ResourceMinCtrlTemperature,
  temp_ctrl_max AS ResourceMaxCtrlTemperature,
  temp_uom AS ResourceCtrlTemperatureUnit,
  ventilated AS ResourceIsVentilated,
  uld_class AS ResourceULDClassification,
  iata_compliant AS ResourceIsIATACompliant,
  valdiate_uld_number AS RsceULDNumberIsToBeChecked,
  uld_loading_instructions AS RsceULDLoadingInstruction,
  max_length AS ResourceMaximumLength,
  max_width AS ResourceMaximumWidth,
  max_height AS ResourceMaximumHeight,
  max_lwh_uom AS ResourceMaximumLengthUnit,
  platform_height AS ResourcePlatformHeight,
  platform_height_uom AS ResourcePlatformHeightUnit,
  topdeck_height AS ResourceTopDeckHeight,
  topdeck_height_uom AS ResourceTopDeckHeightUnit,
  wheel_diameter AS ResourceWheelDiameter,
  wheel_diameter_uom AS ResourceWheelDiameterUnit,
  door_width AS ResourceDoorWidth,
  door_height AS ResourceDoorHeight,
  door_wh_uom AS ResourceDoorLengthUnit,
  load_opening_length AS RsceLoadOpeningLength,
  load_opening_width AS RsceLoadOpeningWidth,
  load_opening_lw_uom AS RsceLoadOpeningLengthUnit,
  axle_count AS NumberOfAxles,
  axle_spacng_dist AS ResourceAxleSpaceDistance,
  axle_spacng_dist_uom AS ResourceAxleSpaceDistanceUnit,
  max_axle_weight AS ResourceMaxAxleWeight,
  max_axle_weight_uom AS ResourceMaxAxleWeightUnit,
  couplerstyle AS ResourceCouplerStyle,
  wheel_bearng_type AS ResourceWheelBearingType,
  draft_gear_type AS ResourceDraftGearType,
  cargo_body_dist AS ResourceCargoBodyDistance,
  connector_dist AS ResourceConnectorDistance,
  connector_max_wght AS ResourceConnectorMaxWeight,
  kingpin_dist AS ResourceKingpinDistance,
  kingpin_max_wght AS ResourceKingpinMaxWeight,
  splitdeck_posn AS ResourceSplitDeckDistance,
  splitdeck_max_wght AS ResourceSplitDeckMaxWeight,
  techn_dist_uom AS ResourceTechnicalDistanceUnit,
  wght_loading_uom AS ResourceLoadWeightUnit,
  max_trailing_load AS RsceMaxTrailingLoadWeight,
  max_trail_load_uom AS RsceMaxTrailingLoadWeightUnit,
  food_grade_ind AS ResourceIsUsableForFood,
  vehloadprofile AS VehicleLoadingProfile,
  attequiprofile AS AttachedEquipmentProfile,
  axle_type_01 AS ResourceAxleGroup1Type,
  axle_space_dist_01 AS RsceAxleGroup1SpaceDistance,
  axgrp_posn_01 AS RsceAxleGroup1Distance,
  axgrp_dist_uom_01 AS ResourceAxleGroup1DistanceUnit,
  axgrp_max_weight_01 AS RsceAxleGroup1MaximumWeight,
  axgrp_empty_weight_01 AS RsceAxleGroup1EmptyWeight,
  axgrp_weight_uom_01 AS RsceAxleGroup1WeightUnit,
  axle_driving_ind_01 AS RsceAxleGroup1IsDrivingAxle,
  axle_steering_ind_01 AS RsceAxleGroup1IsSteeringAxle,
  axle_type_02 AS ResourceAxleGroup2Type,
  axle_space_dist_02 AS RsceAxleGroup2SpaceDistance,
  axgrp_posn_02 AS RsceAxleGroup2Distance,
  axgrp_dist_uom_02 AS ResourceAxleGroup2DistanceUnit,
  axgrp_max_weight_02 AS RsceAxleGroup2MaximumWeight,
  axgrp_empty_weight_02 AS RsceAxleGroup2EmptyWeight,
  axgrp_weight_uom_02 AS RsceAxleGroup2WeightUnit,
  axle_driving_ind_02 AS RsceAxleGroup2IsDrivingAxle,
  axle_steering_ind_02 AS RsceAxleGroup2IsSteeringAxle,
  axle_type_03 AS ResourceAxleGroup3Type,
  axle_space_dist_03 AS RsceAxleGroup3SpaceDistance,
  axgrp_posn_03 AS RsceAxleGroup3Distance,
  axgrp_dist_uom_03 AS ResourceAxleGroup3DistanceUnit,
  axgrp_max_weight_03 AS RsceAxleGroup3MaximumWeight,
  axgrp_empty_weight_03 AS RsceAxleGroup3EmptyWeight,
  axgrp_weight_uom_03 AS RsceAxleGroup3WeightUnit,
  axle_driving_ind_03 AS RsceAxleGroup3IsDrivingAxle,
  axle_steering_ind_03 AS RsceAxleGroup3IsSteeringAxle,
  co2e_emi_factor_emp_load AS EmptyRsceCrbnDioxideEmsnsQty,
  co2e_emi_factor_full_load AS FullRsceCrbnDioxideEmsnsQty,
  co2e_emi_factor_dist_uni AS RsceCrbnDioxideEmsnsDstncUnit,
  co2e_emi_factor_wgth_uni AS RsceCrbnDioxideEmsnsWeightUnit,
  type_class AS ResourceTypeClassification,
  packmatnr AS PackagingMaterialName,
  pic_url AS ResourcePictureURL,
  cmprofile AS ResourceCompartmentProfile,
  comb_res AS ResourceIsCombinationResource,
  deletion_flag AS EquipmentTypeIsDeleted
FROM /scmb/equi_code AS EquipmentType
LEFT OUTER JOIN I_EquipmentGroup AS _EquipmentGroup ON EquipmentGroup = _EquipmentGroup.EquipmentGroup  -- association [0..1]
LEFT OUTER JOIN I_EquipmentTypeText AS _EquipmentTypeText ON EquipmentGroup = _EquipmentTypeText.EquipmentGroup AND EquipmentType = _EquipmentTypeText.EquipmentType  -- association [0..*]
;