I_BCS_MSG_RECIPIENT_STATUS_S

DDL: I_BCS_MSG_RECIPIENT_STATUS_S Type: view_entity

Inerface view for BCS Recipient Status

I_BCS_MSG_RECIPIENT_STATUS_S is a CDS View that provides data about "Inerface view for BCS Recipient Status" in SAP S/4HANA. It reads from 1 data source (bcs_msg_rec_stat) and exposes 7 fields with key field status_id.

Data Sources (1)

SourceAliasJoin Type
bcs_msg_rec_stat bcs_msg_rec_stat from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Inerface view for BCS Recipient Status view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY status_id status_id Trans Doc Status
recipient_id recipient_id Recipient ID
clientNULLasso_dat_crasdat UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
clientNULLasso_tim_crastim UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
status status Workflow Status
statuscode statuscode Statuscode
response response Response

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_STATUS_S.
-- 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_STATUS_S AS
SELECT
  status_id,
  recipient_id,
  cast( tstmp_to_dats( cast( created as timestamp ), abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as so_dat_cr ) as dat AS clientNULLasso_dat_crasdat,
  cast( tstmp_to_tims( cast( created as timestamp ), abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as so_tim_cr ) as tim AS clientNULLasso_tim_crastim,
  status,
  statuscode,
  response
FROM bcs_msg_rec_stat
;