P_PubSecBRFMessageTypeIdn

DDL: P_PUBSECBRFMESSAGETYPEIDN SQL: PPSBRFMSGTYPEIDN Type: view BASIC
6 Fields 1 Data Sources

P_PubSecBRFMessageTypeIdn is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (dfmca_brf_msg) and exposes 6 fields with key field PublicSectorFormBundleUUID.

Data Sources (1)

SourceAliasJoin Type
dfmca_brf_msg dfmca_brf_msg from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPSBRFMSGTYPEIDN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PublicSectorFormBundleUUID return_id Case Key
int1endasNumberOfInfoMsgs
int1endasNumberOfErrorMsgs
int1endendasNumberOfOpenErrorMsgs
int1endendasNumberOfOpenWarningMsgs
int1endasNumberOfWarningMsgs

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 P_PubSecBRFMessageTypeIdn.
-- 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: PPSBRFMSGTYPEIDN

CREATE VIEW P_PubSecBRFMessageTypeIdn AS
SELECT
  return_id AS PublicSectorFormBundleUUID,
  case msgty when 'I' then cast (1 as abap.int1 ) end as NumberOfInfoMsgs AS int1endasNumberOfInfoMsgs,
  case msgty when 'E' then cast (1 as abap.int1 ) end as NumberOfErrorMsgs AS int1endasNumberOfErrorMsgs,
  case msgty when 'E' then case status when '1' then cast (1 as abap.int1 ) end end as NumberOfOpenErrorMsgs AS int1endendasNumberOfOpenErrorMsgs,
  case msgty when 'W' then case status when '1' then cast (1 as abap.int1 ) end end as NumberOfOpenWarningMsgs AS int1endendasNumberOfOpenWarningMsgs,
  case msgty when 'W' then cast (1 as abap.int1 ) end as NumberOfWarningMsgs AS int1endasNumberOfWarningMsgs
FROM dfmca_brf_msg
;

Learn More