C_PrepaymentAgrmtCshSettlmt

DDL: C_PREPAYMENTAGRMTCSHSETTLMT SQL: CPPMGAGRCSHSTLTP Type: view CONSUMPTION
28 Fields 1 Data Sources 5 Associations

Prepayment Agrmt Renegtn Cash Settlement

C_PrepaymentAgrmtCshSettlmt is a Consumption CDS View that provides data about "Prepayment Agrmt Renegtn Cash Settlement" in SAP S/4HANA. It reads from 1 data source (I_PrepaymentAgrmtCshSettlmtTP) and exposes 28 fields with key field PrepaymentAgrmtCshSettlmtUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentAgrmtCshSettlmtTP PrepayAgrCashStl from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_PrepaymentAgreementTP _PrepaymentAgreement $projection.PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID
[0..1] I_PrepaymentRenegttnReasonVH _ReasonText $projection.PurgOrgCompanyCode = _ReasonText.CompanyCode and $projection.PrepaymentAgreementType = _ReasonText.PrepaymentAgreementType and $projection.PrepaymentRenegotiationReason = _ReasonText.PrepaymentRenegotiationReason
[0..1] I_PrepaymentRenegttnAmtTypeVH _AmtTypeText $projection.PurgOrgCompanyCode = _AmtTypeText.CompanyCode and $projection.PrepaymentAgreementType = _AmtTypeText.PrepaymentAgreementType and $projection.PrepaymentRenegttnAmountType = _AmtTypeText.PrepaymentRenegttnAmountType
[0..1] I_CshSettlmtClrgAcctgDoc _ClrgAcctgDoc $projection.PrepaymentAgrmtCshSettlmtUUID = _ClrgAcctgDoc.PrepaymentAgrmtCshSettlmtUUID -- Extension View
[0..1] E_PrepaymentAgrmtCshSettlmt _Extension $projection.PrepaymentAgrmtCshSettlmtUUID = _Extension.PrepaymentAgrmtCshSettlmtUUID

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CPPMGAGRCSHSTLTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Prepayment Agrmt Renegtn Cash Settlement view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Search.searchable true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgrmtCshSettlmtUUID I_PrepaymentAgrmtCshSettlmtTP PrepaymentAgrmtCshSettlmtUUID Key
PrepaymentAgreementUUID I_PrepaymentAgrmtCshSettlmtTP PrepaymentAgreementUUID Key
PrepaymentAgreement
PrepaymentAgrmtCshSettlmtItmNo I_PrepaymentAgrmtCshSettlmtTP PrepaymentAgrmtCshSettlmtItmNo Cash Settlmt Item No
PrepaymentAgrmtCshSettlmtDate I_PrepaymentAgrmtCshSettlmtTP PrepaymentAgrmtCshSettlmtDate Cash Settlement Date
PrepaymentAgrmtPndgRcvryAmt I_PrepaymentAgrmtCshSettlmtTP PrepaymentAgrmtPndgRcvryAmt Unrecovered Amount
PrepaymentAgrmtCshSettlmtAmt I_PrepaymentAgrmtCshSettlmtTP PrepaymentAgrmtCshSettlmtAmt Cash Settlmt Amount
PrepaymentAgreementCurrency I_PrepaymentAgrmtCshSettlmtTP PrepaymentAgreementCurrency Currency
PrepayAgrmtAccrInterestAmount I_PrepaymentAgrmtCshSettlmtTP PrepayAgrmtAccrInterestAmount Accrual Inter. Amt
PrepaymentInterestCalcAmtCrcy I_PrepaymentAgrmtCshSettlmtTP PrepaymentInterestCalcAmtCrcy Accrual Inter. Curr
PrepaymentRenegttnAmountType I_PrepaymentAgrmtCshSettlmtTP PrepaymentRenegttnAmountType Reneg. Amt Tyype
PrepaymentRenegotiationReason I_PrepaymentAgrmtCshSettlmtTP PrepaymentRenegotiationReason Reason
PrepaymentAgrmtCshSettlmtCmnt I_PrepaymentAgrmtCshSettlmtTP PrepaymentAgrmtCshSettlmtCmnt Comments
PrepaymentCshSettlmtIsPosted I_PrepaymentAgrmtCshSettlmtTP PrepaymentCshSettlmtIsPosted CashSettl is Posted
PrepaymentPostedDocument I_PrepaymentAgrmtCshSettlmtTP PrepaymentPostedDocument Posted Document No.
CompanyCode I_PrepaymentAgrmtCshSettlmtTP CompanyCode Receiver Company Code
FiscalYear I_PrepaymentAgrmtCshSettlmtTP FiscalYear G/L Fiscal Year
PrepaymentPostingProfile I_PrepaymentAgrmtCshSettlmtTP PrepaymentPostingProfile Settl Recvry Profile
IsRejected I_PrepaymentAgrmtCshSettlmtTP IsRejected Rejected
PurgOrgCompanyCode I_PrepaymentAgrmtCshSettlmtTP PurgOrgCompanyCode Receiver Company Code
PrepaymentAgreementType I_PrepaymentAgrmtCshSettlmtTP PrepaymentAgreementType Prepay Agreemnt Type
ClearedAccountingDocument _ClrgAcctgDoc ClearedAccountingDocument
ClearingFiscalYear _ClrgAcctgDoc ClearingFiscalYear
ClearingDate _ClrgAcctgDoc ClearingDate Clearing Date
RenegotiationReasonText
RenegotiationAmountTypeText _AmtTypeText RenegotiationAmountTypeText
_ClrgAcctgDoc _ClrgAcctgDoc
_PrepaymentAgreement _PrepaymentAgreement

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 C_PrepaymentAgrmtCshSettlmt.
-- 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: CPPMGAGRCSHSTLTP

