I_ResourceBasic

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_ResourceBasic.
-- 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: IRESOURCEBASIC

CREATE VIEW I_ResourceBasic AS
SELECT
  ResourceBasic.resuid AS ResourceUUID,
  ResourceBasic.simsessid AS ResourceSimulationSessionUUID,
  ResourceBasic.simversid AS ResourceSimulationVersionUUID,
  ResourceBasic.name AS ResourceID,
  ResourceBasic.type AS ResourceType,
  ResourceBasic.tzone AS ResourceTimeZone,
  ResourceBasic.calendar AS ResourceFactoryCalendar,
  ResourceBasic.traty AS TransportMeansType,
  ResourceBasic.locid AS ResourceHomeLocationUUID,
  ResourceBasic.changeuser AS LastChangedByUser,
  ResourceBasic.changedate AS ChangedDateTime,
  _LocationBasic.Location AS ResourceHomeLocation,
  _LocationBasic.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _LocationBasic.AuthorizationGroup AS AuthorizationGroup
FROM /sapapo/res_head AS ResourceBasic
LEFT OUTER JOIN I_ResourceTextBasic AS _ResourceTextBasic ON ResourceUUID = _ResourceTextBasic.ResourceUUID AND ResourceSimulationSessionUUID = _ResourceTextBasic.ResourceSimulationSessionUUID AND ResourceSimulationVersionUUID = _ResourceTextBasic.ResourceSimulationVersionUUID  -- association [0..*]
LEFT OUTER JOIN I_LocationBasic AS _LocationBasic ON ResourceHomeLocationUUID = _LocationBasic.LocationUUID  -- association [0..1]
;