I_BCS_MSG_RECIPIENT_M

DDL: I_BCS_MSG_RECIPIENT_M Type: view_entity
7 Fields 1 Data Sources 2 Associations

Interface view for BCS recipients

I_BCS_MSG_RECIPIENT_M is a CDS View that provides data about "Interface view for BCS recipients" in SAP S/4HANA. It reads from 1 data source (I_BCS_MSG_RECIPIENT) and exposes 7 fields with key field recipient_id. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BCS_MSG_RECIPIENT I_BCS_MSG_RECIPIENT from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_BCS_MSG_COPY_T _copy_text $projection.copy = _copy_text.copy
[0..*] I_BCS_MSG_RECIPIENT_STATUS_M _recipient_status

Annotations (2)

NameValueLevelField
EndUserText.label Interface view for BCS recipients view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY recipient_id recipient_id Recipient ID
request_id request_id Request unique ID
created created UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
address address Subscription address
copy copy Copy
_request _request
_copy_text _copy_text

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 I_BCS_MSG_RECIPIENT_M.
-- 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 I_BCS_MSG_RECIPIENT_M AS
SELECT
  recipient_id,
  request_id,
  created,
  address,
  copy
FROM I_BCS_MSG_RECIPIENT
LEFT OUTER JOIN I_BCS_MSG_COPY_T AS _copy_text ON copy = _copy_text.copy  -- association [0..*]
LEFT OUTER JOIN I_BCS_MSG_RECIPIENT_STATUS_M AS _recipient_status ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More