I_PREPAYMENTAGREEMENT

CDS View
91 Fields 17 CDS Views

Prepayment Agreement Interface View

I_PREPAYMENTAGREEMENT is a CDS View in S/4HANA. Prepayment Agreement Interface View. It contains 91 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_PrepaymentAgrmtIntrstSimln view from CONSUMPTION Prepayment Agreement Interest Simulation
I_ACMPrepaymentAgreementVH view_entity from BASIC App Doc Prepayment Agreement
I_PpaytAgrmtOpnAmt view from COMPOSITE Prepayment Agreement Open Amount
I_PrepaymentAgreementDetails view from BASIC prepaymeny Agreement Details
I_PrepaymentAgreementTP view from TRANSACTIONAL Prepayment Agreement Transactional view
I_PrepaymentAgrmtAmount view from COMPOSITE Prepayment Agreement Amount
I_PrepaymentAgrmtDisPostRev view from COMPOSITE prepayment post and reversal
I_PrepaymentAgrmtDocAmount view from COMPOSITE Prepayment Agreement Document Amount
I_PrepaymentAgrmtRenegttnSts view inner COMPOSITE PPA Renegotiation Status
I_PrepaymentCounterpartyHist view from COMPOSITE Prepayment Counterparty History
I_PrepaymentDocumentHist view inner COMPOSITE Prepayment Document History View
I_PrepaymentHistPrepayment view from COMPOSITE Prepayment Document History View
I_PrepaymentRenegotiation view from COMPOSITE Prepayment Agreement Renegotiation
I_PrepaymentRenegttnOriginal view from COMPOSITE PPA Renegotiation Original Info
I_PrepaymentRenegttnPrevious view from COMPOSITE Renegotiated Prepayment Agreement
P_PrepayAgrmtCashSettlmt view inner COMPOSITE
P_PrepaymentAgrmtCollateral view from COMPOSITE

Fields (91)

