C_PrepaymentAgrmtApproval

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_PrepaymentAgrmtApproval.
-- 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: CPPMGAGRMTAPRVL

CREATE VIEW C_PrepaymentAgrmtApproval AS
SELECT
  cast(PrepaymentAgrmntApproval.PrepaymentAgrmtRjcnReason as abap.char(01) ) AS IsRejected,
  PrepaymentAgrmntApproval.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepaymentAgrmntApproval.PrepaymentAgreement AS PrepaymentAgreement,
  PrepaymentAgrmntApproval.PrepaymentAgreementType AS PrepaymentAgreementType,
  PrepaymentAgrmntApproval.PrepaymentAgreementCategory AS PrepaymentAgreementCategory,
  PrepaymentAgrmntApproval.PrepaymentAgreementDescription AS PrepaymentAgreementDescription,
  PrepaymentAgrmntApproval.PrepaymentAgreementAmount AS PrepaymentAgreementAmount,
  PrepaymentAgrmntApproval.PrepaymentAgreementCurrency AS PrepaymentAgreementCurrency,
  PrepaymentAgrmntApproval.PrepaymentAgreementStatus AS PrepaymentAgreementStatus,
  PrepaymentAgrmntApproval.PrepaymentAgrmtLinkStatus AS PrepaymentAgrmtLinkStatus,
  PrepaymentAgrmntApproval.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  PrepaymentAgrmntApproval.PrepaymentAgreementCommodity AS PrepaymentAgreementCommodity,
  PrepaymentAgrmntApproval.CompanyCode AS CompanyCode,
  PrepaymentAgrmntApproval.PrepaymentEconomicGroup AS PrepaymentEconomicGroup,
  PrepaymentAgrmntApproval.PrepaymentEconomicGroup AS PrepaymentEconomicGroupFilter,
  PrepaymentAgrmntApproval.PurchasingGroup AS PurchasingGroup,
  PrepaymentAgrmntApproval.PurchasingOrganization AS PurchasingOrganization,
  PrepaymentAgrmntApproval.SalesOrganization AS SalesOrganization,
  PrepaymentAgrmntApproval.DistributionChannel AS DistributionChannel,
  PrepaymentAgrmntApproval.Division AS Division,
  PrepaymentAgrmntApproval.Plant AS Plant,
  PrepaymentAgrmntApproval.PrepaymentAgrmtCropSeason AS PrepaymentAgrmtCropSeason,
  PrepaymentAgrmntApproval.Counterparty AS Counterparty,
  PrepaymentAgrmntApproval.PrepaymentAgrmtBPType AS PrepaymentAgrmtBPType,
  PrepaymentAgrmntApproval.PrepaymentAgrmtDueDate AS PrepaymentAgrmtDueDate,
  PrepaymentAgrmntApproval.PrepaymentAgreementRating AS PrepaymentAgreementRating,
  PrepaymentAgrmntApproval.PrepaymentLeasedPlantAreaQty AS PrepaymentLeasedPlantAreaQty,
  PrepaymentAgrmntApproval.PrepaymentPlantingAreaUoM AS PrepaymentPlantingAreaUoM,
  PrepaymentAgrmntApproval.PrepaymentProdtvPlantAreaQty AS PrepaymentProdtvPlantAreaQty,
  PrepaymentAgrmntApproval.PrepaymentProdtvPlantAreaUoM AS PrepaymentProdtvPlantAreaUoM,
  PrepaymentAgrmntApproval.PrepaymentOwnPlantingAreaQty AS PrepaymentOwnPlantingAreaQty,
  PrepaymentAgrmntApproval.PrepaymentOwnPlantingAreaUoM AS PrepaymentOwnPlantingAreaUoM,
  PrepaymentAgrmntApproval.PrepaymentCreditTotalAreaQty AS PrepaymentCreditTotalAreaQty,
  PrepaymentAgrmntApproval.PrepaymentCreditTotalAreaUoM AS PrepaymentCreditTotalAreaUoM,
  PrepaymentAgrmntApproval.PrepaymentPledgedAreaQty AS PrepaymentPledgedAreaQty,
  PrepaymentAgrmntApproval.PrepaymentPledgedAreaUoM AS PrepaymentPledgedAreaUoM,
  PrepaymentAgrmntApproval.PrepaymentPledgedProdtvAreaQty AS PrepaymentPledgedProdtvAreaQty,
  PrepaymentAgrmntApproval.PrepaymentPledgedProdtvAreaUoM AS PrepaymentPledgedProdtvAreaUoM,
  PrepaymentAgrmntApproval.PrepaymentOwnPledgedAreaQty AS PrepaymentOwnPledgedAreaQty,
  PrepaymentAgrmntApproval.PrepaymentOwnPledgedAreaUoM AS PrepaymentOwnPledgedAreaUoM,
  PrepaymentAgrmntApproval.PrepaymentTotalPledgedAreaQty AS PrepaymentTotalPledgedAreaQty,
  PrepaymentAgrmntApproval.PrepaymentTotalPledgedAreaUoM AS PrepaymentTotalPledgedAreaUoM,
  PrepaymentAgrmntApproval.PrepaymentCostPerHectareAmt AS PrepaymentCostPerHectareAmt,
  PrepaymentAgrmntApproval.PrepaymentCostHectareCurrency AS PrepaymentCostHectareCurrency,
  PrepaymentAgrmntApproval.PrepaymentCostOfPledgeAmt AS PrepaymentCostOfPledgeAmt,
  PrepaymentAgrmntApproval.PrepaymentCostOfPledgeCurrency AS PrepaymentCostOfPledgeCurrency,
  PrepaymentAgrmntApproval.PrepaymentCreditTotalCost AS PrepaymentCreditTotalCost,
  PrepaymentAgrmntApproval.PrepaymentTotalCostCurrency AS PrepaymentTotalCostCurrency,
  PrepaymentAgrmntApproval.PrepaymentProductivityFctrQty AS PrepaymentProductivityFctrQty,
  PrepaymentAgrmntApproval.PrepaymentProductivityFctrUoM AS PrepaymentProductivityFctrUoM,
  PrepaymentAgrmntApproval.PrepaymentCreditRegion AS PrepaymentCreditRegion,
  PrepaymentAgrmntApproval.PrepaymentEstimatedProdnQty AS PrepaymentEstimatedProdnQty,
  PrepaymentAgrmntApproval.PrepaymentEstimatedProdnUoM AS PrepaymentEstimatedProdnUoM,
  PrepaymentAgrmntApproval.PrepaymentLimitCreditDate AS PrepaymentLimitCreditDate,
  PrepaymentAgrmntApproval.PrepaymentCmtmtPercent AS PrepaymentCmtmtPercent,
  PrepaymentAgrmntApproval.PrepaymentPayoutPercent AS PrepaymentPayoutPercent,
  PrepaymentAgrmntApproval.PrepaymentCreditContractFlag AS PrepaymentCreditContractFlag,
  PrepaymentAgrmntApproval.PrepaymentStartIntrstDateType AS PrepaymentStartIntrstDateType,
  PrepaymentAgrmntApproval.PrepaymentStartIntrstDate AS PrepaymentStartIntrstDate,
  PrepaymentAgrmntApproval.PrepaymentStopIntrstDateType AS PrepaymentStopIntrstDateType,
  PrepaymentAgrmntApproval.PrepaymentStopIntrstDate AS PrepaymentStopIntrstDate,
  PrepaymentAgrmntApproval.PrepaymentRestrictionsTxt AS PrepaymentRestrictionsTxt,
  PrepaymentAgrmntApproval.PrepaymentCreditHistoryTxt AS PrepaymentCreditHistoryTxt,
  PrepaymentAgrmntApproval.BPTaxNumber AS BPTaxNumber,
  PrepaymentAgrmntApproval.PrepaymentAgrmtExtCommentText AS PrepaymentAgrmtExtCommentText,
  PrepaymentAgrmntApproval.PrepaymentAgrmtIntCommentText AS PrepaymentAgrmtIntCommentText,
  PrepaymentAgrmntApproval.PrepaymentAgrmtRjcnReason AS PrepaymentAgrmtRjcnReason,
  PrepaymentAgrmntApproval.PrepaymentRejectionText AS PrepaymentRejectionText,
  PrepaymentAgrmntApproval.CreatedByUser AS CreatedByUser,
  PrepaymentAgrmntApproval.CreationDate AS CreationDate,
  PrepaymentAgrmntApproval.CreationDateTime AS CreationDateTime,
  PrepaymentAgrmntApproval.LastChangeDateTime AS LastChangeDateTime,
  _BPText.FirstName AS FirstName,
  _BPText.LastName AS LastName,
  _BPText.OrganizationBPName1 AS OrganizationBPName1,
  _BPText.OrganizationBPName2 AS OrganizationBPName2,
  _BPText.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _BPText.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2
