C_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 C_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: CPAYTMEDIAITM
-- Parameters: P_Language : sylangu, P_PaymentRunDate : laufd, P_PaymentRunID : laufi, P_PayingCompanyCode : bukrs, P_PaymentRunIsProposal : xvorl, P_PaymentMediumReference : renum

CREATE VIEW C_PaytMediaItem AS
SELECT
  PaymentRunDate,
  PaymentRunID,
  PayingCompanyCode,
  PaymentRunIsProposal,
  PaymentDocument,
  Supplier,
  Customer,
  SupplierName,
  CustomerName,
  cast (PaidAmountInPaytCurrency as farp_rwbtr ) AS PaidAmountInPaytCurrency,
  PaymentCurrency,
  PostingDate,
  PaidItemDueDate,
  ValueDate,
  cast (AmountInCompanyCodeCurrency as farp_rbetr ) AS AmountInCompanyCodeCurrency,
  Currency,
  cast(ExchangeRate as abap.char(12)) AS ExchangeRate,
  SupplierCountry,
  PostalCode,
  SupplierCityName,
  StreetAddressName,
  SupplierRegion,
  PayeeBankAccount,
  SWIFTCode,
  PayeePaymentSystem,
  PayeeAliasType,
  PayeeAliasName,
  _PayeePaymentSystem._Text[1:Language = $parameters.P_Language].PaymentSystemText AS PaymentSystemText,
  _PayeeAliasType._Text[1:Language = $parameters.P_Language].AliasTypeText AS AliasTypeText,
  BankKey,
  HouseBank,
  HouseBankAccount,
  HouseBankCurrency,
  HouseBankIBAN,
  _HouseBank.BankInternalID AS BankInternalID,
  case when _HouseBank.BankName is null then HouseBankName else _HouseBank.BankName end as HouseBankName AS BankNameendasHouseBankName,
  _HouseBank.CityName AS CityName,
  _HouseBank.StreetName AS StreetName,
  cast (PaytAmountInCoCodeCurrency as farp_rbetr ) AS PaytAmountInCoCodeCurrency,
  CompanyCodeCurrency,
  PaymentMediumStatus,
  BankCountry,
  case when BankCountry is null or BankCountry = '' then '' else _BankCountryText[1:Language = $parameters.P_Language].CountryName end as BankCountryName AS CountryNameendasBankCountryName,
  CreatedByUser,
  CreationDate,
  PaymentMediumReference,
  PaymentMediumFormat,
  CompanyCodeName,
  PaymentMethod,
  _PaymentMethod.PaymentMethodName AS PaymentMethodName,
  PaymentMediumHashValue,
  PaymentMediumHashAlgorithm,
  case _PaymentAdviceHeader.PaymentAdvice when '' then '-' else _PaymentAdviceHeader.PaymentAdvice end as PaymentAdvice AS PaymentAdviceendasPaymentAdvice,
  _JobStatus.ScheduledByUser AS ScheduledByUser,
  _Supplier.AuthorizationGroup AS SupplierBasicAuthorizationGrp,
  _Customer.AuthorizationGroup AS CustomerBasicAuthorizationGrp
FROM I_PaytMediaItem
;