APS_COM_CSCN_INB_UI

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_CSCN_INB_UI.
-- 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_COMCSCNIB_UI

CREATE VIEW APS_COM_CSCN_INB_UI AS
SELECT
  inbound_id,
  ibs_id AS IBSID,
  protocol,
  is_hidden,
  partner_type,
  partner_role,
  message_type,
  message_code,
  process_code,
  cast (trigger_immediately as boole_d) AS TriggerImmediately,
  ibs_type AS IBSType,
  icf_path,
  Description,
  is_deprecated AS IsDeprecated,
  is_deprecated_within_cscn AS IsDeprecatedWithinCscn,
  deprecated_with_release AS DeprecatedWithRelease,
  _ibs_type_text.ddtext AS IBSTypeText,
  INB_Successor,
  INB_API_Keys
FROM APS_COM_CSCN_API_INB_SRV
LEFT OUTER JOIN APS_COM_CSCN_INB_API_KEY_UI AS INB_API_Keys ON inbound_id = INB_API_Keys.InboundID AND communication_scenario_id = INB_API_Keys.CommunicationScenarioID  -- association [0..*]
LEFT OUTER JOIN APS_COM_CSCN_INB_SUCCESSOR_UI AS INB_Successor ON IBSID = INB_Successor.current_ibs_id  -- association [0..*]
;