I_PaymentAdvice

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_PaymentAdvice.
-- 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: IPAYTADVC

CREATE VIEW I_PaymentAdvice AS
SELECT
  bukrs AS CompanyCode,
  koart AS PaymentAdviceAccountType,
  konto AS PaymentAdviceAccount,
  cast(avsid as farp_pa_avsid preserving type) AS PaymentAdvice,
  xausg AS IsOutgoingPayment,
  cast(vblnr as farp_pa_vblnr preserving type) AS PaymentDocument,
  cast(eikto as farp_pa_eikto preserving type) AS AccountByShipper,
  cast(waers as farp_fwaer preserving type) AS PaymentCurrency,
  cast(zaldt as farp_payment_date preserving type) AS PaymentDate,
  rwbtr AS PaidAmountInPaytCurrency,
  cast(rwskt as fis_wskto) AS CashDiscountAmountInPaytCrcy,
  wefae AS BillOfExchangeDueDate,
  rzawe AS PaymentMethod,
  cast(zbnkl as farp_pa_dzbnkl preserving type) AS PartnerBank,
  cast(zbnkn as farp_pa_dzbnkn preserving type) AS PartnerBankAccount,
  zbnks AS PartnerBankCountry,
  zbswi AS PartnerBankSWIFTCode,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  aedat AS LastChangeDate,
  LastChangeDateTime,
  aenam AS LastChangedByUser,
  cast(avtxt as farp_avtxt_avik preserving type) AS PaymentAdviceHeaderText,
  avsrt AS PaymentAdviceType,
  cputm AS CreationTime,
  astat AS PaymentAdviceStatus,
  xkeep AS PaymentAdviceIsHeld,
  xuniq AS PaymentAdviceHasSingleAccount,
  cast(vrsdg as farp_vrsdg preserving type) AS PaytAdvcDiffDeterminationRule,
  sregl AS PaymentAdviceSelectionRule,
  xbenr AS OriginalReferenceDocument,
  xbtyp AS ReferenceDocumentType,
  vgref AS BankReference,
  bvdat AS BankPostingDate,
  butim AS ValueDateTime,
  spesk AS FeeAmountInTransactionCrcy,
  vorgc AS PaymentTransaction,
  cast(kursf as farp_kursf) AS ExchangeRate,
  jpdat AS BillOfExchangeFailureDate,
  chect AS Cheque,
  valut AS ValueDate,
  zbprn AS BusinessPartnerName,
  fica_apbel AS CAPaymentDocument,
  fica_vkont AS ContractAccount,
  fica_avkey AS CAPaymentAdvice
FROM avik
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON CreatedByUser = _UserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON PaymentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ReasonCodeConversionVers AS _PaytAdvcDiffDeterminationRule ON PaytAdvcDiffDeterminationRule = _PaytAdvcDiffDeterminationRule.PaytAdvcDiffDeterminationRule  -- association [1..1]
LEFT OUTER JOIN I_PaytAdviceSelRules AS _PaytAdviceSelRules ON PaymentAdviceSelectionRule = _PaytAdviceSelRules.PaymentAdviceSelectionRule  -- association [1..1]
LEFT OUTER JOIN I_PaymentAdviceType AS _PaymentAdviceType ON PaymentAdviceType = _PaymentAdviceType.PaymentAdviceType  -- association [1..1]
LEFT OUTER JOIN I_PaymentAdviceItem AS _PaymentAdviceItem ON CompanyCode = _PaymentAdviceItem.CompanyCode AND PaymentAdviceAccountType = _PaymentAdviceItem.PaymentAdviceAccountType AND PaymentAdviceAccount = _PaymentAdviceItem.PaymentAdviceAccount AND PaymentAdvice = _PaymentAdviceItem.PaymentAdvice  -- association [1..*]
LEFT OUTER JOIN I_Customer AS _Customer ON PaymentAdviceAccount = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON PaymentAdviceAccount = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON PaymentAdviceAccount = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON PaymentAdviceAccount = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON PaymentAdviceAccount = _BusinessPartner.BusinessPartner AND PaymentAdviceAccountType = 'G'  -- association [0..1]
;