I_PaytTransacEvtPredecessor

DDL: I_PAYTTRANSACEVTPREDECESSOR Type: view_entity BASIC

Payment Transaction Event Predecessor

I_PaytTransacEvtPredecessor is a Basic CDS View that provides data about "Payment Transaction Event Predecessor" in SAP S/4HANA. It reads from 1 data source (fan_pte_prdcssr) and exposes 14 fields with key field PredecessorAcctgNotifUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
fan_pte_prdcssr fan_pte_prdcssr from

Associations (4)

CardinalityTargetAliasCondition
[1] I_PaytTransacEvtAcctgNotif _PaytTransacEvtAcctgNotif $projection.PaytTransacEvtAcctgNotifUUID = _PaytTransacEvtAcctgNotif.PaytTransacEvtAcctgNotifUUID
[1..1] I_PaytTransacEvtApplication _PaytTransacEvtApplication $projection.PaytTransacEvtApplication = _PaytTransacEvtApplication.PaytTransacEvtApplication
[1..1] I_PaytTransacReferenceType _PaytTransacReferenceType $projection.PaytTransactionReferenceType = _PaytTransacReferenceType.PaytTransactionReferenceType
[0..1] I_Currency _BankAccountCurrency $projection.BankAccountCurrency = _BankAccountCurrency.Currency

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Payment Transaction Event Predecessor view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PredecessorAcctgNotifUUID predecessor_acctg_notif_uuid
PaytTransacEvtAcctgNotifUUID payt_transac_evt_an_uuid
PaytTransacEvtApplication payt_transac_evt_application
PaymentTransactionOID payment_transaction_oid
PaytTransactionReferenceType payt_transac_reference_type
PaymentTransactionReference payment_transaction_reference
BankAccountInternalID bank_account_internal_id Technical ID
AmountInBankAccountCurrency amnt_in_bank_account_currency Amount in Acct Crcy
BankAccountCurrency bank_account_currency Acct Currency
ValueDate value_date Value date
_PaytTransacEvtAcctgNotif _PaytTransacEvtAcctgNotif
_PaytTransacEvtApplication _PaytTransacEvtApplication
_PaytTransacReferenceType _PaytTransacReferenceType
_BankAccountCurrency _BankAccountCurrency

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_PaytTransacEvtPredecessor.
-- 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_PaytTransacEvtPredecessor AS
SELECT
  predecessor_acctg_notif_uuid AS PredecessorAcctgNotifUUID,
  payt_transac_evt_an_uuid AS PaytTransacEvtAcctgNotifUUID,
  payt_transac_evt_application AS PaytTransacEvtApplication,
  payment_transaction_oid AS PaymentTransactionOID,
  payt_transac_reference_type AS PaytTransactionReferenceType,
  payment_transaction_reference AS PaymentTransactionReference,
  bank_account_internal_id AS BankAccountInternalID,
  amnt_in_bank_account_currency AS AmountInBankAccountCurrency,
  bank_account_currency AS BankAccountCurrency,
  value_date AS ValueDate
FROM fan_pte_prdcssr
LEFT OUTER JOIN I_PaytTransacEvtAcctgNotif AS _PaytTransacEvtAcctgNotif ON PaytTransacEvtAcctgNotifUUID = _PaytTransacEvtAcctgNotif.PaytTransacEvtAcctgNotifUUID  -- association [1]
LEFT OUTER JOIN I_PaytTransacEvtApplication AS _PaytTransacEvtApplication ON PaytTransacEvtApplication = _PaytTransacEvtApplication.PaytTransacEvtApplication  -- association [1..1]
LEFT OUTER JOIN I_PaytTransacReferenceType AS _PaytTransacReferenceType ON PaytTransactionReferenceType = _PaytTransacReferenceType.PaytTransactionReferenceType  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _BankAccountCurrency ON BankAccountCurrency = _BankAccountCurrency.Currency  -- association [0..1]
;