I_CFinReplicatedTransaction

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_CFinReplicatedTransaction.
-- 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_CFinReplicatedTransaction AS
SELECT
  cast ( msgguid as fins_cfin_repltra_guid preserving type ) AS CFinRpldTransactionUUID,
  cast ( awtyp as fis_src_awtyp preserving type ) AS SourceReferenceDocumentType,
  cast ( awref as fis_src_awref preserving type ) AS SourceReferenceDocument,
  cast ( aworg as fins_cfin_src_aworg preserving type ) AS SourceReferenceDocumentCntxt,
  cast ( awsys as fis_src_awsys preserving type ) AS SourceRefDocLogicalSystem,
  cast ( timestamp as fins_cfin_repltra_create_time preserving type ) AS CFinRpldTransCreationDateTime,
  cast ( tcode as tcode preserving type ) AS TransactionCode,
  cast ( status as fins_cfin_repltra_status preserving type ) AS CFinRpldTransactionStatus,
  cast ( lognumber as balognr preserving type ) AS ApplicationLog,
  cast (ns as /aif/ns preserving type ) AS CFinRpldTransNamespace,
  cast (ifname as /aif/ifname preserving type ) AS CFinRpldTransInterfaceName,
  cast (ifver as /aif/ifversion preserving type ) AS CFinRpldTransInterfaceVersion
FROM cfin_aif_idx_tbl
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON _ReferenceDocumentTypeText.ReferenceDocumentType = SourceReferenceDocumentType AND _ReferenceDocumentTypeText.Language = $session.system_language  -- association [0..1]
;