P_CAPaymentMedia

DDL: P_CAPAYMENTMEDIA Type: view_entity CONSUMPTION Package: ODATA_O2C_FICA_PAYMENTMEDIA
15 Fields 1 Data Sources 2 Associations

Payment Media for Payment Groups

P_CAPaymentMedia is a Consumption CDS View that provides data about "Payment Media for Payment Groups" in SAP S/4HANA. It reads from 1 data source (I_CAPaymentRunGroup) and exposes 15 fields with key fields CAMassRunDate, CAMassRunID, CAPaymentDataOriginCode, CAInternalPaymentGroup. It has 2 associations to related views. Part of development package ODATA_O2C_FICA_PAYMENTMEDIA.

Data Sources (1)

SourceAliasJoin Type
I_CAPaymentRunGroup I_CAPaymentRunGroup from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CAPaymentCompanyCode = _CompanyCode.CompanyCode
[0..1] I_CAPaymentMethod _CAPaymentMethod $projection.CAPaymentMethod = _CAPaymentMethod.CAPaymentMethod and $projection.country = _CAPaymentMethod.Country

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Payment Media for Payment Groups view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate CAMassRunDate Date ID
KEY CAMassRunID CAMassRunID Run ID
KEY CAPaymentDataOriginCode CAPaymentDataOriginCode Source
KEY CAInternalPaymentGroup CAInternalPaymentGroup Routine Number
CAPaymentMediumFormat CAPaymentMediumFormat Payt Mdm Format
CAPaymentCompanyCode CAPaymentCompanyCode Paying Co. Code
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
CAPaymentIsCreditOrDebit CAPaymentIsCreditOrDebit Credit/Debit Memo
CAPaymentMethod CAPaymentMethod Payment Method
NumberOfPayments NumberOfPayments No. of Payts
NumberOfPaymentsInFile NumberOfPaymentsInFile Completed Pymts
Country _CompanyCode Country Venue: Ctry/Reg
_CompanyCode _CompanyCode
_CAPaymentMethod _CAPaymentMethod

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 P_CAPaymentMedia.
-- 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 P_CAPaymentMedia AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAPaymentDataOriginCode,
  CAInternalPaymentGroup,
  CAPaymentMediumFormat,
  CAPaymentCompanyCode,
  HouseBank,
  HouseBankAccount,
  CAPaymentIsCreditOrDebit,
  CAPaymentMethod,
  NumberOfPayments,
  NumberOfPaymentsInFile,
  _CompanyCode.Country AS Country
FROM I_CAPaymentRunGroup
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CAPaymentCompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentMethod AS _CAPaymentMethod ON CAPaymentMethod = _CAPaymentMethod.CAPaymentMethod AND country = _CAPaymentMethod.Country  -- association [0..1]
;

Learn More