C_PrepaymentAgrmtWorkCenter

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_PrepaymentAgrmtWorkCenter.
-- 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: CPPMGAGRMWRKCNTR

CREATE VIEW C_PrepaymentAgrmtWorkCenter AS
SELECT
  PrepaymentAgmnt.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  PrepaymentAgmnt.PrepaymentAgreement AS PrepaymentAgreement,
  PrepaymentAgmnt.PrepaymentAgreementType AS PrepaymentAgreementType,
  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.PrepaymentAgrmtPostingStatus AS PrepaymentAgrmtPostingStatus,
  PrepaymentAgmnt.PrepaymentBarterLinkStatus AS PrepaymentBarterLinkStatus,
  PrepaymentAgmnt.PrepaymentAgreementCommodity AS PrepaymentAgreementCommodity,
  PrepaymentAgmnt.CompanyCode AS CompanyCode,
  PrepaymentAgmnt.PrepaymentEconomicGroup AS PrepaymentEconomicGroup,
  PrepaymentAgmnt.PrepaymentEconomicGroup AS PrepaymentEconomicGroupFilter,
  PrepaymentAgmnt.PurchasingGroup AS PurchasingGroup,
  PrepaymentAgmnt.PurchasingOrganization AS PurchasingOrganization,
  PrepaymentAgmnt.SalesOrganization AS SalesOrganization,
  PrepaymentAgmnt.DistributionChannel AS DistributionChannel,
  PrepaymentAgmnt.Division AS Division,
  PrepaymentAgmnt.Plant AS Plant,
  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.PrepaymentCreditTotalAreaUoM AS PrepaymentCreditTotalAreaUoM,
  PrepaymentAgmnt.CreatedByUser AS CreatedByUser,
  PrepaymentAgmnt.CreationDate AS CreationDate,
  PrepaymentAgmnt.CreationDateTime AS CreationDateTime,
  PrepaymentAgmnt.LastChangeDateTime AS LastChangeDateTime,
  PrepaymentAgmnt._PrepaymentEconomicGrpRel AS _PrepaymentEconomicGrpRel,
  _PrepaymentAmount.PrepaymentAgrmtCshSettlmtAmt AS PrepaymentAgrmtCshSettlmtAmt,
  _PrepaymentAmount.PrepaymentTotalRenegttnAmount AS PrepaymentTotalRenegttnAmount,
  _PrepaymentAmount.PrepaymentTotalRecoveredAmount AS PrepaymentTotalRecoveredAmount
FROM I_PrepaymentAgreementTP AS PrepaymentAgmnt
LEFT OUTER JOIN I_PrepaymentAgrmtAmount AS _PrepaymentAmount ON PrepaymentAgreement = _PrepaymentAmount.PrepaymentAgreement AND _PrepaymentAmount.PrepaymentAgrmtLinkType = 'LN'  -- association [1..1]
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.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_PrepaymentEconomicGrpTxt AS _EconomicGroupText ON PrepaymentEconomicGroup = _EconomicGroupText.PrepaymentEconomicGroup AND Counterparty = _EconomicGroupText.Counterparty AND _EconomicGroupText.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 AND _PrepaymentAgrmtTxt.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_PrepaymentAgrmtCategoryText AS _PrepaymentAgrmtCatTxt ON PrepaymentAgreementCategory = _PrepaymentAgrmtCatTxt.PrepaymentAgrmtDomainCode  -- association [0..*]
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]
;