/SCMTMS/CV_EquipResourceRoot

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_EquipResourceRoot.
-- 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_RSEQR

CREATE VIEW /SCMTMS/CV_EquipResourceRoot AS
SELECT
  _Resource.tmsresuid AS tmsresuid,
  _Resource.res_id AS res_id,
  _Resource.resuid AS resuid,
  '' AS IS_EQUI_TYPE_RES,
  _Resource.restype AS restype,
  _Resource.TZONE AS TZONE,
  _Resource.WORKCAL_CODE AS WORKCAL_CODE,
  _Resource.OWNER AS OWNER,
  _Resource.OWNERUID AS OWNERUID,
  _Resource.ENTITLED AS ENTITLED,
  _Resource.ENTITLEDUID AS ENTITLEDUID,
  _Resource.COSTCENTRE AS COSTCENTRE,
  _Resource.PLATENUMBER AS PLATENUMBER,
  _Resource.PLATECOUNTRY AS PLATECOUNTRY,
  _Resource.MULTI_RES_FLG AS MULTI_RES_FLG,
  _Resource.NUMBER_MULTI AS NUMBER_MULTI,
  _Resource.MINREQSEALS AS MINREQSEALS,
  _Resource.MTRTCO062_I AS MTRTCO062_I,
  _Resource.TRATY_PASSIVE AS TRATY_PASSIVE,
  _Resource.TRMODCODE AS TRMODCODE,
  _Resource.BUILDDATE AS BUILDDATE,
  _Resource.INSERVICEDATE AS INSERVICEDATE,
  _Resource.HOMELOCATION AS HOMELOCATION,
  _Resource.REFMAT AS REFMAT,
  _Resource.REFMATID AS REFMATID,
  _Resource.VALID_FROM AS VALID_FROM,
  _Resource.VALID_TO AS VALID_TO,
  _Resource.DFLT_DRIVER AS DFLT_DRIVER,
  _Resource.DFLT_DRIVER_UID AS DFLT_DRIVER_UID,
  _Resource.DFLT_TRAILER AS DFLT_TRAILER,
  _Resource.DFLT_TRAILER_UID AS DFLT_TRAILER_UID,
  _Resource.INT_ORG_ID AS INT_ORG_ID,
  _Resource.LOCK_MULTIRES AS LOCK_MULTIRES,
  _Resource.RES_CLASS AS RES_CLASS,
  _Resource.DESCRIPTION AS DESCRIPTION,
  _Resource.EM_RELEVANCE AS EM_RELEVANCE,
  _Resource.TYPE_CLASS AS TYPE_CLASS,
  _Resource.SHIPPER_OWNED AS SHIPPER_OWNED,
  _Resource.ADR_LIMIT_REL AS ADR_LIMIT_REL,
  _Resource.LOCATION AS LOCATION,
  _Resource.PLN_BLOCK AS PLN_BLOCK,
  _Resource.OWNERSHIP_CODE AS OWNERSHIP_CODE,
  _Resource.LEASE_CONTRACT_REF AS LEASE_CONTRACT_REF,
  _Resource.RESOURCE_CONDITION AS RESOURCE_CONDITION,
  _Resource.SPECIAL_INSTRUCTION AS SPECIAL_INSTRUCTION,
  _Resource.CMPROFILE AS CMPROFILE,
  _Resource.RES_SPEC_CMPROFILE AS RES_SPEC_CMPROFILE,
  _Resource.COMB_RES AS COMB_RES,
  _Resource.CHANGED_BY AS CHANGED_BY,
  _Resource.CHANGED_ON AS CHANGED_ON,
  _Resource.EQUITYPE AS EQUITYPE,
  _Resource.EQUISZTP AS EQUISZTP,
  _Resource.EQUISUPPL AS EQUISUPPL,
  _Resource.COUNTRY_VEHIC_ID AS COUNTRY_VEHIC_ID,
  _Resource.PAYLOAD_WEIGHT AS PAYLOAD_WEIGHT,
  _Resource.PAYLOAD_WGHT_UOM AS PAYLOAD_WGHT_UOM,
  _Resource.CUBIC_CAPACITY AS CUBIC_CAPACITY,
  _Resource.CUBIC_CAPA_UOM AS CUBIC_CAPA_UOM,
  _Resource.INTERNAL_LENGTH AS INTERNAL_LENGTH,
  _Resource.INTERNAL_WIDTH AS INTERNAL_WIDTH,
  _Resource.INTERNAL_HEIGHT AS INTERNAL_HEIGHT,
  _Resource.INTERNAL_LWH_UOM AS INTERNAL_LWH_UOM,
  _Resource.QUAN_UNITS AS QUAN_UNITS,
  _Resource.QUAN_UNITS_UOM AS QUAN_UNITS_UOM,
  _Resource.ALT_QUAN_UNITS AS ALT_QUAN_UNITS,
  _Resource.ALT_QUAN_UNITS_UOM AS ALT_QUAN_UNITS_UOM,
  _Resource.MAX_GROSS_WEIGHT AS MAX_GROSS_WEIGHT,
  _Resource.MAX_GROSS_WEIGHT_UOM AS MAX_GROSS_WEIGHT_UOM,
  _Resource.TARE_WEIGHT AS TARE_WEIGHT,
  _Resource.TARE_WEIGHT_UOM AS TARE_WEIGHT_UOM,
  _Resource.TARE_VOLUME AS TARE_VOLUME,
  _Resource.TARE_VOLUME_UOM AS TARE_VOLUME_UOM,
  _Resource.TEMP_CONTROL AS TEMP_CONTROL,
  _Resource.TEMP_CTRL_MIN AS TEMP_CTRL_MIN,
  _Resource.TEMP_CTRL_MAX AS TEMP_CTRL_MAX,
  _Resource.TEMP_UOM AS TEMP_UOM,
  _Resource.VENTILATED AS VENTILATED,
  _Resource.MAX_LENGTH AS MAX_LENGTH,
  _Resource.MAX_WIDTH AS MAX_WIDTH,
  _Resource.MAX_HEIGHT AS MAX_HEIGHT,
  _Resource.MAX_LWH_UOM AS MAX_LWH_UOM,
  _Resource.PLATFORM_HEIGHT AS PLATFORM_HEIGHT,
  _Resource.PLATFORM_HEIGHT_UOM AS PLATFORM_HEIGHT_UOM,
  _Resource.TOPDECK_HEIGHT AS TOPDECK_HEIGHT,
  _Resource.TOPDECK_HEIGHT_UOM AS TOPDECK_HEIGHT_UOM,
  _Resource.WHEEL_DIAMETER AS WHEEL_DIAMETER,
  _Resource.WHEEL_DIAMETER_UOM AS WHEEL_DIAMETER_UOM,
  _Resource.AXLE_COUNT AS AXLE_COUNT,
  _Resource.AXLE_SPACNG_DIST AS AXLE_SPACNG_DIST,
  _Resource.AXLE_SPACNG_DIST_UOM AS AXLE_SPACNG_DIST_UOM,
  _Resource.MAX_AXLE_WEIGHT AS MAX_AXLE_WEIGHT,
  _Resource.MAX_AXLE_WEIGHT_UOM AS MAX_AXLE_WEIGHT_UOM,
  _Resource.COUPLERSTYLE AS COUPLERSTYLE,
  _Resource.WHEEL_BEARNG_TYPE AS WHEEL_BEARNG_TYPE,
  _Resource.DRAFT_GEAR_TYPE AS DRAFT_GEAR_TYPE,
  _Resource.CARGO_BODY_DIST AS CARGO_BODY_DIST,
  _Resource.CONNECTOR_DIST AS CONNECTOR_DIST,
  _Resource.CONNECTOR_MAX_WGHT AS CONNECTOR_MAX_WGHT,
  _Resource.KINGPIN_DIST AS KINGPIN_DIST,
  _Resource.KINGPIN_MAX_WGHT AS KINGPIN_MAX_WGHT,
  _Resource.SPLITDECK_POSN AS SPLITDECK_POSN,
  _Resource.SPLITDECK_MAX_WGHT AS SPLITDECK_MAX_WGHT,
  _Resource.TECHN_DIST_UOM AS TECHN_DIST_UOM,
  _Resource.WGHT_LOADING_UOM AS WGHT_LOADING_UOM,
  _Resource.MAX_TRAILING_LOAD AS MAX_TRAILING_LOAD,
  _Resource.MAX_TRAIL_LOAD_UOM AS MAX_TRAIL_LOAD_UOM,
  _Resource.FOOD_GRADE_IND AS FOOD_GRADE_IND,
  _Resource.VEHLOADPROFILE AS VEHLOADPROFILE,
  _Resource.ATTEQUIPROFILE AS ATTEQUIPROFILE,
  _Resource.AXLE_TYPE_01 AS AXLE_TYPE_01,
  _Resource.AXLE_SPACE_DIST_01 AS AXLE_SPACE_DIST_01,
  _Resource.AXGRP_POSN_01 AS AXGRP_POSN_01,
  _Resource.AXGRP_DIST_UOM_01 AS AXGRP_DIST_UOM_01,
  _Resource.AXGRP_MAX_WEIGHT_01 AS AXGRP_MAX_WEIGHT_01,
  _Resource.AXGRP_EMPTY_WEIGHT_01 AS AXGRP_EMPTY_WEIGHT_01,
  _Resource.AXGRP_WEIGHT_UOM_01 AS AXGRP_WEIGHT_UOM_01,
  _Resource.AXLE_DRIVING_IND_01 AS AXLE_DRIVING_IND_01,
  _Resource.AXLE_STEERING_IND_01 AS AXLE_STEERING_IND_01,
  _Resource.AXLE_TYPE_02 AS AXLE_TYPE_02,
  _Resource.AXLE_SPACE_DIST_02 AS AXLE_SPACE_DIST_02,
  _Resource.AXGRP_POSN_02 AS AXGRP_POSN_02,
  _Resource.AXGRP_DIST_UOM_02 AS AXGRP_DIST_UOM_02,
  _Resource.AXGRP_MAX_WEIGHT_02 AS AXGRP_MAX_WEIGHT_02,
  _Resource.AXGRP_EMPTY_WEIGHT_02 AS AXGRP_EMPTY_WEIGHT_02,
  _Resource.AXGRP_WEIGHT_UOM_02 AS AXGRP_WEIGHT_UOM_02,
  _Resource.AXLE_DRIVING_IND_02 AS AXLE_DRIVING_IND_02,
  _Resource.AXLE_STEERING_IND_02 AS AXLE_STEERING_IND_02,
  _Resource.AXLE_TYPE_03 AS AXLE_TYPE_03,
  _Resource.AXLE_SPACE_DIST_03 AS AXLE_SPACE_DIST_03,
  _Resource.AXGRP_POSN_03 AS AXGRP_POSN_03,
  _Resource.AXGRP_DIST_UOM_03 AS AXGRP_DIST_UOM_03,
  _Resource.AXGRP_MAX_WEIGHT_03 AS AXGRP_MAX_WEIGHT_03,
  _Resource.AXGRP_EMPTY_WEIGHT_03 AS AXGRP_EMPTY_WEIGHT_03,
  _Resource.AXGRP_WEIGHT_UOM_03 AS AXGRP_WEIGHT_UOM_03,
  _Resource.AXLE_DRIVING_IND_03 AS AXLE_DRIVING_IND_03,
  _Resource.AXLE_STEERING_IND_03 AS ResourceAdditionalUUIDasTMSRESUID,
  _EquipmentType.RsceAxleGroup3IsSteeringAxle AS AXLE_STEERING_IND_03
FROM /SCMTMS/CV_ResourceRoot AS _Resource
-- UNION with additional select branch(es): /SCMTMS/CV_EquipmentRoot
;