P_CAPaymentListTotal

DDL: P_CAPAYMENTLISTTOTAL SQL: PCAPAYLISTTOTAL Type: view CONSUMPTION
16 Fields 1 Data Sources 1 Associations

P_CAPaymentListTotal is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_CAPaymentListPayment) and exposes 16 fields with key fields CAMassRunDate, CAMassRunID, CAIntPaymentIdentification, CAIntAddlPaymentIdentification. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CAPaymentListPayment P_CAPaymentListPayment from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAPaymentMethod _CAPaymentMethod $projection.CAPaymentMethod = _CAPaymentMethod.CAPaymentMethod and $projection.CompanyCodeCountry = _CAPaymentMethod.Country

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCAPAYLISTTOTAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate CAMassRunDate Date ID
KEY CAMassRunID CAMassRunID Run ID
KEY CAIntPaymentIdentification CAIntPaymentIdentification
KEY CAIntAddlPaymentIdentification CAIntAddlPaymentIdentification
CAPaymentCompanyCode CAPaymentCompanyCode Paying Co. Code
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
CAPaymentMethod CAPaymentMethod Payment Method
CAPaymentMethodName
TransactionCurrency TransactionCurrency Transaction Currency
PaidAmountInPaytCurrency PaidAmountInPaytCurrency Payment Amount
BankAmountInTransactionCrcy BankAmountInTransactionCrcy
CashDiscountAmtInTransacCrcy CashDiscountAmtInTransacCrcy
CAWhldgTaxForCreditsInPaytCrcy CAWhldgTaxForCreditsInPaytCrcy
CADifferenceAmountInClrgProcg CADifferenceAmountInClrgProcg
PaidItemDueDate PaidItemDueDate
ValueDate ValueDate Value Date

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_CAPaymentListTotal.
-- 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: PCAPAYLISTTOTAL

CREATE VIEW P_CAPaymentListTotal AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAIntPaymentIdentification,
  CAIntAddlPaymentIdentification,
  CAPaymentCompanyCode,
  CompanyCodeCountry,
  CAPaymentMethod,
  _CAPaymentMethod._Text[1: Language=$session.system_language].CAPaymentMethodName AS CAPaymentMethodName,
  TransactionCurrency,
  PaidAmountInPaytCurrency,
  BankAmountInTransactionCrcy,
  CashDiscountAmtInTransacCrcy,
  CAWhldgTaxForCreditsInPaytCrcy,
  CADifferenceAmountInClrgProcg,
  PaidItemDueDate,
  ValueDate
FROM P_CAPaymentListPayment
LEFT OUTER JOIN I_CAPaymentMethod AS _CAPaymentMethod ON CAPaymentMethod = _CAPaymentMethod.CAPaymentMethod AND CompanyCodeCountry = _CAPaymentMethod.Country  -- association [0..1]
;

Learn More