I_ResourceTransp

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_ResourceTransp.
-- 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: IRESOURCETP

CREATE VIEW I_ResourceTransp AS
SELECT
  tmsresuid AS ResourceAdditionalUUID,
  resid AS ResourceUUID,
  name AS ResourceID,
  restype AS ResourceType,
  owner AS ResourceOwner,
  owneruid AS ResourceOwnerUUID,
  entitled AS ResourceEntitledUser,
  entitleduid AS ResourceEntitledUserUUID,
  orgcentre AS ResourceOrganizationalCenter,
  platenumber AS RsceRegistrationNumber,
  platecountry AS RsceRegistrationNumberCountry,
  ext_ttype_flg AS IsMultiResource,
  ext_ttype_num AS NumberOfResources,
  minreqseals AS ResourceMinNumberOfRqdSeals,
  builddate AS ResourceBuildDate,
  inservicedate AS ResourceInServiceDate,
  cast (refmatid as /scmb/mdl_matid preserving type) AS ResourcePackagingMaterialUUID,
  valid_from AS ResourceValidityStartDateTime,
  valid_to AS ResourceValidityEndDateTime,
  dflt_driver AS ResourceDefaultDriver,
  dflt_driver_uid AS ResourceDefaultDriverUUID,
  dflt_trailer AS ResourceDefaultTrailer,
  dflt_trailer_uid AS ResourceDefaultTrailerUUID,
  res_class AS ResourceClass,
  em_relevance AS ResourceIsRelevantForEvtMgmt,
  type_class AS ResourceTypeClassification,
  shipper_owned AS ResourceIsShipperOwned,
  adr_limit_rel AS RsceIsDngrsGdsPtsLimitRlvt,
  pln_block AS RscePlanningBlockReason,
  ownership_code AS ResourceOwnership,
  lease_contract_ref AS ResourceLeaseContractRef,
  resource_condition AS ResourceCondition,
  special_instruction AS ResourceSpecialInstruction,
  cmprofile AS ResourceCompartmentProfile,
  res_spec_cmprofile AS CompartmentPrflIsRsceSpecific,
  comb_res AS ResourceIsCombinationResource,
  equitype AS EquipmentGroup,
  equisztp AS EquipmentType,
  equisuppl AS EquipmentSupplier,
  country_vehic_id AS RsceCntrySpcfcRegnNumber,
  payload_weight AS ResourceMaximumLoadWeight,
  payload_wght_uom AS ResourceMaximumLoadWeightUnit,
  cubic_capacity AS ResourceCapacity,
  cubic_capa_uom AS ResourceCapacityUnit,
  internal_length AS ResourceInteriorLength,
  internal_width AS ResourceInteriorWidth,
  internal_height AS ResourceInteriorHeight,
  internal_lwh_uom AS ResourceInteriorLengthUnit,
  quan_units AS RsceAddlCapNmbrOfUnits,
  cast (quan_units_uom as /scmb/quan_units_uom preserving type) AS RsceAddlCapNmbrOfUnitsUnit,
  alt_quan_units AS RsceAddlCapAltvNmbrOfUnits,
  cast (alt_quan_units_uom as /scmb/quan_units_uom_2 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,
  temp_control AS ResourceIsTemperatureCtrld,
  temp_ctrl_min AS ResourceMinCtrlTemperature,
  temp_ctrl_max AS ResourceMaxCtrlTemperature,
  temp_uom AS ResourceCtrlTemperatureUnit,
  ventilated AS ResourceIsVentilated,
  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,
  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,
  door_width AS ResourceDoorWidth,
  door_height AS ResourceDoorHeight,
  door_wh_uom AS ResourceDoorLengthUnit,
  iata_compliant AS ResourceIsIATACompliant,
  valdiate_uld_number AS RsceULDNumberIsToBeChecked,
  uld_loading_instructions AS RsceULDLoadingInstruction,
  load_opening_length AS RsceLoadOpeningLength,
  load_opening_width AS RsceLoadOpeningWidth,
  load_opening_lw_uom AS RsceLoadOpeningLengthUnit,
  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
FROM /scmb/restmshd
;