I_PrepaymentAgrmtAmount

DDL: I_PREPAYMENTAGRMTAMOUNT SQL: IPPMGAMT Type: view COMPOSITE
20 Fields 1 Data Sources 8 Associations

Prepayment Agreement Amount

I_PrepaymentAgrmtAmount is a Composite CDS View that provides data about "Prepayment Agreement Amount" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAgreement) and exposes 20 fields with key field PrepaymentAgreement. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentAgreement PrepaymentAgreement from

Associations (8)

CardinalityTargetAliasCondition
[0..1] P_PreAgrmtConsumeAmount PrepaymentConsumption $projection.PrepaymentAgreement = PrepaymentConsumption.PrepaymentAgreement
[0..1] P_PreAgrmtSettleAmount PrepaymentSettlement $projection.PrepaymentAgreement = PrepaymentSettlement.PrepaymentAgreement
[0..1] P_PreAgrmtEventAmount PrepaymentEvent $projection.PrepaymentAgreement = PrepaymentEvent.PrepaymentAgreement
[0..1] P_PreAgrmtReturnAmount PrepaymentReturn $projection.PrepaymentAgreement = PrepaymentReturn.PrepaymentAgreement
[0..1] P_PreAgrmtInterestAmount PrepaymentInterest $projection.PrepaymentAgreement = PrepaymentInterest.PrepaymentAgreement
[0..1] P_PreAgrmtRetInterestAmount PrepaymentRetInterest $projection.PrepaymentAgreement = PrepaymentRetInterest.PrepaymentAgreement
[0..1] P_PreAgrmtCashSettlmtAmount PrepaymentCashSettlmt $projection.PrepaymentAgreement = PrepaymentCashSettlmt.PrepaymentAgreement
[0..1] P_PrepaymentAgrmtRenegttnAmt PrepaymentRenegttnAmt $projection.PrepaymentAgreement = PrepaymentRenegttnAmt.PrepaymentRenegttnPrevAgrmt

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPPMGAMT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Prepayment Agreement Amount view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgreement I_PrepaymentAgreement PrepaymentAgreement Renegotiation PPA
PrepaymentAgreementType I_PrepaymentAgreement PrepaymentAgreementType Prepay Agreemnt Type
PrepaymentAgreementCategory I_PrepaymentAgreement PrepaymentAgreementCategory Prepayment Category
CompanyCode I_PrepaymentAgreement CompanyCode Receiver Company Code
Counterparty I_PrepaymentAgreement Counterparty Supplier
PrepaymentAgreementStatus I_PrepaymentAgreement PrepaymentAgreementStatus Pre Agreement Status
PrepaymentAgrmtLinkStatus I_PrepaymentAgreement PrepaymentAgrmtLinkStatus Link Status
PrepaymentAgrmtPostingStatus I_PrepaymentAgreement PrepaymentAgrmtPostingStatus Pre Posting Status
PrepaymentAgreementAmount I_PrepaymentAgreement PrepaymentAgreementAmount Pre Agrm Amount
PrepaymentAgreementCurrency I_PrepaymentAgreement PrepaymentAgreementCurrency Currency
PrepaymentAgrmtLinkType PrepaymentConsumption PrepaymentAgrmtLinkType Link Type
PrepaymentAgrmtConsumedAmount PrepaymentConsumption PrepaymentAgrmtConsumedAmount
PrepaymentDistrCurrency PrepaymentConsumption PrepaymentDistrCurrency Currency
PrepaymentAgrmtSettledAmount PrepaymentSettlement PrepaymentAgrmtSettledAmount
PrepayAccrualPostedCurrency PrepaymentSettlement PrepayAccrualPostedCurrency Prepmt Acc Postd Cur
PrepaymentAgrmtEventAmount PrepaymentEvent PrepaymentAgrmtEventAmount
PrepaymentCreditCurrency PrepaymentEvent PrepaymentCreditCurrency
PrepaymentAgrmtCshSettlmtAmt PrepaymentCashSettlmt PrepaymentAgrmtCshSettlmtAmt Cash Settlmt Amount
PrepaymentTotalRenegttnAmount PrepaymentRenegttnAmt PrepaymentTotalRenegttnAmount Total Amount
PrepaymentInterestCalcAmtCrcy I_PrepaymentAgreement PrepaymentAgreementCurrency Currency

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 I_PrepaymentAgrmtAmount.
-- 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: IPPMGAMT

