/SCMTMS/CV_ResourceBE

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_ResourceBE.
-- 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_RES01

CREATE VIEW /SCMTMS/CV_ResourceBE AS
SELECT
  _ResourceBasic.ResourceUUID AS ResourceUUID,
  _ResourceBasic.ResourceID AS ResourceID,
  _LocationBasic.LocationUUID AS LocationUUID,
  _LocationBasic.LocationAdditionalUUID AS LocationAdditionalUUID,
  _ResourceBasic.ResourceType AS ResourceType,
  _ResourceBasic.ResourceFactoryCalendar AS ResourceFactoryCalendar,
  _ResourceBasic.ResourceHomeLocationUUID AS ResourceHomeLocationUUID,
  _ResourceBasic.ResourceSimulationSessionUUID AS ResourceSimulationSessionUUID,
  _ResourceBasic.ResourceSimulationVersionUUID AS ResourceSimulationVersionUUID,
  _ResourceBasic.ResourceTimeZone AS ResourceTimeZone,
  _ResourceBasic.TransportMeansType AS TransportMeansType,
  _ResourceBasic.LastChangedByUser AS LastChangedByUser,
  _ResourceBasic.ChangedDateTime AS ChangedDateTime,
  _MeansOfTransport.ext_ttype_flg AS IsMultiResource,
  _MeansOfTransport.ext_ttype_num AS NumberOfResources,
  _MeansOfTransport.passive AS IsPassiveResource,
  _MeansOfTransport.lock_multires AS MultiResourceIsLocked,
  _MeansOfTransport.trmodcode AS TransportationMode,
  _MtrCompartment.cmprofile AS ResourceCompartmentProfile,
  _ResourceTextBasic.ResourceName AS ResourceName,
  _ResourceTextBasic.Language AS Language
FROM I_ResourceBasic AS _ResourceBasic
LEFT OUTER JOIN /sapapo/trtype AS _MeansOfTransport ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /sapapo/cpmtr AS _MtrCompartment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ResourceTextBasic AS _ResourceTextBasic ON ResourceUUID = _ResourceTextBasic.ResourceUUID AND _ResourceTextBasic.ResourceSimulationSessionUUID = '' AND _ResourceTextBasic.ResourceSimulationVersionUUID = '' AND _ResourceTextBasic.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LocationBasic AS _LocationBasic ON ResourceHomeLocationUUID = _LocationBasic.LocationUUID  -- association [0..1]
;