I_PrepaymentRenegttnOriginal

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_PrepaymentRenegttnOriginal.
-- 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: IPPMGAGRENORG

CREATE VIEW I_PrepaymentRenegttnOriginal AS
SELECT
  PrepaymentAgmnt.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepaymentAgmnt.PrepaymentAgreement AS PrepaymentAgreement,
  PrepaymentAgmnt.PrepaymentAgreementType AS PrepaymentAgreementType,
  PrepaymentAgmnt.PrepaymentAgreementCommodity AS PrepaymentAgreementCommodity,
  PrepaymentAgmnt.PrepaymentAgreementStatus AS PrepaymentAgreementStatus,
  PrepaymentAgmnt.PrepaymentAgreementDescription AS PrepaymentAgreementDescription,
  PrepaymentAgmnt.Counterparty AS Counterparty,
  PrepaymentAgmnt.PrepaymentEconomicGroup AS PrepaymentEconomicGroup,
  PrepaymentAgmnt.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtLinkStatus,
  PrepaymentAgmnt.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  PrepaymentAgmnt.CompanyCode AS CompanyCode,
  PrepaymentAgmnt.CreatedByUser AS CreatedByUser,
  PrepaymentAgmnt.PrepaymentLimitCreditDate AS PrepaymentLimitCreditDate,
  PrepaymentAgmnt.PrepaymentAgreementAmount AS PrepaymentAgreementAmount,
  PrepaymentAgmnt.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  _PrepaymentAgrmtAmount.PrepaymentAgrmtConsumedAmount AS PrepaymentAgrmtLinkAmount,
  _PrepaymentAgrmtAmount.PrepaymentAgrmtSettledAmount AS PrepaymentAgrmtSettledAmount,
  _PrepaymentAgrmtAmount.PrepaymentAgrmtOpenAmount AS PrepaymentAgrmtPndgRcvryAmt,
  PrepaymentAgmnt.PrepaymentAgrmtCropSeason AS PrepaymentAgrmtCropSeason,
  _CropSeasonText.PrepaymentCropSeasonText AS PrepaymentCropSeasonText
FROM I_PrepaymentAgreement AS PrepaymentAgmnt
LEFT OUTER JOIN I_PrepaymentAgrmtAmount AS _PrepaymentAgrmtAmount ON PrepaymentAgreement = _PrepaymentAgrmtAmount.PrepaymentAgreement  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _PreAgrmtPostingStatusText ON PrepaymentAgrmtPostingStatus = _PreAgrmtPostingStatusText.SystemStatus AND _PreAgrmtPostingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _PrepaymentAgrmtStatusText ON PrepaymentAgreementStatus = _PrepaymentAgrmtStatusText.SystemStatus AND _PrepaymentAgrmtStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtUserNameText AS _UserText ON CreatedByUser = _UserText.UserName  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtLinkStsText AS _LinkStatusText ON PrepaymentAgrmtLinkStatus = _LinkStatusText.PrepaymentAgrmtDomainCode AND _LinkStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentEconomicGrpTxt AS _EconomicGroupText ON PrepaymentEconomicGroup = _EconomicGroupText.PrepaymentEconomicGroup AND Counterparty = _EconomicGroupText.Counterparty AND _EconomicGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyText AS _CmmdtyType ON PrepaymentAgreementCommodity = _CmmdtyType.Commodity  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CoCode ON CompanyCode = _CoCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentCropSeasonCalcTxt AS _CropSeasonText ON PrepaymentAgrmtCropSeason = _CropSeasonText.PrepaymentAgrmtCropSeason AND Counterparty = _CropSeasonText.Counterparty AND PrepaymentEconomicGroup = _CropSeasonText.PrepaymentEconomicGroup AND _CropSeasonText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BPText ON Counterparty = _BPText.BusinessPartner  -- association [0..1]
;