CREATE VIEW C_PrepaymentAgrmtCshSettlmt AS
SELECT
  PrepayAgrCashStl.PrepaymentAgrmtCshSettlmtUUID AS PrepaymentAgrmtCshSettlmtUUID,
  PrepayAgrCashStl.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepayAgrCashStl.PrepaymentAgrmtCshSettlmtItmNo AS PrepaymentAgrmtCshSettlmtItmNo,
  PrepayAgrCashStl.PrepaymentAgrmtCshSettlmtDate AS PrepaymentAgrmtCshSettlmtDate,
  PrepayAgrCashStl.PrepaymentAgrmtPndgRcvryAmt AS PrepaymentAgrmtPndgRcvryAmt,
  PrepayAgrCashStl.PrepaymentAgrmtCshSettlmtAmt AS PrepaymentAgrmtCshSettlmtAmt,
  PrepayAgrCashStl.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  PrepayAgrCashStl.PrepayAgrmtAccrInterestAmount AS PrepayAgrmtAccrInterestAmount,
  PrepayAgrCashStl.PrepaymentInterestCalcAmtCrcy AS PrepaymentInterestCalcAmtCrcy,
  PrepayAgrCashStl.PrepaymentRenegttnAmountType AS PrepaymentRenegttnAmountType,
  PrepayAgrCashStl.PrepaymentRenegotiationReason AS PrepaymentRenegotiationReason,
  PrepayAgrCashStl.PrepaymentAgrmtCshSettlmtCmnt AS PrepaymentAgrmtCshSettlmtCmnt,
  PrepayAgrCashStl.PrepaymentCshSettlmtIsPosted AS PrepaymentCshSettlmtIsPosted,
  PrepayAgrCashStl.PrepaymentPostedDocument AS PrepaymentPostedDocument,
  PrepayAgrCashStl.CompanyCode AS CompanyCode,
  PrepayAgrCashStl.FiscalYear AS FiscalYear,
  PrepayAgrCashStl.PrepaymentPostingProfile AS PrepaymentPostingProfile,
  PrepayAgrCashStl.IsRejected AS IsRejected,
  PrepayAgrCashStl.PurgOrgCompanyCode AS PurgOrgCompanyCode,
  PrepayAgrCashStl.PrepaymentAgreementType AS PrepaymentAgreementType,
  _ClrgAcctgDoc.ClearedAccountingDocument AS ClearedAccountingDocument,
  _ClrgAcctgDoc.ClearingFiscalYear AS ClearingFiscalYear,
  _ClrgAcctgDoc.ClearingDate AS ClearingDate,
  _AmtTypeText.RenegotiationAmountTypeText AS RenegotiationAmountTypeText
FROM I_PrepaymentAgrmtCshSettlmtTP AS PrepayAgrCashStl
LEFT OUTER JOIN C_PrepaymentAgreementTP AS _PrepaymentAgreement ON PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID  -- association [1..1]
LEFT OUTER JOIN I_PrepaymentRenegttnReasonVH AS _ReasonText ON PurgOrgCompanyCode = _ReasonText.CompanyCode AND PrepaymentAgreementType = _ReasonText.PrepaymentAgreementType AND PrepaymentRenegotiationReason = _ReasonText.PrepaymentRenegotiationReason  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentRenegttnAmtTypeVH AS _AmtTypeText ON PurgOrgCompanyCode = _AmtTypeText.CompanyCode AND PrepaymentAgreementType = _AmtTypeText.PrepaymentAgreementType AND PrepaymentRenegttnAmountType = _AmtTypeText.PrepaymentRenegttnAmountType  -- association [0..1]
LEFT OUTER JOIN I_CshSettlmtClrgAcctgDoc AS _ClrgAcctgDoc ON PrepaymentAgrmtCshSettlmtUUID = _ClrgAcctgDoc.PrepaymentAgrmtCshSettlmtUUID  -- association [0..1]
LEFT OUTER JOIN E_PrepaymentAgrmtCshSettlmt AS _Extension ON PrepaymentAgrmtCshSettlmtUUID = _Extension.PrepaymentAgrmtCshSettlmtUUID  -- association [0..1]
;

Learn More