C_APS_COM_CA_OUT_SRV

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_APS_COM_CA_OUT_SRV.
-- 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: CAPS_CA_OUT_SRV

CREATE VIEW C_APS_COM_CA_OUT_SRV AS
SELECT
  db_key,
  parent_key,
  CommSystOutboundUser,
  CommunicationScenarioService,
  CommArrgmtOutbSrvcLgclPortName,
  CmArrOutbSrvcPrevUsdlglprtname,
  ComputerNetworkCommProtocol,
  CommArrgmtOutbServiceTCPPort,
  CommArrgmtOutbServiceURLPath,
  CommArrgmtOutboundSrvcStatus,
  RecurrenceValue,
  Frequency,
  StartTime,
  TimeZoneCode,
  LastExecution,
  NextExecution,
  PackageSize,
  IDOC_Basic_Type,
  SOAP_WSRM_Version,
  IsUilEmbeddedActive,
  RemoteSchemaName,
  RemoteDbName,
  cast('' as boole_d) AS IsJobActive,
  cast('' as abap.char( 256 )) AS RemoteSchemaNameProposal,
  CommunicationScenarioID AS CommunicationScenario,
  _OutboundService.Description AS SRV_Description,
  _OutboundService.IsMandatory AS SRV_IsMandatory,
  _OutboundService.HasOutboundWSDL AS SRV_HasOutboundWSDL,
  _OutboundService.SupportsPing AS SRV_SupportsPing,
  _OutboundService.ApplicationProtocol AS SRV_ApplicationProtocol,
  _OutboundService.ApplicationProtocolText AS SRV_ApplicationProtocolText,
  _OutboundService.ServiceInterface AS SRV_ServiceInterface,
  _OutboundService.Basic_Type AS SRV_IDOC_Basic_Type,
  _OutboundService.HasJobDefinition AS SRV_HasJobDefinition,
  _OutboundService.JobDefinitionName AS SRV_JobDefinitionName,
  _OutboundService.IsUilEmbeddedAllowed AS SRV_IsUilEmbeddedAllowed,
  _OutboundService.Is_Deprecated AS SRV_Is_Deprecated,
  _OutboundService.IsDeprecatedWithinCSCN AS SRV_IsDeprecatedWithinCSCN,
  _OutboundService.DeprecatedWithRelease AS SRV_DeprecatedWithRelease,
  _OutboundService.OBSID AS SRV_OBSID,
  _FrequencyText.Description AS FrequencyText
FROM I_APS_COM_CA_OUT_SRV_TP
LEFT OUTER JOIN C_APS_COM_CA AS _CommunicationArrangement ON parent_key = _CommunicationArrangement.db_key  -- association [1..1]
LEFT OUTER JOIN I_APS_COM_COMM_OUTB_SERVICE AS _OutboundService ON _OutboundService.CommunicationScenarioID = CommunicationScenario AND _OutboundService.OutboundID = CommunicationScenarioService  -- association [0..1]
LEFT OUTER JOIN APS_COM_CA_OUT_SUCCESSOR AS _OutboundServiceSuccessors ON SRV_OBSID = _OutboundServiceSuccessors.OBSID  -- association [0..*]
LEFT OUTER JOIN C_APS_COM_CA_OUT_SRV_APIKEY AS _Outbound_API_Keys ON db_key = _Outbound_API_Keys.parent_key  -- association [0..*]
LEFT OUTER JOIN I_Aps_Com_Domain_Value_Text AS _FrequencyText ON _FrequencyText.Name = 'JR_O_FREQUENCY' AND _FrequencyText.Code = Frequency  -- association [0..1]
LEFT OUTER JOIN APS_COM_CA_IDOC_BASIC_TYPE_VH AS _IDOC_Basic_Type_VH ON _IDOC_Basic_Type_VH.CommunicationScenarioID = CommunicationScenario AND _IDOC_Basic_Type_VH.OutboundID = CommunicationScenarioService  -- association [0..*]
;