P_CAPaymentListGroupPre

DDL: P_CAPAYMENTLISTGROUPPRE SQL: PCAPAYLISTGROUPP Type: view CONSUMPTION
16 Fields 1 Data Sources 3 Associations

P_CAPaymentListGroupPre is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_CAPaymentRunGroup) and exposes 16 fields with key fields CAMassRunDate, CAMassRunID, CAInternalPaymentGroup. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CAPaymentRunGroup I_CAPaymentRunGroup from

Associations (3)

CardinalityTargetAliasCondition
[1..1] P_CAPaymentListGroup2 _CAPaymentListGroup2 $projection.CAMassRunDate = _CAPaymentListGroup2.CAMassRunDate and $projection.CAMassRunID = _CAPaymentListGroup2.CAMassRunID and $projection.CAInternalPaymentGroup = _CAPaymentListGroup2.CAInternalPaymentGroup
[0..1] I_CAPaymentMediaFormat _CAPaymentMediaFormat $projection.CAPaymentMediumFormat = _CAPaymentMediaFormat.CAPaymentMediumFormat
[0..1] I_CAInternalPaymentGroup _CAInternalPaymentGroup $projection.CAInternalPaymentGroup = _CAInternalPaymentGroup.CAInternalPaymentGroup

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCAPAYLISTGROUPP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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 CAInternalPaymentGroup CAInternalPaymentGroup Routine Number
CAInternalPaymentGroupName
CAPaymentMediumFormat CAPaymentMediumFormat Payt Mdm Format
CAPaymentMediumFormatName
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
CAPaymentMethod CAPaymentMethod Payment Method
NumberOfPayments NumberOfPayments No. of Payts
NumberOfPaymentsInFile NumberOfPaymentsInFile Completed Pymts
TransactionCurrency _CAPaymentListGroup2 TransactionCurrency Transaction Currency
BankAmountByGroup _CAPaymentListGroup2 BankAmountByGroup
NumberOfPaymentsByGroup _CAPaymentListGroup2 NumberOfPaymentsByGroup
NumberOfRepaymentReqByGroup _CAPaymentListGroup2 NumberOfRepaymentReqByGroup
NumberOfPaymentOrdersByGroup _CAPaymentListGroup2 NumberOfPaymentOrdersByGroup

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_CAPaymentListGroupPre.
-- 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: PCAPAYLISTGROUPP

CREATE VIEW P_CAPaymentListGroupPre AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAInternalPaymentGroup,
  _CAInternalPaymentGroup._Text[1: Language=$session.system_language].CAInternalPaymentGroupName AS CAInternalPaymentGroupName,
  CAPaymentMediumFormat,
  _CAPaymentMediaFormat._Text[1: Language=$session.system_language].PaymentMediumFormatDescription AS CAPaymentMediumFormatName,
  HouseBank,
  HouseBankAccount,
  CAPaymentMethod,
  NumberOfPayments,
  NumberOfPaymentsInFile,
  _CAPaymentListGroup2.TransactionCurrency AS TransactionCurrency,
  _CAPaymentListGroup2.BankAmountByGroup AS BankAmountByGroup,
  _CAPaymentListGroup2.NumberOfPaymentsByGroup AS NumberOfPaymentsByGroup,
  _CAPaymentListGroup2.NumberOfRepaymentReqByGroup AS NumberOfRepaymentReqByGroup,
  _CAPaymentListGroup2.NumberOfPaymentOrdersByGroup AS NumberOfPaymentOrdersByGroup
FROM I_CAPaymentRunGroup
LEFT OUTER JOIN P_CAPaymentListGroup2 AS _CAPaymentListGroup2 ON CAMassRunDate = _CAPaymentListGroup2.CAMassRunDate AND CAMassRunID = _CAPaymentListGroup2.CAMassRunID AND CAInternalPaymentGroup = _CAPaymentListGroup2.CAInternalPaymentGroup  -- association [1..1]
LEFT OUTER JOIN I_CAPaymentMediaFormat AS _CAPaymentMediaFormat ON CAPaymentMediumFormat = _CAPaymentMediaFormat.CAPaymentMediumFormat  -- association [0..1]
LEFT OUTER JOIN I_CAInternalPaymentGroup AS _CAInternalPaymentGroup ON CAInternalPaymentGroup = _CAInternalPaymentGroup.CAInternalPaymentGroup  -- association [0..1]
;

Learn More