I_BankPaytIncgStatusRef

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_BankPaytIncgStatusRef.
-- 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: IBNKPAYTINCGSTS

CREATE VIEW I_BankPaytIncgStatusRef AS
SELECT
  _StatusRef.stref_guid AS IncomingStatusRefUUID,
  _StatusRef.ref_guid AS BatchUUID,
  _StatusRef.ref_type AS IncomingStatusReferenceType,
  _StatusRef.batch_no AS PaymentBatch,
  cast(_StatusRef.item_no as farp_bnk_com_btch_cnt) AS PaymentBatchItem,
  _StatusRef.ref_id AS BankCommunicationStatusRef,
  cast(_StatusRef.crusr as fclm_bam_created_by) AS CreatedByUser,
  cast(_StatusRef.crdat as fis_cpdat) AS CreationDate,
  cast(_StatusRef.crtim as ttet_dt_cr_time) AS CreationTime
FROM bnk_btch_stref AS _StatusRef
;