I_PrepaymentAgrmtCollateral

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_PrepaymentAgrmtCollateral.
-- 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: IPPMGCOLLTRL

CREATE VIEW I_PrepaymentAgrmtCollateral AS
SELECT
  Collateral.prepaymentagreementuuid AS PrepaymentAgreementUUID,
  Collateral.prepaymentcolltrltype AS PrepaymentColltrlType,
  Collateral.prepaymentcolltrlsubtype AS PrepaymentColltrlSubType,
  Collateral.prepaymentcolltrlcode AS PrepaymentColltrlCode,
  Collateral.prepaymentcolltrlisrcvd AS PrepaymentColltrlIsRcvd,
  Collateral.prepaymentcolltrlissettlmtrqd AS PrepaymentColltrlIsSettlmtRqd,
  Collateral.prepaymentcolltrllandareaqty AS PrepaymentColltrlLandAreaQty,
  Collateral.prepaymentcolltrllandareauom AS PrepaymentColltrlLandAreaUoM,
  Collateral.prepaymentcolltrltotprptyqty AS PrepaymentColltrlTotPrptyQty,
  Collateral.prepaymentcolltrltotprptyuom AS PrepaymentColltrlTotPrptyUoM,
  Collateral.prepaymentcolltrlareaqty AS PrepaymentColltrlAreaQty,
  Collateral.prepaymentcolltrlareauom AS PrepaymentColltrlAreaUoM,
  Collateral.prepaymentcolltrlprodtvqty AS PrepaymentColltrlProdtvQty,
  Collateral.prepaymentcolltrlprodtvareauom AS PrepaymentColltrlProdtvAreaUoM,
  Collateral.prepaymentcolltrlplntareaqty AS PrepaymentColltrlPlntAreaQty,
  Collateral.prepaymentcolltrlplntareauom AS PrepaymentColltrlPlntAreaUoM,
  Collateral.prepaymentcolltrlplntareaamt AS PrepaymentColltrlPlntAreaAmt,
  Collateral.prepaymentcolltrlplntareacrcy AS PrepaymentColltrlPlntAreaCrcy,
  Collateral.prepaymentcolltrlcattleareaqty AS PrepaymentColltrlCattleAreaQty,
  Collateral.prepaymentcolltrlcattleareauom AS PrepaymentColltrlCattleAreaUoM,
  Collateral.prepaymentcolltrlcattleareaamt AS PrepaymentColltrlCattleAreaAmt,
  Collateral.prepaymentcolltrlcattlecrcy AS PrepaymentColltrlCattleCrcy,
  Collateral.prepaymentcolltrlclsdareaqty AS PrepaymentColltrlClsdAreaQty,
  Collateral.prepaymentcolltrlclsdareauom AS PrepaymentColltrlClsdAreaUoM,
  Collateral.prepaymentcolltrlclsdareaamt AS PrepaymentColltrlClsdAreaAmt,
  Collateral.prepaymentcolltrlclsdareacrcy AS PrepaymentColltrlClsdAreaCrcy,
  Collateral.prepaymentcolltrlenvrmtareaqty AS PrepaymentColltrlEnvrmtAreaQty,
  Collateral.prepaymentcolltrlenvrmtareauom AS PrepaymentColltrlEnvrmtAreaUoM,
  Collateral.prepaymentcolltrlenvrmtareaamt AS PrepaymentColltrlEnvrmtAreaAmt,
  Collateral.prepaymentcolltrlenvrmtcrcy AS PrepaymentColltrlEnvrmtCrcy,
  Collateral.prepaymentcolltrlinvmttext AS PrepaymentColltrlInvmtText,
  Collateral.prepaymentcolltrlinvmtamt AS PrepaymentColltrlInvmtAmt,
  Collateral.prepaymentcolltrlinvmtamtcrcy AS PrepaymentColltrlInvmtAmtCrcy,
  Collateral.prepaymentcolltrlrotateareaamt AS PrepaymentColltrlRotateAreaAmt,
  Collateral.prepaymentcolltrlrotateamtcrcy AS PrepaymentColltrlRotateAmtCrcy,
  Collateral.prepaymentcolltrlrotatedudte AS PrepaymentColltrlRotateDuDte,
  Collateral.prepaymentcolltrltotamt AS PrepaymentColltrlTotAmt,
  Collateral.prepaymentcolltrltotamtcrcy AS PrepaymentColltrlTotAmtCrcy,
  Collateral.prepaymentcolltrlcitycode AS PrepaymentColltrlCityCode,
  Collateral.prepaymentcolltrlbnfcyname AS PrepaymentColltrlBnfcyName,
  Collateral.prepaymentcolltrlsitn AS PrepaymentColltrlSitn,
  Collateral.prepaymentcolltrldegtext AS PrepaymentColltrlDegText,
  Collateral.prepaymentcolltrlavgprodnqty AS PrepaymentColltrlAvgProdnQty,
  Collateral.prepaymentcolltrlprodnwgtuom AS PrepaymentColltrlProdnWgtUoM,
  Collateral.prepaymentcolltrlavgprodnuom AS PrepaymentColltrlAvgProdnUoM,
  Collateral.prepaymentcolltrlcmtdqty AS PrepaymentColltrlCmtdQty,
  Collateral.prepaymentcolltrlcmtdqtyuom AS PrepaymentColltrlCmtdQtyUoM,
  Collateral.prepaymentcolltrlregnmbrtext AS PrepaymentColltrlRegNmbrText,
  Collateral.prepaymentcolltrltxcodejx AS PrepaymentColltrlTxCodeJx,
  Collateral.prepaymentcolltrlrespname AS PrepaymentColltrlRespName,
  Collateral.prepaymentcolltrlappraisaldte AS PrepaymentColltrlAppraisalDte,
  Collateral.prepaymentcolltrldudte AS PrepaymentColltrlDuDte,
  Collateral.prepaymentcolltrlvenalvalamt AS PrepaymentColltrlVenalValAmt,
  Collateral.prepaymentcolltrlvenalvalcrcy AS PrepaymentColltrlVenalValCrcy,
  Collateral.prepaymentcolltrlstmnttext AS PrepaymentColltrlStmntText,
  Collateral.prepaymentcolltrldesc AS PrepaymentColltrlDesc,
  Collateral.prepaymentmortgagecmtdamt AS PrepaymentMortgageCmtdAmt,
  Collateral.prepaymentmortgagecmtdamtcrcy AS PrepaymentMortgageCmtdAmtCrcy,
  Collateral.prepaymentcolltrlobsvntext AS PrepaymentColltrlObsvnText,
  Collateral.companyregion AS CompanyRegion,
  Collateral.countrycode AS CountryCode,
  _PrepayAgreement.PrepaymentAgreement AS PrepaymentAgreement,
  Collateral.creationdatetime AS CreationDateTime,
  Collateral.lastchangedbyuser AS LastChangedByUser,
  Collateral.lastchangedatetime AS LastChangeDateTime
FROM ppmgag_t_colltrl AS Collateral
LEFT OUTER JOIN E_PrepaymentAgrmtCollateral AS _Extension ON PrepaymentAgrmtColltrlUUID = _Extension.PrepaymentAgrmtColltrlUUID  -- association [0..1]
;