KeyField CDS FieldsUsed in Views
KEY Counterparty Counterparty 9
KEY PrepaymentAgreement PrepaymentAgreement 9
KEY PrepaymentAgreementUUID PrepaymentAgreementUUID 10
AddressNumber AddressNumber 1
AuthorizationGroup AuthorizationGroup 2
BPTaxNumber BPTaxNumber 3
CompanyCode CompanyCode 9
CompanyRegion CompanyRegion 2
CountryCode CountryCode 2
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 4
CustomerCityCode CustomerCityCode 1
DistributionChannel DistributionChannel 6
Division Division 6
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 2
Plant Plant 4
PrepaymentAgreementAmount PrepaymentAgreementAmount 8
PrepaymentAgreementCategory PrepaymentAgreementCategory 7
PrepaymentAgreementCommodity PrepaymentAgreementCommodity 8
PrepaymentAgreementCurrency PrepaymentAgreementCurrency,PrepaymentInterestCalcAmtCrcy 7
PrepaymentAgreementDescription PrepaymentAgreementDescription 4
PrepaymentAgreementRating PrepaymentAgreementRating 4
PrepaymentAgreementStatus PrepaymentAgreementStatus 9
PrepaymentAgreementType PrepaymentAgreementType 9
PrepaymentAgrmtBPType PrepaymentAgrmtBPType 3
PrepaymentAgrmtCropSeason PrepaymentAgrmtCropSeason 5
PrepaymentAgrmtDueDate PrepaymentAgrmtDueDate 1
PrepaymentAgrmtExtCommentText PrepaymentAgrmtExtCommentText 3
PrepaymentAgrmtIntCommentText PrepaymentAgrmtIntCommentText 3
PrepaymentAgrmtIsReopened PrepaymentAgrmtIsReopened 1
PrepaymentAgrmtLinkStatus PrepaymentAgrmtLinkStatus 7
PrepaymentAgrmtPostingStatus PrepaymentAgrmtPostingStatus 6
PrepaymentAgrmtRjcnReason PrepaymentAgrmtRjcnReason 1
PrepaymentAgrmtSource PrepaymentAgrmtSource 1
PrepaymentAgrmtSrceIsRenegttn PrepaymentAgrmtSrceIsRenegttn 1
PrepaymentApprovalDateTime PrepaymentApprovalDateTime 1
PrepaymentBarterLinkStatus PrepaymentBarterLinkStatus 1
PrepaymentCmtmtPercent PrepaymentCmtmtPercent 3
PrepaymentCostHectareCurrency PrepaymentCostHectareCurrency 2
PrepaymentCostOfPledgeAmt PrepaymentCostOfPledgeAmt 2
PrepaymentCostOfPledgeCurrency PrepaymentCostOfPledgeCurrency 2
PrepaymentCostPerHectareAmt PrepaymentCostPerHectareAmt 2
PrepaymentCreditContractFlag PrepaymentCreditContractFlag 3
PrepaymentCreditHistoryTxt PrepaymentCreditHistoryTxt 3
PrepaymentCreditRegion PrepaymentCreditRegion 2
PrepaymentCreditTotalAreaQty PrepaymentCreditTotalAreaQty 2
PrepaymentCreditTotalAreaUoM PrepaymentCreditTotalAreaUoM 2
PrepaymentCreditTotalCost PrepaymentCreditTotalCost 2
PrepaymentEconomicGroup PrepaymentEconomicGroup 5
PrepaymentEstimatedProdnQty PrepaymentEstimatedProdnQty 2
PrepaymentEstimatedProdnUoM PrepaymentEstimatedProdnUoM 2
PrepaymentEstimatedProdPerUoM PrepaymentEstimatedProdPerUoM 1
PrepaymentIsRenegotiated PrepaymentIsRenegotiated 1
PrepaymentIsRenegttnCshSettlmt PrepaymentIsRenegttnCshSettlmt 1
PrepaymentIsRenegttnStopIntrst PrepaymentIsRenegttnStopIntrst 1
PrepaymentLeasedPlantAreaQty PrepaymentLeasedPlantAreaQty 2
PrepaymentLimitCreditDate PrepaymentLimitCreditDate 6
PrepaymentOwnPlantingAreaQty PrepaymentOwnPlantingAreaQty 2
PrepaymentOwnPlantingAreaUoM PrepaymentOwnPlantingAreaUoM 2
PrepaymentOwnPledgedAreaQty PrepaymentOwnPledgedAreaQty 2
PrepaymentOwnPledgedAreaUoM PrepaymentOwnPledgedAreaUoM 2
PrepaymentPayoutPercent PrepaymentPayoutPercent 3
PrepaymentPlantingAreaUoM PrepaymentPlantingAreaUoM 2
PrepaymentPledgedAreaQty PrepaymentPledgedAreaQty 2
PrepaymentPledgedAreaUoM PrepaymentPledgedAreaUoM 2
PrepaymentPledgedProdtvAreaQty PrepaymentPledgedProdtvAreaQty 2
PrepaymentPledgedProdtvAreaUoM PrepaymentPledgedProdtvAreaUoM 2
PrepaymentPostingProfile PrepaymentPostingProfile 1
PrepaymentPrincipalReduction PrepaymentPrincipalReduction 1
PrepaymentProdtvPlantAreaQty PrepaymentProdtvPlantAreaQty 2
PrepaymentProdtvPlantAreaUoM PrepaymentProdtvPlantAreaUoM 2
PrepaymentProductiveFctrPerUoM PrepaymentProductiveFctrPerUoM 1
PrepaymentProductivityFctrQty PrepaymentProductivityFctrQty 2
PrepaymentProductivityFctrUoM PrepaymentProductivityFctrUoM 2
PrepaymentRejectionText PrepaymentRejectionText 1
PrepaymentRenegttnStopDate PrepaymentRenegttnStopDate 1
PrepaymentRestrictionsTxt PrepaymentRestrictionsTxt 3
PrepaymentStartIntrstDate PrepaymentStartIntrstDate 3
PrepaymentStartIntrstDateType PrepaymentStartIntrstDateType 3
PrepaymentStopIntrstDate PrepaymentStopIntrstDate 3
PrepaymentStopIntrstDateType PrepaymentStopIntrstDateType 3
PrepaymentSuspendIntrstFromDte PrepaymentSuspendIntrstFromDte 1
PrepaymentSuspendIntrstToDte PrepaymentSuspendIntrstToDte 1
PrepaymentTotalCostCurrency PrepaymentTotalCostCurrency 2
PrepaymentTotalPledgedAreaQty PrepaymentTotalPledgedAreaQty 2
PrepaymentTotalPledgedAreaUoM PrepaymentTotalPledgedAreaUoM 2
PurchasingGroup PurchasingGroup 5
PurchasingOrganization PurchasingOrganization 6
SalesOrganization SalesOrganization 6

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Prepayment Agreement Interface View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PREPAYMENTAGREEMENT (
    COUNTERPARTY,
    PREPAYMENTAGREEMENT,
    PREPAYMENTAGREEMENTUUID,
    ADDRESSNUMBER,
    AUTHORIZATIONGROUP,
    BPTAXNUMBER,
    COMPANYCODE,
    COMPANYREGION,
    COUNTRYCODE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    CUSTOMERCITYCODE,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    ISBUSINESSPURPOSECOMPLETED,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PLANT,
    PREPAYMENTAGREEMENTAMOUNT,
    PREPAYMENTAGREEMENTCATEGORY,
    PREPAYMENTAGREEMENTCOMMODITY,
    PREPAYMENTAGREEMENTCURRENCY,
    PREPAYMENTAGREEMENTDESCRIPTION,
    PREPAYMENTAGREEMENTRATING,
    PREPAYMENTAGREEMENTSTATUS,
    PREPAYMENTAGREEMENTTYPE,
    PREPAYMENTAGRMTBPTYPE,
    PREPAYMENTAGRMTCROPSEASON,
    PREPAYMENTAGRMTDUEDATE,
    PREPAYMENTAGRMTEXTCOMMENTTEXT,
    PREPAYMENTAGRMTINTCOMMENTTEXT,
    PREPAYMENTAGRMTISREOPENED,
    PREPAYMENTAGRMTLINKSTATUS,
    PREPAYMENTAGRMTPOSTINGSTATUS,
    PREPAYMENTAGRMTRJCNREASON,
    PREPAYMENTAGRMTSOURCE,
    PREPAYMENTAGRMTSRCEISRENEGTTN,
    PREPAYMENTAPPROVALDATETIME,
    PREPAYMENTBARTERLINKSTATUS,
    PREPAYMENTCMTMTPERCENT,
    PREPAYMENTCOSTHECTARECURRENCY,
    PREPAYMENTCOSTOFPLEDGEAMT,
    PREPAYMENTCOSTOFPLEDGECURRENCY,
    PREPAYMENTCOSTPERHECTAREAMT,
    PREPAYMENTCREDITCONTRACTFLAG,
    PREPAYMENTCREDITHISTORYTXT,
    PREPAYMENTCREDITREGION,
    PREPAYMENTCREDITTOTALAREAQTY,
    PREPAYMENTCREDITTOTALAREAUOM,
    PREPAYMENTCREDITTOTALCOST,
    PREPAYMENTECONOMICGROUP,
    PREPAYMENTESTIMATEDPRODNQTY,
    PREPAYMENTESTIMATEDPRODNUOM,
    PREPAYMENTESTIMATEDPRODPERUOM,
    PREPAYMENTISRENEGOTIATED,
    PREPAYMENTISRENEGTTNCSHSETTLMT,
    PREPAYMENTISRENEGTTNSTOPINTRST,
    PREPAYMENTLEASEDPLANTAREAQTY,
    PREPAYMENTLIMITCREDITDATE,
    PREPAYMENTOWNPLANTINGAREAQTY,
    PREPAYMENTOWNPLANTINGAREAUOM,
    PREPAYMENTOWNPLEDGEDAREAQTY,
    PREPAYMENTOWNPLEDGEDAREAUOM,
    PREPAYMENTPAYOUTPERCENT,
    PREPAYMENTPLANTINGAREAUOM,
    PREPAYMENTPLEDGEDAREAQTY,
    PREPAYMENTPLEDGEDAREAUOM,
    PREPAYMENTPLEDGEDPRODTVAREAQTY,
    PREPAYMENTPLEDGEDPRODTVAREAUOM,
    PREPAYMENTPOSTINGPROFILE,
    PREPAYMENTPRINCIPALREDUCTION,
    PREPAYMENTPRODTVPLANTAREAQTY,
    PREPAYMENTPRODTVPLANTAREAUOM,
    PREPAYMENTPRODUCTIVEFCTRPERUOM,
    PREPAYMENTPRODUCTIVITYFCTRQTY,
    PREPAYMENTPRODUCTIVITYFCTRUOM,
    PREPAYMENTREJECTIONTEXT,
    PREPAYMENTRENEGTTNSTOPDATE,
    PREPAYMENTRESTRICTIONSTXT,
    PREPAYMENTSTARTINTRSTDATE,
    PREPAYMENTSTARTINTRSTDATETYPE,
    PREPAYMENTSTOPINTRSTDATE,
    PREPAYMENTSTOPINTRSTDATETYPE,
    PREPAYMENTSUSPENDINTRSTFROMDTE,
    PREPAYMENTSUSPENDINTRSTTODTE,
    PREPAYMENTTOTALCOSTCURRENCY,
    PREPAYMENTTOTALPLEDGEDAREAQTY,
    PREPAYMENTTOTALPLEDGEDAREAUOM,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    PRIMARY KEY (COUNTERPARTY, PREPAYMENTAGREEMENT, PREPAYMENTAGREEMENTUUID)
);

Learn More