I_BankPaytExtStatusMsg

DDL: I_BANKPAYTEXTSTATUSMSG SQL: IBNKEXTSTSMSG Type: view BASIC

External Status Message of Bank Payments

I_BankPaytExtStatusMsg is a Basic CDS View that provides data about "External Status Message of Bank Payments" in SAP S/4HANA. It reads from 1 data source (bnk_xstat_msg) and exposes 9 fields with key field BankStatusMessageUUID.

Data Sources (1)

SourceAliasJoin Type
bnk_xstat_msg bnk_xstat_msg from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IBNKEXTSTSMSG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label External Status Message of Bank Payments view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BankStatusMessageUUID
SystemMessageIdentification bnk_xstat_msg msgid Message ID
BankStatusMsgCreationTime
BankStatusMsgCreationDate
CreatedByUser
CreationTime
CreationDate
BankCommOriginalMessage
BankCommOriginalMessageName

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_BankPaytExtStatusMsg.
-- 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: IBNKEXTSTSMSG

CREATE VIEW I_BankPaytExtStatusMsg AS
SELECT
  cast(bnk_xstat_msg.guid as farp_bnk_com_msg_guid) AS BankStatusMessageUUID,
  bnk_xstat_msg.msgid AS SystemMessageIdentification,
  cast(bnk_xstat_msg.sttime as farp_bnk_com_msg_cr_time) AS BankStatusMsgCreationTime,
  cast(bnk_xstat_msg.stdate as farp_bnk_com_msg_cr_date) AS BankStatusMsgCreationDate,
  cast(bnk_xstat_msg.crusr as fclm_bam_created_by) AS CreatedByUser,
  cast(bnk_xstat_msg.crtime as ttet_dt_cr_time) AS CreationTime,
  cast(bnk_xstat_msg.crdate as fis_cpdat) AS CreationDate,
  cast(bnk_xstat_msg.omsgid as farp_bnk_com_omsg_id) AS BankCommOriginalMessage,
  cast(bnk_xstat_msg.omsgna as farp_bnk_com_omsg_nm_id) AS BankCommOriginalMessageName
FROM bnk_xstat_msg
;