C_PrepaymentAgrmtCshSettlmtTP

DDL: C_PREPAYMENTAGRMTCSHSETTLMTTP SQL: CPPMGCASHSTLTP Type: view CONSUMPTION
24 Fields 1 Data Sources 4 Associations

Prepayment Agrmt Cash Settlement

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

Data Sources (1)

SourceAliasJoin Type
I_PrepaymentAgrmtCshSettlmtTP PrepayAgrCashStl from

Associations (4)

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

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CPPMGCASHSTLTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Prepayment Agrmt 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 (24)

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
RenegotiationReasonText
RenegotiationAmountTypeText _AmtTypeText RenegotiationAmountTypeText
_PrepaymentRenegotiation _PrepaymentRenegotiation

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_PrepaymentAgrmtCshSettlmtTP.
-- 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: CPPMGCASHSTLTP

CREATE VIEW C_PrepaymentAgrmtCshSettlmtTP 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,
  _AmtTypeText.RenegotiationAmountTypeText AS RenegotiationAmountTypeText
FROM I_PrepaymentAgrmtCshSettlmtTP AS PrepayAgrCashStl
LEFT OUTER JOIN C_PreRenegotiationTP AS _PrepaymentRenegotiation ON PrepaymentAgreementUUID = _PrepaymentRenegotiation.PrepaymentAgreementUUID  -- association [1..1]
LEFT OUTER JOIN I_PrepaymentRenegttnReasonVH AS _ReasonText ON PurgOrgCompanyCode = _ReasonText.CompanyCode AND PrepaymentAgreementType = _ReasonText.PrepaymentAgreementType AND PrepaymentRenegotiationReason = _ReasonText.PrepaymentRenegotiationReason  -- association [1..1]
LEFT OUTER JOIN I_PrepaymentRenegttnAmtTypeVH AS _AmtTypeText ON PurgOrgCompanyCode = _AmtTypeText.CompanyCode AND PrepaymentAgreementType = _AmtTypeText.PrepaymentAgreementType AND PrepaymentRenegttnAmountType = _AmtTypeText.PrepaymentRenegttnAmountType  -- association [1..1]
LEFT OUTER JOIN E_PrepaymentAgrmtCshSettlmt AS _Extension ON PrepaymentAgrmtCshSettlmtUUID = _Extension.PrepaymentAgrmtCshSettlmtUUID  -- association [0..1]
;

Learn More