I_BCS_MSG_REQUEST_S

DDL: I_BCS_MSG_REQUEST_S Type: view_entity

Inerface view for BCS Request

I_BCS_MSG_REQUEST_S is a CDS View that provides data about "Inerface view for BCS Request" in SAP S/4HANA. It reads from 1 data source (bcs_msg_request) and exposes 11 fields with key field request_id.

Data Sources (1)

SourceAliasJoin Type
bcs_msg_request bcs_msg_request from

Annotations (2)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY request_id request_id Request unique ID
clientNULLasso_dat_crasdat UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
clientNULLasso_tim_crastim UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
creator creator User ID
sender sender Sender
subject subject Title
protocol protocol Single-Character Flag
msg_status msg_status Status
msg_response msg_response Response
category category Violation Category
sending_api sending_api Mail Origin

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_REQUEST_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_REQUEST_S AS
SELECT
  request_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,
  creator,
  sender,
  subject,
  protocol,
  msg_status,
  msg_response,
  category,
  sending_api
FROM bcs_msg_request
;