I_PrepaymentAgreement

DDL: I_PREPAYMENTAGREEMENT SQL: IPPMGAGREEMENT Type: view BASIC
88 Fields 1 Data Sources 2 Associations

Prepayment Agreement Interface View

I_PrepaymentAgreement is a Basic CDS View that provides data about "Prepayment Agreement Interface View" in SAP S/4HANA. It reads from 1 data source (ppmgag_t_ppmt) and exposes 88 fields with key field PrepaymentAgreementUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ppmgag_t_ppmt PrepaymentAgmnt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerSupplier _BusinessPartner $projection.Counterparty = _BusinessPartner.Supplier -- Extension View for Free Characteristics in Prepayment Agreement Header
[0..1] E_PrepaymentAgreement _Extension $projection.PrepaymentAgreementUUID = _Extension.PrepaymentAgreementUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPPMGAGREEMENT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Prepayment Agreement Interface View view

Fields (88)

KeyFieldSource TableSource FieldDescription
KEY PrepaymentAgreementUUID ppmgag_t_ppmt prepaymentagreementuuid Key
PrepaymentAgreement ppmgag_t_ppmt prepaymentagreement Renegotiation PPA
PrepaymentAgreementCategory ppmgag_t_ppmt prepaymentagreementcategory Prepayment Category
PrepaymentAgreementDescription ppmgag_t_ppmt prepaymentagreementdescription Pre Agreement Desc.
PrepaymentAgreementAmount ppmgag_t_ppmt prepaymentagreementamount Pre Agrm Amount
PrepaymentAgreementCurrency ppmgag_t_ppmt prepaymentagreementcurrency Currency
PrepaymentAgreementStatus ppmgag_t_ppmt prepaymentagreementstatus Pre Agreement Status
PrepaymentAgreementCommodity ppmgag_t_ppmt prepaymentagreementcommodity Commodity
CompanyCode ppmgag_t_ppmt companycode Receiver Company Code
PrepaymentEconomicGroup ppmgag_t_ppmt prepaymenteconomicgroup Economic Group
PrepaymentAgrmtExtCommentText ppmgag_t_ppmt prepaymentagrmtextcommenttext Internal Comments
PrepaymentAgrmtIntCommentText ppmgag_t_ppmt prepaymentagrmtintcommenttext External Comments
PurchasingGroup ppmgag_t_ppmt purchasinggroup Purchasing Group
PurchasingOrganization ppmgag_t_ppmt purchasingorganization Purchasing Organization
SalesOrganization ppmgag_t_ppmt salesorganization Sales Organization
DistributionChannel ppmgag_t_ppmt distributionchannel RefDistCh-Cust/Mat.
Division ppmgag_t_ppmt division Internal Division ID
Plant ppmgag_t_ppmt plant Valuation Area
PrepaymentAgrmtCropSeason ppmgag_t_ppmt prepaymentagrmtcropseason Crop Season
Counterparty ppmgag_t_ppmt counterparty Supplier
PrepaymentAgrmtBPType ppmgag_t_ppmt prepaymentagrmtbptype Counterparty Type
PrepaymentPrincipalReduction ppmgag_t_ppmt prepaymentprincipalreduction Principal Reduction
PrepaymentAgreementRating ppmgag_t_ppmt prepaymentagreementrating Credit Rating
PrepaymentLeasedPlantAreaQty ppmgag_t_ppmt prepaymentleasedplantareaqty Size-Leasd PlntgArea
PrepaymentPlantingAreaUoM ppmgag_t_ppmt prepaymentplantingareauom Size of Leased Pl.Ar
PrepaymentProdtvPlantAreaQty ppmgag_t_ppmt prepaymentprodtvplantareaqty Prod Planting Area
PrepaymentProdtvPlantAreaUoM ppmgag_t_ppmt prepaymentprodtvplantareauom Prod Plntng Area UoM
PrepaymentOwnPlantingAreaQty ppmgag_t_ppmt prepaymentownplantingareaqty Own Planting Area
PrepaymentOwnPlantingAreaUoM ppmgag_t_ppmt prepaymentownplantingareauom Planting Area UoM
PrepaymentCreditTotalAreaQty ppmgag_t_ppmt prepaymentcredittotalareaqty Total Credit Area
PrepaymentCreditTotalAreaUoM ppmgag_t_ppmt prepaymentcredittotalareauom Total Area UoM
PrepaymentPledgedAreaQty ppmgag_t_ppmt prepaymentpledgedareaqty Pledged Area
PrepaymentPledgedAreaUoM ppmgag_t_ppmt prepaymentpledgedareauom Pledged Area UoM
PrepaymentPledgedProdtvAreaQty ppmgag_t_ppmt prepaymentpledgedprodtvareaqty Productive Area
PrepaymentPledgedProdtvAreaUoM ppmgag_t_ppmt prepaymentpledgedprodtvareauom Productive Area UoM
PrepaymentOwnPledgedAreaQty ppmgag_t_ppmt prepaymentownpledgedareaqty Own Pledged Area
PrepaymentOwnPledgedAreaUoM ppmgag_t_ppmt prepaymentownpledgedareauom Own Pledged Area UoM
PrepaymentTotalPledgedAreaQty ppmgag_t_ppmt prepaymenttotalpledgedareaqty Pledged Area
PrepaymentTotalPledgedAreaUoM ppmgag_t_ppmt prepaymenttotalpledgedareauom Totl Pldged Area UoM
PrepaymentCostPerHectareAmt ppmgag_t_ppmt prepaymentcostperhectareamt Cost Per Hectare
PrepaymentCostHectareCurrency ppmgag_t_ppmt prepaymentcosthectarecurrency Cost/Hectare Currenc
PrepaymentCostOfPledgeAmt ppmgag_t_ppmt prepaymentcostofpledgeamt Cost of Pledge
PrepaymentCostOfPledgeCurrency ppmgag_t_ppmt prepaymentcostofpledgecurrency Cost of Pledge Curr.
PrepaymentCreditTotalCost ppmgag_t_ppmt prepaymentcredittotalcost Total Cost
PrepaymentTotalCostCurrency ppmgag_t_ppmt prepaymenttotalcostcurrency Total Cost Currency
PrepaymentProductivityFctrQty ppmgag_t_ppmt prepaymentproductivityfctrqty Productivity Factor
PrepaymentProductivityFctrUoM ppmgag_t_ppmt prepaymentproductivityfctruom Prodvty Factor UoM
PrepaymentProductiveFctrPerUoM ppmgag_t_ppmt prepaymentproductivefctrperuom Prod. Factor UoM
PrepaymentCreditRegion ppmgag_t_ppmt prepaymentcreditregion Credit Region
PrepaymentEstimatedProdnQty ppmgag_t_ppmt prepaymentestimatedprodnqty Estimated Production
PrepaymentEstimatedProdnUoM ppmgag_t_ppmt prepaymentestimatedprodnuom Estimated Prod. UoM
PrepaymentEstimatedProdPerUoM ppmgag_t_ppmt prepaymentestimatedprodperuom Est Prod Per UoM
PrepaymentLimitCreditDate ppmgag_t_ppmt prepaymentlimitcreditdate Crdt Use Limit Date
PrepaymentCmtmtPercent ppmgag_t_ppmt prepaymentcmtmtpercent % of Commitment
PrepaymentPayoutPercent ppmgag_t_ppmt prepaymentpayoutpercent Payout Percentage
PrepaymentCreditContractFlag ppmgag_t_ppmt prepaymentcreditcontractflag Credit Contract
PrepaymentStartIntrstDateType ppmgag_t_ppmt prepaymentstartintrstdatetype Int. Start Date Type
PrepaymentStartIntrstDate ppmgag_t_ppmt prepaymentstartintrstdate Interest Start Date
PrepaymentStopIntrstDateType ppmgag_t_ppmt prepaymentstopintrstdatetype Int. Stop Date Type
PrepaymentStopIntrstDate ppmgag_t_ppmt prepaymentstopintrstdate Interest Stop Date
PrepaymentRestrictionsTxt ppmgag_t_ppmt prepaymentrestrictionstxt Credit Restrictions
PrepaymentCreditHistoryTxt ppmgag_t_ppmt prepaymentcredithistorytxt Credit History
BPTaxNumber ppmgag_t_ppmt bptaxnumber Tax Number
AddressNumber ppmgag_t_ppmt addressnumber Src Address No
PrepaymentAgrmtLinkStatus ppmgag_t_ppmt prepaymentagrmtlinkstatus Link Status
PrepaymentAgrmtPostingStatus ppmgag_t_ppmt prepaymentagrmtpostingstatus Pre Posting Status
PrepaymentPostingProfile ppmgag_t_ppmt prepaymentpostingprofile Settl Recvry Profile
PrepaymentBarterLinkStatus ppmgag_t_ppmt prepaymentbarterlinkstatus Prepmt Barter Status
PrepaymentApprovalDateTime ppmgag_t_ppmt prepaymentapprovaldatetime Prepmt Appr DateTime
CountryCode ppmgag_t_ppmt countrycode Country/Reg.
CompanyRegion ppmgag_t_ppmt companyregion Region
CustomerCityCode ppmgag_t_ppmt customercitycode City Code
PrepaymentAgrmtRjcnReason ppmgag_t_ppmt prepaymentagrmtrjcnreason Reason Code
PrepaymentRejectionText ppmgag_t_ppmt prepaymentrejectiontext Rejection Comment
PrepaymentAgrmtSource ppmgag_t_ppmt prepaymentagrmtsource PreAgmnt Source
PrepaymentSuspendIntrstFromDte ppmgag_t_ppmt prepaymentsuspendintrstfromdte Susp. Interest From
PrepaymentSuspendIntrstToDte ppmgag_t_ppmt prepaymentsuspendintrsttodte Susp. Interest Until
PrepaymentIsRenegotiated ppmgag_t_ppmt prepaymentisrenegotiated PPA Renegotiated
PrepaymentIsRenegttnStopIntrst ppmgag_t_ppmt prepaymentisrenegttnstopintrst Stop Interest Ind.
PrepaymentAgrmtSrceIsRenegttn ppmgag_t_ppmt prepaymentagrmtsrceisrenegttn Source Is Reneg.
PrepaymentIsRenegttnCshSettlmt ppmgag_t_ppmt prepaymentisrenegttncshsettlmt Reneg. Cash Stlmt
PrepaymentAgrmtIsReopened ppmgag_t_ppmt prepaymentagrmtisreopened PPA is Reopened
IsBusinessPurposeCompleted
AuthorizationGroup _BusinessPartner AuthorizationGroup AuthorizGroup
createdbyuserasCreatedByUser
CreationDateTime ppmgag_t_ppmt creationdatetime Timestamp
LastChangedByUser ppmgag_t_ppmt lastchangedbyuser User Name
LastChangeDateTime ppmgag_t_ppmt lastchangedatetime Timestamp

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_PrepaymentAgreement.
-- 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: IPPMGAGREEMENT

