C_PaytMedia

DDL: C_PAYTMEDIA SQL: CPAYTMEDIA Type: view CONSUMPTION Package: FINS_AP_PP
27 Fields 1 Data Sources

Payment Media

C_PaytMedia is a Consumption CDS View that provides data about "Payment Media" in SAP S/4HANA. It reads from 1 data source (I_PaytMedia) and exposes 27 fields with key field PaymentMediumReference. Part of development package FINS_AP_PP.

Data Sources (1)

SourceAliasJoin Type
I_PaytMedia I_PaytMedia from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPAYTMEDIA view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Payment Media view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY PaymentMediumReference PaymentMediumReference Reference Number
PayingCompanyCode PayingCompanyCode Paying Company Code
HouseBank HouseBank House Bank
BankCountry BankCountry Bank Ctry/Rgn. Key
PaymentRunDate PaymentRunDate Run On
PaymentRunID PaymentRunID Settlement ID
PaymentRunIsProposal PaymentRunIsProposal Proposal Run
PaymentMethod PaymentMethod Pymt Meth.
SequenceNumber SequenceNumber Sort sequence
PaytMdmStorageAddlKey PaytMdmStorageAddlKey Addit.Field for the TemSe Key Fields
CompanyCodeCurrency CompanyCodeCurrency Local Currency
PaytAmountInCoCodeCurrency
PaymentMediumFormat PaymentMediumFormat Payment Format
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
DownloadFileName DownloadFileName User
DownloadDate DownloadDate Date of Download
PaymentMediumStatus PaymentMediumStatus
DownloadTime DownloadTime Time of Download
DownloadDateTime DownloadDateTime
DownloadByUser DownloadByUser User Name
BankStatementDate BankStatementDate Statement Date
PaymentMediumHashValue PaymentMediumHashValue Hash Value as Hex Encoded String
PaymentMediumHashAlgorithm PaymentMediumHashAlgorithm Hash Algorithm
CompanyCodeName _Company CompanyCodeName Company Name
PaymentOrigin _DMEFilePayingCoCode PaymentOrigin Routine Number
BankCountryName

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_PaytMedia.
-- 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: CPAYTMEDIA

CREATE VIEW C_PaytMedia AS
SELECT
  PaymentMediumReference,
  PayingCompanyCode,
  HouseBank,
  BankCountry,
  PaymentRunDate,
  PaymentRunID,
  PaymentRunIsProposal,
  PaymentMethod,
  SequenceNumber,
  PaytMdmStorageAddlKey,
  CompanyCodeCurrency,
  cast (PaytAmountInCoCodeCurrency as farp_rbetr ) AS PaytAmountInCoCodeCurrency,
  PaymentMediumFormat,
  CreationDate,
  CreatedByUser,
  DownloadFileName,
  DownloadDate,
  PaymentMediumStatus,
  DownloadTime,
  DownloadDateTime,
  DownloadByUser,
  BankStatementDate,
  PaymentMediumHashValue,
  PaymentMediumHashAlgorithm,
  _Company.CompanyCodeName AS CompanyCodeName,
  _DMEFilePayingCoCode.PaymentOrigin AS PaymentOrigin,
  _BankCountryText[1:Language = $session.system_language].CountryName AS BankCountryName
FROM I_PaytMedia
;

Learn More