B_APS_COM_CA_OUT_SRV

DDL: B_APS_COM_CA_OUT_SRV SQL: APS_COM_CA_OUT_B Type: view Package: SR_APS_COM_CA

Buffered Communication Arrangement Outbound Service View

B_APS_COM_CA_OUT_SRV is a CDS View that provides data about "Buffered Communication Arrangement Outbound Service View" in SAP S/4HANA. It reads from 1 data source (aps_ca_d_outbnd) and exposes 19 fields with key field db_key. It has 1 association to related views. Part of development package SR_APS_COM_CA.

Data Sources (1)

SourceAliasJoin Type
aps_ca_d_outbnd aps_ca_d_outbnd from

Associations (1)

CardinalityTargetAliasCondition
[1..1] B_APS_COM_CA _CommunicationArrangement $projection.parent_key = _CommunicationArrangement.db_key

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName APS_COM_CA_OUT_B view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.preserveKey true view
EndUserText.label Buffered Communication Arrangement Outbound Service View view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY db_key db_key UUID
parent_key parent_key UUID
CommSystOutboundUser commsystoutbounduser
CommunicationScenarioService communicationscenarioservice
CommArrgmtOutbSrvcLgclPortName commarrgmtoutbsrvclgclportname
CmArrOutbSrvcPrevUsdlglprtname cmarroutbsrvcprevusdlglprtname
ComputerNetworkCommProtocol computernetworkcommprotocol
CommArrgmtOutbServiceTCPPort commarrgmtoutbservicetcpport
CommArrgmtOutboundSrvcStatus commarrgmtoutboundsrvcstatus
RecurrenceValue recurrencevalue
Frequency frequency Reporting Frequency
StartTime starttime Time Stamp
TimeZoneCode timezonecode
LastExecution lastexecution
NextExecution nextexecution
PackageSize packagesize Pkg Size
IsJobActive isjobactive
IDOC_Basic_Type idoc_basic_type
_CommunicationArrangement _CommunicationArrangement

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 B_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: APS_COM_CA_OUT_B

CREATE VIEW B_APS_COM_CA_OUT_SRV AS
SELECT
  db_key,
  parent_key,
  CommSystOutboundUser,
  CommunicationScenarioService,
  CommArrgmtOutbSrvcLgclPortName,
  CmArrOutbSrvcPrevUsdlglprtname,
  ComputerNetworkCommProtocol,
  CommArrgmtOutbServiceTCPPort,
  CommArrgmtOutboundSrvcStatus,
  RecurrenceValue,
  Frequency,
  StartTime,
  TimeZoneCode,
  LastExecution,
  NextExecution,
  PackageSize,
  IsJobActive,
  IDOC_Basic_Type
FROM aps_ca_d_outbnd
LEFT OUTER JOIN B_APS_COM_CA AS _CommunicationArrangement ON parent_key = _CommunicationArrangement.db_key  -- association [1..1]
;