C_RfqBidderVH

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_RfqBidderVH.
-- 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: CRFQBIDDERVH

CREATE VIEW C_RfqBidderVH AS
SELECT
  _Supplier.ContactCardID AS Supplier,
  _Supplier.FullName AS SupplierName,
  _Supplier.AddressID AS AddressID,
  cast('' as contactcardformattedaddress) AS FormattedAddress,
  _Supplier.PhoneNumber AS PhoneNumber,
  _Supplier.MobilePhoneNumber AS MobilePhoneNumber,
  _Supplier.EmailAddress AS EmailAddress,
  _Supplier.Country AS Country,
  _Address.AddresseeFullName AS AddresseeFullName,
  _Address.CityName AS CityName,
  _Address.PostalCode AS PostalCode,
  _CountryText[1: Language = $session.system_language].CountryName AS CountryName,
  _SupplierPurchasingOrg.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingOrganization.CompanyCode AS CompanyCode,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _Supplier.DataController1 AS DataController1,
  _Supplier.DataController2 AS DataController2,
  _Supplier.DataController3 AS DataController3,
  _Supplier.DataController4 AS DataController4,
  _Supplier.DataController5 AS DataController5,
  _Supplier.DataController6 AS DataController6,
  _Supplier.DataController7 AS DataController7,
  _Supplier.DataController8 AS DataController8,
  _Supplier.DataController9 AS DataController9,
  _Supplier.DataController10 AS DataController10,
  _Supplier.DataControllerSet AS DataControllerSet
FROM I_SuplrContactCard AS _Supplier
LEFT OUTER JOIN I_AddressDefaultRepresentation AS _Address ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierPurchasingOrg AS _SupplierPurchasingOrg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CountryText AS _CountryText ON Country = _CountryText.Country  -- association [1..*]
LEFT OUTER JOIN P_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
;