I_PrepaymentAgreementTP

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_PrepaymentAgreementTP.
-- 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: IPPMGAGRMTTP

CREATE VIEW I_PrepaymentAgreementTP AS
SELECT
  PrepaymentAgreement.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepaymentAgreement.PrepaymentAgreement AS PrepaymentAgreement,
  PrepaymentAgreement.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  PrepaymentAgreement.PrepaymentAgreementDescription AS PrepaymentAgreementDescription,
  PrepaymentAgreement.PrepaymentAgreementAmount AS PrepaymentAgreementAmount,
  PrepaymentAgreement.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  PrepaymentAgreement.PrepaymentAgreementStatus AS PrepaymentAgreementStatus,
  PrepaymentAgreement.PrepaymentAgreementCommodity AS PrepaymentAgreementCommodity,
  PrepaymentAgreement.CompanyCode AS CompanyCode,
  PrepaymentAgreement.PrepaymentEconomicGroup AS PrepaymentEconomicGroup,
  PrepaymentAgreement.PurchasingGroup AS PurchasingGroup,
  PrepaymentAgreement.PurchasingOrganization AS PurchasingOrganization,
  PrepaymentAgreement.SalesOrganization AS SalesOrganization,
  PrepaymentAgreement.DistributionChannel AS DistributionChannel,
  PrepaymentAgreement.Division AS Division,
  PrepaymentAgreement.Plant AS Plant,
  PrepaymentAgreement.PrepaymentAgrmtCropSeason AS PrepaymentAgrmtCropSeason,
  PrepaymentAgreement.Counterparty AS Counterparty,
  PrepaymentAgreement.PrepaymentAgrmtBPType AS PrepaymentAgrmtBPType,
  PrepaymentAgreement.PrepaymentPrincipalReduction AS PrepaymentPrincipalReduction,
  PrepaymentAgreement.PrepaymentPostingProfile AS PrepaymentPostingProfile,
  PrepaymentAgreement.PrepaymentAgreementRating AS PrepaymentAgreementRating,
  PrepaymentAgreement.PrepaymentLeasedPlantAreaQty AS PrepaymentLeasedPlantAreaQty,
  PrepaymentAgreement.PrepaymentPlantingAreaUoM AS PrepaymentPlantingAreaUoM,
  PrepaymentAgreement.PrepaymentProdtvPlantAreaQty AS PrepaymentProdtvPlantAreaQty,
  PrepaymentAgreement.PrepaymentProdtvPlantAreaUoM AS PrepaymentProdtvPlantAreaUoM,
  PrepaymentAgreement.PrepaymentOwnPlantingAreaQty AS PrepaymentOwnPlantingAreaQty,
  PrepaymentAgreement.PrepaymentOwnPlantingAreaUoM AS PrepaymentOwnPlantingAreaUoM,
  PrepaymentAgreement.PrepaymentCreditTotalAreaQty AS PrepaymentCreditTotalAreaQty,
  PrepaymentAgreement.PrepaymentCreditTotalAreaUoM AS PrepaymentCreditTotalAreaUoM,
  PrepaymentAgreement.PrepaymentPledgedAreaQty AS PrepaymentPledgedAreaQty,
  PrepaymentAgreement.PrepaymentPledgedAreaUoM AS PrepaymentPledgedAreaUoM,
  PrepaymentAgreement.PrepaymentPledgedProdtvAreaQty AS PrepaymentPledgedProdtvAreaQty,
  PrepaymentAgreement.PrepaymentPledgedProdtvAreaUoM AS PrepaymentPledgedProdtvAreaUoM,
  PrepaymentAgreement.PrepaymentOwnPledgedAreaQty AS PrepaymentOwnPledgedAreaQty,
  PrepaymentAgreement.PrepaymentOwnPledgedAreaUoM AS PrepaymentOwnPledgedAreaUoM,
  PrepaymentAgreement.PrepaymentTotalPledgedAreaQty AS PrepaymentTotalPledgedAreaQty,
  PrepaymentAgreement.PrepaymentTotalPledgedAreaUoM AS PrepaymentTotalPledgedAreaUoM,
  PrepaymentAgreement.PrepaymentCostPerHectareAmt AS PrepaymentCostPerHectareAmt,
  PrepaymentAgreement.PrepaymentCostHectareCurrency AS PrepaymentCostHectareCurrency,
  PrepaymentAgreement.PrepaymentCostOfPledgeAmt AS PrepaymentCostOfPledgeAmt,
  PrepaymentAgreement.PrepaymentCostOfPledgeCurrency AS PrepaymentCostOfPledgeCurrency,
  PrepaymentAgreement.PrepaymentCreditTotalCost AS PrepaymentCreditTotalCost,
  PrepaymentAgreement.PrepaymentTotalCostCurrency AS PrepaymentTotalCostCurrency,
  PrepaymentAgreement.PrepaymentProductivityFctrQty AS PrepaymentProductivityFctrQty,
  PrepaymentAgreement.PrepaymentProductivityFctrUoM AS PrepaymentProductivityFctrUoM,
  PrepaymentAgreement.PrepaymentProductiveFctrPerUoM AS PrepaymentProductiveFctrPerUoM,
  PrepaymentAgreement.PrepaymentCreditRegion AS PrepaymentCreditRegion,
  PrepaymentAgreement.PrepaymentEstimatedProdnQty AS PrepaymentEstimatedProdnQty,
  PrepaymentAgreement.PrepaymentEstimatedProdnUoM AS PrepaymentEstimatedProdnUoM,
  PrepaymentAgreement.PrepaymentEstimatedProdPerUoM AS PrepaymentEstimatedProdPerUoM,
  PrepaymentAgreement.PrepaymentLimitCreditDate AS PrepaymentLimitCreditDate,
  PrepaymentAgreement.PrepaymentCmtmtPercent AS PrepaymentCmtmtPercent,
  PrepaymentAgreement.PrepaymentPayoutPercent AS PrepaymentPayoutPercent,
  PrepaymentAgreement.PrepaymentCreditContractFlag AS PrepaymentCreditContractFlag,
  PrepaymentAgreement.PrepaymentStartIntrstDateType AS PrepaymentStartIntrstDateType,
  PrepaymentAgreement.PrepaymentStartIntrstDate AS PrepaymentStartIntrstDate,
  PrepaymentAgreement.PrepaymentStopIntrstDateType AS PrepaymentStopIntrstDateType,
  PrepaymentAgreement.PrepaymentStopIntrstDate AS PrepaymentStopIntrstDate,
  PrepaymentAgreement.PrepaymentRestrictionsTxt AS PrepaymentRestrictionsTxt,
  PrepaymentAgreement.PrepaymentCreditHistoryTxt AS PrepaymentCreditHistoryTxt,
  PrepaymentAgreement.BPTaxNumber AS BPTaxNumber,
  PrepaymentAgreement.AddressNumber AS AddressNumber,
  PrepaymentAgreement.PrepaymentAgrmtExtCommentText AS PrepaymentAgrmtExtCommentText,
  PrepaymentAgreement.PrepaymentAgrmtIntCommentText AS PrepaymentAgrmtIntCommentText,
  PrepaymentAgreement.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtLinkStatus,
  PrepaymentAgreement.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  PrepaymentAgreement.PrepaymentBarterLinkStatus AS PrepaymentBarterLinkStatus,
  PrepaymentAgreement.PrepaymentApprovalDateTime AS PrepaymentApprovalDateTime,
  PrepaymentAgreement.CountryCode AS CountryCode,
  PrepaymentAgreement.CompanyRegion AS CompanyRegion,
  PrepaymentAgreement.CustomerCityCode AS CustomerCityCode,
  PrepaymentAgreement.PrepaymentAgrmtRjcnReason AS PrepaymentAgrmtRjcnReason,
  PrepaymentAgreement.PrepaymentRejectionText AS PrepaymentRejectionText,
  PrepaymentAgreement.PrepaymentAgrmtSource AS PrepaymentAgrmtSource,
  PrepaymentAgreement.PrepaymentRenegttnStopDate AS PrepaymentRenegttnStopDate,
  PrepaymentAgreement.PrepaymentSuspendIntrstFromDte AS PrepaymentSuspendIntrstFromDte,
  PrepaymentAgreement.PrepaymentSuspendIntrstToDte AS PrepaymentSuspendIntrstToDte,
  PrepaymentAgreement.PrepaymentIsRenegotiated AS PrepaymentIsRenegotiated,
  PrepaymentAgreement.PrepaymentIsRenegttnStopIntrst AS PrepaymentIsRenegttnStopIntrst,
  PrepaymentAgreement.PrepaymentAgrmtSrceIsRenegttn AS PrepaymentAgrmtSrceIsRenegttn,
  PrepaymentAgreement.PrepaymentIsRenegttnCshSettlmt AS PrepaymentIsRenegttnCshSettlmt,
  PrepaymentAgreement.PrepaymentAgrmtIsReopened AS PrepaymentAgrmtIsReopened,
  cast( ' ' as ppmgag_e_reneguseraction preserving type ) AS PrepaymentRenegotiationAction,
  PrepaymentAgreement.CreationDateTime AS CreationDateTime,
  tstmp_to_dats( PrepaymentAgreement.CreationDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CreationDate AS clientNULLasCreationDate,
  PrepaymentAgreement.LastChangedByUser AS LastChangedByUser,
  PrepaymentAgreement.LastChangeDateTime AS LastChangeDateTime
FROM I_PrepaymentAgreement AS PrepaymentAgreement
LEFT OUTER JOIN I_PrepaymentAgrmtIntrstRatesTP AS _InterestRates ON PrepaymentAgreementUUID = _InterestRates.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtSurchargeTP AS _Surcharge ON PrepaymentAgreementUUID = _Surcharge.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtDistrTP AS _Distribution ON PrepaymentAgreementUUID = _Distribution.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtCollateralTP AS _Collateral ON PrepaymentAgreementUUID = _Collateral.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtCommlRefTP AS _Reference ON PrepaymentAgreementUUID = _Reference.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtHarvestTP AS _PastHarvest ON PrepaymentAgreementUUID = _PastHarvest.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtDocumentsTP AS _Documents ON PrepaymentAgreementUUID = _Documents.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentHistoryProdTP AS _ProdHistory ON PrepaymentAgreementUUID = _ProdHistory.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentHistorySalesTP AS _SalesHistory ON PrepaymentAgreementUUID = _SalesHistory.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtPlantsTP AS _Plant ON PrepaymentAgreementUUID = _Plant.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtNotesTP AS _Notes ON PrepaymentAgreementUUID = _Notes.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtRenegttnTP AS _Renegttn ON PrepaymentAgreementUUID = _Renegttn.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentEconomicGrpRel AS _PrepaymentEconomicGrpRel ON PrepaymentEconomicGroup = _PrepaymentEconomicGrpRel.PrepaymentEconomicGroup  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtCshSettlmtTP AS _CashSettlement ON PrepaymentAgreementUUID = _CashSettlement.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN E_PrepaymentAgreement AS _Extension ON PrepaymentAgreementUUID = _Extension.PrepaymentAgreementUUID  -- association [0..1]
;