R_PaymentAdviceEvent

DDL: R_PAYMENTADVICEEVENT Type: view_entity TRANSACTIONAL
54 Fields 1 Data Sources

Payment Advice Business Event

R_PaymentAdviceEvent is a Transactional CDS View that provides data about "Payment Advice Business Event" in SAP S/4HANA. It reads from 1 data source (I_PaymentAdvice) and exposes 54 fields with key fields CompanyCode, PaymentAdviceAccountType, PaymentAdviceAccount, PaymentAdvice.

Data Sources (1)

SourceAliasJoin Type
I_PaymentAdvice I_PaymentAdvice from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Payment Advice Business Event view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.sapObjectNodeType.name PaymentAdvice view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PaymentAdviceAccountType PaymentAdviceAccountType Account Type
KEY PaymentAdviceAccount PaymentAdviceAccount Account
KEY PaymentAdvice PaymentAdvice Payment Advice Number
IsOutgoingPayment IsOutgoingPayment Self-issued doc.
PaymentDocument PaymentDocument Payment Document Number
AccountByShipper AccountByShipper Payee's Account at the Customer
PaymentCurrency PaymentCurrency Payment Currency
PaymentDate PaymentDate Payment Date
PaidAmountInPaytCurrency PaidAmountInPaytCurrency Payment Amount
CashDiscountAmountInPaytCrcy CashDiscountAmountInPaytCrcy Cash Discount Amount
BillOfExchangeDueDate BillOfExchangeDueDate BoE Due Date
PaymentMethod PaymentMethod Pymt Meth.
PartnerBank PartnerBank
PartnerBankAccount PartnerBankAccount
PartnerBankCountry PartnerBankCountry Part. Ctry/Rgn
PartnerBankSWIFTCode PartnerBankSWIFTCode Partner SWIFT
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
PaymentAdviceHeaderText PaymentAdviceHeaderText Payment Advice Header Text
PaymentAdviceType PaymentAdviceType Payt Adv. Type
CreationTime CreationTime Time of Change
PaymentAdviceStatus PaymentAdviceStatus Payment Advice Status
PaymentAdviceIsHeld PaymentAdviceIsHeld Hold Payt Adv.
PaymentAdviceHasSingleAccount PaymentAdviceHasSingleAccount Specific Account?
PaytAdvcDiffDeterminationRule PaytAdvcDiffDeterminationRule Reason Code Conversion
PaymentAdviceSelectionRule PaymentAdviceSelectionRule Selection Rule
OriginalReferenceDocument OriginalReferenceDocument Reference Key
ReferenceDocumentType ReferenceDocumentType Reference Document Type
BankReference BankReference Payment Reference
BankPostingDate BankPostingDate Last resubmiss.
FeeAmountInTransactionCrcy FeeAmountInTransactionCrcy AC Fees
PaymentTransaction PaymentTransaction Bus Trans Code
BillOfExchangeFailureDate BillOfExchangeFailureDate Date in Japan
Cheque Cheque Cheque No
ValueDate ValueDate Value Date
BusinessPartnerName BusinessPartnerName Extracted Customer Name
CAPaymentDocument CAPaymentDocument Usage Doc.
ContractAccount ContractAccount Contract Acct
CAPaymentAdvice CAPaymentAdvice Payment Advice Note
_BusinessPartner _BusinessPartner
_CompanyCode _CompanyCode
_Currency _Currency
_Customer _Customer
_CustomerCompany _CustomerCompany
_PaymentAdviceItem _PaymentAdviceItem
_PaymentAdviceType _PaymentAdviceType
_PaytAdvcDiffDeterminationRule _PaytAdvcDiffDeterminationRule
_PaytAdviceSelRules _PaytAdviceSelRules
_Supplier _Supplier
_SupplierCompany _SupplierCompany
_UserContactCard _UserContactCard

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 R_PaymentAdviceEvent.
-- 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 R_PaymentAdviceEvent AS
SELECT
  CompanyCode,
  PaymentAdviceAccountType,
  PaymentAdviceAccount,
  PaymentAdvice,
  IsOutgoingPayment,
  PaymentDocument,
  AccountByShipper,
  PaymentCurrency,
  PaymentDate,
  PaidAmountInPaytCurrency,
  CashDiscountAmountInPaytCrcy,
  BillOfExchangeDueDate,
  PaymentMethod,
  PartnerBank,
  PartnerBankAccount,
  PartnerBankCountry,
  PartnerBankSWIFTCode,
  CreatedByUser,
  CreationDate,
  LastChangeDate,
  LastChangedByUser,
  PaymentAdviceHeaderText,
  PaymentAdviceType,
  CreationTime,
  PaymentAdviceStatus,
  PaymentAdviceIsHeld,
  PaymentAdviceHasSingleAccount,
  PaytAdvcDiffDeterminationRule,
  PaymentAdviceSelectionRule,
  OriginalReferenceDocument,
  ReferenceDocumentType,
  BankReference,
  BankPostingDate,
  FeeAmountInTransactionCrcy,
  PaymentTransaction,
  BillOfExchangeFailureDate,
  Cheque,
  ValueDate,
  BusinessPartnerName,
  CAPaymentDocument,
  ContractAccount,
  CAPaymentAdvice
FROM I_PaymentAdvice
;

Learn More