C_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 C_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: CPPMGAGRMTTP

CREATE VIEW C_PrepaymentAgreementTP AS
SELECT
  PrepaymentAgmnt.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepaymentAgmnt.PrepaymentAgreement AS PrepaymentAgreement,
  PrepaymentAgmnt.PrepaymentAgreementType AS PrepaymentAgreementType,
  PrepaymentAgmnt.PrepaymentAgrmtIsBarter AS PrepaymentAgrmtIsBarter,
  PrepaymentAgmnt.PrepaymentSimulateIsVisible AS PrepaymentSimulateIsVisible,
  PrepaymentAgmnt.PrepaymentAgrmtIsPosted AS PrepaymentAgrmtIsPosted,
  PrepaymentAgmnt.PrepaymentAgrmtIsLinked AS PrepaymentAgrmtIsLinked,
  PrepaymentAgmnt.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  PrepaymentAgmnt.PrepaymentAgreementDescription AS PrepaymentAgreementDescription,
  PrepaymentAgmnt.PrepaymentAgreementAmount AS PrepaymentAgreementAmount,
  PrepaymentAgmnt.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  PrepaymentAgmnt.PrepaymentAgreementStatus AS PrepaymentAgreementStatus,
  PrepaymentAgmnt.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtLinkStatus,
  PrepaymentAgmnt.PrepaymentBarterLinkStatus AS PrepaymentBarterLinkStatus,
  PrepaymentAgmnt.PrepaymentPostingProfile AS PrepaymentPostingProfile,
  PrepaymentAgmnt.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  PrepaymentAgmnt.PrepaymentAgreementCommodity AS PrepaymentAgreementCommodity,
  PrepaymentAgmnt.CompanyCode AS CompanyCode,
  PrepaymentAgmnt.PrepaymentEconomicGroup AS PrepaymentEconomicGroup,
  PrepaymentAgmnt.PrepaymentEconomicGroup AS PrepaymentEconomicGroupFilter,
  PrepaymentAgmnt.PurchasingOrganization AS PurchasingOrganization,
  PrepaymentAgmnt.PurchasingGroup AS PurchasingGroup,
  PrepaymentAgmnt.SalesOrganization AS SalesOrganization,
  PrepaymentAgmnt.DistributionChannel AS DistributionChannel,
  PrepaymentAgmnt.Division AS Division,
  PrepaymentAgmnt.PrepaymentAgrmtCropSeason AS PrepaymentAgrmtCropSeason,
  PrepaymentAgmnt.Counterparty AS Counterparty,
  _BPText.FirstName AS FirstName,
  _BPText.LastName AS LastName,
  _BPText.OrganizationBPName1 AS OrganizationBPName1,
  _BPText.OrganizationBPName2 AS OrganizationBPName2,
  _BPText.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _BPText.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  PrepaymentAgmnt.PrepaymentAgrmtBPType AS PrepaymentAgrmtBPType,
  PrepaymentAgmnt.PrepaymentAgrmtDueDate AS PrepaymentAgrmtDueDate,
  PrepaymentAgmnt.PrepaymentAgreementRating AS PrepaymentAgreementRating,
  PrepaymentAgmnt.PrepaymentLeasedPlantAreaQty AS PrepaymentLeasedPlantAreaQty,
  PrepaymentAgmnt.PrepaymentPlantingAreaUoM AS PrepaymentPlantingAreaUoM,
  PrepaymentAgmnt.PrepaymentProdtvPlantAreaQty AS PrepaymentProdtvPlantAreaQty,
  PrepaymentAgmnt.PrepaymentProdtvPlantAreaUoM AS PrepaymentProdtvPlantAreaUoM,
  PrepaymentAgmnt.PrepaymentOwnPlantingAreaQty AS PrepaymentOwnPlantingAreaQty,
  PrepaymentAgmnt.PrepaymentOwnPlantingAreaUoM AS PrepaymentOwnPlantingAreaUoM,
  PrepaymentAgmnt.PrepaymentCreditTotalAreaQty AS PrepaymentCreditTotalAreaQty,
  PrepaymentAgmnt.PrepaymentCreditTotalAreaUoM AS PrepaymentCreditTotalAreaUoM,
  PrepaymentAgmnt.PrepaymentPledgedAreaQty AS PrepaymentPledgedAreaQty,
  PrepaymentAgmnt.PrepaymentPledgedAreaUoM AS PrepaymentPledgedAreaUoM,
  PrepaymentAgmnt.PrepaymentPledgedProdtvAreaQty AS PrepaymentPledgedProdtvAreaQty,
  PrepaymentAgmnt.PrepaymentPledgedProdtvAreaUoM AS PrepaymentPledgedProdtvAreaUoM,
  PrepaymentAgmnt.PrepaymentOwnPledgedAreaQty AS PrepaymentOwnPledgedAreaQty,
  PrepaymentAgmnt.PrepaymentOwnPledgedAreaUoM AS PrepaymentOwnPledgedAreaUoM,
  PrepaymentAgmnt.PrepaymentTotalPledgedAreaQty AS PrepaymentTotalPledgedAreaQty,
  PrepaymentAgmnt.PrepaymentTotalPledgedAreaUoM AS PrepaymentTotalPledgedAreaUoM,
  PrepaymentAgmnt.PrepaymentCostPerHectareAmt AS PrepaymentCostPerHectareAmt,
  PrepaymentAgmnt.PrepaymentCostHectareCurrency AS PrepaymentCostHectareCurrency,
  PrepaymentAgmnt.PrepaymentCostOfPledgeAmt AS PrepaymentCostOfPledgeAmt,
  PrepaymentAgmnt.PrepaymentCostOfPledgeCurrency AS PrepaymentCostOfPledgeCurrency,
  PrepaymentAgmnt.PrepaymentCreditTotalCost AS PrepaymentCreditTotalCost,
  PrepaymentAgmnt.PrepaymentTotalCostCurrency AS PrepaymentTotalCostCurrency,
  PrepaymentAgmnt.PrepaymentProductivityFctrQty AS PrepaymentProductivityFctrQty,
  PrepaymentAgmnt.PrepaymentProductivityFctrUoM AS PrepaymentProductivityFctrUoM,
  PrepaymentAgmnt.PrepaymentCreditRegion AS PrepaymentCreditRegion,
  PrepaymentAgmnt.CountryCode AS CountryCode,
  PrepaymentAgmnt.CompanyRegion AS CompanyRegion,
  PrepaymentAgmnt.PrepaymentEstimatedProdnQty AS PrepaymentEstimatedProdnQty,
  PrepaymentAgmnt.PrepaymentEstimatedProdnUoM AS PrepaymentEstimatedProdnUoM,
  PrepaymentAgmnt.PrepaymentProductiveFctrPerUoM AS PrepaymentProductiveFctrPerUoM,
  PrepaymentAgmnt.PrepaymentLimitCreditDate AS PrepaymentLimitCreditDate,
  PrepaymentAgmnt.PrepaymentCmtmtPercent AS PrepaymentCmtmtPercent,
  PrepaymentAgmnt.PrepaymentPayoutPercent AS PrepaymentPayoutPercent,
  PrepaymentAgmnt.PrepaymentCreditContractFlag AS PrepaymentCreditContractFlag,
  PrepaymentAgmnt.PrepaymentPrincipalReduction AS PrepaymentPrincipalReduction,
  PrepaymentAgmnt.PrepaymentStartIntrstDateType AS PrepaymentStartIntrstDateType,
  PrepaymentAgmnt.PrepaymentStartIntrstDate AS PrepaymentStartIntrstDate,
  PrepaymentAgmnt.PrepaymentStopIntrstDateType AS PrepaymentStopIntrstDateType,
  PrepaymentAgmnt.PrepaymentStopIntrstDate AS PrepaymentStopIntrstDate,
  PrepaymentAgmnt.PrepaymentRestrictionsTxt AS PrepaymentRestrictionsTxt,
  PrepaymentAgmnt.PrepaymentCreditHistoryTxt AS PrepaymentCreditHistoryTxt,
  PrepaymentAgmnt.BPTaxNumber AS BPTaxNumber,
  PrepaymentAgmnt.AddressNumber AS AddressNumber,
  PrepaymentAgmnt.PrepaymentAgrmtExtCommentText AS PrepaymentAgrmtExtCommentText,
  PrepaymentAgmnt.PrepaymentAgrmtIntCommentText AS PrepaymentAgrmtIntCommentText,
  PrepaymentAgmnt.PrepaymentAgrmtRjcnReason AS PrepaymentAgrmtRjcnReason,
  PrepaymentAgmnt.PrepaymentRejectionText AS PrepaymentRejectionText,
  PrepaymentAgmnt.IsRejected AS IsRejected,
  PrepaymentAgmnt.PrepaymentRenegttnStopDate AS PrepaymentRenegttnStopDate,
  PrepaymentAgmnt.PrepaymentSuspendIntrstFromDte AS PrepaymentSuspendIntrstFromDte,
  PrepaymentAgmnt.PrepaymentSuspendIntrstToDte AS PrepaymentSuspendIntrstToDte,
  PrepaymentAgmnt.PrepaymentIsRenegotiated AS PrepaymentIsRenegotiated,
  PrepaymentAgmnt.PrepaymentIsRenegttnStopIntrst AS PrepaymentIsRenegttnStopIntrst,
  PrepaymentAgmnt.PrepaymentAgrmtIsRenegotiated AS PrepaymentAgrmtIsRenegotiated,
  PrepaymentAgmnt.PrepaymentIsRenegttnCshSettlmt AS PrepaymentIsRenegttnCshSettlmt,
  PrepaymentAgmnt.PrepaymentAgrmtIsReopened AS PrepaymentAgrmtIsReopened,
  PrepaymentAgmnt.PrepaymentRenegotiationAction AS PrepaymentRenegotiationAction,
  PrepaymentAgmnt.CreatedByUser AS CreatedByUser,
  PrepaymentAgmnt.CreationDate AS CreationDate,
  PrepaymentAgmnt.CreationDateTime AS CreationDateTime,
  PrepaymentAgmnt.LastChangeDateTime AS LastChangeDateTime,
  _SectionHide.PrepaymentCommlRefSctnActv AS PrepaymentCommlRefSctnActv,
  _SectionHide.PrepaymentDistributionSctnActv AS PrepaymentDistributionSctnActv,
  _SectionHide.PrepaymentDocumentsSctnActv AS PrepaymentDocumentsSctnActv,
  _SectionHide.PrepaymentIntrstRateSctnActv AS PrepaymentIntrstRateSctnActv,
  _SectionHide.PrepaymentSurchargeSctnActv AS PrepaymentSurchargeSctnActv,
  _SectionHide.PrepaymentHarvestSctnActv AS PrepaymentHarvestSctnActv,
  _SectionHide.PrepaymentHistoryProdnSctnActv AS PrepaymentHistoryProdnSctnActv,
  _SectionHide.PrepaymentHistorySalesSctnActv AS PrepaymentHistorySalesSctnActv,
  cast(' ' as abap.char(1)) AS PrepaymentColltrlSctnIsActv,
  cast(' ' as boolean ) AS PrepaymentAgrmtIsCashSettlmt,
  cast(' ' as boolean ) AS PrepaymentAgrmtIsStopIntrst,
  cast(' ' as boolean ) AS PrepaymentAgrmtIsRenegttn
