R_SuplrListProposedSupplierTP

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 R_SuplrListProposedSupplierTP.
-- 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: RSUPLRLBUPPROPTP

CREATE VIEW R_SuplrListProposedSupplierTP AS
SELECT
  _SupplierListProposedSupplier.SuplrListProposedSupplierUUID AS SuplrListProposedSupplierUUID,
  _SupplierListProposedSupplier.BusinessPartnerUUID AS BusinessPartnerUUID,
  _SupplierListProposedSupplier.BusinessPartner AS BusinessPartner,
  _SupplierListProposedSupplier.SupplierListUUID AS SupplierListUUID,
  _SupplierListProposedSupplier.Supplier AS Supplier,
  _SupplierListProposedSupplier.SuplrListSuplrProposalUniqueID AS SuplrListSuplrProposalUniqueID,
  _SupplierListProposedSupplier.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  _SupplierListProposedSupplier._SuplrContactCard.AddressID AS AddressID,
  _SupplierListProposedSupplier.SupplierCountryGroup AS SupplierCountryGroup,
  _SupplierListProposedSupplier.SuplrListSuplrProposedDateTime AS SuplrListSuplrProposedDateTime,
  _SupplierListProposedSupplier.SuplrListSupplierProposalText AS SuplrListSupplierProposalText,
  _SupplierListProposedSupplier.SupplierProposedByUser AS SupplierProposedByUser,
  _SupplierListProposedSupplier.SuplrListSupplierApprovalText AS SuplrListSupplierApprovalText,
  SuplrListSuplrProposalStatus,
  IsDeleted,
  SuplrListSuplrProposalAction,
  _SupplierListProposedSupplier._SuplrContactCard.Country AS Country,
  cast( '' as vdm_suplrlprpslsitntrigger ) AS SuplrListPrpslSitnTriggerCode
FROM R_SupplierListProposedSupplier AS _SupplierListProposedSupplier
LEFT OUTER JOIN I_SuplrListSuplrCntryGroupText AS _SuplrListSuplrCntryGroupText ON SupplierCountryGroup = _SuplrListSuplrCntryGroupText.SupplierCountryGroup AND _SuplrListSuplrCntryGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _Address ON addressid = _Address.AddressID AND _Address.AddressPersonID = '' AND _Address.AddressRepresentationCode = ''  -- association [1..1]
LEFT OUTER JOIN I_BuPaIdentification AS _BuPaIdentification ON BusinessPartner = _BuPaIdentification.BusinessPartner AND _BuPaIdentification.BPIdentificationType = 'BUP001'  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _ProposedByUser ON SupplierProposedByUser = _ProposedByUser.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON country = _CountryText.Country  -- association [1..*]
LEFT OUTER JOIN E_SupplierListProposedSupplier AS _Extension ON SuplrListProposedSupplierUUID = _Extension.SuplrListProposedSupplierUUID  -- association [1..1]
;