P_EvtBsdErrorSituation

DDL: P_EVTBSDERRORSITUATION Type: view_entity COMPOSITE Package: FINS_PCC_RTPC_SIT2
9 Fields 1 Data Sources

Event-Based Error Situation

P_EvtBsdErrorSituation is a Composite CDS View that provides data about "Event-Based Error Situation" in SAP S/4HANA. It reads from 1 data source (I_EventBasedErrorLogSituation) and exposes 9 fields with key field EventbasedProductCostgErrorID. Part of development package FINS_PCC_RTPC_SIT2.

Data Sources (1)

SourceAliasJoin Type
I_EventBasedErrorLogSituation error from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EventbasedProductCostgErrorID EventbasedProductCostgErrorID
CompanyCode I_EventBasedErrorLogSituation CompanyCode Receiver Company Code
SystemMessageClass I_EventBasedErrorLogSituation SystemMessageClass Message ID
SystemMessageNumber
SystemMessageVariable1 I_EventBasedErrorLogSituation SystemMessageVariable1 Variable 1
SystemMessageVariable2 I_EventBasedErrorLogSituation SystemMessageVariable2 Variable 2
SystemMessageVariable3 I_EventBasedErrorLogSituation SystemMessageVariable3 Variable 3
SystemMessageVariable4 I_EventBasedErrorLogSituation SystemMessageVariable4 Variable 4
text1asermsgtxtendasText

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_EvtBsdErrorSituation.
-- 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 P_EvtBsdErrorSituation AS
SELECT
  EventbasedProductCostgErrorID,
  error.CompanyCode AS CompanyCode,
  error.SystemMessageClass AS SystemMessageClass,
  cast ( error.SystemMessageNumber as msgnr ) AS SystemMessageNumber,
  error.SystemMessageVariable1 AS SystemMessageVariable1,
  error.SystemMessageVariable2 AS SystemMessageVariable2,
  error.SystemMessageVariable3 AS SystemMessageVariable3,
  error.SystemMessageVariable4 AS SystemMessageVariable4,
  case when instr(error.SystemMessageText, '&') > 0 then cast( replace_regexpr( pcre => '&', occurrence => 1, value => replace_regexpr( pcre => '&', occurrence => 1, value => replace_regexpr( pcre => '&', occurrence => 1, value => replace_regexpr( pcre => '&', value => text1, occurrence => 1, with => error.SystemMessageVariable1, result_length => 300 ), with => error.SystemMessageVariable2, result_length => 300 ), with => error.SystemMessageVariable3, result_length => 300 ), with => error.SystemMessageVariable4, result_length => 300 ) as ermsgtxt) else cast( text1 as ermsgtxt) end as Text AS text1asermsgtxtendasText
FROM I_EventBasedErrorLogSituation AS error
;

Learn More