CREATE VIEW I_PrepaymentAgrmtAmount AS
SELECT
  PrepaymentAgreement.PrepaymentAgreement AS PrepaymentAgreement,
  PrepaymentAgreement.PrepaymentAgreementType AS PrepaymentAgreementType,
  PrepaymentAgreement.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  PrepaymentAgreement.CompanyCode AS CompanyCode,
  PrepaymentAgreement.Counterparty AS Counterparty,
  PrepaymentAgreement.PrepaymentAgreementStatus AS PrepaymentAgreementStatus,
  PrepaymentAgreement.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtLinkStatus,
  PrepaymentAgreement.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  PrepaymentAgreement.PrepaymentAgreementAmount AS PrepaymentAgreementAmount,
  PrepaymentAgreement.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  PrepaymentConsumption.PrepaymentAgrmtLinkType AS PrepaymentAgrmtLinkType,
  PrepaymentConsumption.PrepaymentAgrmtConsumedAmount AS PrepaymentAgrmtConsumedAmount,
  PrepaymentConsumption.PrepaymentDistrCurrency AS PrepaymentDistrCurrency,
  PrepaymentSettlement.PrepaymentAgrmtSettledAmount AS PrepaymentAgrmtSettledAmount,
  PrepaymentSettlement.PrepayAccrualPostedCurrency AS PrepayAccrualPostedCurrency,
  PrepaymentEvent.PrepaymentAgrmtEventAmount AS PrepaymentAgrmtEventAmount,
  PrepaymentEvent.PrepaymentCreditCurrency AS PrepaymentCreditCurrency,
  PrepaymentCashSettlmt.PrepaymentAgrmtCshSettlmtAmt AS PrepaymentAgrmtCshSettlmtAmt,
  PrepaymentRenegttnAmt.PrepaymentTotalRenegttnAmount AS PrepaymentTotalRenegttnAmount,
  PrepaymentAgreement.PrepaymentAgreementCurrency AS PrepaymentInterestCalcAmtCrcy
FROM I_PrepaymentAgreement AS PrepaymentAgreement
LEFT OUTER JOIN P_PreAgrmtConsumeAmount AS PrepaymentConsumption ON PrepaymentAgreement = PrepaymentConsumption.PrepaymentAgreement  -- association [0..1]
LEFT OUTER JOIN P_PreAgrmtSettleAmount AS PrepaymentSettlement ON PrepaymentAgreement = PrepaymentSettlement.PrepaymentAgreement  -- association [0..1]
LEFT OUTER JOIN P_PreAgrmtEventAmount AS PrepaymentEvent ON PrepaymentAgreement = PrepaymentEvent.PrepaymentAgreement  -- association [0..1]
LEFT OUTER JOIN P_PreAgrmtReturnAmount AS PrepaymentReturn ON PrepaymentAgreement = PrepaymentReturn.PrepaymentAgreement  -- association [0..1]
LEFT OUTER JOIN P_PreAgrmtInterestAmount AS PrepaymentInterest ON PrepaymentAgreement = PrepaymentInterest.PrepaymentAgreement  -- association [0..1]
LEFT OUTER JOIN P_PreAgrmtRetInterestAmount AS PrepaymentRetInterest ON PrepaymentAgreement = PrepaymentRetInterest.PrepaymentAgreement  -- association [0..1]
LEFT OUTER JOIN P_PreAgrmtCashSettlmtAmount AS PrepaymentCashSettlmt ON PrepaymentAgreement = PrepaymentCashSettlmt.PrepaymentAgreement  -- association [0..1]
LEFT OUTER JOIN P_PrepaymentAgrmtRenegttnAmt AS PrepaymentRenegttnAmt ON PrepaymentAgreement = PrepaymentRenegttnAmt.PrepaymentRenegttnPrevAgrmt  -- association [0..1]
;

Learn More