I_PREPAYMENTAGRMTCOLLATERALTP

CDS View
47 Fields 2 CDS Views

Prepayment Agreement Collateral TP View

I_PREPAYMENTAGRMTCOLLATERALTP is a CDS View in S/4HANA. Prepayment Agreement Collateral TP View. It contains 47 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_PrepaymentAgrmtCollateralTP view from CONSUMPTION Prepayment Aggrement Collateral C View
C_PrepaymentRenegttnCollateTP view from CONSUMPTION Prepayment Agreement Collaterals

Fields (47)

KeyField CDS FieldsUsed in Views
CompanyRegion CompanyRegion 2
CountryCode CountryCode 2
PrepaymentColltrlAppraisalDte PrepaymentColltrlAppraisalDte 2
PrepaymentColltrlAreaUoM PrepaymentColltrlAreaUoM 2
PrepaymentColltrlAvgProdnQty PrepaymentColltrlAvgProdnQty 2
PrepaymentColltrlAvgProdnUoM PrepaymentColltrlAvgProdnUoM 2
PrepaymentColltrlBnfcyName PrepaymentColltrlBnfcyName 2
PrepaymentColltrlCattleAreaAmt PrepaymentColltrlCattleAreaAmt 2
PrepaymentColltrlCattleAreaUoM PrepaymentColltrlCattleAreaUoM 2
PrepaymentColltrlCattleCrcy PrepaymentColltrlCattleCrcy 2
PrepaymentColltrlCityCode PrepaymentColltrlCityCode 2
PrepaymentColltrlClsdAreaAmt PrepaymentColltrlClsdAreaAmt 2
PrepaymentColltrlClsdAreaCrcy PrepaymentColltrlClsdAreaCrcy 2
PrepaymentColltrlClsdAreaUoM PrepaymentColltrlClsdAreaUoM 2
PrepaymentColltrlCmtdQty PrepaymentColltrlCmtdQty 2
PrepaymentColltrlCmtdQtyUoM PrepaymentColltrlCmtdQtyUoM 2
PrepaymentColltrlCode PrepaymentColltrlCode 2
PrepaymentColltrlDegText PrepaymentColltrlDegText 2
PrepaymentColltrlDesc PrepaymentColltrlDesc 2
PrepaymentColltrlDuDte PrepaymentColltrlDuDte 2
PrepaymentColltrlEnvrmtAreaAmt PrepaymentColltrlEnvrmtAreaAmt 2
PrepaymentColltrlEnvrmtAreaUoM PrepaymentColltrlEnvrmtAreaUoM 2
PrepaymentColltrlEnvrmtCrcy PrepaymentColltrlEnvrmtCrcy 2
PrepaymentColltrlInvmtAmt PrepaymentColltrlInvmtAmt 2
PrepaymentColltrlInvmtAmtCrcy PrepaymentColltrlInvmtAmtCrcy 2
PrepaymentColltrlLandAreaUoM PrepaymentColltrlLandAreaUoM 2
PrepaymentColltrlObsvnText PrepaymentColltrlObsvnText 2
PrepaymentColltrlPlntAreaAmt PrepaymentColltrlPlntAreaAmt 2
PrepaymentColltrlPlntAreaCrcy PrepaymentColltrlPlntAreaCrcy 2
PrepaymentColltrlPlntAreaUoM PrepaymentColltrlPlntAreaUoM 2
PrepaymentColltrlProdnWgtUoM PrepaymentColltrlProdnWgtUoM 2
PrepaymentColltrlProdtvAreaUoM PrepaymentColltrlProdtvAreaUoM 2
PrepaymentColltrlRegNmbrText PrepaymentColltrlRegNmbrText 2
PrepaymentColltrlRespName PrepaymentColltrlRespName 2
PrepaymentColltrlRotateAmtCrcy PrepaymentColltrlRotateAmtCrcy 2
PrepaymentColltrlRotateDuDte PrepaymentColltrlRotateDuDte 2
PrepaymentColltrlSitn PrepaymentColltrlSitn 2
PrepaymentColltrlStmntText PrepaymentColltrlStmntText 2
PrepaymentColltrlSubType PrepaymentColltrlSubType 2
PrepaymentColltrlTotAmt PrepaymentColltrlTotAmt 2
PrepaymentColltrlTotAmtCrcy PrepaymentColltrlTotAmtCrcy 2
PrepaymentColltrlTotPrptyUoM PrepaymentColltrlTotPrptyUoM 2
PrepaymentColltrlTxCodeJx PrepaymentColltrlTxCodeJx 2
PrepaymentColltrlVenalValAmt PrepaymentColltrlVenalValAmt 2
PrepaymentColltrlVenalValCrcy PrepaymentColltrlVenalValCrcy 2
PrepaymentMortgageCmtdAmt PrepaymentMortgageCmtdAmt 2
PrepaymentMortgageCmtdAmtCrcy PrepaymentMortgageCmtdAmtCrcy 2

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 Collateral TP View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PREPAYMENTAGRMTCOLLATERALTP (
    COMPANYREGION,
    COUNTRYCODE,
    PREPAYMENTCOLLTRLAPPRAISALDTE,
    PREPAYMENTCOLLTRLAREAUOM,
    PREPAYMENTCOLLTRLAVGPRODNQTY,
    PREPAYMENTCOLLTRLAVGPRODNUOM,
    PREPAYMENTCOLLTRLBNFCYNAME,
    PREPAYMENTCOLLTRLCATTLEAREAAMT,
    PREPAYMENTCOLLTRLCATTLEAREAUOM,
    PREPAYMENTCOLLTRLCATTLECRCY,
    PREPAYMENTCOLLTRLCITYCODE,
    PREPAYMENTCOLLTRLCLSDAREAAMT,
    PREPAYMENTCOLLTRLCLSDAREACRCY,
    PREPAYMENTCOLLTRLCLSDAREAUOM,
    PREPAYMENTCOLLTRLCMTDQTY,
    PREPAYMENTCOLLTRLCMTDQTYUOM,
    PREPAYMENTCOLLTRLCODE,
    PREPAYMENTCOLLTRLDEGTEXT,
    PREPAYMENTCOLLTRLDESC,
    PREPAYMENTCOLLTRLDUDTE,
    PREPAYMENTCOLLTRLENVRMTAREAAMT,
    PREPAYMENTCOLLTRLENVRMTAREAUOM,
    PREPAYMENTCOLLTRLENVRMTCRCY,
    PREPAYMENTCOLLTRLINVMTAMT,
    PREPAYMENTCOLLTRLINVMTAMTCRCY,
    PREPAYMENTCOLLTRLLANDAREAUOM,
    PREPAYMENTCOLLTRLOBSVNTEXT,
    PREPAYMENTCOLLTRLPLNTAREAAMT,
    PREPAYMENTCOLLTRLPLNTAREACRCY,
    PREPAYMENTCOLLTRLPLNTAREAUOM,
    PREPAYMENTCOLLTRLPRODNWGTUOM,
    PREPAYMENTCOLLTRLPRODTVAREAUOM,
    PREPAYMENTCOLLTRLREGNMBRTEXT,
    PREPAYMENTCOLLTRLRESPNAME,
    PREPAYMENTCOLLTRLROTATEAMTCRCY,
    PREPAYMENTCOLLTRLROTATEDUDTE,
    PREPAYMENTCOLLTRLSITN,
    PREPAYMENTCOLLTRLSTMNTTEXT,
    PREPAYMENTCOLLTRLSUBTYPE,
    PREPAYMENTCOLLTRLTOTAMT,
    PREPAYMENTCOLLTRLTOTAMTCRCY,
    PREPAYMENTCOLLTRLTOTPRPTYUOM,
    PREPAYMENTCOLLTRLTXCODEJX,
    PREPAYMENTCOLLTRLVENALVALAMT,
    PREPAYMENTCOLLTRLVENALVALCRCY,
    PREPAYMENTMORTGAGECMTDAMT,
    PREPAYMENTMORTGAGECMTDAMTCRCY
);

Learn More