I_PaytMediaItem

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_PaytMediaItem.
-- 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: IPAYTMEDIAITM

CREATE VIEW I_PaytMediaItem AS
SELECT
  PaymentRunDate,
  PaymentRunID,
  PayingCompanyCode,
  PaymentRunIsProposal,
  PaymentDocument,
  Supplier,
  Customer,
  concat_with_space(SupplierName,SupplierAdditionalName,1) AS SupplierName,
  _Customer.CustomerName AS CustomerName,
  cast (PaidAmountInPaytCurrency as abap.curr( 23, 2 )) AS PaidAmountInPaytCurrency,
  PaymentCurrency,
  PostingDate,
  PaidItemDueDate,
  ValueDate,
  cast (AmountInCompanyCodeCurrency as abap.curr( 23, 2 )) AS AmountInCompanyCodeCurrency,
  _PaytMedia._Company.Currency AS Currency,
  cast(ExchangeRate as abap.char(12)) AS ExchangeRate,
  SupplierCountry,
  PaymentOrigin,
  PostalCode,
  SupplierCityName,
  StreetAddressName,
  SupplierRegion,
  PayeeBankCountry,
  PayeeBank,
  _PayeeBank.BankName AS BankName,
  PayeeName,
  PayeeBankAccount,
  PayeeBankAccountLongID,
  PayeeBankInternalID,
  PayeeIBAN,
  SWIFTCode,
  PayeePaymentSystem,
  PayeeAliasType,
  PayeeAliasName,
  _PaytMedia.HouseBank AS HouseBank,
  _Bank.BankName AS HouseBankName,
  _PaytMedia.HouseBankAccount AS HouseBankAccount,
  _PaytMedia._HouseBankAccount.BankAccountCurrency AS HouseBankCurrency,
  _PaytMedia.BankKey AS BankKey,
  HouseBankIBAN,
  cast (_PaytMedia.PaytAmountInCoCodeCurrency as abap.curr( 23, 2 )) AS PaytAmountInCoCodeCurrency,
  _PaytMedia.CompanyCodeCurrency AS CompanyCodeCurrency,
  _PaytMedia.PaymentMediumStatus AS PaymentMediumStatus,
  _PaytMedia.BankCountry AS BankCountry,
  _PaytMedia.CreationDate AS CreationDate,
  _PaytMedia.CreatedByUser AS CreatedByUser,
  _PaytMedia.PaymentMediumReference AS PaymentMediumReference,
  _PaytMedia.PaymentMediumFormat AS PaymentMediumFormat,
  _PaytMedia._Company.CompanyCodeName AS CompanyCodeName,
  _PaytMedia.PaymentMethod AS PaymentMethod,
  _PaytMedia.PaymentMediumHashValue AS PaymentMediumHashValue,
  _PaytMedia.PaymentMediumHashAlgorithm AS PaymentMediumHashAlgorithm,
  concat(concat(concat('F110-',PaymentRunDate),'-'),PaymentRunID) AS ApplicationJobName,
  concat('07',_PaytMedia.PaymentMediumReference) AS PaymentAdvice
FROM I_PaymentProposalHeader AS _PaymentProposalHeader
LEFT OUTER JOIN I_PaytMedia AS _PaytMedia ON PaymentRunDate = _PaytMedia.PaymentRunDate AND PaymentRunID = _PaytMedia.PaymentRunID AND PayingCompanyCode = _PaytMedia.PayingCompanyCode AND PaymentRunIsProposal = _PaytMedia.PaymentRunIsProposal AND _PaymentProposalHeader.PaymentOrigin = _PaytMedia.PaymentOrigin  -- association [0..1]
LEFT OUTER JOIN I_Bank AS _HouseBank ON bankcountry = _HouseBank.BankCountry AND bankkey = _HouseBank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Jobstatus AS _JobStatus ON ApplicationJobName = _JobStatus.ApplicationJobName  -- association [0..*]
LEFT OUTER JOIN I_Paymentadviceheader AS _PaymentAdviceHeader ON PaymentAdvice = _PaymentAdviceHeader.PaymentAdvice AND PayingCompanyCode = _PaymentAdviceHeader.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON paymentmethod = _PaymentMethod.PaymentMethod AND SupplierCountry = _PaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _BankCountryText ON bankcountry = _BankCountryText.Country  -- association [1..*]
LEFT OUTER JOIN I_PaymentSystem AS _PayeePaymentSystem ON PayeePaymentSystem = _PayeePaymentSystem.PaymentSystem  -- association [0..1]
LEFT OUTER JOIN I_AliasType AS _PayeeAliasType ON PayeeAliasType = _PayeeAliasType.AliasType  -- association [0..1]
;