I_PrepaymentAgrmtPartnersTP

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_PrepaymentAgrmtPartnersTP.
-- 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: IPPMGPARTNERTP

CREATE VIEW I_PrepaymentAgrmtPartnersTP AS
SELECT
  Partner.PrepaymentBusinessPartnerUUID AS PrepaymentBusinessPartnerUUID,
  Partner.PrepaymentAgrmtColltrlUUID AS PrepaymentAgrmtColltrlUUID,
  Partner.PrepaymentAgreementUUID AS PrepaymentAgreementUUID,
  Partner.Partner AS Partner,
  Partner.BPTaxNumber AS BPTaxNumber,
  Partner.AddressNumber AS AddressNumber,
  Partner.CreationDateTime AS CreationDateTime,
  Partner.LastChangedByUser AS LastChangedByUser,
  Partner.LastChangeDateTime AS LastChangeDateTime
FROM I_PrepaymentAgrmtPartners AS Partner
LEFT OUTER JOIN I_PrepaymentAgrmtCollateralTP AS _PrepaymentCollateral ON PrepaymentAgrmtColltrlUUID = _PrepaymentCollateral.PrepaymentAgrmtColltrlUUID  -- association [1..1]
LEFT OUTER JOIN I_PrepaymentAgreementTP AS _PrepaymentAgreement ON PrepaymentAgreementUUID = _PrepaymentAgreement.PrepaymentAgreementUUID  -- association [1..1]
LEFT OUTER JOIN E_PrepaymentAgrmtPartners AS _Extension ON PrepaymentBusinessPartnerUUID = _Extension.PrepaymentBusinessPartnerUUID  -- association [0..1]
;