FROM I_PrepaymentAgreementTP AS PrepaymentAgmnt
LEFT OUTER JOIN C_PrepaymentAgrmtIntrstRatesTP AS _InterestRates ON PrepaymentAgreementUUID = _InterestRates.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtSurchargeTP AS _Surcharge ON PrepaymentAgreementUUID = _Surcharge.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtDistrTP AS _Distribution ON PrepaymentAgreementUUID = _Distribution.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtCommlRefTP AS _Reference ON PrepaymentAgreementUUID = _Reference.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtHarvestTP AS _PastHarvest ON PrepaymentAgreementUUID = _PastHarvest.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtCollateralTP AS _Collateral ON PrepaymentAgreementUUID = _Collateral.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtDocumentsTP AS _Documents ON PrepaymentAgreementUUID = _Documents.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentHistoryProdTP AS _ProdHistory ON PrepaymentAgreementUUID = _ProdHistory.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentHistorySalesTP AS _SalesHistory ON PrepaymentAgreementUUID = _SalesHistory.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtPlantsTP AS _Plant ON PrepaymentAgreementUUID = _Plant.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtNotesTP AS _Notes ON PrepaymentAgreementUUID = _Notes.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentRenegttnHdrTP AS _Renegttn ON PrepaymentAgreementUUID = _Renegttn.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAgrmtCshSettlmt AS _CashSettlement ON PrepaymentAgreementUUID = _CashSettlement.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentAssignedDocumentTP AS _BarterDoc ON PrepaymentAgreement = _BarterDoc.PrepaymentAgreement AND _BarterDoc.DocNumber <> '' AND _BarterDoc.PrepaymentAgrmtLinkType = 'BR'  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentLinkedDocumentTP AS _LinkedDoc ON PrepaymentAgreement = _LinkedDoc.PrepaymentAgreement AND _LinkedDoc.PrepaymentAgreement <> '' AND _LinkedDoc.DocNumber <> '' AND _LinkedDoc.PrepaymentAgrmtLinkType = 'LN'  -- association [0..*]
LEFT OUTER JOIN C_PrepaymentPostedDocumentsTP AS _PostedDoc ON PrepaymentAgreement = _PostedDoc.PrepaymentAgreement AND _PostedDoc.PrepaymentAgreement <> ''  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UoMText ON PrepaymentCreditTotalAreaUoM = _UoMText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON PrepaymentAgreementCurrency = _CurrencyText.Currency  -- association [0..*]
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_BusinessPartner AS _BPText ON Counterparty = _BPText.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusPartCategoryText AS _BusPartCatTxt ON PrepaymentAgrmtBPType = _BusPartCatTxt.BusinessPartnerCategory AND _BusPartCatTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroup AS _PurgGrpTxt ON _PurgGrpTxt.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrganizationVHTemp AS _PurgOrgTxt ON PurchasingOrganization = _PurgOrgTxt.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SlsOrgTxt ON SalesOrganization = _SlsOrgTxt.SalesOrganization AND _SlsOrgTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistrChnlTxt ON DistributionChannel = _DistrChnlTxt.DistributionChannel AND _DistrChnlTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _DivnTxt ON Division = _DivnTxt.Division AND _DivnTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON CountryCode = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RegionText AS _RegionText ON CompanyRegion = _RegionText.Region AND _RegionText.Language = $session.system_language AND CountryCode = _RegionText.Country  -- 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_PrepaymentCropSeasonCalcTxt AS _CropSeasonText ON PrepaymentAgrmtCropSeason = _CropSeasonText.PrepaymentAgrmtCropSeason AND Counterparty = _CropSeasonText.Counterparty AND PrepaymentEconomicGroup = _CropSeasonText.PrepaymentEconomicGroup AND _CropSeasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _OrderStatusText ON PrepaymentAgreementStatus = _OrderStatusText.SystemStatus AND _OrderStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _PostingStatusText ON PrepaymentAgrmtPostingStatus = _PostingStatusText.SystemStatus AND _PostingStatusText.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_PrepaymentAgreementTypeVH AS _PrepaymentAgrmtTxt ON PrepaymentAgreementType = _PrepaymentAgrmtTxt.PrepaymentAgreementType  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtCategoryText AS _PrepaymentAgrmtCatTxt ON PrepaymentAgreementCategory = _PrepaymentAgrmtCatTxt.PrepaymentAgrmtDomainCode AND _PrepaymentAgrmtCatTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentStrtIntrstTypeTxt AS _StartIntrstTypeText ON PrepaymentStartIntrstDateType = _StartIntrstTypeText.PrepaymentAgrmtDomainCode AND _StartIntrstTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentStopIntrstTypeTxt AS _StopIntrstTypeText ON PrepaymentStopIntrstDateType = _StopIntrstTypeText.PrepaymentAgrmtDomainCode AND _StopIntrstTypeText.Language = $session.system_language  -- 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_PrepaymentAgrmtLinkStsText AS _BarterLinkStatusText ON PrepaymentBarterLinkStatus = _BarterLinkStatusText.PrepaymentAgrmtDomainCode AND _BarterLinkStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentPrncplReducnText AS _PrincipalReductionText ON PrepaymentPrincipalReduction = _PrincipalReductionText.PrepaymentAgrmtDomainCode AND _PrincipalReductionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtHideSection AS _SectionHide ON CompanyCode = _SectionHide.CompanyCode AND PrepaymentAgreementType = _SectionHide.PrepaymentAgreementType  -- association [0..1]
LEFT OUTER JOIN C_PrepaymentRenegotiation AS _RenegttnList ON PrepaymentAgreementUUID = _RenegttnList.PrepaymentAgreementUUID  -- association [0..*]
LEFT OUTER JOIN E_PrepaymentAgreement AS _Extension ON PrepaymentAgreementUUID = _Extension.PrepaymentAgreementUUID  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentAgrmtRjcnReasonVH AS _PrepaymentAgrmtRjcnRsn ON PrepaymentAgrmtRjcnReason = _PrepaymentAgrmtRjcnRsn.PrepaymentAgrmtRjcnReason  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentIsRenegotiatedText AS _RenegttnIndicatorText ON PrepaymentIsRenegotiated = _RenegttnIndicatorText.PrepaymentIsRenegotiated AND _RenegttnIndicatorText.Language = $session.system_language  -- association [0..1]
;