APS_COM_OBS_BASE

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 APS_COM_OBS_BASE.
-- 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 APS_COM_OBS_BASE AS
SELECT
  _outboundService.obs_id AS ObsId,
  _outboundService.description AS Description,
  _outboundService.obs_type AS ObsType,
  _outboundService.change_user AS ChangeUser,
  _outboundService.change_timestamp AS ChangeTimestamp,
  _outboundService.service_interface AS ServiceInterface,
  _outboundService.is_deprecated AS IsDeprecated,
  _outboundService.deprecated_with_release AS DeprecatedWithRelease,
  _outboundService.abap_language_version AS AbapLanguageVersion,
  _c1.state AS C1ReleasedState,
  _scope.scope_state AS Scope,
  case when IsDeprecated = 'X' then _Text_Deprecated.text else '' end as IsDeprecatedText AS textelseendasIsDeprecatedText,
  case when IsDeprecated = 'X' then _Text_Deprecated.text else _Text_NotDeprecated.text end as IsDeprecatedTextVH AS textendasIsDeprecatedTextVH,
  case when IsCustomService = 'X' then _Text_CustomService.text else _Text_NotCustomService.text end as IsCustomServiceText AS textendasIsCustomServiceText,
  _Text_Deprecated.text AS DeprecatedText,
  _Text_NotDeprecated.text AS NotDeprecatedText
FROM APS_COM_CSCN_API_OBS AS _outboundService
LEFT OUTER JOIN ARS_APIS_RELEASED_C1_ALL AS _c1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_com_c_obs AS _scope ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_Deprecated ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_NotDeprecated ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_CustomService ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_NotCustomService ON /* join condition not captured in parsed metadata */
;