CREATE VIEW I_PrepaymentAgreement AS
SELECT
  PrepaymentAgmnt.prepaymentagreementuuid AS PrepaymentAgreementUUID,
  PrepaymentAgmnt.prepaymentagreement AS PrepaymentAgreement,
  PrepaymentAgmnt.prepaymentagreementcategory AS PrepaymentAgreementCategory,
  PrepaymentAgmnt.prepaymentagreementdescription AS PrepaymentAgreementDescription,
  PrepaymentAgmnt.prepaymentagreementamount AS PrepaymentAgreementAmount,
  PrepaymentAgmnt.prepaymentagreementcurrency AS PrepaymentAgreementCurrency,
  PrepaymentAgmnt.prepaymentagreementstatus AS PrepaymentAgreementStatus,
  PrepaymentAgmnt.prepaymentagreementcommodity AS PrepaymentAgreementCommodity,
  PrepaymentAgmnt.companycode AS CompanyCode,
  PrepaymentAgmnt.prepaymenteconomicgroup AS PrepaymentEconomicGroup,
  PrepaymentAgmnt.prepaymentagrmtextcommenttext AS PrepaymentAgrmtExtCommentText,
  PrepaymentAgmnt.prepaymentagrmtintcommenttext AS PrepaymentAgrmtIntCommentText,
  PrepaymentAgmnt.purchasinggroup AS PurchasingGroup,
  PrepaymentAgmnt.purchasingorganization AS PurchasingOrganization,
  PrepaymentAgmnt.salesorganization AS SalesOrganization,
  PrepaymentAgmnt.distributionchannel AS DistributionChannel,
  PrepaymentAgmnt.division AS Division,
  PrepaymentAgmnt.plant AS Plant,
  PrepaymentAgmnt.prepaymentagrmtcropseason AS PrepaymentAgrmtCropSeason,
  PrepaymentAgmnt.counterparty AS Counterparty,
  PrepaymentAgmnt.prepaymentagrmtbptype AS PrepaymentAgrmtBPType,
  PrepaymentAgmnt.prepaymentprincipalreduction AS PrepaymentPrincipalReduction,
  PrepaymentAgmnt.prepaymentagreementrating AS PrepaymentAgreementRating,
  PrepaymentAgmnt.prepaymentleasedplantareaqty AS PrepaymentLeasedPlantAreaQty,
  PrepaymentAgmnt.prepaymentplantingareauom AS PrepaymentPlantingAreaUoM,
  PrepaymentAgmnt.prepaymentprodtvplantareaqty AS PrepaymentProdtvPlantAreaQty,
  PrepaymentAgmnt.prepaymentprodtvplantareauom AS PrepaymentProdtvPlantAreaUoM,
  PrepaymentAgmnt.prepaymentownplantingareaqty AS PrepaymentOwnPlantingAreaQty,
  PrepaymentAgmnt.prepaymentownplantingareauom AS PrepaymentOwnPlantingAreaUoM,
  PrepaymentAgmnt.prepaymentcredittotalareaqty AS PrepaymentCreditTotalAreaQty,
  PrepaymentAgmnt.prepaymentcredittotalareauom AS PrepaymentCreditTotalAreaUoM,
  PrepaymentAgmnt.prepaymentpledgedareaqty AS PrepaymentPledgedAreaQty,
  PrepaymentAgmnt.prepaymentpledgedareauom AS PrepaymentPledgedAreaUoM,
  PrepaymentAgmnt.prepaymentpledgedprodtvareaqty AS PrepaymentPledgedProdtvAreaQty,
  PrepaymentAgmnt.prepaymentpledgedprodtvareauom AS PrepaymentPledgedProdtvAreaUoM,
  PrepaymentAgmnt.prepaymentownpledgedareaqty AS PrepaymentOwnPledgedAreaQty,
  PrepaymentAgmnt.prepaymentownpledgedareauom AS PrepaymentOwnPledgedAreaUoM,
  PrepaymentAgmnt.prepaymenttotalpledgedareaqty AS PrepaymentTotalPledgedAreaQty,
  PrepaymentAgmnt.prepaymenttotalpledgedareauom AS PrepaymentTotalPledgedAreaUoM,
  PrepaymentAgmnt.prepaymentcostperhectareamt AS PrepaymentCostPerHectareAmt,
  PrepaymentAgmnt.prepaymentcosthectarecurrency AS PrepaymentCostHectareCurrency,
  PrepaymentAgmnt.prepaymentcostofpledgeamt AS PrepaymentCostOfPledgeAmt,
  PrepaymentAgmnt.prepaymentcostofpledgecurrency AS PrepaymentCostOfPledgeCurrency,
  PrepaymentAgmnt.prepaymentcredittotalcost AS PrepaymentCreditTotalCost,
  PrepaymentAgmnt.prepaymenttotalcostcurrency AS PrepaymentTotalCostCurrency,
  PrepaymentAgmnt.prepaymentproductivityfctrqty AS PrepaymentProductivityFctrQty,
  PrepaymentAgmnt.prepaymentproductivityfctruom AS PrepaymentProductivityFctrUoM,
  PrepaymentAgmnt.prepaymentproductivefctrperuom AS PrepaymentProductiveFctrPerUoM,
  PrepaymentAgmnt.prepaymentcreditregion AS PrepaymentCreditRegion,
  PrepaymentAgmnt.prepaymentestimatedprodnqty AS PrepaymentEstimatedProdnQty,
  PrepaymentAgmnt.prepaymentestimatedprodnuom AS PrepaymentEstimatedProdnUoM,
  PrepaymentAgmnt.prepaymentestimatedprodperuom AS PrepaymentEstimatedProdPerUoM,
  PrepaymentAgmnt.prepaymentlimitcreditdate AS PrepaymentLimitCreditDate,
  PrepaymentAgmnt.prepaymentcmtmtpercent AS PrepaymentCmtmtPercent,
  PrepaymentAgmnt.prepaymentpayoutpercent AS PrepaymentPayoutPercent,
  PrepaymentAgmnt.prepaymentcreditcontractflag AS PrepaymentCreditContractFlag,
  PrepaymentAgmnt.prepaymentstartintrstdatetype AS PrepaymentStartIntrstDateType,
  PrepaymentAgmnt.prepaymentstartintrstdate AS PrepaymentStartIntrstDate,
  PrepaymentAgmnt.prepaymentstopintrstdatetype AS PrepaymentStopIntrstDateType,
  PrepaymentAgmnt.prepaymentstopintrstdate AS PrepaymentStopIntrstDate,
  PrepaymentAgmnt.prepaymentrestrictionstxt AS PrepaymentRestrictionsTxt,
  PrepaymentAgmnt.prepaymentcredithistorytxt AS PrepaymentCreditHistoryTxt,
  PrepaymentAgmnt.bptaxnumber AS BPTaxNumber,
  PrepaymentAgmnt.addressnumber AS AddressNumber,
  PrepaymentAgmnt.prepaymentagrmtlinkstatus AS PrepaymentAgrmtLinkStatus,
  PrepaymentAgmnt.prepaymentagrmtpostingstatus AS PrepaymentAgrmtPostingStatus,
  PrepaymentAgmnt.prepaymentpostingprofile AS PrepaymentPostingProfile,
  PrepaymentAgmnt.prepaymentbarterlinkstatus AS PrepaymentBarterLinkStatus,
  PrepaymentAgmnt.prepaymentapprovaldatetime AS PrepaymentApprovalDateTime,
  PrepaymentAgmnt.countrycode AS CountryCode,
  PrepaymentAgmnt.companyregion AS CompanyRegion,
  PrepaymentAgmnt.customercitycode AS CustomerCityCode,
  PrepaymentAgmnt.prepaymentagrmtrjcnreason AS PrepaymentAgrmtRjcnReason,
  PrepaymentAgmnt.prepaymentrejectiontext AS PrepaymentRejectionText,
  PrepaymentAgmnt.prepaymentagrmtsource AS PrepaymentAgrmtSource,
  PrepaymentAgmnt.prepaymentsuspendintrstfromdte AS PrepaymentSuspendIntrstFromDte,
  PrepaymentAgmnt.prepaymentsuspendintrsttodte AS PrepaymentSuspendIntrstToDte,
  PrepaymentAgmnt.prepaymentisrenegotiated AS PrepaymentIsRenegotiated,
  PrepaymentAgmnt.prepaymentisrenegttnstopintrst AS PrepaymentIsRenegttnStopIntrst,
  PrepaymentAgmnt.prepaymentagrmtsrceisrenegttn AS PrepaymentAgrmtSrceIsRenegttn,
  PrepaymentAgmnt.prepaymentisrenegttncshsettlmt AS PrepaymentIsRenegttnCshSettlmt,
  PrepaymentAgmnt.prepaymentagrmtisreopened AS PrepaymentAgrmtIsReopened,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  PrepaymentAgmnt.creationdatetime AS CreationDateTime,
  PrepaymentAgmnt.lastchangedbyuser AS LastChangedByUser,
  PrepaymentAgmnt.lastchangedatetime AS LastChangeDateTime
FROM ppmgag_t_ppmt AS PrepaymentAgmnt
LEFT OUTER JOIN I_BusinessPartnerSupplier AS _BusinessPartner ON Counterparty = _BusinessPartner.Supplier  -- association [0..1]
LEFT OUTER JOIN E_PrepaymentAgreement AS _Extension ON PrepaymentAgreementUUID = _Extension.PrepaymentAgreementUUID  -- association [0..1]
;

Learn More