P_PaytProposalItemAggregation

DDL: P_PAYTPROPOSALITEMAGGREGATION SQL: PPAYTITMAGGRGN Type: view BASIC Package: FINS_AP_PP
18 Fields 1 Data Sources 1 Associations

Payment Proposal Item Aggregation

P_PaytProposalItemAggregation is a Basic CDS View that provides data about "Payment Proposal Item Aggregation" in SAP S/4HANA. It reads from 1 data source (reguh) and exposes 18 fields with key fields PaymentRunDate, PaymentRunID, PaymentRunIsProposal, PayingCompanyCode, Supplier. It has 1 association to related views. Part of development package FINS_AP_PP.

Data Sources (1)

SourceAliasJoin Type
reguh reguh from

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_PaymentProposalItem _PaymentProposalItem $projection.PaymentRunDate = _PaymentProposalItem.PaymentRunDate and $projection.PaymentRunID = _PaymentProposalItem.PaymentRunID and $projection.PaymentRunIsProposal = _PaymentProposalItem.PaymentRunIsProposal and $projection.PayingCompanyCode = _PaymentProposalItem.PayingCompanyCode and $projection.Supplier = _PaymentProposalItem.Supplier and $projection.Customer = _PaymentProposalItem.Customer and $projection.PaymentRecipient = _PaymentProposalItem.PaymentRecipient and $projection.PaymentDocument = _PaymentProposalItem.PaymentDocument

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPAYTITMAGGRGN view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PaymentRunDate laufd Run On
KEY PaymentRunID laufi Settlement ID
KEY PaymentRunIsProposal xvorl Proposal Run
KEY PayingCompanyCode zbukr Paying CoCd
KEY Supplier lifnr Vendor no.
KEY Customer kunnr Stock customer
KEY PaymentRecipient empfg Pmnt Recipient
KEY PaymentDocument vblnr Payment Doc.No.
PaymentCurrency waers Transaction Currency
AmountInTransactionCurrency
HeaderAmtInCoCodeCurrency
WhldgTaxAmtInTransacCrcy
WhldgTaxAmtInCoCodeCrcy
TotDeductionAmtInTransacCrcy
TotDeductionAmtInCoCodeCrcy
NetAmountInTransacCurrency
NetAmountInCoCodeCurrency
_PaymentProposalItem _PaymentProposalItem

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_PaytProposalItemAggregation.
-- 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: PPAYTITMAGGRGN

CREATE VIEW P_PaytProposalItemAggregation AS
SELECT
  laufd AS PaymentRunDate,
  laufi AS PaymentRunID,
  xvorl AS PaymentRunIsProposal,
  zbukr AS PayingCompanyCode,
  lifnr AS Supplier,
  kunnr AS Customer,
  empfg AS PaymentRecipient,
  vblnr AS PaymentDocument,
  waers AS PaymentCurrency,
  cast ( sum(_PaymentProposalItem.AmountInTransactionCurrency) as abap.curr(23,2)) AS AmountInTransactionCurrency,
  cast ( sum(_PaymentProposalItem.AmountInCompanyCodeCurrency) as abap.curr(23,2)) AS HeaderAmtInCoCodeCurrency,
  cast ( sum(_PaymentProposalItem.WhldgTaxAmtInTransacCrcy) as abap.curr(23,2)) AS WhldgTaxAmtInTransacCrcy,
  cast ( sum(_PaymentProposalItem.WhldgTaxAmtInCoCodeCrcy) as abap.curr(23,2)) AS WhldgTaxAmtInCoCodeCrcy,
  cast ( sum(_PaymentProposalItem.TotDeductionAmtInTransacCrcy) as abap.curr(23,2)) AS TotDeductionAmtInTransacCrcy,
  cast ( sum(_PaymentProposalItem.TotDeductionAmtInCoCodeCrcy) as abap.curr(23,2)) AS TotDeductionAmtInCoCodeCrcy,
  cast ( sum(_PaymentProposalItem.NetAmountInTransacCurrency) as abap.curr(23,2)) AS NetAmountInTransacCurrency,
  cast ( sum(_PaymentProposalItem.NetAmountInCoCodeCurrency) as abap.curr(23,2)) AS NetAmountInCoCodeCurrency
FROM reguh
LEFT OUTER JOIN P_PaymentProposalItem AS _PaymentProposalItem ON PaymentRunDate = _PaymentProposalItem.PaymentRunDate AND PaymentRunID = _PaymentProposalItem.PaymentRunID AND PaymentRunIsProposal = _PaymentProposalItem.PaymentRunIsProposal AND PayingCompanyCode = _PaymentProposalItem.PayingCompanyCode AND Supplier = _PaymentProposalItem.Supplier AND Customer = _PaymentProposalItem.Customer AND PaymentRecipient = _PaymentProposalItem.PaymentRecipient AND PaymentDocument = _PaymentProposalItem.PaymentDocument  -- association [1..*]
;

Learn More