C_TDATestDataContainer

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 C_TDATestDataContainer.
-- 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.

CREATE VIEW C_TDATestDataContainer AS
SELECT
  TDACreateUUID,
  TDAContainerNameText,
  TDAContainerNumberOfVariants,
  TDAContainerType,
  TDAApplicationText,
  TDACreateTagText,
  TDACreateScopeText,
  TDATemplateDescText,
  TDAContainerCreatedOnDateTime,
  TDACreatedByName,
  ChangedByName,
  TDAContainerChangedDateTime,
  ProcessedTimeZone,
  _TimeZoneText.TimeZoneText AS TimeZoneText
FROM I_TDATestDataContainer
LEFT OUTER JOIN C_TDAContainerMappingField AS _ContRepo ON TDACreateUUID = _ContRepo.TDACreateUUID  -- association [1..*]
LEFT OUTER JOIN C_TDAContainerVariant AS _ContVariant ON TDACreateUUID = _ContVariant.TDACreateUUID  -- association [1..*]
LEFT OUTER JOIN I_TimeZoneText AS _TimeZoneText ON ProcessedTimeZone = _TimeZoneText.TimeZoneID AND _TimeZoneText.Language = $session.system_language  -- association [1..1]
;