FROM I_PrepaymentAgreementTP AS PrepaymentAgrmntApproval
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 E_PrepaymentAgreement AS _Extension ON PrepaymentAgreementUUID = _Extension.PrepaymentAgreementUUID  -- 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_BusinessPartner AS _BPText ON Counterparty = _BPText.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusPartCategoryText AS _BusPartCatTxt ON PrepaymentAgrmtBPType = _BusPartCatTxt.BusinessPartnerCategoryText AND _BusPartCatTxt.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN C_PurchasingGroupValueHelp 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_PlantStdVH AS _PlntTxt ON Plant = _PlntTxt.Plant  -- association [0..1]
LEFT OUTER JOIN I_PrepaymentEconomicGrpVH AS _EconomicGroupText ON PrepaymentEconomicGroup = _EconomicGroupText.PrepaymentEconomicGroup AND Counterparty = _EconomicGroupText.Counterparty  -- 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_PrepaymentAgrmtLinkStsText AS _LinkStatusText ON PrepaymentAgrmtLinkStatus = _LinkStatusText.PrepaymentAgrmtDomainCode AND _LinkStatusText.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 AND _PrepaymentAgrmtTxt.Language = $session.system_language  -- 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_PrepaymentStrtIntrstTypeVH AS _StartIntrstTypeText ON PrepaymentStartIntrstDateType = _StartIntrstTypeText.PrepaymentAgrmtDomainCode  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentStopIntrstTypeVH AS _StopIntrstTypeText ON PrepaymentStopIntrstDateType = _StopIntrstTypeText.PrepaymentAgrmtDomainCode  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtRjcnReasonVH AS _PrepaymentAgrmtRjcnRsn ON PrepaymentAgrmtRjcnReason = _PrepaymentAgrmtRjcnRsn.PrepaymentAgrmtRjcnReason  -- association [0..1]
;