/SCMTMS/CV_ResourceRoot

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_ResourceRoot.
-- 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_RESRT

CREATE VIEW /SCMTMS/CV_ResourceRoot AS
SELECT
  _ResourceTransp.ResourceAdditionalUUID AS TMSRESUID,
  _ResourceTransp.ResourceID AS RES_ID,
  _ResourceTransp.ResourceUUID AS RESUID,
  _ResourceTransp.ResourceType AS RESTYPE,
  _ResourceBasicEnh.ResourceTimeZone AS TZONE,
  _ResourceBasicEnh.ResourceFactoryCalendar AS WORKCAL_CODE,
  _ResourceTransp.ResourceOwner AS OWNER,
  _ResourceTransp.ResourceOwnerUUID AS OWNERUID,
  _ResourceTransp.ResourceEntitledUser AS ENTITLED,
  _ResourceTransp.ResourceEntitledUserUUID AS ENTITLEDUID,
  _ResourceTransp.ResourceOrganizationalCenter AS COSTCENTRE,
  _ResourceTransp.RsceRegistrationNumber AS PLATENUMBER,
  _ResourceTransp.RsceRegistrationNumberCountry AS PLATECOUNTRY,
  _ResourceTransp.IsMultiResource AS MULTI_RES_FLG,
  cast ( _ResourceTransp.NumberOfResources as abap.dec(13)) AS NUMBER_MULTI,
  _ResourceTransp.ResourceMinNumberOfRqdSeals AS MINREQSEALS,
  _ResourceBasicEnh.TransportMeansType AS MTRTCO062_I,
  _ResourceBasicEnh.IsPassiveResource AS TRATY_PASSIVE,
  _ResourceBasicEnh.TransportationMode AS TRMODCODE,
  _ResourceTransp.ResourceBuildDate AS BUILDDATE,
  _ResourceTransp.ResourceInServiceDate AS INSERVICEDATE,
  _ResourceBasicEnh.LocationAdditionalUUID AS HOMELOCATION,
  cast (_Product.matnr as /scmtms/product_id) AS REFMAT,
  cast (_Product.scm_matid_guid16 as /scmtms/uuid_id) AS REFMATID,
  case TSTMP_TO_DATS(_ResourceTransp.ResourceValidityEndDateTime, 'UTC', $session.client, 'INITIAL') when '99991231' then _ResourceTransp.ResourceValidityEndDateTime else DATS_TIMS_TO_TSTMP( TSTMP_TO_DATS(_ResourceTransp.ResourceValidityEndDateTime, 'UTC', $session.client, 'INITIAL'), TSTMP_TO_TIMS(_ResourceTransp.ResourceValidityEndDateTime, 'UTC', $session.client, 'INITIAL'), _ResourceBasicEnh.ResourceTimeZone, $session.client, 'NULL' ) end as VALID_TO AS clientNULLendasVALID_TO,
  DATS_TIMS_TO_TSTMP( TSTMP_TO_DATS(_ResourceTransp.ResourceValidityStartDateTime, 'UTC', $session.client, 'INITIAL'), TSTMP_TO_TIMS(_ResourceTransp.ResourceValidityStartDateTime, 'UTC', $session.client, 'INITIAL'), _ResourceBasicEnh.ResourceTimeZone, $session.client, 'NULL' ) as VALID_FROM AS clientNULLasVALID_FROM,
  _ResourceTransp.ResourceDefaultDriver AS DFLT_DRIVER,
  _ResourceTransp.ResourceDefaultDriverUUID AS DFLT_DRIVER_UID,
  _ResourceTransp.ResourceDefaultTrailer AS DFLT_TRAILER,
  _ResourceTransp.ResourceDefaultTrailerUUID AS DFLT_TRAILER_UID,
  _ResourceTransp.ResourceOrganizationalCenter AS INT_ORG_ID,
  _ResourceBasicEnh.MultiResourceIsLocked AS LOCK_MULTIRES,
  _ResourceTransp.ResourceClass AS RES_CLASS,
  _ResourceBasicEnh.ResourceName AS DESCRIPTION,
  _ResourceTransp.ResourceIsRelevantForEvtMgmt AS EM_RELEVANCE,
  _ResourceTransp.ResourceTypeClassification AS TYPE_CLASS,
  _ResourceTransp.ResourceIsShipperOwned AS SHIPPER_OWNED,
  _ResourceTransp.RsceIsDngrsGdsPtsLimitRlvt AS ADR_LIMIT_REL,
  _ResourcePosition._LocationBasic.Location AS LOCATION,
  _ResourceTransp.RscePlanningBlockReason AS PLN_BLOCK,
  _ResourceTransp.ResourceOwnership AS OWNERSHIP_CODE,
  _ResourceTransp.ResourceLeaseContractRef AS LEASE_CONTRACT_REF,
  _ResourceTransp.ResourceCondition AS RESOURCE_CONDITION,
  _ResourceTransp.ResourceSpecialInstruction AS SPECIAL_INSTRUCTION,
  case when _ResourceTransp.CompartmentPrflIsRsceSpecific = 'X' then _ResourceTransp.ResourceCompartmentProfile else _ResourceBasicEnh.ResourceCompartmentProfile end as CMPROFILE AS ResourceCompartmentProfileendasCMPROFILE,
  _ResourceTransp.CompartmentPrflIsRsceSpecific AS RES_SPEC_CMPROFILE,
  _ResourceTransp.ResourceIsCombinationResource AS COMB_RES,
  _ResourceBasicEnh.LastChangedByUser AS CHANGED_BY,
  _ResourceBasicEnh.ChangedDateTime AS CHANGED_ON,
  _ResourceTransp.EquipmentGroup AS EQUITYPE,
  _ResourceTransp.EquipmentType AS EQUISZTP,
  _ResourceTransp.EquipmentSupplier AS EQUISUPPL,
  _ResourceTransp.RsceCntrySpcfcRegnNumber AS COUNTRY_VEHIC_ID,
  _ResourceTransp.ResourceMaximumLoadWeight AS PAYLOAD_WEIGHT,
  _ResourceTransp.ResourceMaximumLoadWeightUnit AS PAYLOAD_WGHT_UOM,
  _ResourceTransp.ResourceCapacity AS CUBIC_CAPACITY,
  _ResourceTransp.ResourceCapacityUnit AS CUBIC_CAPA_UOM,
  _ResourceTransp.ResourceInteriorLength AS INTERNAL_LENGTH,
  _ResourceTransp.ResourceInteriorWidth AS INTERNAL_WIDTH,
  _ResourceTransp.ResourceInteriorHeight AS INTERNAL_HEIGHT,
  _ResourceTransp.ResourceInteriorLengthUnit AS INTERNAL_LWH_UOM,
  _ResourceTransp.RsceAddlCapNmbrOfUnits AS QUAN_UNITS,
  _ResourceTransp.RsceAddlCapNmbrOfUnitsUnit AS QUAN_UNITS_UOM,
  _ResourceTransp.RsceAddlCapAltvNmbrOfUnits AS ALT_QUAN_UNITS,
  _ResourceTransp.RsceAddlCapAltvNmbrOfUnitsUnit AS ALT_QUAN_UNITS_UOM,
  _ResourceTransp.ResourceMaximumGrossWeight AS MAX_GROSS_WEIGHT,
  _ResourceTransp.ResourceMaximumGrossWeightUnit AS MAX_GROSS_WEIGHT_UOM,
  _ResourceTransp.ResourceTareWeight AS TARE_WEIGHT,
  _ResourceTransp.ResourceTareWeightUnit AS TARE_WEIGHT_UOM,
  _ResourceTransp.ResourceTareVolume AS TARE_VOLUME,
  _ResourceTransp.ResourceTareVolumeUnit AS TARE_VOLUME_UOM,
  _ResourceTransp.ResourceIsTemperatureCtrld AS TEMP_CONTROL,
  _ResourceTransp.ResourceMinCtrlTemperature AS TEMP_CTRL_MIN,
  _ResourceTransp.ResourceMaxCtrlTemperature AS TEMP_CTRL_MAX,
  _ResourceTransp.ResourceCtrlTemperatureUnit AS TEMP_UOM,
  _ResourceTransp.ResourceIsVentilated AS VENTILATED,
  _ResourceTransp.ResourceMaximumLength AS MAX_LENGTH,
  _ResourceTransp.ResourceMaximumWidth AS MAX_WIDTH,
  _ResourceTransp.ResourceMaximumHeight AS MAX_HEIGHT,
  _ResourceTransp.ResourceMaximumLengthUnit AS MAX_LWH_UOM,
  _ResourceTransp.ResourcePlatformHeight AS PLATFORM_HEIGHT,
  _ResourceTransp.ResourcePlatformHeightUnit AS PLATFORM_HEIGHT_UOM,
  _ResourceTransp.ResourceTopDeckHeight AS TOPDECK_HEIGHT,
  _ResourceTransp.ResourceTopDeckHeightUnit AS TOPDECK_HEIGHT_UOM,
  _ResourceTransp.ResourceWheelDiameter AS WHEEL_DIAMETER,
  _ResourceTransp.ResourceWheelDiameterUnit AS WHEEL_DIAMETER_UOM,
  _ResourceTransp.NumberOfAxles AS AXLE_COUNT,
  _ResourceTransp.ResourceAxleSpaceDistance AS AXLE_SPACNG_DIST,
  _ResourceTransp.ResourceAxleSpaceDistanceUnit AS AXLE_SPACNG_DIST_UOM,
  _ResourceTransp.ResourceMaxAxleWeight AS MAX_AXLE_WEIGHT,
  _ResourceTransp.ResourceMaxAxleWeightUnit AS MAX_AXLE_WEIGHT_UOM,
  _ResourceTransp.ResourceCouplerStyle AS COUPLERSTYLE,
  _ResourceTransp.ResourceWheelBearingType AS WHEEL_BEARNG_TYPE,
  _ResourceTransp.ResourceDraftGearType AS DRAFT_GEAR_TYPE,
  _ResourceTransp.ResourceCargoBodyDistance AS CARGO_BODY_DIST,
  _ResourceTransp.ResourceConnectorDistance AS CONNECTOR_DIST,
  _ResourceTransp.ResourceConnectorMaxWeight AS CONNECTOR_MAX_WGHT,
  _ResourceTransp.ResourceKingpinDistance AS KINGPIN_DIST,
  _ResourceTransp.ResourceKingpinMaxWeight AS KINGPIN_MAX_WGHT,
  _ResourceTransp.ResourceSplitDeckDistance AS SPLITDECK_POSN,
  _ResourceTransp.ResourceSplitDeckMaxWeight AS SPLITDECK_MAX_WGHT,
  _ResourceTransp.ResourceTechnicalDistanceUnit AS TECHN_DIST_UOM,
  _ResourceTransp.ResourceLoadWeightUnit AS WGHT_LOADING_UOM,
  _ResourceTransp.RsceMaxTrailingLoadWeight AS MAX_TRAILING_LOAD,
  _ResourceTransp.RsceMaxTrailingLoadWeightUnit AS MAX_TRAIL_LOAD_UOM,
  _ResourceTransp.ResourceIsUsableForFood AS FOOD_GRADE_IND,
  _ResourceTransp.VehicleLoadingProfile AS VEHLOADPROFILE,
  _ResourceTransp.AttachedEquipmentProfile AS ATTEQUIPROFILE,
  _ResourceTransp.ResourceAxleGroup1Type AS AXLE_TYPE_01,
  _ResourceTransp.RsceAxleGroup1SpaceDistance AS AXLE_SPACE_DIST_01,
  _ResourceTransp.RsceAxleGroup1Distance AS AXGRP_POSN_01,
  _ResourceTransp.ResourceAxleGroup1DistanceUnit AS AXGRP_DIST_UOM_01,
  _ResourceTransp.RsceAxleGroup1MaximumWeight AS AXGRP_MAX_WEIGHT_01,
  _ResourceTransp.RsceAxleGroup1EmptyWeight AS AXGRP_EMPTY_WEIGHT_01,
  _ResourceTransp.RsceAxleGroup1WeightUnit AS AXGRP_WEIGHT_UOM_01,
  _ResourceTransp.RsceAxleGroup1IsDrivingAxle AS AXLE_DRIVING_IND_01,
  _ResourceTransp.RsceAxleGroup1IsSteeringAxle AS AXLE_STEERING_IND_01,
  _ResourceTransp.ResourceAxleGroup2Type AS AXLE_TYPE_02,
  _ResourceTransp.RsceAxleGroup2SpaceDistance AS AXLE_SPACE_DIST_02,
  _ResourceTransp.RsceAxleGroup2Distance AS AXGRP_POSN_02,
  _ResourceTransp.ResourceAxleGroup2DistanceUnit AS AXGRP_DIST_UOM_02,
  _ResourceTransp.RsceAxleGroup2MaximumWeight AS AXGRP_MAX_WEIGHT_02,
  _ResourceTransp.RsceAxleGroup2EmptyWeight AS AXGRP_EMPTY_WEIGHT_02,
  _ResourceTransp.RsceAxleGroup2WeightUnit AS AXGRP_WEIGHT_UOM_02,
  _ResourceTransp.RsceAxleGroup2IsDrivingAxle AS AXLE_DRIVING_IND_02,
  _ResourceTransp.RsceAxleGroup2IsSteeringAxle AS AXLE_STEERING_IND_02,
  _ResourceTransp.ResourceAxleGroup3Type AS AXLE_TYPE_03,
  _ResourceTransp.RsceAxleGroup3SpaceDistance AS AXLE_SPACE_DIST_03,
  _ResourceTransp.RsceAxleGroup3Distance AS AXGRP_POSN_03,
  _ResourceTransp.ResourceAxleGroup3DistanceUnit AS AXGRP_DIST_UOM_03,
  _ResourceTransp.RsceAxleGroup3MaximumWeight AS AXGRP_MAX_WEIGHT_03,
  _ResourceTransp.RsceAxleGroup3EmptyWeight AS AXGRP_EMPTY_WEIGHT_03,
  _ResourceTransp.RsceAxleGroup3WeightUnit AS AXGRP_WEIGHT_UOM_03,
  _ResourceTransp.RsceAxleGroup3IsDrivingAxle AS AXLE_DRIVING_IND_03,
  _ResourceTransp.RsceAxleGroup3IsSteeringAxle AS AXLE_STEERING_IND_03
FROM I_ResourceTransp AS _ResourceTransp
LEFT OUTER JOIN mara AS _Product ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SCMTMS/CV_ResourceBasicEnh AS _ResourceBasicEnh ON RESUID = _ResourceBasicEnh.ResourceUUID  -- association [0..1]
LEFT OUTER JOIN I_ResourcePosition AS _ResourcePosition ON TMSRESUID = _ResourcePosition.ResourceAdditionalUUID AND _ResourcePosition.ResourceLocationIsLastReported = 'X'  -- association [0..1]
;