aps_com_obs_pub_ddl

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_pub_ddl.
-- 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: APS_COM_OBS_P

CREATE VIEW aps_com_obs_pub_ddl AS
SELECT
  aps_com_w_obs.obs_id AS OutboundServiceID,
  aps_com_w_obs.obs_type AS OutboundServiceType,
  obs_type_text.ddtext AS OutboundServiceTypeText,
  aps_com_w_obs.scope_dependent AS ScopeDependent,
  aps_com_w_obs.idoc_msg_type AS IDocMessageType,
  aps_com_w_obs.idoc_type AS IDocBasicType,
  aps_com_w_obs.rfc_service_id AS RfcServiceID,
  aps_com_w_obs.ws_proxy_name AS SOAPInterfaceName,
  aps_com_w_obs.publish_api_hub AS ApiHubPublish,
  obs_service_text.text AS ServiceDescription,
  case when aps_com_w_obs.obs_type = #APS_COM_OBS_TYPE.'IDOC' then aps_com_w_obs.idoc_msg_type when aps_com_w_obs.obs_type = #APS_COM_OBS_TYPE.'SPRX' then aps_com_w_obs.ws_proxy_name when aps_com_w_obs.obs_type = #APS_COM_OBS_TYPE.'SRFC' then aps_com_w_obs.rfc_service_id when aps_com_w_obs.obs_type = #APS_COM_OBS_TYPE.'IDOC' then aps_com_w_obs.idoc_msg_type when aps_com_w_obs.obs_type = #APS_COM_OBS_TYPE.'SMTP' then '' when aps_com_w_obs.obs_type = #APS_COM_OBS_TYPE.'ODBC' then '' when aps_com_w_obs.obs_type = #APS_COM_OBS_TYPE.'UIL' then '' else '' end as ServiceInterface AS UILthenelseendasServiceInterface,
  aps_com_w_obs.url_path AS URLPath,
  aps_com_w_obs.leading_bo_type AS LeadingBOType,
  bo_type_text.bo_text AS LeadingBOTypeText,
  aps_com_w_obs.create_user AS CreatedBy,
  aps_com_w_obs.create_timestamp AS CreatedAt,
  aps_com_w_obs.change_user AS ChangedBy,
  aps_com_w_obs.change_timestamp AS ChangedAt
FROM aps_com_w_obs
LEFT OUTER JOIN dd07t AS obs_type_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sbo_i_botypet AS bo_type_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_com_w_obst AS obs_service_text ON /* join condition not captured in parsed metadata */
;